Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - MySQL Quarantine Database not working ...
  FAQ FAQ  Forum Search   Register Register  Login Login

MySQL Quarantine Database not working ...

 Post Reply Post Reply
Author
TuXX View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote TuXX Quote  Post ReplyReply Direct Link To This Post Topic: MySQL Quarantine Database not working ...
    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

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
TuXX View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote TuXX Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.336 seconds.