SQL Problem

Occasionally you may experience problems loading default databases, due to the current system being busy with SQL processing, and you may get errors as below:

info: loading default databases…
 taking longer. please wait…
 Info: mysql is stopped.
 Info: mysql is stopped.
 Error: MySQL is not running. Can't restore databases.
 initializing all databases…
 Current Version: 201608010100
 Installing Version: 201706031500
 stop mysql events
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2003 (HY000): Can't connect to MySQL server on 'mysqldb' (111)
 ERROR 2003 (HY000): Can't connect to MySQL server on 'mysqldb' (111)
 Error: mbox mysql user not permitted to mboxadmin.
 init DB mboxadmin
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 mysqlshow: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 upgrade DB mboxadmin
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  • After the last step is completed, restart your mbox (it should boot up with a basic default config without any SQL running).
  • Execute ‘# write erase’ command, This will be able to reset your mbox completely

If it’s still not resolved, then it might be due to the SQL dynamic pass generation issue.
Follow the below steps to pass-rest

mbox# 
mbox# configure 
mbox(config)# mfusion mysql-server 
mbox(config-mysql)# pass-reset
……
……
[info] mysql DB pass normalized successfully.
mbox(config-mysql)# end
mbox# write erase