Print Page | Close Window

MySQL Quarantine Database not working ...

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1222
Printed Date: 27 December 2024 at 10:52am


Topic: MySQL Quarantine Database not working ...
Posted By: Guests
Subject: MySQL Quarantine Database not working ...
Date Posted: 02 July 2003 at 2:36pm

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




Replies:
Posted By: LogSat
Date Posted: 02 July 2003 at 3:20pm

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



Posted By: Guests
Date Posted: 03 July 2003 at 12:40am

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




Print Page | Close Window