Yup... On the same server. We use SQL to manage the qmail users, and DBI and DBD are used all the time from packages such as phpMySQLadmin, etc... They're there.
-----Original Message----- From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 6:28 PM To: Don O'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 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. > >HFC > > >Don O'Neil wrote: > > > >>Spamd is being called through spamc in a | to the ifspamh wrapper.... >> >>http://www.gbnet.net/~jrg/qmail/ifspamh/ >> >>It's a wrapper that is called from the virtual sql users .qmail file. >> >>-----Original Message----- >>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: "-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 have /etc/mail/spamassassin/sql.cf: >>> >>>user_scores_dsn DBI:mysql:spamassassin:localhost >>>user_scores_sql_password spamkiller >>>user_scores_sql_username spamassassin >>> >>>And created the tables with the included templates, and installed one >>>of the web based config tools (from http://mail.limelyte.net/webspam/ >>>) and it >>>wrote: >>> >>>username preference value prefid >>>[EMAIL PROTECTED] rewrite_header Subject ***SPAM*** 1 [EMAIL PROTECTED] >>>report_safe 1 2 [EMAIL PROTECTED] use_terse_report 0 3 [EMAIL PROTECTED] >>>always_add_headers 1 4 [EMAIL PROTECTED] always_add_report 0 5 >>>[EMAIL PROTECTED] required_hits 5 6 >>> >>>To the userpref table... But it doesn't seem to be working. >>> >>>There is a message from the daemon: >>> >>>Feb 12 14:24:42 bigbird spamd[5154]: spamd: setuid to shcu0129 >>>succeeded, reading scores from SQL So it seems to be connecting... >>> >>>But I never see a message "retrieving prefs for [EMAIL PROTECTED] from >>>SQL server" >>> >>>I'm sending myself spam... And it gets flagged, but the subject isn't >>>being rewritten. >>> >>>What am I doing wrong or missing? >>> >>> >>>Thanks again!!!! >>>Don >>> >>> >>> >>> >>> >>>
