Hi Luis and list Em Qui, 2009-07-23 às 19:15 -0500, Luis Daniel Lucio Quiroz escreveu: > Le jeudi 23 juillet 2009 15:20:29, paulobruck1 a écrit : > > Hi Luis and list > > > > Em Qui, 2009-07-23 às 13:32 -0500, Luis Daniel Lucio Quiroz escreveu: > > > Le jeudi 23 juillet 2009 10:10:32, paulobruck1 a écrit : > > > > Hi list > > > > > > > > environnment: > > > > debian lenny 5.0 > > > > amavisd-new 2.6.3-3 > > > > postfix 2.5.5-1.1 > > > > clamav-base 0.95.2 > > > > spamassassin 3.2.5-2 > > > > mysql 5.0.51a-24+lenny1 > > > > mailzu 0.83 > > > > > > > > Well amavis+mailzu+postfix are working ( not 100% but working 8) > > > > Spam/bad_headers and virus are already into mysql and do not go to > > > > final user unless postmaster releases. > > > > > > > > I would like to maintain a copy of clean email in mysql to. > > > > > > > > I've been reading from: > > > > http://www.engardelinux.org/modules/index/list_archives.cgi?list=amavis > > > >&pag e=0074.html&month=2007-10 > > > > http://groups.google.com/group/mailing.unix.amavis-user/msg/d5ff7d657a1 > > > >209f f?pli=1 amavisd-new/amavisd-new-docs.html#checks > > > > > > > > ----cut----- > > > > It is also possible to enable > > > > quarantining of clean messages for archiving or troubleshooting > > > > purposes." > > > > ________________ > > > > > > > > but as I'm not native ,I'm not sure what I have to do to have a copy of > > > > all clean messages at amavis+mysql. > > > > > > > > Any clues??? > > > > > > > > part of my amavis: > > > > > > > > use strict; > > > > $log_level = 1; > > > > $sql_allow_8bit_address = 1; > > > > $mydomain = 'xxx.com.br'; > > > > $myhostname = 'xxx.xxx.com.br'; > > > > $mailfrom_notify_admin = "postmast...@$mydomain"; > > > > $mailfrom_notify_recip = "postmast...@$mydomain"; > > > > $mailfrom_notify_spamadmin = "postmast...@$mydomain"; > > > > $hdrfrom_notify_sender = "amavisd-new <postmast...@$mydomain>"; > > > > $notify_method = 'smtp:[127.0.0.1]:10035'; # where to submit > > > > notifications > > > > $max_servers = 2; > > > > $final_virus_destiny = D_DISCARD; > > > > $final_banned_destiny = D_BOUNCE; > > > > $final_spam_destiny = D_DISCARD; > > > > $final_bad_header_destiny = D_PASS; > > > > $enable_dkim_verification = 0; # enable DKIM signatures verification > > > > $enable_dkim_signing = 0; # load DKIM signing code, keys defined by > > > > dkim_key > > > > $bad_header_quarantine_to = undef; > > > > $sa_spam_subject_tag = 'Spam> '; > > > > $sa_tag_level_deflt = undef; > > > > $sa_tag2_level_deflt = 6.31;@virus_admin_maps = ({ > > > > '.xxx.com.br' => 'postmas...@xxx.com.br', > > > > '.example.net' => 'postmas...@example.net', > > > > '.' => 'postmas...@xxx.com.br', > > > > }); > > > > @banned_admin_maps = ({ > > > > '.xxx.com.br' => 'postmas...@xxx.com.br', > > > > '.example.net' => 'postmas...@example.net', > > > > '.' => 'postmas...@xxx.com.br', > > > > }); > > > > $warnbannedrecip = 1; > > > > $defang_banned = 1; > > > > $defang_virus = 1; > > > > $penpals_bonus_score = 5; > > > > $penpals_threshold_low = 1; > > > > $penpals_threshold_high = 18; > > > > @mynetworks = qw( 127.0.0.0/8 [::1] [FE80::]/10 [FEC0::]/10 > > > > 172.16.0.0/24 192.168.1.0/24 ); > > > > $inet_socket_port = [10024, 10026, 9998]; > > > > $inet_socket_bind = undef; > > > > $interface_policy{'9998'} = 'MAILZU'; > > > > $policy_bank{'MAILZU'} = { > > > > protocol => 'AM.PDP', > > > > inet_acl => [qw( 127.0.0.1 [::1] 192.168.1.1 xxx.207.xxx.76)], > > > > }; > > > > > > > > $sa_kill_level_deflt = 5; > > > > > > > > > > > > $banned_files_quarantine_method = 'sql:'; > > > > $spam_quarantine_method = 'sql:'; > > > > %banned_rules = ( > > > > 'BLOCK_EXE' => new_RE( > > > > # block double extensions in names: > > > > qr'\.[^./]*\.(exe|vbs|pif|scr|bat|cmd|com|cpl|dll)\.?$'i, > > > > # allow any name or type (except viruses) within an archive: > > > > [ qr'^\.(Z|gz|bz2|rpm|cpio|tar|zip|rar|arc|arj|zoo)$' => 0], > > > > # blocks MS executable file(1) types, unless allowed above: > > > > qr'^\.(exe|exe-ms)$', > > > > ), > > > > 'DEFAULT' => $banned_filename_re, > > > > ); > > > > $policy_bank{'MYNETS'} = { # mail originating from @mynetworks > > > > originating => 1, > > > > os_fingerprint_method => undef, > > > > spam_admin_maps => ["postmast...@$mydomain"], # alert of internal > > > > spam > > > > final_spam_destiny => D_BOUNCE, # so the sender knows they are a > > > > spammer > > > > spam_kill_level_maps => [9.0], > > > > spam_dsn_cutoff_level_maps => [9999], > > > > spam_dsn_cutoff_level_bysender_maps => [9999], > > > > banned_filename_maps => ['BLOCK_EXE'], > > > > };$interface_policy{'10026'} = 'TRUSTED'; > > > > $policy_bank{'TRUSTED'} = { # mail originating from trusted senders > > > > originating => 1, > > > > os_fingerprint_method => undef, > > > > spam_admin_maps => ["postmast...@$mydomain"], # alert of internal > > > > spam > > > > final_spam_destiny => D_BOUNCE, # so the sender knows they are a > > > > spammer > > > > spam_kill_level_maps => [9.0], > > > > spam_dsn_cutoff_level_maps => [9999], > > > > spam_dsn_cutoff_level_bysender_maps => [9999], > > > > banned_filename_maps => ['BLOCK_EXE'], > > > > }; > > > > @lookup_sql_dsn = ( ['DBI:mysql:amavis:localhost', 'amavis', > > > > 'amavis'] ); > > > > @storage_sql_dsn = @lookup_sql_dsn; > > > > $quarantine_subdir_levels = undef; > > > > $timestamp_fmt_mysql = 1; > > > > 1; # ensure a defined return > > > > > > > > > > > > rest of it is debian default files > > > > > > > > > > > > > > > > ----------------------------------------------------------------------- > > > >---- --- _______________________________________________ > > > > 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/ > > > > > > Hi Paulo, > > > > > > well , i have same configuration and it seems that amavis logs messages > > > (HAMones). > > > > > > Look in your msgs table. > > > > nope....8( > > > > at msgs table I have ( cleaned amavis table and send 3 email. teste1 > > without spam/virus, teste2 w/ spam, teste3 w/ virus... > > > > ################################### > > mysql> select * from msgs; > > +---------------+--------------+--------------+----------+------------+---- > >------------+-----+------- > > -+--------------+------+---------+-----------+--------------------+-------- > >--+------------+---------- > > --------------------------------------------+------------------------------ > >------+----------------+-- -------------------------+ > > > > | partition_tag | mail_id | secret_id | am_id | time_num | > > > > time_iso | sid | policy > > > > | client_addr | size | content | quar_type | quar_loc | > > > > dsn_sent | spam_level | message_i > > d | from_addr > > > > | subject | h > > > > ost | > > +---------------+--------------+--------------+----------+------------+---- > >------------+-----+------- > > -+--------------+------+---------+-----------+--------------------+-------- > >--+------------+---------- > > --------------------------------------------+------------------------------ > >------+----------------+-- -------------------------+ > > > > | 0 | 12EoTIUJg7Al | z1GVm3MRFuhN | 05650-03 | 1248378334 | > > > > 20090723194534 | 32 | > > > > | 64.34.197.77 | 1649 | S | Q | 12EoTIUJg7Al | N > > | > > | 1000.05 | <12483783 > > > > 27.4036.58.ca...@pauloric.contatogs.com.br> | pauloric > > <paulo...@contato.com.br> | teste2 - spam | c > > erberus.contatogs.com.br | > > > > | 0 | 17ERfAjnqzCh | zrbk+7MsS0EW | 05651-02 | 1248378286 | > > > > 20090723194446 | 32 | > > > > | 64.34.197.77 | 1081 | M | | | N > > | > > | 0.053 | <12483782 > > > > 70.4036.56.ca...@pauloric.contatogs.com.br> | pauloric > > <paulo...@contato.com.br> | teste1 | c > > erberus.contatogs.com.br | > > > > | 0 | GZ8yKEfZvG0t | 3Mt8n+Qn3c73 | 05651-03 | 1248378361 | > > > > 20090723194601 | 32 | > > > > | 64.34.197.77 | 1941 | V | F | virus-GZ8yKEfZvG0t | N > > | > > | 0 | <12483783 > > > > 53.4036.60.ca...@pauloric.contatogs.com.br> | pauloric > > <paulo...@contato.com.br> | teste3 - eicar | c > > erberus.contatogs.com.br | > > +---------------+--------------+--------------+----------+------------+---- > >------------+-----+------- > > -+--------------+------+---------+-----------+--------------------+-------- > >--+------------+---------- > > --------------------------------------------+------------------------------ > >------+----------------+-- ################################### > > > > > > > > remembering that I would like to insert at amavis database a copy of all > > email that passed as clean..... > > > > thanks for helping > > > > > ------------------------------------------------------------------------- > > >----- _______________________________________________ > > > 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 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/ > > This: > select * from msgs where content ='C'; > > is returning you something? C means Clean
nope, following Sahil Tandon advice from the list I insert : $clean_quarantine_method = 'sql:'; restart amavis and test it again sending an simple email to me and checking table msgs again: mysql> use amavis ; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from msgs where content ='C'; Empty set (0.00 sec) any other idea ?? thx in advanced > > ------------------------------------------------------------------------------ > _______________________________________________ > 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 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/
