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 <emaw...@gmail.com> 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, > > -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/