If you are getting an error like this in your Plesk login page:
ERROR: PleskMainDBException
MySQL query
failed: Unknown column 'ip_dual_stack' in 'field list'
0: common_func.php3:220
db_query(string
'SELECT login, type, ip_address, ip_dual_stack FROM sessions WHERE
sess_id=""')
1: class.Session.php:420
Session->init(string
'xx.xx.xx.xx')
2: auth.php3:194
Follow the below steps to fix the issue:
1. Login to psa database:
#mysql -uadmin -p'password' psa
2. Run the below query:
mysql> ALTER TABLE sessions ADD ip_dual_stack VARCHAR(39) NULL;
Waiting for your feedback!!!
Thank you very much, I was a big help.
ReplyDeleteThis is what I used for the BD conectarame:
mysql -uadmin -p `cat /etc/psa/.psa.shadow`
Hey Luis, I am happy that the post helped you. :)
DeleteYes, you can use mysql -uadmin -p `cat /etc/psa/.psa.shadow` psa to connect psa database.
In-fact the file "/etc/psa/.psa.shadow", itself contains plesk admin password. Hence in the password field, we can directly mention the command "cat /etc/psa/.psa.shadow"
Nice blog....very helpful...Thanks
ReplyDeleteReally helpful. Thanks:-)
ReplyDeleteWhich database do I have to select before running this command????
ReplyDeleteYou need to select psa db. Sorry for my late reply.
Delete