Deliver / Whitelist / ODBC error
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=6052
Printed Date: 03 June 2025 at 3:47am
Topic: Deliver / Whitelist / ODBC error
Posted By: caratking
Subject: Deliver / Whitelist / ODBC error
Date Posted: 30 April 2007 at 5:56am
|
I noticed an email in the quarantine today that was not spam. I clicked the deliver button and it was delivered to my email shortly after. I then noticed this in the activity log: 04/30/07 05:21:00:859 -- (2184) Adding to C:\Program Files\SpamFilter\domains\ypp.com\WL_AutoWhiteListForceDelive ry.txt:jt@gmail.com|rg@ypp.com 04/30/07 05:21:02:265 -- (2184) Exception occurred during SaveToDBMemoControl (7): [MySQL][ODBC 3.51 Driver][mysqld-5.0.22]There is no 'root'@'%' registered 04/30/07 05:21:02:484 -- (2184) Delivering quarantined email from <jt@gmail.com> to rg@ypp.com 04/30/07 05:21:02:968 -- (2212) Starting to process queue directory... 04/30/07 05:21:02:968 -- (2184) Sending email from jt@gmail.com to rg@ypp.com -- 04/30/07 05:21:05:250 -- (2184) EMail from jt@gmail.com to rg@ypp.com -- was forwarded to mail.ypp.com:25 I am using ODBC to connect to mysql on linux, but the strange part is I am not using the username root to connect the the mysql server as the error message would lead you to believe. |
Replies:
Posted By: LogSat
Date Posted: 30 April 2007 at 7:49pm
|
What is you connection string within SpamFilter (are you using a UDL file or using an actual connection string)? Did you specify a username/password in the MySQL ODBC DSN on the SpamFilter server? If using a UDL file, usually you would leave the username/password there blank, while you'd enter them in the ODBC DSN.
------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: caratking
Date Posted: 03 May 2007 at 1:36am
|
I'm using an ODBC datasource, with a connection string. Provider=MSDASQL.1;Persist Security Info=False;Data Source=spamfilter The username & password are specified in the ODBC datasource. I'm using the name admin to connect to the database in the ODBC datasource, not root as is being shown in the error. I've got two servers running SFE 3.5.622 and I just confirmed that both servers are doing it when I release and item from quarantine. Neither of the machines connect using the root username. |
Posted By: caratking
Date Posted: 03 May 2007 at 9:42am
|
I just tried to add (manually) an item to the whitelist for a domain, and the activity log shows the following error in response to my attempt:
05/03/07 09:27:36:156 -- (2080) Exception occurred during SaveToDBMemoControl (4): [MySQL][ODBC 3.51 Driver][mysqld-5.0.22]There is no mailto:'root'@'%' - 'root'@'%' registered
I am using the mySQL ODBC driver version 3.51.14.00. Very strange, since it is doing some aspects of operation OK with that ODBC datasource and others are no good. |
Posted By: caratking
Date Posted: 03 May 2007 at 10:08am
|
I have found the source of the problem. It is a mySQL issue, that has come about as the result of: - I installed the spamfilter database on Server A - I did a mysqldump of the database - I restored it on Server B Server A was using root as the user, so some of the views/triggers are owned by root. When moved to Server B, an issue has been created because there is no root account. I have found several documented cases. So it is not a spamfilter issue at all. |
Posted By: LogSat
Date Posted: 03 May 2007 at 4:35pm
I'm glad you let us know  . We were looking to see if the fact that the "@" sign in the autowhitelist entry was somehow "messing up" the query used to insert the record into MySQL. But no matter what we did everythink looked fine...
------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |