spamd and SQL

2006-08-31 Thread Fábio Gomes
Hi list, Recently I faced a problem with my network where my e-mail servers couldn't contact my MySQL server. Because of that communication error, the incoming messages passed through without being scanned by spamd. Reading the sql/README I found the following information:

Re: spamd and SQL

2006-02-10 Thread Daryl C. W. O'Shea
Matt Kettler wrote: Henry F. Camacho Jr wrote: "[EMAIL PROTECTED]" is passed to spamd as "hfc" Since I am running spamassassin site wide, and I have a number of domains hitting this mail server, I really need to have the entire email address represented...Here is what my database looks like:

Re: spamd and SQL

2006-02-10 Thread Henry F. Camacho Jr
Matt: Did you see my post, I got it working just fine. spamass-milter options -u -e coupled with the following args for SPAMd made this work... SPAMDOPTIONS="-d -m5 -q -x" The system now _IGNORES_ the user specified when the milter was called, and _READS_ the to: address and uses that for a

Re: spamd and SQL

2006-02-10 Thread Matt Kettler
Henry F. Camacho Jr wrote: > Ok, > >> Just do what Matt said and pass the username to spamc with the -u >> option. It'll do exactly what you want. > > I don't understand what Daryl and Matt are saying by the above? > Remember this is a system wide installation and not just running for my > acc

Re: spamd and SQL

2006-02-10 Thread Matt Kettler
Henry F. Camacho Jr wrote: > Matt: > >> True.. And that username CAN be specified by spamc -u. Spamc passes it >> to spamd, >> spamd uses it when calling SQL. >> >> > Quoting from the SPAMc man page: > >>-u username >>This argument has been semi-obsoleted. To have spamd use

Re: spamd and SQL

2006-02-09 Thread DAve
DAve wrote: Henry F. Camacho Jr wrote: Ok, Just do what Matt said and pass the username to spamc with the -u option. It'll do exactly what you want. I don't understand what Daryl and Matt are saying by the above? Yes, I believe I have the same basic setup as you. I run spamd on a c

Re: spamd and SQL

2006-02-09 Thread DAve
Henry F. Camacho Jr wrote: Ok, Just do what Matt said and pass the username to spamc with the -u option. It'll do exactly what you want. I don't understand what Daryl and Matt are saying by the above? Yes, I believe I have the same basic setup as you. I run spamd on a central server an

Re: spamd and SQL

2006-02-09 Thread Henry F. Camacho Jr
Ok, Just do what Matt said and pass the username to spamc with the -u option. It'll do exactly what you want. I don't understand what Daryl and Matt are saying by the above? Remember this is a system wide installation and not just running for my account. I don't know where I would set sp

Re: spamd and SQL

2006-02-09 Thread Randy Smith
[EMAIL PROTECTED] wrote: Randy Smith wrote: Then I run spamc like so: spamc -s 512000 -u $RECIPIENT $RECIPIENT is set by my MTA and is replaced with the user's account name. [snip] What do you do for mail with multiple recipients? In my case, postfix breaks the message out fo

Re: spamd and SQL

2006-02-09 Thread Daryl C. W. O'Shea
Henry F. Camacho Jr wrote: Matt: True.. And that username CAN be specified by spamc -u. Spamc passes it to spamd, spamd uses it when calling SQL. Quoting from the SPAMc man page: -u username This argument has been semi-obsoleted. To have spamd use per-user-config file

Re: spamd and SQL

2006-02-09 Thread Henry F. Camacho Jr
Matt: True.. And that username CAN be specified by spamc -u. Spamc passes it to spamd, spamd uses it when calling SQL. Quoting from the SPAMc man page: -u username This argument has been semi-obsoleted. To have spamd use per-user-config files, run spamc as the user

Re: spamd and SQL

2006-02-09 Thread Matt Kettler
Henry F. Camacho Jr wrote: > Matt: > > Correct, however it is SPAMD that makes the call to the SQL database if > I am not mistaken, and there is a convention of passing username with in > the message. True.. And that username CAN be specified by spamc -u. Spamc passes it to spamd, spamd uses it w

Re: spamd and SQL

2006-02-09 Thread Matt Kettler
[EMAIL PROTECTED] wrote: > Randy Smith wrote: >> Then I run spamc like so: >> >> spamc -s 512000 -u $RECIPIENT >> >> $RECIPIENT is set by my MTA and is replaced with the user's account >> name. >> >> [snip] > > What do you do for mail with multiple recipients? > You either have to accept t

Re: spamd and SQL

2006-02-09 Thread Henry F. Camacho Jr
Matt: Correct, however it is SPAMD that makes the call to the SQL database if I am not mistaken, and there is a convention of passing username with in the message. What I want to have happen is each time SPAMd runs a distributed spam check I would like it to take the To: address, use that to

RE: spamd and SQL

2006-02-09 Thread Matthew.van.Eerde
Randy Smith wrote: > Then I run spamc like so: > > spamc -s 512000 -u $RECIPIENT > > $RECIPIENT is set by my MTA and is replaced with the user's account > name. > > [snip] What do you do for mail with multiple recipients? -- Matthew.van.Eerde (at) hbinc.com 805.964.4554 x

Re: spamd and SQL

2006-02-09 Thread Randy Smith
Henry F. Camacho Jr wrote: Matt: Thanks, yeah, ideally as each peice of email is being scanned by SPAMc/SPAMd it would change users and grab the userprefs from the SQL database. That's fairly simple. I use that same setup on my systems. I run spamd with these flags. spamd -x -d -q

Re: spamd and SQL

2006-02-09 Thread Matt Kettler
Henry F. Camacho Jr wrote: > Matt: > > Thanks, yeah, ideally as each peice of email is being scanned by > SPAMc/SPAMd it would change users and grab the userprefs from the SQL > database. Ok, well then pass it to spamc.. why are you trying to pass spamd a per-message parameter? That can't and w

Re: spamd and SQL

2006-02-09 Thread Henry F. Camacho Jr
Matt: Thanks, yeah, ideally as each peice of email is being scanned by SPAMc/SPAMd it would change users and grab the userprefs from the SQL database. HFC Matt Kettler wrote: Henry F. Camacho Jr wrote: I am trying to integrate spamassassin and Scalix. At this point I don't see anyway

Re: spamd and SQL

2006-02-09 Thread Matt Kettler
Henry F. Camacho Jr wrote: > I am trying to integrate spamassassin and Scalix. At this point I don't > see anyway of passing a username so that spamd will be able to base it's > query on. It is possible to configure spamd to use the "to:" address as > the username? It appears from everything tha

spamd and SQL

2006-02-09 Thread Henry F. Camacho Jr
I am trying to integrate spamassassin and Scalix. At this point I don't see anyway of passing a username so that spamd will be able to base it's query on. It is possible to configure spamd to use the "to:" address as the username? It appears from everything that I have read, you have to pass