• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Sql user is disable even after activatin suspended domain

K

KartikM

Guest
When we Activate the suspended domain,
sql-user of the database owned by the activated domain is assigned the role 'db_denydatareader' and 'db_denydatawriter'.

And so the user can not perform any database operation.

Any solution?
 
Hi Kartik,

This is known bug of plesk panel and we did reported them many time but no fix yet.

To get around this what you can do is just recreate the database user after deleting that from control panel. To know what was the earlier username password stored in the database use the following command

"%plesk_bin%\dbclient.exe" --direct-sql --sql="SELECT d.name AS 'Database Name', d1.login AS 'Dabase Users', d1.passwd AS 'Password' FROM data_bases d, db_users d1 WHERE d.id=d1.db_id and d.db_server_id=db_server_ID and d.name='your-database-name';

Put the db server ID as per your plesk installation
 
Back
Top