Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-23 Thread Rubin Bennett
Here you go, and thanks! Output of spamd -q -D, left running for a while. Well... it reveals that it is in fact pulling my userprefs from SQL, but it was ignoring the ones with the $GLOBAL username. Apparently, it now requires the @GLOBAL username instead (which IIRC it didn't at some point in th

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-23 Thread Michael Parker
On Jan 23, 2008, at 6:37 AM, Rubin Bennett wrote: Spamd output below:[EMAIL PROTECTED] ~]# spamd -q -D [12373] dbg: logger: adding facilities: all [12373] dbg: logger: logging level is DBG Can you run this again and this time pass 1-2 msgs through just like you would normally, instead of j

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-23 Thread Rubin Bennett
On Tue, 2008-01-22 at 12:49 -0600, Michael Parker wrote: > On Jan 22, 2008, at 12:17 PM, Rubin Bennett wrote: > > > > > On Tue, 2008-01-22 at 10:45 -0600, Michael Parker wrote: > >> On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: > >>> > >>> WTF am I doing wrong?! > >> > >> Not including debug

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Michael Parker
On Jan 22, 2008, at 12:17 PM, Rubin Bennett wrote: On Tue, 2008-01-22 at 10:45 -0600, Michael Parker wrote: On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: WTF am I doing wrong?! Not including debug logs in your message. User prefs does not work with spamassassin, so you won't see any

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Rubin Bennett
On Tue, 2008-01-22 at 19:12 +0100, Alex Woick wrote: > Rubin Bennett schrieb am 22.01.2008 17:12: > > > I'm running SpamAssassin 3.2.3 (from Mandriva 2008.0), MySQL 5.0.45, > > perl-DBD-mysql-4.005, libdbi-drivers-dbd-mysql-0.8.2. > > What about perl-DBI-*? The libdbi-* drivers are not for perl,

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Rubin Bennett
On Tue, 2008-01-22 at 10:45 -0600, Michael Parker wrote: > On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: > > > > WTF am I doing wrong?! > > Not including debug logs in your message. > > User prefs does not work with spamassassin, so you won't see anything > there, but you should be seeing

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Alex Woick
Rubin Bennett schrieb am 22.01.2008 17:12: I'm running SpamAssassin 3.2.3 (from Mandriva 2008.0), MySQL 5.0.45, perl-DBD-mysql-4.005, libdbi-drivers-dbd-mysql-0.8.2. What about perl-DBI-*? The libdbi-* drivers are not for perl, they are for C programming. For database access to MySQL from Per

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Michael Parker
On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: WTF am I doing wrong?! Not including debug logs in your message. User prefs does not work with spamassassin, so you won't see anything there, but you should be seeing something for Bayes SQL and AWL SQL if they are configured correctly.

Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Rubin Bennett
Hello all... I've spent the past 2 days trying, utterly unsuccessfully, to get spamd to run against a MySQL database. My head is bloody from banging it on the wall, and now I prostrate myself to the mailing list gods in the hopes that you may be able to help me :) I'm running SpamAssassin 3.2.3 (

Re: CGPSA + MySQL, Userprefs Problems

2006-11-12 Thread Magnus Anderson
On Sun, 12 Nov 2006 12:59:33 +0100, Magnus Anderson wrote: > Hi, > > I'm having a problem with CGPSA and MySQL Userprefs settings. > > For the record, this *was* working a few days ago when I was testing to > set it up, but somehow it stopped working suddenly. Just in tim

CGPSA + MySQL, Userprefs Problems

2006-11-12 Thread Magnus Anderson
Hi, I'm having a problem with CGPSA and MySQL Userprefs settings. For the record, this *was* working a few days ago when I was testing to set it up, but somehow it stopped working suddenly. Just in time for me to implement it into a working system. Well, my problem is that it only reac

RE: MySQL userprefs

2006-02-12 Thread Raimonds Aronietis
-Original Message- From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 9:28 PM To: Raimonds Aronietis Cc: users@spamassassin.apache.org Subject: Re: MySQL userprefs Raimonds: I am not sure ether, although I've looked at the source code for the SQL l

Re: MySQL userprefs

2006-02-12 Thread Henry F. Camacho Jr
Raimonds: I am not sure ether, although I've looked at the source code for the SQL loader. Here is what it looks like: $sql = "select $f_preference, $f_value from $f_table where ". "$f_username = ".$dbh->quote($username). " or $f_username = '[EMAIL PROTECTED]' order by $f_username asc"; } dbg(

Re: MySQL userprefs

2006-02-12 Thread Jonn R Taylor
Create a sql table like this: CREATE TABLE `userpref` ( `prefid` int(11) unsigned NOT NULL auto_increment, `username` varchar(100) NOT NULL default '', `preference` varchar(30) NOT NULL default '', `value` varchar(100) NOT NULL default '', PRIMARY KEY (`prefid`) ) TYPE=MyISAM; INSERT IN

MySQL userprefs

2006-02-12 Thread Raimonds Aronietis
Hi, I am trying to make a sql-based per user setup of preferences and want to ask if anyone knows how the entries in mysql table should be made correctly. I have not been able to find corresponding documentation. :( There are two possible ways and I am in doubt which is correct: 1. userpref