Plesk 9.X Upgrades : Table ‘mysql.procs_priv’ doesn’t exist

Plesk Upgrades to Plesk 9.X may result in MySQL errors while adding new Database user under Plesk.

Error under Plesk :
Table ‘mysql.procs_priv’ doesn’t exist

You can also check the same error under command line :

mysql> flush privileges;
ERROR 1146 (42S02): Table ‘mysql.procs_priv’ doesn’t exist
mysql>

This can be fixed using below command. This will try to repair/ recreate the tables having issues.

cat /usr/share/mysql/mysql_fix_privilege_tables.sql | mysql --no-defaults --force --user=admin -p --host=localhost --database=mysql

Note: Before executing this command, make sure that you have taken the full backup of MySQL.

Hope this helps 🙂

cPanel : Horde login error !

Horde login error

Horde Login shows below error :

Warning: Unknown: write failed: Disk quota exceeded (122) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of
session.save_path is correct (/var/cpanel/userhomes/cpanelhorde/sessions) in Unknown on line 0

Then try this cPanel script :

/scripts/autorepair phpapps_owner_fix

The above cPanel script will reset all the quotas for the cPanel users.