Database Configuration

[Phil Daws]

Hmmm, I have created the config table within a database and updated the SQL in MailScanner.conf but when I restart nothing happens :(

This is what I have:

SQL Serial Number = SELECT value FROM mailscanner_config WHERE internal = 'confserialnumber'
SQL Quick Peek = SELECT value FROM mailscanner_config WHERE external=? AND hostname=?
SQL Config = SELECT internal, value FROM mailscanner_config WHERE hostname=?
SQL Ruleset =
SQL SpamAssassin Config =
SQL Debug = yes

and the table itself:

mysql> desc mailscanner_config;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| hostname | varchar(255) | NO   | PRI | NULL    |       |
| internal | varchar(255) | NO   | MUL | NULL    |       |
| external | varchar(255) | NO   |     | NULL    |       |
| value    | text         | NO   |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+

mysql> select * from mailscanner_config;
+-----------------------+------------------+------------------+-------+
| hostname              | internal         | external         | value |
+-----------------------+------------------+------------------+-------+
| my.host.name          | confserialnumber | confserialnumber | 1     |
+-----------------------+------------------+------------------+-------+

Any ideas please ?
-- 
Thanks, Phil

----- Original Message -----
> Thanks Andrew. Very straight forward then! ;)
> --
> Thanks, Phil
> 
> ----- Original Message -----
> > 
> > On 14 Mar 2012, at 10:52 AM, Phil Daws wrote:
> > 
> > > are any of you using a database to store the MailScanner
> > > configuration ? am trying to understand what the documentation
> > > says but its not make sense to me at the moment.  If you are
> > > using
> > > a ruleset file for certain options eg. Maximum Message Size can
> > > they be stored in the database as-well ?
> > 
> > Yes that possible, you can store any ruleset in the database. take
> > a
> > look at how i do it,
> > 
> > https://github.com/akissa/baruwa/blob/master/extras/baruwa-mailscanner.conf
> > https://github.com/akissa/baruwa/blob/master/src/baruwa/config/sql/domainsignature.sql
> > 
> > - Andrew
> > 
> > --
> > www.baruwa.org
> > 
> > 
> > 
> > --
> > MailScanner mailing list
> > mailscanner at lists.mailscanner.info
> > http://lists.mailscanner.info/mailman/listinfo/mailscanner
> > 
> > Before posting, read http://wiki.mailscanner.info/posting
> > 
> > Support MailScanner development - buy the book off the website!
> > 
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
> 
> Before posting, read http://wiki.mailscanner.info/posting
> 
> Support MailScanner development - buy the book off the website!
>