Spam Filter ISP Forums : Deliver / Whitelist / ODBC error https://www.logsat.com/spamfilter/forums/ Sun, 14 Jun 2026 02:47:01 +0000 Thu, 03 May 2007 16:35:07 +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=6052 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Deliver / Whitelist / ODBC error : I&#039;m glad you let us know....]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10101&title=deliver-whitelist-odbc-error#10101 Author: LogSat
Subject: 6052
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...]]> Thu, 03 May 2007 16:35:07 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10101&title=deliver-whitelist-odbc-error#10101 <![CDATA[Deliver / Whitelist / ODBC error : I have found the source of the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10094&title=deliver-whitelist-odbc-error#10094 Author: caratking
Subject: 6052
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.
]]> Thu, 03 May 2007 10:08:48 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10094&title=deliver-whitelist-odbc-error#10094 <![CDATA[Deliver / Whitelist / ODBC error : I just tried to add (manually)...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10093&title=deliver-whitelist-odbc-error#10093 Author: caratking
Subject: 6052
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 'root'@'%' registered
05/03/07 09:27:37:421 -- (2080) Exception occurred during TFilterObject.SaveFilterSettings: Query-based update failed because the row to update could not be found - 12345 SPFFilterEnable SPFNeutralFilter SPFSoftfailFilter SPFFailFilter SPFFilterEnableForceDelete RejectNoReverseForceDelete RejectNoMXForceDelete RejectEmptyMailFromForceDelete RejectSameToFromForceDelete RejectSameToFromDomainForceDelete BL_MAPSForceDelete BL_KeywordsForceDelete BL_IPsForceDelete BL_DomainsForceDelete BL_CountriesForceDelete BL_EmailsFromForceDelete BL_EmailsTOForceDelete BL_AttachmentsForceDelete BL_HoneypotEmailsForceDelete BL_SURBLForceDelete SFDB_NetworkReliability SFDB_FiltersAll SFDBForceDelete SFDB_FiltersList AllowPercent TagSPAM TagSPAMSubject TagSPAMAndQuarantine RejectNoReverse RejectNoMX RejectEmptyMailFrom RejectSameToFrom RejectSameToFromDomain AutoWhiteListForceDeliveryEnabled MinMAPS MaxSubjectSpaces SpamImageThreshold

 

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.

]]> Thu, 03 May 2007 09:42:56 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10093&title=deliver-whitelist-odbc-error#10093 <![CDATA[Deliver / Whitelist / ODBC error : I&#039;m using an ODBC datasource,...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10092&title=deliver-whitelist-odbc-error#10092 Author: caratking
Subject: 6052
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.
]]> Thu, 03 May 2007 01:36:28 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10092&title=deliver-whitelist-odbc-error#10092 <![CDATA[Deliver / Whitelist / ODBC error : What is you connection string...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10081&title=deliver-whitelist-odbc-error#10081 Author: LogSat
Subject: 6052
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.]]> Mon, 30 Apr 2007 19:49:35 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10081&title=deliver-whitelist-odbc-error#10081 <![CDATA[Deliver / Whitelist / ODBC error : I noticed an email in the quarantine...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10076&title=deliver-whitelist-odbc-error#10076 Author: caratking
Subject: 6052
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.
]]> Mon, 30 Apr 2007 05:56:37 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052&PID=10076&title=deliver-whitelist-odbc-error#10076