Error with Spam-Quarantine to a MySQL Server onto Linux |
Post Reply 
|
| Author | |
Bruno 
Guest Group 
|
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Error with Spam-Quarantine to a MySQL Server onto Linux Posted: 02 July 2003 at 12:04pm |
|
Hi, I'll get following error-message in the log-window of spamfilter : 07.02.03 17:48:10:198 -- (289) 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 ??? or is there a fix ? cu bruno! |
|
 |
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 July 2003 at 12:07pm |
|
... here the output on step 2 while configuring the spam-db :
Adding default Reject Codes...
thanks to all ! bruno |
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 02 July 2003 at 3:21pm |
|
For both this posting and the other posted just after 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 |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2003 at 12:42am |
|
hi, please see the post you regarding to ... it's the same error. thank's bruno |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2003 at 12:50am |
|
Hi, here some additional output after creating a new DB with the MySQL.sql directly. I've made step1 ( ok ) , step2 gives following output : ================ Info: MySQL Server Version 4.0.13 Linux Version : SuSE Linux 7.2 - Kernel 2.4.4-4GB MyODBC Driver 3.51 System running with Spamfilter : Windows NT 4 SP 6a Access-grants : ALL PRIVILEGES ( connect as root ) cu tuxx |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2003 at 3:19am |
|
I got it : 22 Query INSERT INTO `spamfilter`..`tblMsgs` (`Msg`) VALUES ('Received: from it's very unusual to select a table with a dubble-dot !?! isn't it ??? how do I change that ??? cu bruno |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2003 at 9:46am |
|
Can you try setting the following two MySQL ODBC properties as in the screenshot below (http://www.logsat.com/SpamFilter/images/MySQLODBC.gif) and see if that makes a difference? We were not able to duplicate your error by using your version of MySQL and of the ODBC driver. The only difference is that our MySQL runs on Windows, not Linux. SHould not make a difference, buyt maybe some defaults are different. Roberto Franceschetti |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2003 at 9:56am |
|
The trace you are seing is how Microsoft's ADO (OLE/DB) interpets the commands SpamFilter sends and translates them into platform-specific SQL statements. Unfortunately we have no control over them. This issue may be fixed if you apply the two MySQL ODBC settings in the other posting. If not, can you please let us what version of MDAC (Microsoft Data Components) you have on the server, and what connection string you are using in SpamFilter to connect to MySQL? If you are not using the sample UDL file we provided, can you try doing so? Roberto Franceschetti |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 July 2003 at 7:48am |
|
Hi, I am using the sample file, and changed the neccessary values. I've tried the modifications on the mysql-odbc driver but isn't working yet :-( ... cu bruno |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 July 2003 at 7:52am |
|
Hi, how do I find out which MDAC version I'm running ? cu ::bruno:: |
|
|
|
|
Bruno
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 July 2003 at 8:25am |
|
Hi, I got it ! It's possibly a bug at the MySQL ODBC Driver for Windows ... have installed Version 2.5 directly for WinNT/2k/XP and is working now correctly ... cu bruno |
|
|
|
Topic Options
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.361 seconds.