Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Deliver / Whitelist / ODBC error
  FAQ FAQ  Forum Search   Register Register  Login Login

Deliver / Whitelist / ODBC error

 Post Reply Post Reply
Author
caratking View Drop Down
Groupie
Groupie


Joined: 13 March 2006
Location: United States
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote caratking Quote  Post ReplyReply Direct Link To This Post Topic: Deliver / Whitelist / ODBC error
    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.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
caratking View Drop Down
Groupie
Groupie


Joined: 13 March 2006
Location: United States
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote caratking Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
caratking View Drop Down
Groupie
Groupie


Joined: 13 March 2006
Location: United States
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote caratking Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
caratking View Drop Down
Groupie
Groupie


Joined: 13 March 2006
Location: United States
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote caratking Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.