Mark,
I need just one more clarification..
> > (Is it right to unset "bypass_virus_checks_maps"?)
> >
> > Then I have added the following config line:
> >
> > @lookup_sql_dsn =
> > ( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306', 'user',
> > 'password'],);
> > @storage_sql_dsn = @lookup_sql_dsn; # none, same, or separate
> database
> > $sql_select_policy = 'SELECT 0 as virus_lover FROM domain WHERE
> active=1
> > AND domain IN (%k)';
> > %virus_lovers = ('.' => 1);
>
> Ok.
>
> > After restarting amavisd I get error such the following:
>
> > amavis[483]: (00483-01) sql: preparing and executing:
> > SELECT id FROM maddr WHERE email=?
> > amavis[483]: (00483-01) sending SMTP response:
> > "451 4.5.0 Error in processing, id=00483-01, sql-enter FAILED:
> > sql exec: err=1146, S1000, DBD::mysql::st execute failed:
> > Table 'postfix.maddr' doesn't exist at
> > (eval 66) line 169, <GEN11> line 21."
>
> This has nothing to do with SQL lookups. It is SQL logging that fails,
> apparently you don't have r/w tables needed for logging to SQL /
> penpals
> (tables maddr, msgs, msgrcpt), yet you have enabled the SQL logging.
>
> Either provide the needed tables (README.sql-mysql),
> or leave @storage_sql_dsn at its default (empty).
>
> > Infact when I uncomment @lookup_sql_dsn I enable sql Amavisd-new
> logging
> > in amavis database.. But I need to lookup for domain on mail
> database..
> > what I have to do?
>
> Leave out the
> @storage_sql_dsn = @lookup_sql_dsn;
>
I'm currentry using @lookup_sql_dsn for storing quarantine in DB.
So I have tried to include both DSN in @lookup_sql_dsn array:
@lookup_sql_dsn =
(
['DBI:mysql:database=amavis;host=127.0.0.1;port=3306', 'user1',
'apss1'],
['DBI:mysql:database=postfix;host=127.0.0.1;port=3306', 'user2',
'pass2'],
);
But after that Amavisd-new won't go on. Nevertheles gives error. How I
have to do to preserve both features (virus_lover that queries "postfix"
database, and SQL quarantine that interact with "amavis" database)?
TIA,
rocsca
------------------------------------------------------------------------------
_______________________________________________
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/
