I haven't had any reply from the amavis-user list, OR the squirrelmail list. I need to get this project finished ASAP and am running into walls. =/
I hope someone else has seen this issue pop up before. =/
---
Greetings again.
I have a fairly common setup.. internet -> mailgate box -> mail server.
The mail server (postal) is running Postfix 2.0.19, Apache 1.3.31 and Squirrelmail 1.4.3-RC1. PHP 4.3.6. The mailgate box is running Postfix 2.0.19, MySQL 4.0.18, and amavisd-new-20030616_p8. SpamAssassin 2.63
I am using the latest (0.7.2) Amavis-New SQL plugin.
I have a very similar setup working at home, but here at my day job, it's doing something strange.
What's happenning is this: * Mail comes into the mailgate box, gets scanned, and is passed along to the postal box. * I can SSH into either box and access the "amavis" SQL DB. Permissions are correct. * If I'm logged into Squirrelmail, the visual aspect of the plugin is working - I can see the scores, the whitelist, everything. I can even add & remove stuff from the whitelist and then check the actual MySQL DB and see the changes.
Amavis-New is not doing that, however. It's not pulling anything out of the database. I have compiled it with MySQL support as well. The DSN settings are correct, passwords are correct, everything seems to be correct.
In my test mail, I'd see this: From: [EMAIL PROTECTED] X-X-Sender: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Test Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at mailgate.jtllc.com X-Spam-Status: No, hits=0.3 tagged_above=-999.0 required=6.0 tests=NO_REAL_NAME X-Spam-Level:
Whereas the database (amavis, running on the mailgate machine) shows this:
mysql> select * from wblist
-> ;
+-----+-----+----------+-----------------------+----+
| rid | sid | priority | email | wb |
+-----+-----+----------+-----------------------+----+
| 3 | 0 | 7 | [EMAIL PROTECTED] | W |
| 3 | 0 | 6 | [EMAIL PROTECTED] | W |
+-----+-----+----------+-----------------------+----+
2 rows in set (0.00 sec)mysql>
I am really not sure what's causing this. The only thing that I can think of is that at home, I'm using users/email stored in MySQL and on this machine (postal) the users have actual $HOME/.maildir setups, but I didn't think that would matter any.
To quickly summarize:
Setup A (home) works
Setup B (work) isn't working
..yet both are virtually identical, except for the hardware involved and the postfix "transport" - might this affect it?
I haven't emailed the author of the plugin, but I was hoping he hung out here or someone had set this up in a similar manner.
Also, with this plugin, how do you set it up in a multiple-box setup like I have? Any experience with that?
Thanks! -Jonathan
