Pkgacct and daily backups lock the mysql user passwords Print

  • 0

Symptoms

When running the script "/scripts/pkgacct" or daily backups, it can be observed that some MySQL users stop working.

 

ERROR 1045 (28000): Access denied for user 'database_user'@'localhost' (using password: YES)

 

Description 

During "/scripts/pkgacct" or daily backups, cPanel will attempt to ensure the account is in the same state of suspended or unsuspended when the backup completes. If the account is only partially suspended, it can cause the pkgacct script to re-lock the MySQL users after the backup completes. This state shouldn't normally occur, but when actions are terminated or not completed correctly in cPanel, some data may be left in an inconsistent state.

 

Workaround

Ensure the account is fully suspended:

 

/scripts/suspendacct cpanel-username

 

Then unsuspend the account once more:

 

/scripts/unsuspendacct cpanel-username

 

Note: Replace cpanel-username with the username of your cPanel account that experiences the issue.


Was this answer helpful?
Back

Send Message