Anders wrote:

> Yeah, you're right about the work part, but still it would be nice to
> have a one-point-edit for things.

> Postfix reads the database via pam_mysql, which probably isn't optimal, 
> but it works fine, and fast.

> I noticed while surfing on the subject that there is a 
> $local_domains_sql thing in the amavis code, but I can't find any 
> explanations on how to use it. And I'm definately not a perl coder.. :)

> Anyway, the database table that carries the domains has this format;

> CREATE TABLE `domain` (
>    `domain_name` varchar(255) NOT NULL default '',
>    `prefix` varchar(50) NOT NULL default '',
>    `maxaccounts` int(11) NOT NULL default '20',
>    `quota` int(10) NOT NULL default '20000',
>    `transport` varchar(255) NOT NULL default 'cyrus',
>    `freenames` enum('YES','NO') NOT NULL default 'NO',
>    `freeaddress` enum('YES','NO') NOT NULL default 'NO',
>    PRIMARY KEY  (`domain_name`),
>    UNIQUE KEY `prefix` (`prefix`)
> ) TYPE=MyISAM;

> Where a post whould carry this info;

> INSERT INTO `domain` VALUES ('example.net', 'ex', 20, 10240, 'cyrus', 
> 'NO', 'NO');

> So, the domains are cleanly presented in the DB, so I think it would be 
> possible to use it, if I only knew how...

> For now, I'll go with a text file dump, but I still want to know if it's 
> possible.. ;)

For SQL, amavisd-new would need the form @example.com for a domain by
itself. This differs from hash lookups that do not use the @
See: http://www.ijs.si/software/amavisd/README.lookups.txt

Gary V


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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/

Reply via email to