On Wed, November 1, 2006 11:42, _AA_ wrote: > Originally posted here: http://forums.gentoo.org/viewtopic-t-512336.html
not much there > Hope someone can help me with this. > > Setup > AMD64, postfix, mysql, courierauth, amavis, spamassassin and clamav > doing virtual mailboxes. send it to me, i might get something out of it :-) > Now the mail system works perfectly until I add amavis. good > This is what happens once amavis is thrown into the equation: > > elvira ~ # telnet 127.0.0.1 10024 > Trying 127.0.0.1... > Connected to 127.0.0.1. > Escape character is '^]'. > 220 [127.0.0.1] ESMTP amavisd-new service ready > ehlo localhost > 250-[127.0.0.1] > 250-VRFY > 250-PIPELINING > 250-SIZE > 250-ENHANCEDSTATUSCODES > 250-8BITMIME > 250-DSN > 250 XFORWARD NAME ADDR PROTO HELO > MAIL FROM: <[EMAIL PROTECTED]> > 250 2.1.0 Sender [EMAIL PROTECTED] OK > RCPT TO: <[EMAIL PROTECTED]> > 421 4.3.2 Service shutting down, closing channel > Connection closed by foreign host. > elvira ~ # > > SMTP error code 421: The service is not available and the connection > will be closed. > > In /var/log/messages : > > elvira amavis[5281]: (05281-01) (!) lookup_sql: sql exec: err=1146, > S1000, DBD::mysql::st execute failed: Table 'vmail_db.policy' doesn't > exist at (eval 38) line 138, line 3., 1146, Table 'vmail_db.policy' > doesn't exist > Oct 31 22:05:17 elvira amavis[5281]: (05281-01) (!!) TROUBLE in > process_request: sql exec: err=1146, S1000, DBD::mysql::st execute > failed: Table 'vmail_db.policy' doesn't exist at (eval 38) line 138, > line 3. at (eval 41) line 262, line 3. > Oct 31 22:05:17 elvira amavis[5281]: (05281-01) (!) Requesting > process rundown after fatal error > Oct 31 22:05:17 elvira amavis[5336]: TIMING [total 5 ms] - bdb-open: > 5 (100%)100, rundown: 0 (0%)100 > >>From /etc/amavisd.conf > > @lookup_sql_dsn = > ( ['DBI:mysql:database=vmail_db;host=127.0.0.1;port=3306', > 'vmail_user', 'vmail_password'] ); try removeing the lookup_sql_dsn until we know that amavisd works read after that README.sql from amavisd tarball more closely > Why is it looking for a policy table when I have not set up per > recipient policies? you have when you put lookup_sql_dns > Any help would be muchly appreciated. Ta. and friends :-) > P.S. I followed this guide (amongst others): > http://gentoo-wiki.com/HOWTO_Spam_Filtering_with_Gentoo,_Postfix,_Amavis nice guide -- "This message was sent using 100% recycled spam mails." ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
