test for sql user prefs fails - debug not helpful - followup

[Dale Morin]

Hello,

The db name, username, and password all had underscores, so I renamed the db, 
added a new user, and set a password
without an underscore in any of them.  No change.  I had read a post that 
suggested the parser might be confused by some
unexpected characters so I removed the underscores.

Running "spamassassin --lint --debug --nocreate-prefs" is clean with no errors 
or warnings.

Any suggestions?


-- 
Dale Morin, Mustang Internet Services, Inc.
"Support Without Compromise"
main office: 847.541.2811
direct line: 815.496.9853
email: [EMAIL PROTECTED]

test for sql user prefs fails - debug not helpful

[Dale Morin]

Hello,

OS: RHES 3.0
SA 3.1.0
spamd start options: SPAMDOPTIONS="-d -D -q -x -m5 -H -u qscand
--max-conn-per-child=10"
spamass-milter 0.3.0
spamass-milter start options: SM_EXTRA_FLAGS="-i xx.xxx.xx.0/24 -r 21 -u
qscand -x -- -f -s 64000"

Here is the output from running "spamd -q -D", then running "echo -e
"From: user\nTo:user\nSubject: Test\n\n" | spamc -u dale" from a different
ssh session:

[28798] dbg: config: Conf::SQL: executing SQL: select preference, value 
from userpref where username = 'dale' or username = '@GLOBAL' order by
username asc
[28798] dbg: config: retrieving prefs for dale from SQL server
[27688] dbg: prefork: new lowest idle kid: 29185
[27688] info: spamd: handled cleanup of child pid 28798 due to SIGCHLD
[27688] dbg: prefork: child closed connection
[27688] info: prefork: child states: I
[29505] dbg: prefork: sysread(8) not ready, wait max 300 secs
[27688] info: spamd: server successfully spawned child process, pid 29505
[27688] dbg: prefork: child 29505: entering state 0
[27688] dbg: prefork: new lowest idle kid: 29185
[27688] dbg: prefork: child 29505: entering state 1
[27688] dbg: prefork: new lowest idle kid: 29185
[27688] dbg: prefork: child reports idle
[27688] info: prefork: child states: II

The "executing SQL" looks OK, as does the "retrieving prefs for dale", but
nothing happens after that.  I have verified the username/password and
that the user has select privileges (actually has select, delete, insert,
update).  I have installed the squirrelmail plugin for users to manage
their whitelists/blacklists.

Any suggestions?


-- 
Dale Morin, Mustang Internet Services, Inc.
"Support Without Compromise"
main office: 847.541.2811
direct line: 815.496.9853
email: [EMAIL PROTECTED]