Hi all,

I've created the neccessary DBs and executed the script shiped by spamfilter, and worked fine, except this :

- the tablenames are NOT named correctly

- at the end of the script is following error :

Adding default Reject Codes...
Error working with tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '.`tblRejectCodes` (`RejectID`,`RejectDesc`) VALUES (1,'Domain i
Error working with tblServers - [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '.`tblServers` (`ServerName`) VALUES ('analytek_pdc')' at line 1

- if a mail should be quarantined, following error occures :

Exception occurred during RECEIVEMESSAGE: [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '.`tblMsgs` (`Msg`) VALUES ('Received: from 192.168.1.5 by 192.1

Does anybody know, how to change the syntax of the script ? Does anybody has an easy workaround ?

Thanks!

TuXX

For both this posting and the other posted just prior to this, have you tried running the "MySql.sql" setup script in the spamfilter/database directly against the database from within MySQL or MySqlCC ? What errors, if any, does it produce?

Roberto Franceschetti
LogSat Software

Hi !

So, I've made a new DB and inserted thy MySQL.sql directly and didn't get any error-message.

When configuring the Spamfilter-Quarantine-DB, I'll get the named error only at STEP2/STEP2b ( what file is that in step2b - I haven't one for selection ) !?! Is it possible to post some screenshots ?

Now, when Spam is arrived, I repeatedly get the posted message at the Activity-Log. No Entries made in Spamfilter-Quarantine-DB.

cu

tuxx