Backup finishes with warning: type mysql is skipped from backup due to error: Can't use string as a HASH

Created:

2016-11-16 13:03:34 UTC

Modified:

2017-04-24 11:58:56 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Backup finishes with warning: type mysql is skipped from backup due to error: Can't use string as a HASH

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

Backup of subscription finishes with warning:

 Warning: mysql "db_name"

Database db_name, type mysql is skipped from backup due to error: Can't use string ("") as a HASH ref while "strict refs" in use at /usr/local/psa/PMM/agents/PleskX/DAL.pm line xxx.

Cause

Database user is absent from mysql.user table, although it exists in psa database.

Resolution

Run plesk repair utility to fix the issue. It will check for missing users and will recreate them:

# plesk repair mysql
Repair database users on available servers

The user contoso is absent from the database server ................ [ERROR]
Recreate the user contoso with default permissions and default hosts? [Y/n] y
Recreating the user contoso ...................................... [FIXED]
Have more questions? Submit a request
Please sign in to leave a comment.