i am using pgsql to manage my mail server, and i can't get amavis to
work with that.
the how-to i followed is for mysql:
http://workaround.org/articles/ispmail-sarge/
so he has this:
'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k)';
in may talks, i adopted this for pgsql:
$sql_select_policy = "SELECT 'Y' as local FROM mail_domains WHERE
'@'||domain IN (%k)";
Oct 5 17:56:40 localhost amavis[8984]: (08984-01-8) lookup_sql: -1,
called with 3 bind variables when 0 are needed
Oct 5 17:56:40 localhost amavis[8984]: (08984-01-8) TROUBLE in
check_mail: creating_partsdir FAILED: DBD::Pg::st execute failed: called
with 3 bind variables when 0 are needed at (eval 38) line 238, <GEN16>
line 40.
Oct 5 17:56:40 localhost amavis[8984]: (08984-01-8) PRESERVING EVIDENCE
in /var/lib/amavis/amavis-20051005T175640-08984
Oct 5 17:56:40 localhost postfix/lmtp[9005]: E5272C535E:
to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=-760,
status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in
processing, id=08984-01-8, creating_partsdir FAILED: DBD::Pg::st execute
failed: called with 3 bind variables when 0 are needed at (eval 38) line
238, <GEN16> line 40. (in reply to end of DATA command))
anyone can risk a solution?
best regards
Luis Matos
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
