@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_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';
%sql_clause = (
'sel_policy' => \$sql_select_policy,
'sel_wblist' => \$sql_select_white_black_list,
);
@sa_userconf_maps = (
{
'.*' => 'sql:',
}
);
@sa_username_maps = new_RE (
[ qr'^([^@]+@.*)'i => '${1}' ]
);
@spam_scanners = (
# ['SpamAssassin', 'Amavis::SpamControl::SpamAssassin']
['SpamdClient', 'Amavis::SpamControl::SpamdClient']
);
1; # insure a defined return value
logs
Jun 14 21:46:02 localhost postgres[22001]: [7-1] 2023-06-14 19:46:02.275
UTC [22001] ERROR: operator does not exist: bytea = character varying
at character 88
Jun 14 21:46:02 localhost postgres[22001]: [7-2] 2023-06-14 19:46:02.275
UTC [22001] HINT: No operator matches the given name and argument
types. You might need to add explicit type casts.
Jun 14 21:46:02 localhost postgres[22001]: [7-3] 2023-06-14 19:46:02.275
UTC [22001] STATEMENT: SELECT *,users.id FROM users,policy WHERE
(users.policy_id=policy.id) AND (users.email IN ($1,$2,$3,$4,$5,$6))
ORDER BY users.priority DESC
yes it worked in fuglu as i liked it, but have to drop fuglu since its
nearly unmaintained in gentoo :/
hope i can get amavisd and mailzu working as it did for me some years
ago
postgresql 13
amavisd 2.12
