Hello,
> 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)?
rocsca
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
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/
