Hi,
I have been trying to make spamassassin with qmail scanner work aginst SQL user
preferences wothout any luck.
My local.cf contains.
user_scores_dsn
DBI:mysql:spamassassin:mysql_socket=/var/lib/mysql/mysql.sock
user_scores_sql_username username
user_scores_sql_password password
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE
username = _USERNAME_ OR username = '@GLOBAL' ORDER BY username ASC
I am running spamd with following switches
/usr/bin/spamd -q -x -u spamd -H /home/spamd -d -D -r
/var/run/spamassassin/spamd.pid
the debug message from spamd says
Feb 29 04:47:37 sreedevi spamd[4100]: debug: Conf::SQL: executing SQL: SELECT
preference, value FROM userpref WHERE username = 'qscand' OR username =
'@GLOBAL' ORDER BY username ASC
Feb 29 04:47:37 sreedevi spamd[4100]: debug: retrieving prefs for qscand from
SQL server
Here qmail scanner is not able to identify the recipient as the user, I know
that we need to tweak sub-spamassassin.pl for this.
Following is the code added to sub-spamassassin.pl before opening spamc.
if ($recips =~ m/\,/) {
$sa_domain = &recips_in_same_domain($recips);
if (defined $sa_domain && $sa_domain ne "") {
$sa_user = "\%" . $sa_domain;
}
else {
$sa_user = "\$GLOBAL";
}
}
else {
$sa_user = $recips;
}
$sa_user=~s/[EMAIL PROTECTED]/_/gi;
$sa_user=~/^([EMAIL PROTECTED])$/i;
$sa_user=tolower($1);
But while installing I am getting the below error. Please suggest me on this.
Global symbol "$sa_domain" requires explicit package name at
./qmail-scanner-queue.pl line 3311.
Global symbol "$sa_domain" requires explicit package name at
./qmail-scanner-queue.pl line 3312.
Global symbol "$sa_domain" requires explicit package name at
./qmail-scanner-queue.pl line 3312.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3313.
Global symbol "$sa_domain" requires explicit package name at
./qmail-scanner-queue.pl line 3313.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3316.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3320.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3322.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3323.
Global symbol "$sa_user" requires explicit package name at
./qmail-scanner-queue.pl line 3324.
Execution of ./qmail-scanner-queue.pl aborted due to compilation errors.
Please suggest me on this.
Sincerely,
Sreedevi.
Now you can chat without downloading messenger. Go to
http://in.messenger.yahoo.com/webmessengerpromo.php-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Qmail-scanner-general mailing list
Qmail-scanner-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qmail-scanner-general
