HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Developers' Forum (http://www.howtoforge.com/forums/forumdisplay.php?f=33)
-   -   ISPconfig 3, dropmail issue (http://www.howtoforge.com/forums/showthread.php?t=27505)

Justin Albstmeijer 6th October 2008 00:22

ISPconfig 3, dropmail issue
 
mail is recognized as local, but gets bounced by dropmail..

any idea?

----

Oct 6 00:05:16 mail01 postfix/pipe[1877]: B927E2A8059: to=<xxx@test.com>, relay=maildrop, delay=0.06, delays=0.02/0.02/0/0.02, dsn=5.1.1, status=bounced (user unknown. Command output: Invalid user specified. )

------------
/etc/postfix/master.cf:

maildrop unix - n n - - pipe
flags=R user=vmail argv=/usr/bin/maildrop -d ${recipient} ${extension} ${recipient} ${user} ${nexthop} ${sender}

Ben 6th October 2008 09:04

Moved this thread, as ISPCOnfig 3 is in development / beta stadium.

till 6th October 2008 09:52

Is the exact email address xxx@test.com listed in the database table mail_user ?

Justin Albstmeijer 6th October 2008 19:31

yes,

SELECT email FROM mail_user WHERE email='xxx@test.com' and server_id = 5;
+-----------------+
| email |
+-----------------+
| xxx@test.com |
+-----------------+
1 row in set (0.00 sec)

----

when trying
# maildrop -d xxx@test.com
Invalid user specified.

I see no query to the database during this command.
is dropmail supposed to do a db call? or should pam_mysql be working on the mailserver?


here mail and db traces:

-- mail from mailserver shell

echo "test123" | mail -s test xxx@test.com


--- maillog ---

Oct 6 19:16:09 mail01 postfix/pickup[20382]: 8D05F2A8018: uid=0 from=<root>
Oct 6 19:16:09 mail01 postfix/cleanup[6051]: 8D05F2A8018: message-id=<20081006171609.8D05F2A8018@mail01.notreal.nl>
Oct 6 19:16:09 mail01 postfix/qmgr[29981]: 8D05F2A8018: from=<root@mail01.notreal.nl>, size=313, nrcpt=1 (queue active)
Oct 6 19:16:09 mail01 amavis[24052]: (24052-07) (!!)WARN: all primary virus scanners failed, considering backups
Oct 6 19:16:15 mail01 postfix/smtpd[6081]: connect from unknown[127.0.0.1]
Oct 6 17:16:15 mail01 postfix/smtpd[6081]: 18B0F2A8046: client=unknown[127.0.0.1]
Oct 6 19:16:15 mail01 postfix/cleanup[6051]: 18B0F2A8046: message-id=<20081006171609.8D05F2A8018@mail01.notreal.nl>
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 18B0F2A8046: from=<root@mail01.notreal.nl>, size=751, nrcpt=1 (queue active)
Oct 6 17:16:15 mail01 postfix/smtpd[6081]: disconnect from unknown[127.0.0.1]
Oct 6 19:16:15 mail01 amavis[24052]: (24052-07) Passed CLEAN, <root@mail01.notreal.nl> -> <xxx@test.com>, Message-ID: <20081006171609.8D05F2A8018@mail01.notreal.nl>, mail_id: W3aDphxOy9ci, Hits: 2.313, size: 313, queued_as: 18B0F2A8046, 5483 ms
Oct 6 19:16:15 mail01 postfix/smtp[6056]: 8D05F2A8018: to=<xxx@test.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=5.7, delays=0.14/0.04/0/5.5, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 18B0F2A8046)
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 8D05F2A8018: removed
Oct 6 19:16:15 mail01 postfix/pipe[6086]: 18B0F2A8046: to=<xxx@test.com>, relay=maildrop, delay=0.19, delays=0.04/0.05/0/0.1, dsn=5.1.1, status=bounced (user unknown. Command output: Invalid user specified. )
Oct 6 19:16:15 mail01 postfix/cleanup[6051]: 459672A8018: message-id=<20081006171615.459672A8018@mail01.notreal.nl>
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 459672A8018: from=<>, size=2634, nrcpt=1 (queue active)
Oct 6 19:16:15 mail01 postfix/bounce[6088]: 18B0F2A8046: sender non-delivery notification: 459672A8018
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 18B0F2A8046: removed
Oct 6 19:16:15 mail01 postfix/local[6089]: 459672A8018: to=<root@mail01.notreal.nl>, relay=local, delay=0.09, delays=0.02/0.02/0/0.05, dsn=2.0.0, status=sent (delivered to mailbox)
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 459672A8018: removed


