Spam Filter ISP Forums : Error with Spam-Quarantine to a MySQL Server onto Linux

Spam Filter ISP Forums : Error with Spam-Quarantine to a MySQL Server onto Linux https://www.logsat.com/spamfilter/forums/ Tue, 18 Aug 2026 15:33:05 +0000 Fri, 04 Jul 2003 08:25:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=1220 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : Hi, I got it ! It's possibly...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1247&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1247 Author: Guests
Subject: 1220
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 ...

bruno

]]> Fri, 04 Jul 2003 08:25:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1247&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1247 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : Hi, how do I find out which MDAC...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1246&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1246 Author: Guests
Subject: 1220
Posted: 04 July 2003 at 7:52am

Hi,

how do I find out which MDAC version I'm running ?

cu ::bruno::

]]> Fri, 04 Jul 2003 07:52:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1246&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1246 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : Hi, I am using the sample file,...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1245&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1245 Author: Guests
Subject: 1220
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 :-( ...

bruno

]]> Fri, 04 Jul 2003 07:48:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1245&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1245 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : The trace you are seing is how...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1239&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1239 Author: LogSat
Subject: 1220
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
LogSat Software

]]> Thu, 03 Jul 2003 09:56:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1239&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1239 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : Can you try setting the following...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1238&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1238 Author: LogSat
Subject: 1220
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 Software

WARNING: Image embedded by poster.

]]> Thu, 03 Jul 2003 09:46:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1238&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1238 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : I got it : 22 Query INSERT INTO...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1234&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1234 Author: Guests
Subject: 1220
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 ???

bruno

]]> Thu, 03 Jul 2003 03:19:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1234&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1234 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : Hi, here some additional output...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1232&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1232 Author: Guests
Subject: 1220
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 :

================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
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
Done.

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 )

tuxx

]]> Thu, 03 Jul 2003 00:50:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1232&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1232 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : hi, please see the post you regarding...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1231&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1231 Author: Guests
Subject: 1220
Posted: 03 July 2003 at 12:42am

hi,

please see the post you regarding to ... it's the same error.

thank's

bruno

]]> Thu, 03 Jul 2003 00:42:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1231&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1231 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : For both this posting and the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1225&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1225 Author: LogSat
Subject: 1220
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
LogSat Software

]]> Wed, 02 Jul 2003 15:21:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1225&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1225 <![CDATA[Error with Spam-Quarantine to a MySQL Server onto Linux : ... here the output on step...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1221&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1221 Author: Guests
Subject: 1220
Posted: 02 July 2003 at 12:07pm

...

here the output on step 2 while configuring the spam-db :

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

thanks to all !

bruno

]]> Wed, 02 Jul 2003 12:07:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1220&PID=1221&title=error-with-spamquarantine-to-a-mysql-server-onto-linux#1221