Re: [qmailtoaster] Server Upgrade - now spamd not scanning

2010-03-18 Thread Gilbert T. Gutierrez, Jr.
I believe you are referencing using MySQL with Spamassasin.  I am trying to 
find my notes.  Install the SquirrelMail plugin and follow the instructions 
in http://wiki.apache.org/spamassassin/UsingSQL to modify your spamassasin 
installation.  Below is a couple of my configurations.  I believe there is a 
flag modification on compilation.  I am looking for it now.


/var/qmail/supervise/spamd/run reads...
#!/bin/sh
exec /usr/bin/spamd -x -q --max-children=15 -u vpopmail -s stderr 21


/etc/mail/spamassassin/local.cf has some lines similar to ...

# Add MySQL User Support
user_scores_dsn  DBI:mysql:spamassassin:127.0.0.1
user_scores_sql_password xx
user_scores_sql_username xx
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE 
username = _USERNAME_ OR username = '$GLOBAL' OR username = 
CONCAT('%',_DOMAIN_) ORDER BY username ASC



Gilbert T. Gutierrez, Jr.
Phoenix Internet

- Original Message - 
From: Ronnie Tartar

To: qmailtoaster-list@qmailtoaster.com
Sent: Wednesday, March 17, 2010 6:23 PM
Subject: RE: [qmailtoaster] Server Upgrade - now spamd not scanning


Help



-
Qmailtoaster is sponsored by Vickers Consulting Group 
(www.vickersconsulting.com)
   Vickers Consulting Group offers Qmailtoaster support and installations.
 If you need professional help with your setup, contact them today!
-
Please visit qmailtoaster.com for the latest news, updates, and packages.

 To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com

For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com




Re: [qmailtoaster] Server Upgrade - now spamd not scanning

2010-03-18 Thread Gilbert T. Gutierrez, Jr.

I found some of my notes...
Under Installing qmailadmin-toaster . . .
change the line rpmbuild --rebuild --with $DISTRO $ADMN
to rpmbuild --rebuild --with $DISTRO --define 'spambox 1' $ADMN


Under Installing simscan-toaster . . .
change the line rpmbuild --rebuild --with $DISTRO $SIMS
to rpmbuild -bb --with $DISTRO --target $(uname -m) 
/usr/src/redhat/SPECS/simscan-toaster.spec


Gilbert T. Gutierrez, Jr.
Phoenix Internet


- Original Message - 
From: Gilbert T. Gutierrez, Jr. mailing-li...@phoenixinternet.net

To: qmailtoaster-list@qmailtoaster.com
Sent: Thursday, March 18, 2010 10:34 AM
Subject: Re: [qmailtoaster] Server Upgrade - now spamd not scanning


I believe you are referencing using MySQL with Spamassasin.  I am trying to 
find my notes.  Install the SquirrelMail plugin and follow the instructions 
in http://wiki.apache.org/spamassassin/UsingSQL to modify your spamassasin 
installation.  Below is a couple of my configurations.  I believe there is 
a flag modification on compilation.  I am looking for it now.


/var/qmail/supervise/spamd/run reads...
#!/bin/sh
exec /usr/bin/spamd -x -q --max-children=15 -u vpopmail -s stderr 21


/etc/mail/spamassassin/local.cf has some lines similar to ...

# Add MySQL User Support
user_scores_dsn  DBI:mysql:spamassassin:127.0.0.1
user_scores_sql_password xx
user_scores_sql_username xx
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ 
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username = 
CONCAT('%',_DOMAIN_) ORDER BY username ASC



Gilbert T. Gutierrez, Jr.
Phoenix Internet

- Original Message - 
From: Ronnie Tartar

To: qmailtoaster-list@qmailtoaster.com
Sent: Wednesday, March 17, 2010 6:23 PM
Subject: RE: [qmailtoaster] Server Upgrade - now spamd not scanning


Help



-
Qmailtoaster is sponsored by Vickers Consulting Group 
(www.vickersconsulting.com)

   Vickers Consulting Group offers Qmailtoaster support and installations.
 If you need professional help with your setup, contact them today!
-
Please visit qmailtoaster.com for the latest news, updates, and 
packages.

To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com
For additional commands, e-mail: 
qmailtoaster-list-h...@qmailtoaster.com







-
Qmailtoaster is sponsored by Vickers Consulting Group 
(www.vickersconsulting.com)
   Vickers Consulting Group offers Qmailtoaster support and installations.
 If you need professional help with your setup, contact them today!
-
Please visit qmailtoaster.com for the latest news, updates, and packages.

 To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com

For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com




RE: [qmailtoaster] Server Upgrade - now spamd not scanning

2010-03-17 Thread Ronnie Tartar
Help

 

From: Ronnie Tartar [mailto:rtar...@host2max.com] 
Sent: Wednesday, March 17, 2010 11:41 AM
To: qmailtoaster-list@qmailtoaster.com
Subject: [qmailtoaster] Server Upgrade - now spamd not scanning

 

I migrated all my users to a new server a few weeks ago.  But it looks like
it's not forwarding through spamassassin.  

 

looks like my config is ok.

 

Does anybody have the link to the configuration of simscan to use per user
sasql scores?

 

Thanks