On 2021-08-21, SysAdmin EM via Exim-users <[email protected]> wrote:
> 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
Sorry, I handed you bad syntax try this:
/opt/exim/bin/exim -be '${lookup
mysql{servers=127.0.0.1::6033/c233/sqlmonitor/9cCnX7NigY99; select 1+1 }'
If that password was an important secret sorry about that too.
If it works you should get "2" as the result. so then try without the
"servers=127.0.0.1::6033/c233/sqlmonitor/9cCnX7NigY99;" part to cinfirm
that the config file is working.
you can also try adding debug flags before the -be
-d+lookup
which will give more diagnostics on the connection to mysql.
--
Jasen.
--
## 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/
