Hey all,
I'm working on a spamassassin gateway machine, and I'm a bit confused on how to set up the machine so users can have their own user_prefs files.
* The machine has no local users at all
* Mail is merely scanned by SA, f-prot, clamav, amavis, and anomy mailtools before it's passed along to the final destination machine.
* Users are stored in MySQL - the final mail server has no local users either.
Now, how can I set this up so users can have a web interface to edit stuff? If I have to install Apache & stuff on the gateway box, that's ok.
Is --virtual-config-dir what I need?
Will spamd create the directory for each user? Where does it find the user information? Will it just pull from the to:<> field?
I'm just wondering if anyone has set anything like this up before and can give me some pointers.
Ok, so I set up the web interface, the database, and everything that I could think of, but spamd isn't talking to the database. :(
Here's what happens on the mailgate machine:
Jan 21 13:04:50 [postfix/smtpd] connect from c-67-172-176-74.client.comcast.net[67.172.176.74]
Jan 21 13:04:50 [postfix/smtpd] D61B85165B: client=c-67-172-176-74.client.comcast.net[67.172.176.74]
Jan 21 13:04:51 [postfix/cleanup] D61B85165B: message-id=<[EMAIL PROTECTED]>
Jan 21 13:04:51 [postfix/qmgr] D61B85165B: from=<[EMAIL PROTECTED]>, size=740, nrcpt=1 (queue active)
spamd[10415]: [processing message <[EMAIL PROTECTED]> for filter] 1000._
Jan 21 13:04:51 [postfix/smtpd] disconnect from c-67-172-176-74.client.comcast.net[67.172.176.74]
spamd[10415]: [clean message (-4.9/5.0) for filter] 1000 in 4.7 seconds, 764 bytes._
Jan 21 13:04:56 [amavisd] starting. amavis 0.3.12 Tue Oct 7 17:16:53 PDT 2003
Jan 21 13:04:56 [postfix/smtpd] connect from unknown[127.0.0.1]
Jan 21 13:04:56 [postfix/smtpd] 6928D516A3: client=unknown[127.0.0.1]
Jan 21 13:04:56 [postfix/cleanup] 6928D516A3: message-id=<[EMAIL PROTECTED]>
Jan 21 13:04:56 [postfix/qmgr] 6928D516A3: from=<[EMAIL PROTECTED]>, size=1131, nrcpt=1 (queue active)
Jan 21 13:04:56 [postfix/smtpd] disconnect from unknown[127.0.0.1]
Jan 21 13:04:56 [postfix/pipe] D61B85165B: to=<[EMAIL PROTECTED]>, relay=filter, delay=6, status=sent (dummy)
Jan 21 13:04:56 [postfix/smtp] 6928D516A3: to=<[EMAIL PROTECTED]>, relay=192.168.10.35[192.168.10.35], delay=0, status=sent (250 Ok: queued as 79E2521FAA)
Now, I did also check it with the -D flag, but no SQL attempts were made. In local.cf, I have this:
user_scores_dsn DBI:mysql:sa_userpref:databox2.pbp.net user_scores_sql_username spam user_scores_sql_password (removed) user_scores_sql_table userpref
DNS is working fine. I can fire up "mysql" from mailgate and connect with the spam username & password and manipulate the database that way, but spamd isn't looking at it.
I'm calling spamc/spamd from the filter.sh script, found at http://advosys.ca/papers/postfix-filtering.html
Perhaps that has something to do with it? I'm not entirely sure.
If this is easier to accomplish with amavisd-new, let me know. I haven't been able to get that working but haven't really needed to because the current setup has been working ok.. I just wanted to add per-user prefs.
Thanks, everyone! :-)
-Jonathan
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
