Хосты удаленного доступа к MySQL в cPanel & amp; MySQL Governor
Форум
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Faraz
  2. Tuesday, 11 June 2019
  3.  Subscribe via email
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] Can't 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
Rate this post:
  1. 11.06.2019 19:06:23
  2. # 1
Sergey Khristich Accepted Answer
Posts: 88
Joined: 20.05.2019
0
Votes
Undo
Hello Faraz,
Our technical support team completed your request.
Please let us know if you have any questions.
Thanks in advance!
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
гость
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.