Hi everybody! Today i started playing with the sql config options for MailScanner and i cant make it work.<div><div><br></div><div>My "config" table definition:</div><div><div><br></div><div>CREATE TABLE `config` (</div>
<div> `id` int(11) NOT NULL auto_increment,</div><div> `hostname` varchar(100) NOT NULL,</div><div> `value` varchar(100) NOT NULL,</div><div> `external` varchar(100) NOT NULL,</div><div> `options` varchar(100) NOT NULL,</div>
<div> PRIMARY KEY (`id`)</div><div>) ENGINE=MyISAM</div></div><div><br></div><div>MailScanner.conf:</div><div><br></div><div>DB DSN = DBI:mysql:dbname=mailscanner;host=localhost;port=3306</div><div>DB Username = root</div>
<div>DB Password = password</div></div><div>SQL Serial Number = SELECT value FROM config WHERE options='confserialnumber'</div><div><div>SQL Quick Peek = SELECT value FROM config WHERE external=? AND hostname=?</div>
<div>SQL Config = SELECT options, value FROM config WHERE hostname=?</div><div>SQL Ruleset =</div><div>SQL SpamAssassin Config =</div><div>SQL Debug = yes</div></div><div><br></div><div>this is the output i get:</div><div>
<div><br></div><div>/opt/MailScanner/bin/MailScanner --debug --lint</div><div><br></div><div><b>Database functions disabled</b></div><div>Trying to setlogsock(unix)</div><div><br></div><div>Reading configuration file /opt/MailScanner/etc/MailScanner.conf</div>
<div>Read 865 hostnames from the phishing whitelist</div><div>Read 5278 hostnames from the phishing blacklists</div><div><br></div><div>Checking version numbers...</div><div>Version number in MailScanner.conf (4.81.4) is correct.</div>
</div><div>(...)</div><div><br></div><div>Does anybody have any idea of what i am doing wrong?</div><div><br></div><div><br></div><div>Also, if the line "include" is enable at the end of MailScanner.conf with a valid config file all the DB config seems to dissapear, does anybody knows what is the precedence between the include and the db?</div>
<div><br></div><div>Thanks!!!</div><div><br></div><div>Eduardo.</div>