Deliver / Whitelist / ODBC error |
Post Reply 
|
| Author | |
caratking 
Groupie 
Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Deliver / Whitelist / ODBC errorPosted: 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. |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
caratking
Groupie
Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
caratking
Groupie
Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
Quote Reply
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
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. |
|
|
|
|
caratking
Groupie
Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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...
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.145 seconds.