Re: [exim] Database lookup tainted

Góra strony
Delete this message
Reply to this message
Autor: daniel
Data:  
Dla: Jeremy Harris, exim-users
Temat: Re: [exim] Database lookup tainted
Thanks, changing the syntax for the pgsql server/credentials did the trick!

2. Juni 2020 16:37, "Jeremy Harris via Exim-users" <exim-users@???> schrieb:

> On 02/06/2020 15:29, daniel@??? wrote:
>
>> The only thing I replaced is database name, database user and password.
>>
>> so it is "127.0.0.1/mail/mailro/mysupersecretpassword"
>> (password obviously changed), it doesn't say anything else...
>>
>> Pasting the full line here again:
>> message: failed to expand "${lookup pgsql {servers=127.0.0.1/xx/xx/xx; SELECT string_agg(DISTINCT
>> userid,',') AS target FROM aliases WHERE address='${quote_pgsql:$local_part@$domain}';}}": lookup
>> of "servers=127.0.0.1/xx/xx/xx; SELECT string_agg(DISTINCT userid,',') AS target FROM aliases WHERE
>> address='xx@xxxx';" gave DEFER: PostgreSQL server "127.0.0.1/xx/xx/xx" is tainted
>
> So something in that database-server specification is tainted.
>
> Per
> http://exim.org/exim-html-current/doc/html/spec_html/ch-file_and_database_lookups.html#SECTspeserque
>
> the preferred syntax is now to place the server spec directly after
> the lookup type:
>
> ${lookup pgsql,servers=master/db/name/pw {UPDATE ...} }
>
> --
> Cheers,
> Jeremy
>
> --
> ## 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