• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

ERROR: PleskMainDBException

M

MrApples

Guest
Apparently Plesk's database has been corrupted due to a bad-parsed my.cnf file during a reboot, at least 10 tables appear to have the 'Incorrect information' problem. I tried a variety of things in the SSH I found online to repair the MySQL, but unfortunately nothing has happened.

Service 'mysqld' is running

Code:
ERROR: PleskMainDBException
MySQL query failed: Incorrect information in file: './psa/misc.frm'

0: /usr/local/psa/admin/plib/common_func.php3:250
	db_query(string 'select param, val from misc')
1: /usr/local/psa/admin/plib/common_func.php3:562
	get_param(string 'mysql41_compatible')
2: /usr/local/psa/admin/plib/common_func.php3:459
	db_set_names()
3: /usr/local/psa/admin/plib/common_func.php3:438
	db_connect_real(string 'localhost', string 'admin', string '**********', string 'psa')
4: /usr/local/psa/admin/plib/common_func.php3:418
	db_connect()
5: /usr/local/psa/admin/auto_prepend/auth.php3:90

After restarting all services in the SSH...
Code:
ERROR 1033 (HY000) at line 1: Incorrect information in file: './psa/DomainServices.frm'
websrvmng: DB error (mysql41 compatible query) 1033: Incorrect information in file: './psa/misc.frm'
websrvmng: DB error (mysql41 compatible query) 1033: Incorrect information in file: './psa/misc.frm'
websrvmng: Unable to connect to the mysql database
websrvmng: Unable to connect to the mysql database
ERROR 1033 (HY000) at line 1: Incorrect information in file: './psa/sessions.frm'
Starting Plesk...                                                    done
ERROR 1033 (HY000) at line 1: Incorrect information in file: './psa/misc.frm'

If anyone could offer some assistance on this that would be great. Apache is still running, but the cP and MySQL are dead.
 
Back
Top