--- actions on the database ----

081006 19:16:09 1283 Connect ispconfig@mail01.notreal.nl on dbispconfig
1283 Query SELECT transport FROM mail_transport WHERE domain='*' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='*' and active = 'y' and server_id = 5
081006 19:16:15 1284 Connect ispconfig@mail01.notreal.nl on dbispconfig
1284 Query SELECT 'domain' FROM mail_domain WHERE domain='mail01.notreal.nl' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='root@mail01.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='mail01.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.nl' and active = 'y' and server_id = 5
1284 Query SELECT 'domain' FROM mail_domain WHERE domain='test.com' and server_id = 5
1285 Connect ispconfig@mail01.notreal.nl on dbispconfig
1285 Query SELECT domain FROM mail_transport WHERE domain='test.com' and active = 'y' and server_id = 5
1285 Query SELECT domain FROM mail_transport WHERE domain='com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='xxx@test.com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='test.com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.com' and active = 'y' and server_id = 5
1286 Connect ispconfig@mail01.notreal.nl on dbispconfig
1286 Query SELECT destination FROM mail_forwarding WHERE source='xxx@test.com' and active = 'y' and server_id = 5
1287 Connect ispconfig@mail01.notreal.nl on dbispconfig
1287 Query SELECT email FROM mail_user WHERE email='xxx@test.com' and server_id = 5
1284 Query SELECT 'domain' FROM mail_domain WHERE domain='test.com' and server_id = 5
1285 Query SELECT domain FROM mail_transport WHERE domain='test.com' and active = 'y' and server_id = 5
1285 Query SELECT domain FROM mail_transport WHERE domain='com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='xxx@test.com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='test.com' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.com' and active = 'y' and server_id = 5
1286 Query SELECT destination FROM mail_forwarding WHERE source='root@mail01.notreal.nl' and active = 'y' and server_id = 5
1287 Query SELECT email FROM mail_user WHERE email='root@mail01.notreal.nl' and server_id = 5
1286 Query SELECT destination FROM mail_forwarding WHERE source='root' and active = 'y' and server_id = 5
1287 Query SELECT email FROM mail_user WHERE email='root' and server_id = 5
1286 Query SELECT destination FROM mail_forwarding WHERE source='@mail01.notreal.nl' and active = 'y' and server_id = 5
1287 Query SELECT email FROM mail_user WHERE email='@mail01.notreal.nl' and server_id = 5
1284 Query SELECT 'domain' FROM mail_domain WHERE domain='mail01.notreal.nl' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='root@mail01.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='mail01.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.notreal.nl' and active = 'y' and server_id = 5
1283 Query SELECT transport FROM mail_transport WHERE domain='.nl' and active = 'y' and server_id = 5

till 6th October 2008 19:39

The program is named maildrop and not dropmail and yes, dropmail is doing the lookup. Maybe the dropmail that you installed is not compiled with mysql support. You will have to compile and install maildrop as described in the installation instructions for ISPConfig 3 and not use the maildrop package from fedora or centos as that package lacks the mysql bindings.

jaimie 6th October 2008 20:57

I am having same problem
 
I have the exact same issue on a system that worked fine as of friday.

I am running fedora 9 x64. Looks like the maildrop program was changed on 10/04 so the Fedora Updates broke it.

is there a way to reload the config for Postfix?

Justin Albstmeijer 6th October 2008 21:00

thnx

ps. is pam_mysql not needed for ISPconfig-3 anymore? INSTALL_CENTOS_5.2.txt does not mention it.

jaimie 6th October 2008 21:16

Resolved
 
removing the Updated RPM from Fedora and re-installing the rpm I built fixed the problem. Thanks for pointing me in the correct direction.

Justin Albstmeijer 6th October 2008 21:16

Quote:

Originally Posted by jaimie (Post 148895)
I have the exact same issue on a system that worked fine as of friday.

I am running fedora 9 x64. Looks like the maildrop program was changed on 10/04 so the Fedora Updates broke it.

is there a way to reload the config for Postfix?

I'm not sure what you mean with 'reload the config for Postfix'.
If you are right about the update of dropmail being the cause of your issue.. I would suggest to reinstall the previous rpm (with --force) and exclude future updates of maildrop in /etc/yum.conf

exclude=maildrop*

to make sure an future update does not break it again...

jaimie 6th October 2008 21:20

Issue is confirmed and resolved. We shoud add exclude=maildrop* to the /etc/yum.conf as part of the install instructions for Fedora. This threw me for a few as I was thinking it was a config issue with Postfix.


All times are GMT +2. The time now is 04:52.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.