MySQL Governor failing

[roni]

Installed mysql governor and not getting it to work

[morten]

Hello,

Wanted to test mysql governor on a live server, but have some issues.
Installed it and did try to start it:
[~]# service db_governor restart
Stopping /usr/sbin/db_governor: [FAILED]
Starting /usr/sbin/db_governor: [ OK ]

When checking status I get:
service db_governor status
db_governor dead but pid file exists

How to fix that?

[morten]

Also tried setting lve-mode to on but error:
dbctl --lve-mode on
Configuration saved. Unable to apply to live instance - cant connect to socket. Maybe governor is not started

fs.suid_dumpable = 1 was also added correctly when installed.
Did install governor-mysql.x86_64 0:1.0-89.el6.cloudlinux

[morten]

Did get it to run for a moment:
service db_governor status
db_governor (pid 22251 8) is running...

But it only worked for a couple of seconds:
service db_governor status
db_governor dead but pid file exists

[bogdan.sh]

Hello,

Could you please try our latest version? Just released: http://www.cloudlinux.com/blog/clnew...r-updated-.php

[morten]

Did just try 1.0-93.el6.cloudlinux, but same message:
root@c [~]# service db_governor stop
Stopping /usr/sbin/db_governor: [FAILED]

root@c [~]# service db_governor start
Starting /usr/sbin/db_governor: [ OK ]
root@c [~]# service db_governor status
db_governor dead but pid file exists

Are there any logs I can check?

[bogdan.sh]

You may check /var/log/dbgovernor-error.log , however in case of segmentation fault nothing useful will be there. If so we would really like to check the issue in please, so please create a trouble ticket in our system.

[morten]

[Tue May 26 15:21:44 2015] Failed governor daemon, restart daemon
[Tue May 26 15:22:23 2015] Open govern connection operation
[Tue May 26 15:22:23 2015] Try to connect with options from dbgovernor config file
[Tue May 26 15:22:23 2015] Try to connect with no password under root
[Tue May 26 15:22:23 2015] Open write connection operation
[Tue May 26 15:22:23 2015] Try to connect with options from dbgovernor config file
[Tue May 26 15:22:23 2015] Try to connect with no password under root
[Tue May 26 15:22:23 2015] Try to connect with options from dbgovernor config file
[Tue May 26 15:22:23 2015] Try to connect with no password under root
[Tue May 26 15:22:23 2015] Update your MySQL to CLL version from repo.cloudlinux.com. Current is 5.5.42-cll
[Tue May 26 15:22:23 2015] Incorrect mysql version

Found these.
Is MySQL version the problem?

[bogdan.sh]

Yeah, looks like that is not our MySQL version, as of now what you have to do is:
/usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mysql55
/usr/share/lve/dbgovernor/mysqlgovernor.py --install

And.. did you follow http://docs.cloudlinux.com/installation3.html ?

[morten]

That did work! :-)
But you should add /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mysql55 to the howto!

Also, Im getting this now:
Problems were detected with cPanel-provided files which are RPM controlled.
If you did not make these changes intentionally, you can correct them by running:

> /usr/local/cpanel/scripts/check_cpanel_rpms --fix

The following RPMs are missing from your system:
MySQL55-client-5.5.42-2.cp1148
MySQL55-devel-5.5.42-2.cp1148
MySQL55-server-5.5.42-2.cp1148
MySQL55-shared-5.5.42-2.cp1148
MySQL55-test-5.5.42-2.cp1148
compat-MySQL50-shared-5.0.96-4.cp1136
compat-MySQL51-shared-5.1.73-7.cp1136

What do I do with them?

[bogdan.sh]

Could you please post here a content of /var/cpanel/rpm.versions.d/local.versions ?

[morten]

---
file_format:
version: 2
install_targets: {}

rpm_locations: {}

srpm_sub_packages: {}

srpm_versions: {}

target_settings:
clamav: installed
easy-tomcat7: uninstalled
url_templates: {}

[alexey.com.s]

Hello,

can you show me such file:
cat /var/cpanel/rpm.versions.d/cloudlinux.versions

and add such strings to /var/cpanel/rpm.versions.d/local.versions:

---
file_format:
version: 2
install_targets: {}

rpm_locations: {}

srpm_sub_packages: {}

srpm_versions: {}

target_settings:
MySQL50: unmanaged
MySQL51: unmanaged
MySQL55: unmanaged
MySQL56: unmanaged
clamav: installed
easy-tomcat7: uninstalled
url_templates: {}

and show content of directory:
ls -l /var/cpanel/rpm.versions.d

?

[morten]

I have now added these to local.versions:
MySQL50: unmanaged
MySQL51: unmanaged
MySQL55: unmanaged
MySQL56: unmanaged

cat: /var/cpanel/rpm.versions.d/cloudlinux.versions: No such file or directory

-rw-r--r-- 1 root root 2518 May 13 14:00 easy.versions
-rw-r--r-- 1 root root 279 May 28 20:08 local.versions

[alexey.com.s]

Hello,

need to make such command:

cp /usr/share/lve/dbgovernor/cpanel/cloudlinux.versions /var/cpanel/rpm.versions.d/

looks like file was deleted from directory or it was trouble on installation of this file during mysqlgovernor --install.