On 5/17/06, Rick Macdougall <[EMAIL PROTECTED]> wrote:
Hi ,
Funny you should talk about the same im in the middle of right now, the sql userprefs.
Im just gonna jump in with my thing:
I used the toaster and instead of qmailscanner, this time I decided to use simscan/clamav etc. I got another server running the qmailscanner setup and this issue is not there.
Im calling spamd in debug mode for the time and disabled it from /service with the cmd: "/usr/bin/spamd -D -q -u vpopmail -H /home/vpopmail"
On my other server this makes the bayes stuff lookup like this in the debug output:
Calling spamd with:
"/usr/bin/spamd -D -x -q -u spamd -H /home/vpopmail "
([EMAIL PROTECTED] beeing the local mail reciever)
-------------------
[586] dbg: config: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = ' [EMAIL PROTECTED]' OR username = '$GLOBAL' OR username = CONCAT('%','domain.com') ORDER BY username ASC
[586] dbg: config: retrieving prefs for [EMAIL PROTECTED] from SQL server
-------------------
On my simscan server I get this (/usr/bin/spamd -D -q -u vpopmail -H /home/vpopmail):
-------------------
[24557] dbg: config: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = 'clamav' OR username = '$GLOBAL' OR username = CONCAT('%',NULL) ORDER BY username ASC
[24557] dbg: config: retrieving prefs for clamav from SQL server
-------------------
SQL tables and stuff are right, its connecting and doing its stuff. Replica from the working one. Same local.cf conf too. I can see one diff in the calling cmd's and thats the -u vpopmail vs -u spamd, but i have no idea if that could be the case.
Can anyone please point me in the right direction i cant remember?
Thanks :)
/Aleks
B Kreps wrote:
> Rick,
>
> Thank you for the link, I'll give this a spin since it looks so simple;
> perhaps it's even worth the time to fix the globals and port it to
> Squirrelmail. I'm assuming I'll need to add the -q parameter to my spamd
> instantiation so it will read user preferences from SQL. Are there any
> other tricks I need to know?
>
> Regards,
> Brian
>
Hi,
You'll also need to tell SA about the user, password and database to
use, man Mail::SpamAssassin::Conf. It all goes in your local.cf
Regards,
ick
Hi ,
Funny you should talk about the same im in the middle of right now, the sql userprefs.
Im just gonna jump in with my thing:
I used the toaster and instead of qmailscanner, this time I decided to use simscan/clamav etc. I got another server running the qmailscanner setup and this issue is not there.
Im calling spamd in debug mode for the time and disabled it from /service with the cmd: "/usr/bin/spamd -D -q -u vpopmail -H /home/vpopmail"
On my other server this makes the bayes stuff lookup like this in the debug output:
Calling spamd with:
"/usr/bin/spamd -D -x -q -u spamd -H /home/vpopmail "
([EMAIL PROTECTED] beeing the local mail reciever)
-------------------
[586] dbg: config: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = ' [EMAIL PROTECTED]' OR username = '$GLOBAL' OR username = CONCAT('%','domain.com') ORDER BY username ASC
[586] dbg: config: retrieving prefs for [EMAIL PROTECTED] from SQL server
-------------------
On my simscan server I get this (/usr/bin/spamd -D -q -u vpopmail -H /home/vpopmail):
-------------------
[24557] dbg: config: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = 'clamav' OR username = '$GLOBAL' OR username = CONCAT('%',NULL) ORDER BY username ASC
[24557] dbg: config: retrieving prefs for clamav from SQL server
-------------------
SQL tables and stuff are right, its connecting and doing its stuff. Replica from the working one. Same local.cf conf too. I can see one diff in the calling cmd's and thats the -u vpopmail vs -u spamd, but i have no idea if that could be the case.
Can anyone please point me in the right direction i cant remember?
Thanks :)
/Aleks
