HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)

- - amavis & ispconfig 3 (http://www.howtoforge.com/forums/showthread.php?t=43508)

amavis & ispconfig 3

Hi all!
Решил создать топик на русском :)

Вопрос вобшем про настрлйку amavis для борьбы со спамом и Вирусами.

Необходимо что бы весь спам и все зараженные письма падали в специальный ишик (antispam), но что то не как не получается: (

Все делал по манам с зтого сайта, но чет не очень все плучилось: (
В место нормальной работы amavis+pistfix подучилось то что поствикс ставил все сообшения в очередь, приходяшие как из нутри так и с наружи.

Может кто делал такое, подскажите что где править?

p.s.
Сори за ишибки, писал снового телефона на котором не все русские буквы есть: )

Sorry yalex2000

Only In English, how should all the people help you wich could not your language?

admins

Quote:

Originally Posted by admins (Post 219533)

Sorry yalex2000

Only In English, how should all the people help you wich could not your language?

admins

I badly write in English :(

That should be all spam and all the infected messages fell into a special ishik (antispam).

All done by guides from this site.

But I do not what did not work.
As a result, a bunch of postfix + amavis + spamassassin + clamav, normally does not work.

Not even know where to begin looking for problems.

Here are found such errors in the syslog:

Code:

Feb 17 13:14:09 server postfix/smtp[27522]: ABDBD14A0B5: to=<fosteringseky@art-dtex.ru>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=2, delay=98539, delays=98403/135/0/0.01, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to MAIL FROM command))

Feb 17 13:14:09 server amavis[27661]: (27661-01) (!!)TROUBLE in check_mail: sql-enter FAILED: sql exec: err=1146, 42S02, DBD::mysql::st execute failed: Table 'dbispconfig.maddr' doesn't exist at (eval 112) line 166, <GEN35> line 13.

Feb 17 13:14:09 server amavis[27661]: (27661-01) (!)PRESERVING EVIDENCE in /var/lib/amavis/tmp/amavis-20100217T131409-27661

Feb 17 13:14:09 server postfix/smtp[27653]: AE37B14A6FC: to=<sculptorsnaq8@antivsd.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=82955, delays=82819/135/0.02/0.08, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=27661-01, sql-enter FAILED: sql exec: err=1146, 42S02, DBD::mysql::st execute failed: Table 'dbispconfig.maddr' doesn't exist at (eval 112) line 166, <GEN35> line 13. (in reply to end of DATA command))

Feb 17 13:14:09 server amavis[27661]: (27661-01-2) (!!)TROUBLE in process_request: Can't create file /var/lib/amavis/tmp/amavis-20100217T131409-27661/email.txt: File exists at /usr/sbin/amavisd-new line 5307, <GEN34> line 296.

Feb 17 13:14:09 server amavis[27661]: (27661-01-2) (!)Requesting process rundown after fatal error

Where to look for errors?

Quote:

Originally Posted by admins (Post 219533)

Sorry yalex2000

Only In English, how should all the people help you wich could not your language?

admins

Code:

Feb 17 13:14:09 server postfix/smtp[27522]: ABDBD14A0B5: to=<fosteringseky@art-dtex.ru>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=2, delay=98539, delays=98403/135/0/0.01, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to MAIL FROM command))

Feb 17 13:14:09 server amavis[27661]: (27661-01) (!!)TROUBLE in check_mail: sql-enter FAILED: sql exec: err=1146, 42S02, DBD::mysql::st execute failed: Table 'dbispconfig.maddr' doesn't exist at (eval 112) line 166, <GEN35> line 13.

Feb 17 13:14:09 server amavis[27661]: (27661-01) (!)PRESERVING EVIDENCE in /var/lib/amavis/tmp/amavis-20100217T131409-27661

Feb 17 13:14:09 server postfix/smtp[27653]: AE37B14A6FC: to=<sculptorsnaq8@antivsd.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=82955, delays=82819/135/0.02/0.08, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=27661-01, sql-enter FAILED: sql exec: err=1146, 42S02, DBD::mysql::st execute failed: Table 'dbispconfig.maddr' doesn't exist at (eval 112) line 166, <GEN35> line 13. (in reply to end of DATA command))

Feb 17 13:14:09 server amavis[27661]: (27661-01-2) (!!)TROUBLE in process_request: Can't create file /var/lib/amavis/tmp/amavis-20100217T131409-27661/email.txt: File exists at /usr/sbin/amavisd-new line 5307, <GEN34> line 296.

Feb 17 13:14:09 server amavis[27661]: (27661-01-2) (!)Requesting process rundown after fatal error

Where to look for errors?

You seem to have modified the amavisd config file, there has never been a db table dbispconfig.maddr in ispconfig, so you use some kind of manually edited amavisd config file and not the one from ispconfig.

Please make sure that you installed your server exactly as described in the perfect server guide and undo the manual edits that you made in the amavisd configuration to ensure that amavisd is able to start again.

Quote:

Originally Posted by till (Post 219578)

I did everything on this documentation:
http://www.howtoforge.org/perfect-se...04-ispconfig-3

But anti-spam does not work, I corrected these files:

/etc/amavis/conf.d/15-content_filter_mode

Code:

# If You wish to enable it, please uncomment the following lines:





@bypass_virus_checks_maps = (

   \%bypass_virus_checks, \@bypass_virus_checks_acl, \$bypass_virus_checks_re);





#

# Default SPAM checking mode

# Please note, that anti-spam checking is DISABLED by

# default.

# If You wish to enable it, please uncomment the following lines:





@bypass_spam_checks_maps = (

   \%bypass_spam_checks, \@bypass_spam_checks_acl, \$bypass_spam_checks_re);

/etc/amavis/conf.d/50-user

Code:

@lookup_sql_dsn =

   ( ['DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306', 'ispconfig', '*****************************'] );



@storage_sql_dsn = @lookup_sql_dsn;  # none, same, or separate database



$sql_select_policy = 'SELECT "Y" as local FROM mail_domain WHERE CONCAT("@",domain) IN (%k)';

$banned_files_quarantine_method = 'sql';

$spam_quarantine_method         = 'sql';

/etc/postfix/main.cf

Code:

content_filter = amavis:[127.0.0.1]:10024

receive_override_options = no_address_mappings

message_size_limit = 0

That's all.

what does it need to change I read in this forum...

Maybe it did not need to do?

Quote:

But anti-spam does not work, I corrected these files:

Spam filtering is not working because you modified these files and thats also the reason why amavisd is not starting anymore. Please undo all modifications that you did!

To enable spamfiltering, simply login to ispconfig, select the spamfilter mode for the domain or mailbox and adjust the spam score in the policy in ispconfig, if you want stricter spam filtering.

Quote:

Originally Posted by till (Post 219591)

Thank you very much.
We will try to return everything to its original state.

All configs changed.
But after restarting postfix, amavis, spamassassin - that's got this result:

Code:

Feb 17 11:25:52 server postfix/qmgr[16008]: 4618E14B609: from=<yu@yandex.ru>, size=1645, nrcpt=1 (queue active)

and so with all messages...
:(

Please restart amavis and post the messages that get added to the mail log by the restart. Afterwards, restart postfix.