Tweet
Hi,
Since beginning I have MySQL server separated from cPanel server through Additional MySQL Access Hosts and that has been working fine.
The MySQL server which is separated is running just minimum CentOS OS without any panel and running MariaDB mysql Ver 15.1 Distrib 10.2.24-MariaDB.
On my cPanel server with CloudLinux when I have initialized Home » Server Configuration » CloudLinux LVE Manager all seems to be running but not MySQL Governor and it is keep saying to start the service.
So, I logged into SSH of cPanel and run command sudo systemctl restart db_governor and in error log it returned rightly as follows:
------------------
[Tue Jun 11 13:19:45 2019] Send governor connection error
[Tue Jun 11 13:19:45 2019] Cant connect to mysql. Please check that mysql is running otherwise check host, login and password in /etc/container/mysql-governor.xml file
[Tue Jun 11 13:19:48 2019] Open govern connection operation
------------------
I then opened this file /etc/container/mysql-governor.xml and edit following line
------------------
<connector host="172.20.10.10" login="root" password="mysqlrootpassword" prefix_separator="_"/>
------------------
After making this change when I try to restart sudo systemctl restart db_governor, I now get this:
------------------
[Tue Jun 11 14:09:32 2019] Governor successfully connected to mysql
[Tue Jun 11 14:09:32 2019] Update your MySQL to CLL version from repo.cloudlinux.com. Current is 10.2.24-MariaDB
[Tue Jun 11 14:09:32 2019] Incorrect mysql version
------------------
Can you please tell me what do I need to do on my minimum CentOS OS server without any panel and running MariaDB mysql Ver 15.1 Distrib 10.2.24-MariaDB.
Regards,
Faraz
Since beginning I have MySQL server separated from cPanel server through Additional MySQL Access Hosts and that has been working fine.
The MySQL server which is separated is running just minimum CentOS OS without any panel and running MariaDB mysql Ver 15.1 Distrib 10.2.24-MariaDB.
On my cPanel server with CloudLinux when I have initialized Home » Server Configuration » CloudLinux LVE Manager all seems to be running but not MySQL Governor and it is keep saying to start the service.
So, I logged into SSH of cPanel and run command sudo systemctl restart db_governor and in error log it returned rightly as follows:
------------------
[Tue Jun 11 13:19:45 2019] Send governor connection error
[Tue Jun 11 13:19:45 2019] Cant connect to mysql. Please check that mysql is running otherwise check host, login and password in /etc/container/mysql-governor.xml file
[Tue Jun 11 13:19:48 2019] Open govern connection operation
------------------
I then opened this file /etc/container/mysql-governor.xml and edit following line
------------------
<connector host="172.20.10.10" login="root" password="mysqlrootpassword" prefix_separator="_"/>
------------------
After making this change when I try to restart sudo systemctl restart db_governor, I now get this:
------------------
[Tue Jun 11 14:09:32 2019] Governor successfully connected to mysql
[Tue Jun 11 14:09:32 2019] Update your MySQL to CLL version from repo.cloudlinux.com. Current is 10.2.24-MariaDB
[Tue Jun 11 14:09:32 2019] Incorrect mysql version
------------------
Can you please tell me what do I need to do on my minimum CentOS OS server without any panel and running MariaDB mysql Ver 15.1 Distrib 10.2.24-MariaDB.
Regards,
Faraz
Comment