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,
