Re: [exim] Differences exim 4.93 and 4.94

Góra strony
Delete this message
Reply to this message
Autor: SysAdmin EM
Data:  
Dla: exim-users
Temat: Re: [exim] Differences exim 4.93 and 4.94
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,
>
>