Mailing List Archive

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





------- Additional Comments From kgc@sonic.net 2004-06-03 15:01 -------
Subject: Re: spamd zombies in conjunction with failed handle_user lookups

I haven't pulled a new copy from SVN for quite some time. I'll try to do
this ASAP and retest.





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

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

kgc@sonic.net changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WORKSFORME



------- Additional Comments From kgc@sonic.net 2004-06-04 11:52 -------
Looks like it has been fixed and is working okay. It'd probably be better if
the child didn't exit and instead 'failed open' running a default config but
it's not creating zombies.

Jun 4 11:40:38 a spamd[3809]: connection from eth0.a.lds.sonic.net
[208.201.249.231] at port 55067
Jun 4 11:40:38 a spamd[3809]: handle_user() -> unable to find user [kgfdsfdsfsdf]!
Jun 4 11:40:38 a spamd[3809]: service unavailable: Error fetching user
preferences via SQL
Jun 4 11:40:38 a spamd[3803]: server hit by SIGCHLD, pid 3809
Jun 4 11:40:38 a spamd[3803]: server successfully spawned child process, pid 3860



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

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





------- Additional Comments From dallase@nmgi.com 2004-06-04 13:44 -------
kelsey.. you are running spamd with -q right?? i was seeing that handle_user
error and it was a result of bad syntax in user_scores_sql_custom_query

what does your user_scores_sql_custom_query look like?

mine looks like this... you might give it a shot.

user_scores_sql_custom_query SELECT preference, value FROM user_prefs
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC

Note: I do it this way so an ascensding sort on $GLOBAL, %nmgi.com,
dallase@nmgi.com lets the user have the final say.

i'm running redhat 7.3 perl 5.6.1 and latest SVN that i checked out this morning.







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

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





------- Additional Comments From kgc@sonic.net 2004-06-04 15:35 -------
Subject: Re: spamd zombies in conjunction with failed handle_user lookups

On Fri, Jun 04, 2004 at 01:44:52PM -0700, bugzilla-daemon@bugzilla.spamassassin.org wrote:
> http://bugzilla.spamassassin.org/show_bug.cgi?id=3352
>
>
>
>
>
> ------- Additional Comments From dallase@nmgi.com 2004-06-04 13:44 -------
> kelsey.. you are running spamd with -q right?? i was seeing that handle_user

-Q actually, ie, setuid'ing and using SQL. Come to think of it, I probably
don't need to do this anymore since we disabled the AWL a long long time
ago.





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