[Bug 3640] New: Retriving SQL prefs from mySQL DB stops shortly after spamd start.

[bu...@bugzilla.spamassassin.org]

http://bugzilla.spamassassin.org/show_bug.cgi?id=3640

           Summary: Retriving SQL prefs from mySQL DB stops shortly after
                    spamd start.
           Product: Spamassassin
           Version: SVN Trunk (Latest Devel Version)
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P5
         Component: spamc/spamd
        AssignedTo: spamassassin-dev@incubator.apache.org
        ReportedBy: upwoodj@bsk.com


After starting spamd, the user prefs are read from the mysql table correctlly, 
but then stops reading the prefs:

Jul 28 11:20:50 antispam spamd[30777]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:50 antispam spamd[30778]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:50 antispam spamd[30780]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:50 antispam spamd[30786]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:53 antispam spamd[30787]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:56 antispam spamd[30788]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:20:58 antispam spamd[30789]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 
Jul 28 11:21:02 antispam spamd[30790]: debug: Conf::SQL: executing SQL: select 
preference, value  from userpref where username = 'nobody' or username 
= '@GLOBAL' order by username asc 

The above logs successful reads, but then there is no error at all indicating 
it can't read the sql user prefs.  The only think in the SQL DB are @GLOBAL 
whitelist/blacklist rules.



------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.