What tables to create for using SQL capability of MailScanner conf.

[Richard Mealing]

The create.sql script in mailwatch will have all the details you require (just download the latest mailwatch). You should look at the set-up links to mailwatch as to what to change in the mailscanner.conf file. 

Rich

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Jeremy McSpadden
Sent: 04 April 2012 14:13
To: MailScanner discussion
Cc: mailscanner at lists.mailscanner.info
Subject: Re: What tables to create for using SQL capability of MailScanner conf.

Try looking at mailwatch ... Maybe their SQL will point you in the right direction. 


--
Jeremy McSpadden

On Mar 28, 2012, at 5:43 AM, "Tomáš Kurinec" <tomb.stoney at gmail.com> wrote:

> Hi all,
> 
> I'm trying to use mailscanner sql configuration capabilities mainly 
> for custom rulesets and spamassassin, but I can't find out how should 
> the tables looks like.
> Could you be so kind and provide me SQL like this:
> CREATE TABLE mailscanner_config (
>  id int(11) NOT NULL auto_increment,
>  hostname varchar(100) NOT NULL,
>  value varchar(100) NOT NULL,
>  external varchar(100) NOT NULL,
>  options varchar(100) NOT NULL,
>  PRIMARY KEY (id)
> ) ENGINE=MyISAM
> 
> I don't know if this is a good table for such a purpose, but you 
> probably get the idea.
> 
> Thank you very much!
> 
> Tom
> --
> 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!