Good morning, I hope to receive help since I can not solve the problem.
I am trying to connect from exim to proxysql but I am getting the following error:
ProxySQL Admin> SELECT hostgroup_id, hostname, port, status FROM mysql_servers;
+--------------+-------------+------+--------+
| hostgroup_id | hostname | port | status |
+--------------+-------------+------+--------+
| 1 | 172.17.54.2 | 3306 | ONLINE |
+--------------+-------------+------+--------+
1 row in set (0,00 sec)
When I test the connection from the console I do not see errors. Some help please.
[root@c233a ~] # mysql -usqlmonitor -p9cCnX7NigY99 -h 127.0.0.1 -P6033 -e "SELECT @@hostname";
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------------------+
| @@hostname |
+-------------------------+
| mysqlfz04.linux.backend |
+-------------------------+
ProxySQL Admin> SELECT * FROM monitor.mysql_server_ping_log ORDER BY time_start_us DESC LIMIT 10;
+-------------+------+------------------+----------------------+------------+
| hostname | port | time_start_us | ping_success_time_us | ping_error |
+-------------+------+------------------+----------------------+------------+
| 172.17.54.2 | 3306 | 1629480008967131 | 322 | NULL |
| 172.17.54.2 | 3306 | 1629480006990121 | 509 | NULL |
| 172.17.54.2 | 3306 | 1629480004982443 | 516 | NULL |
| 172.17.54.2 | 3306 | 1629480002991257 | 521 | NULL |
| 172.17.54.2 | 3306 | 1629480000992403 | 514 | NULL |
| 172.17.54.2 | 3306 | 1629479998977638 | 450 | NULL |
| 172.17.54.2 | 3306 | 1629479997005232 | 421 | NULL |
| 172.17.54.2 | 3306 | 1629479994970232 | 651 | NULL |
| 172.17.54.2 | 3306 | 1629479992974443 | 224 | NULL |
| 172.17.54.2 | 3306 | 1629479990987309 | 404 | NULL |
+-------------+------+------------------+----------------------+------------+
10 rows in set (0,00 sec)
Regards,