Re: amavisd-new with postgresql help

2023-06-14 Thread Christoph Moench-Tegeder
## Benny Pedersen (m...@junc.eu): > $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr WHERE > (wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN > (%k)) ORDER BY mailaddr.priority DESC'; > Jun 14 21:46:02 localhost postgres[22001]: [7-1] 2023-06-14 > 19:46:02.275 UTC

amavisd-new with postgresql help

2023-06-14 Thread Benny Pedersen
@lookup_sql_dsn = ( ['DBI:Pg:database=amavis;host=127.0.0.1;port=5432', 'amavis', 'password' ] ); @storage_sql_dsn = @lookup_sql_dsn; $sql_select_policy = 'SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (%k)) ORDER BY users.priority DESC'; $sql_s