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/