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