I try to make a connection but I see the following error:
/opt/exim/bin/exim -be '${lookup
mysql{servers=127.0.0.1::6033/c233/sqlmonitor/9cCnX7NigY99
select 1+1 }'
Failed: lookup of "servers=127.0.0.1::6033/c233/sqlmonitor/9cCnX7NigY99
select 1+1 " gave DEFER: missing ; after "servers=" in MySQL lookup
in the proxysql logs I see this but if I do a connection test it works
correctly.
2021-08-20 14:13:59
MySQL_Session.cpp:1404:handler_again___status_PINGING_SERVER(): [ERROR]
Detected a broken connection during ping on (1,172.17.54
.2,3306) , FD (Conn:29 , MyDS:29) : 2013, Lost connection to MySQL server
during query
2021-08-20 14:13:59
MySQL_Session.cpp:1404:handler_again___status_PINGING_SERVER(): [ERROR]
Detected a broken connection during ping on (1,172.17.54
.2,3306) , FD (Conn:28 , MyDS:28) : 2013, Lost connection to MySQL server
during query
########################################################################
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 -ppassword -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)
I don't know how to debug the complete exim connection since when I run
/opt/exim/bin/exim -bd -d I don't see connection errors to proxysql.
Any ideas??
Regards,
On Fri, Aug 20, 2021 at 9:13 AM SysAdmin EM <emawata@???> wrote:
> I am installing proxysql as a local cache. In a laboratory the connection
> between exim and proxysql works correctly.
>
> hide mysql_servers = 127.0.0.1::6033/database/user/pass
>
> ### Testing Server ###
>
> [root@centos7 ~] # /opt/exim/bin/exim -bV
> Exim version 4.94 #2 built 03-Aug-2020 15:07:07
> Copyright (c) University of Cambridge, 1995 - 2018
> (c) The Exim Maintainers and contributors in ACKNOWLEDGMENTS file, 2007 -
> 2018
> Berkeley DB: Berkeley DB 5.3.21: (May 11, 2012)
> Support for: crypteq iconv() IPv6 Perl OpenSSL Content_Scanning DKIM
> DNSSEC Event PIPE_CONNECT PRDR SPF TCP_Fast_Open
> Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch dbm dbmjz
> dbmnz mysql
> Authenticators: cram_md5 plaintext spa
> Routers: accept dnslookup ipliteral manualroute queryprogram redirect
> Transports: appendfile/maildir autoreply pipe smtp
> Malware: f-protd f-prot6d drweb fsecure sophie clamd avast sock cmdline
> Fixed never_users: 0
> Configure owner: 0:0
> Size of off_t: 8
> Configuration file is /etc/exim/configure
>
> ### Production Server ###
>
> In the server in production we use a version prior to exim and I cannot
> make the connection to proxysql work.
>
> Exim version 4.93 #5 built 18-Dec-2019 13:45:23
> Copyright (c) University of Cambridge, 1995 - 2018
> (c) The Exim Maintainers and contributors in ACKNOWLEDGMENTS file, 2007 -
> 2018
> Berkeley DB: Berkeley DB 5.3.21: (May 11, 2012)
> Support for: crypteq iconv() IPv6 Perl OpenSSL Content_Scanning DKIM
> DNSSEC Event PRDR SPF TCP_Fast_Open
> Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch dbm dbmjz
> dbmnz mysql
> Authenticators: cram_md5 plaintext spa
> Routers: accept dnslookup ipliteral manualroute queryprogram redirect
> Transports: appendfile/maildir autoreply pipe smtp
> Malware: f-protd f-prot6d drweb fsecure sophie clamd avast sock cmdline
> Fixed never_users: 0
> Configure owner: 0:0
> Size of off_t: 8
> Configuration file is /etc/exim/configure
>
> Are there many differences between the exim versions? Any suggestion?
>
> Regards,
>
>
