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.
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.
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
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id�66&op=click
--
squirrelmail-users mailing list
List Address: [EMAIL PROTECTED]
List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
