Print Page | Close Window

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: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6052
Printed Date: 18 October 2017 at 10:59am


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
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.



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



Print Page | Close Window