On 2021-08-21, SysAdmin EM via Exim-users <exim-users@exim.org> 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/