Hi to all, i have a mail server with virtual accounts for 3 domains. It is based on: gentoo with postfix-2.2.10, amavisd-new-2.4.1, PostgreSQL-8.0.9-r1, clamav-0.90, spamassassin-3.1.3 and courieri-imap-4.0.4. I have a db amavis where all the spam and virus messages are saved, BUT only the spam goes there. When i receive virus message the following error is received:
Feb 26 13:29:36 dexter postfix/lmtp[11136]: BBB7D8DBD9: to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=2, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=11138-01, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id M+ECNSAIM2Mb failed: writing mail text to SQL failed: Error closing, flush: sql inserting text failed, sql exec: err=7, 22P02, DBD::Pg::st execute failed: ERROR: invalid input syntax for type bytea at (eval 64) line 177. at (eval 64) line 68. at (eval 64) line 293., id=11138-01 at /usr/sbin/amavisd line 8525. (in reply to end of DATA command)) The configuration of the MTA is based on http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System and the amavis DB is based on this script http://www.ijs.si/software/amavisd/README.sql.txt as is described there the quarantine.mail_text field type is bytea, and from the beginning it was in this type. All the messages that are temporarily rejected are saved in /var/amavis/tmp and the current size of this directory is 1.3GB for one week working of the server. Please help i don't have enough hard disk space for leaving this error :) (joke) The other thing that I'm thinking about is to stop put quarantine in SQL DB and make amavis to store them in one administrator account, but i prefer to use the database. Thanks a lot for any help and be sure that it will be greatly appreciated. Best regards, Niki -- Cyberly yours, Nikolay Balov mail: [EMAIL PROTECTED] Linux Registered User #382280 http://keyserver.linux.it/ Key fingerprint = D80E A05B 5727 B40C 7431 2CC0 0845 E79E 428A 1109 -- Cyberly yours, Nikolay Balov mail: [EMAIL PROTECTED] Linux Registered User #382280 http://keyserver.linux.it/ Key fingerprint = D80E A05B 5727 B40C 7431 2CC0 0845 E79E 428A 1109 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ 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/
