qmail-scanner configuration for spamassassin mysql user prefs.

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/[^0-9a-z\.\_\-\=\+\@\$\%]/_/gi;
    $sa_user=~/^([0-9a-z\.\_\-\=\+\@\$\%]+)$/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
[email protected]
https://lists.sourceforge.net/lists/listinfo/qmail-scanner-general