Can't connect to socket. Maybe governor is not started- dbtop command error

Issue:
# dbtop
Can't connect to socket. Maybe governor is not started

Analysis:

Check error log for db governor /var/log/dbgovernor-error.log when running this command. I got below errors from log.

---------------------

Try to connect with options from dbgovernor config file

Try to connect with no password under root

Update your MySQL to CLL version from repo.cloudlinux.com. Current is 5.5.37-cll

Incorrect mysql version

Failed governor daemon, restart daemon

---------------------

 The db governor configuartion is looking for a different version of MySQL hence the issue. We need to correct the db governor configuartion with current MySQL version.

Fix:

Run the following commands:

# /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=MYSQL_VERSION

# /usr/share/lve/dbgovernor/mysqlgovernor.py --install

Thats it!!