[AMaViS-user] forward SPAM for few domains
Hello, is there some way how to setup forwarding mails marked as SPAM for some domains to one user (spam for domains @example.com, @example2.com, @example3.com, ... forward to s...@example.com) ? Thank you for advices and help. -- Lampa -- ___ 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/
Re: [AMaViS-user] amavis corrupt db
This triggered me in your logfile: "The table 'quarantine' is full" Google it and you'll find: http://dev.mysql.com/doc/refman/5.0/en/full-table.html Regards, Alrik On Thu, Apr 29, 2010 at 12:25 AM, troxlinux wrote: > Hi list, I want to comment something very strange, configure a new > server with amavisd-new 2.6.4 and mysql with mailzu, all well for a > couple of days, then I see that some messages didn't come out and the > server sent error in the chart msg of amavisd-new > > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) SEND via SQL > (DBI:mysql:database=amavisd_db;host=127.0.0.1;port=3306): > -> > ,, mail_id 50035po2-Vo4 > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) _WARN: [32470] > Amavis::IO::SQL::close error: Error closing, flush: sql inserting text > failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The > table 'quarantine' is full at (eval 110) line 166, line > 144717. at (eval 112) line 250, line 144717. at (eval 112) > line 113, line 144717. at (eval 112) line 88, line > 144717. > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) writing mail text > to SQL failed: print: sql inserting mail text failed, sql exec: > err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' > is full at (eval 110) line 166, line 144717. at (eval 112) > line 286, line 144717. > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) mail_via_sql: rollback > done > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!!)TROUBLE in > check_mail: quar+notif FAILED: temporarily unable to quarantine: 451 > 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail > text to SQL failed: print: sql inserting mail text failed, sql exec: > err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' > is full at (eval 110) line 166, line 144717. at (eval 112) > line 286, line 144717. at (eval 112) line 387, line > 144717., id=32470-16 at /usr/sbin/amavisd line 12613, line > 144717. > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!)PRESERVING > EVIDENCE in /var/spool/amavis/tmp/amavis-20100428T105045-32470 > Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) TIMING [total 347 > ms] - SMTP greeting: 1 (0%)0, SMTP LHLO: 0 (0%)0, SMTP pre-MAIL: 0 > (0%)1, lookup_sql: 2 (0%)1, lookup_sql: 1 (0%)1, SMTP pre-DATA-flush: > 1 (0%)1, SMTP DATA: 86 (25%)26, check_init: 0 (0%)26, digest_hdr: 1 > (0%)27, digest_body_dkim: 9 (3%)29, sql-enter: 113 (33%)62, > mime_decode: 61 (18%)79, get-file-type3: 10 (3%)82, parts_decode: 0 > (0%)82, check_header: 1 (0%)83, AV-scan-1: 9 (3%)85, spam-wb-list: 2 > (1%)86, update_cache: 1 (0%)86, decide_mail_destiny: 1 (0%)86, > notif-quar: 2 (0%)87, write-header: 2 (1%)88, fwd-sql: 38 (11%)99, > SMTP pre-response: 1 (0%)99, SMTP response: 3 (1%)100, rundown: 1 > (0%)100 > Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: > to=, relay=127.0.0.1[127.0.0.1]:10024, > delay=529, delays=529/0.01/0/0.34, dsn=4.5.0, status=deferred (host > 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, > quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing > to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL > failed: print: sql inserting mail text failed, sql exec: err=1114, > HY000, DBD::mysql::st execute failed: The table 'quarantine' is full > at (eval 110) line 166, line 144717. at (eval 112) line 286, > line 144717. at (eval 112) line 387, line 144717., > id=32470-16 at /usr/sbin/amavisd line 12613, lin 451 4.5.0 e > 144717. (in reply to end of DATA command)) > Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: > to=, relay=127.0.0.1[127.0.0.1]:10024, > delay=529, delays=529/0.01/0/0.48, dsn=4.5.0, status=deferred (host > 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, > quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing > to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL > failed: print: sql inserting mail text failed, sql exec: err=1114, > HY000, DBD::mysql::st execute failed: The table 'quarantine' is full > at (eval 110) line 166, line 144717. at (eval 112) line 286, > line 144717. at (eval 112) line 387, line 144717., > id=32470-16 at /usr/sbin/amavisd line 12613, lin 451 4.5.0 e > 144717. (in reply to end of DATA command)) > Apr 28 12:21:53 lentesnic postfix/smtpd[1770]: connect from > ppp-203-225.21-151.libero.it[151.21.225.203] > > I check mysql, postfix, amavisd-new and all these services are running > well , somebody in the list that wants to shake hands me with this > problem, for my this problem is ignored > > regardss > > > -- > rickygm > > http://gnuforever.homelinux.com > > > -- > ___ > 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-HowT
Re: [AMaViS-user] How to get any mail from quarantine
On 4/28/10, osmcr...@gmail.com wrote: > Hello, > > i want to get some of my quarantained mails off quarantine that why amavis > is marking some legitimate emails as spam > > The quarantine-directory is /var/lib/amavis/virusmails/--- > > There are the maildir-files. > > amavisd-release do not have any manpages. > How do i release the mails from quarantine. > > Any idea what I could do to re-injectect these emails into the system ? > > > > Thanks, http://www.ijs.si/software/amavisd/amavisd-new-docs.html#quar-release http://www.freespamfilter.org/forum/viewtopic.php?f=7&t=380&p=2066 -- Gary V -- ___ 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/
Re: [AMaViS-user] How to get any mail from quarantine
On 29 Apr 2010, at 01:32, osmcr...@gmail.com wrote: > Hello, > > i want to get some of my quarantained mails off quarantine that why amavis > is marking some legitimate emails as spam > > The quarantine-directory is /var/lib/amavis/virusmails/--- > > There are the maildir-files. > > amavisd-release do not have any manpages. > How do i release the mails from quarantine. > > Any idea what I could do to re-injectect these emails into the system ? > In my system, amavisd-new sends a me a report about all quarantined mail. Somewhere in that report it will say something like: The message has been quarantined as: virus/123456789abcd.gz You may need to cd to /var/lib/amavis/virusmails/ and then issue the command 'amavisd-release virus/123456789abcd.gz' The mail should then be released to it's original recipient, provided amavisd-release has been set up correctly. Hope this helps you. Robert. -- ___ 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/
[AMaViS-user] How to get any mail from quarantine
Hello, i want to get some of my quarantained mails off quarantine that why amavis is marking some legitimate emails as spam The quarantine-directory is /var/lib/amavis/virusmails/--- There are the maildir-files. amavisd-release do not have any manpages. How do i release the mails from quarantine. Any idea what I could do to re-injectect these emails into the system ? Thanks, -- ___ 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/
[AMaViS-user] amavis corrupt db
Hi list, I want to comment something very strange, configure a new server with amavisd-new 2.6.4 and mysql with mailzu, all well for a couple of days, then I see that some messages didn't come out and the server sent error in the chart msg of amavisd-new Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) SEND via SQL (DBI:mysql:database=amavisd_db;host=127.0.0.1;port=3306): -> ,, mail_id 50035po2-Vo4 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) _WARN: [32470] Amavis::IO::SQL::close error: Error closing, flush: sql inserting text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, line 144717. at (eval 112) line 250, line 144717. at (eval 112) line 113, line 144717. at (eval 112) line 88, line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, line 144717. at (eval 112) line 286, line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) mail_via_sql: rollback done Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!!)TROUBLE in check_mail: quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, line 144717. at (eval 112) line 286, line 144717. at (eval 112) line 387, line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!)PRESERVING EVIDENCE in /var/spool/amavis/tmp/amavis-20100428T105045-32470 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) TIMING [total 347 ms] - SMTP greeting: 1 (0%)0, SMTP LHLO: 0 (0%)0, SMTP pre-MAIL: 0 (0%)1, lookup_sql: 2 (0%)1, lookup_sql: 1 (0%)1, SMTP pre-DATA-flush: 1 (0%)1, SMTP DATA: 86 (25%)26, check_init: 0 (0%)26, digest_hdr: 1 (0%)27, digest_body_dkim: 9 (3%)29, sql-enter: 113 (33%)62, mime_decode: 61 (18%)79, get-file-type3: 10 (3%)82, parts_decode: 0 (0%)82, check_header: 1 (0%)83, AV-scan-1: 9 (3%)85, spam-wb-list: 2 (1%)86, update_cache: 1 (0%)86, decide_mail_destiny: 1 (0%)86, notif-quar: 2 (0%)87, write-header: 2 (1%)88, fwd-sql: 38 (11%)99, SMTP pre-response: 1 (0%)99, SMTP response: 3 (1%)100, rundown: 1 (0%)100 Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.34, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, line 144717. at (eval 112) line 286, line 144717. at (eval 112) line 387, line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.48, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, line 144717. at (eval 112) line 286, line 144717. at (eval 112) line 387, line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:53 lentesnic postfix/smtpd[1770]: connect from ppp-203-225.21-151.libero.it[151.21.225.203] I check mysql, postfix, amavisd-new and all these services are running well , somebody in the list that wants to shake hands me with this problem, for my this problem is ignored regardss -- rickygm http://gnuforever.homelinux.com -- ___ 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/
Re: [AMaViS-user] getting policy fired on email from SQL
On Apr 28, 2010, at 4:46 PM, Michael Scheidell wrote: > > On 4/28/10 10:37 AM, Jernej Porenta wrote: >> Heya, >> >> I was wondering whether there is a way to find out with SQL query from >> amavis database, which emails were sent through SA and which were not. I >> know that it depends on the policy, but is there a way to combine policy >> with msgs table? >> >> > anything in the msgs table was sent through amavisd. > You might write a sql query that does a double join on msgs, msgrcpt, > and maddr to get everything you want. I am looking for emails that were sent through spam scanner in amavis (SA), not just amavis. This means that I need to find out which emails were spam scanned and which weren't (by setting bypass_spam in policy). I could do analyze logs for this, but it would be way more appropriate using SQL, but I dont know whether this information is actually stored in SQL or not. regards,Jernej -- ___ 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/
Re: [AMaViS-user] getting policy fired on email from SQL
On 4/28/10 10:37 AM, Jernej Porenta wrote: > Heya, > > I was wondering whether there is a way to find out with SQL query from amavis > database, which emails were sent through SA and which were not. I know that > it depends on the policy, but is there a way to combine policy with msgs > table? > > anything in the msgs table was sent through amavisd. You might write a sql query that does a double join on msgs, msgrcpt, and maddr to get everything you want. -- Michael Scheidell, CTO Phone: 561-999-5000, x 1259 > *| *SECNAP Network Security Corporation * Certified SNORT Integrator * 2008-9 Hot Company Award Winner, World Executive Alliance * Five-Star Partner Program 2009, VARBusiness * Best Anti-Spam Product 2008, Network Products Guide * King of Spam Filters, SC Magazine 2008 __ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.secnap.com/products/spammertrap/ __ -- ___ 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/
[AMaViS-user] getting policy fired on email from SQL
Heya, I was wondering whether there is a way to find out with SQL query from amavis database, which emails were sent through SA and which were not. I know that it depends on the policy, but is there a way to combine policy with msgs table? Filtering out spam_level = 0 is not the way, since some of the emails might get the score 0. policy field in msgs table is not representing the policy used for email, so the only way that I can think of is, parsing the logs for 'Hits: -,' and combining results from SQL. Since Mark is on vacation, does anyone knows how to get this information? thank you in advance, regards, Jernej -- ___ 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/