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
Hello good morning everyone.

[root@c233a ~] # /opt/exim/bin/exim -be '${lookup
mysql{servers=127.0.0.1::6033/c233/sqlmonitor/9cCnX7NigY99;
select 1+1 }}'
2

I think that the connection to proxysql is not failing, but some queries
that I execute from exim fail but if I execute them directly from the
console, no, here are some logs.

###

/opt/exim/bin/exim -d+lookup -be '${lookup
mysql{servers=127.0.0.1::6033/c233/sqlmonitor/password;
SELECT domain FROM eximdomains WHERE active=1 AND domain='
feudaleyasociados.com.ar'}}'

https://pastecode.io/s/jc85ovhb

The error it indicates is: gave DEFER: MYSQL: query failed: Unknown column '
feudaleyasociados.com.ar' in 'where clause'

I make the query from proxysql the result is successful:

[root@c233a ~] # mysql -usqlmonitor -p9cCnX7NigY99 -h 127.0.0.1 -P6033 c233
-e "SELECT domain FROM eximdomains WHERE active=1 AND domain='feudaleyas
ociados.com.ar'";
mysql: [Warning] Using a password on the command line interface can be
insecure.
+--------------------------+
| domain                   |

+--------------------------+
| feudaleyasociados.com.ar |

+--------------------------+

It might be a problem from exim?

Regards,