My configuration is kinda like yours, I think. I use vpopmail/qmail so there are no local users. From the vpopmail mailing list I got an answer about how to pass the username over.
If you are calling spamc from the .qmail file, you can use "-u [EMAIL PROTECTED]" as a spamc argument, and you'll end up with the full email address as the username that spamd uses. On Fri, 2004-08-27 at 12:36, Ziekke wrote: > Hello, > I'm trying to get SpamAssassin set up to locate all the user prefs from MySQL. > The problem I am running into is that all my mail users are virtual > users, none of them hae local accounts. Thus, setting spamd to use the > userid calling spamc isn't really useful. > > Is there any way to get spamassassin to use the "to" e-mail address as > the "userid" it looks up in the mysql tables? > > I looked all over for an option or something like that, and tried many > combinations of commandline switches. > > Unfortunately the -V switch isn't very useful to me, however an > extension off the -V would be exactly what I need. > > I've got php-sa up and running perfectly, I just need to figure out > this part of the puzzle. > > Any assistance would be great. > > I am using spamassassin 2.64 > commandline arguments are: > --nouser-config --sql-config --auto-whitelist --username=spamfilter > > My sql-related things in local.cf are: > > user_scores_dsn DBI:mysql:spamassassin:localhost > user_scores_sql_username *USERNAME* > user_scores_sql_password *PASSWORD* > user_scores_sql_table userpref > user_scores_sql_field_username username > user_scores_sql_field_preference preference > user_scores_sql_field_value value > user_scores_sql_field_scope spamassassin -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
