Re: Enabling per user rules in SQL db

2006-02-13 Thread Henry F. Camacho Jr
@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db Don O'Neil wrote: Looks like the problem is the username interpretation Feb 12 19:53:44 bigbird spamd[85410]: config: Conf::SQL: executing SQL: select p reference, value from userpref where username = 'shc

Re: Enabling per user rules in SQL db

2006-02-12 Thread Daryl C. W. O'Shea
Don O'Neil wrote: Even if I use the -v (vpopmail) option? How else can the pref's come from a username if there is no username assigned in the /etc/password? I thought that was why there was the -v and -q options to begin with. To be honest I have no idea what using -v gets you (what changes).

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
014? I want per user settings, not per domain. Although per domain is nice too! Don -Original Message- From: Don O'Neil [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 8:38 PM To: 'Daryl C. W. O'Shea' Cc: users@spamassassin.apache.org Subject: RE: Enabl

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
password file for spamc to grab the config for? If so, how? Thanks! -Original Message- From: Daryl C. W. O'Shea [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 8:20 PM To: Don O'Neil Cc: users@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db

Re: Enabling per user rules in SQL db

2006-02-12 Thread Daryl C. W. O'Shea
Don O'Neil wrote: Looks like the problem is the username interpretation Feb 12 19:53:44 bigbird spamd[85410]: config: Conf::SQL: executing SQL: select p reference, value from userpref where username = 'shcu0003' or username = '@GLOBAL' order by username asc Feb 12 19:53:44 bigbird spamd[854

Re: Enabling per user rules in SQL db

2006-02-12 Thread Daryl C. W. O'Shea
e I've never run anything earlier, I can't confirm if it's something specific with 3.1.0. Don -Original Message- From: Dale Morin [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 7:34 PM To: users@spamassassin.apache.org Cc: Don O'Neil Subject: RE: Enablin

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
ary 12, 2006 7:44 PM To: Don O'Neil Cc: users@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db it isn't 3.1, I am pretty sure it is 3.0 HFC Don O'Neil wrote: >Which version of Spamassassin are you running? > >-Original Message- >From: Henry F. Ca

Re: Enabling per user rules in SQL db

2006-02-12 Thread Henry F. Camacho Jr
From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 3:00 PM To: Don O'Neil Cc: users@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db How is spamd getting called? spamass-milter? If so put the following in your sysconfig: &quo

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
Which version of Spamassassin are you running? -Original Message- From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 3:11 PM To: Don O'Neil Subject: Re: Enabling per user rules in SQL db I am using -q -x on spamd. HFC Don O'Neil wrote:

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
ary 12, 2006 7:34 PM To: users@spamassassin.apache.org Cc: Don O'Neil Subject: RE: Enabling per user rules in SQL db Hello Don, I ran into exactly the same problem and I have not been able to get per-user rules to work from mysql. I hacked a workaround but have not revisited it lately. Any

RE: Enabling per user rules in SQL db

2006-02-12 Thread Dale Morin
Hello Don, I ran into exactly the same problem and I have not been able to get per-user rules to work from mysql. I hacked a workaround but have not revisited it lately. Anyway, here is a patch file for SQL.pm that will give you additional output that may be helpful while you're debugging. This

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
'Neil Cc: users@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db Very interesting. Is the mysql server on the same machine spamassassin is running on? I assumed you have insured DBI and the DBD for MySQL is installed. HFC Don O'Neil wrote: >I've tr

Re: Enabling per user rules in SQL db

2006-02-12 Thread Henry F. Camacho Jr
rom: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 3:11 PM To: Don O'Neil Subject: Re: Enabling per user rules in SQL db I am using -q -x on spamd. HFC Don O'Neil wrote: Spamd is being called through spamc in a | to the ifspamh wrapper http:

RE: Enabling per user rules in SQL db

2006-02-12 Thread Don O'Neil
I've tride with both -Q and -q... But neither makes a difference. Don -Original Message- From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 3:11 PM To: Don O'Neil Subject: Re: Enabling per user rules in SQL db I am using -q -x on spamd.

Re: Enabling per user rules in SQL db

2006-02-12 Thread Henry F. Camacho Jr
How is spamd getting called? spamass-milter? If so put the following in your sysconfig: "-u -e" HFC Don O'Neil wrote: I'm having problems getting rules to be read from a DB: I'm launching spamd: /usr/local/bin/spamd -x -Q -s local5 -d (thanks for the brainfart fix on the logs) And hav