Sql user is disable even after activatin suspended domain

[KartikM]

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?

 

[GigsH]

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