If you're experiencing issues with the latest version of MariaDB on some cPanel accounts and the MySQL server is offline, here's a step-by-step guide to help you resolve the problem:
Step 1: Execute the Autofix To begin, you can try executing the autofix command:
/scripts/autorepair fix_mariadb_show_grants_roles
This command is designed to fix the issue automatically. Run it and observe if it resolves the problem.
Step 2: Check the cPanel Error Log If the autofix didn't resolve the issue. This log file often provides additional details about the problem, which can help in resolving it. To access the log, use the following command:
tail -n 50 /usr/local/cpanel/logs/error_log
This will display the last 50 lines of the error log. By reviewing the log entries, you may find valuable information to further troubleshoot and resolve the issue.
Step 3: Resolve the "CpuserNotInMap" Error If you encounter the error message:
Cpanel::Exception::Database::CpuserNotInMap/(XID xfttxq) The cPanel user "username" does not exist in the database map
while loading the MySQL Databases page in cPanel, it indicates an issue with the MySQL system. Fortunately, cPanel provides a tool to address this problem.
Execute the following command, replacing $user with the affected cPanel account's username, to update the user's database map on the server:
/scripts/rebuild_dbmap $user
After running this command, the database map will be updated, resolving the issue and ensuring proper functionality.
Important: Remember to replace $user in the command with the actual username of the affected cPanel account.
By following these steps, you should be able to resolve the issue caused by the latest version of MariaDB on cPanel accounts.
