Re: [AMaViS-user] MySQL setup?

On Thu, Feb 24, 2005 at 11:19:25AM +0100, Anders Norrbring wrote:
>
> Does anybody out there have any real life experiencies and maybe a HOW-TO on
> setting up Amavis-new to run with MySQL lookups?
>
> Also, are there any "easy-to-use" tools for that kind of setup?

README.lookups tells how it all works.

If your O/S has a package to install MySQL, that will probably do all
the setting up at that end. README.lookups contains details how to
create suitable tables (cut and paste the scripts). If you have an
existing database then modify the queries to return suitable fields.
Maintaining the contents of the database is down to you :)

You will also need to install perl DBI and DBD::MySQL modules (get them
from CPAN).

If you take those defaults, all you need to do to amavis is setup
mysql.conf to connect to your MySQL server(s), something like this:

@lookup_sql_dsn =
( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306' , 'user1', 'passwd1'],
['DBI:mysql:database=mail;host=host2', 'username2', 'password2']);

Nick


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/