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=<[email protected]>, 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}

 

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

 

yes,

SELECT email FROM mail_user WHERE email='[email protected]' and server_id = 5;
+-----------------+
| email |
+-----------------+
| [email protected] |
+-----------------+
1 row in set (0.00 sec)

----

when trying
# maildrop -d [email protected]
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 [email protected]


--- 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=<[email protected]>
Oct 6 19:16:09 mail01 postfix/qmgr[29981]: 8D05F2A8018: from=<[email protected]>, 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=<[email protected]>
Oct 6 19:16:15 mail01 postfix/qmgr[29981]: 18B0F2A8046: from=<[email protected]>, 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, <[email protected]> -> <[email protected]>, Message-ID: <[email protected]>, mail_id: W3aDphxOy9ci, Hits: 2.313, size: 313, queued_as: 18B0F2A8046, 5483 ms
Oct 6 19:16:15 mail01 postfix/smtp[6056]: 8D05F2A8018: to=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>
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=<[email protected]>, 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 [email protected] 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 [email protected] 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='[email protected]' 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 [email protected] 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='[email protected]' 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 [email protected] on dbispconfig
1286 Query SELECT destination FROM mail_forwarding WHERE source='[email protected]' and active = 'y' and server_id = 5
1287 Connect [email protected] on dbispconfig
1287 Query SELECT email FROM mail_user WHERE email='[email protected]' 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='[email protected]' 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='[email protected]' and active = 'y' and server_id = 5
1287 Query SELECT email FROM mail_user WHERE email='[email protected]' 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='[email protected]' 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

 

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?

 

thnx

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

 

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.

 

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...

 

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.

 

compile remark..

to be precise maildrop will not query mysql by sql.. but will call courier-auth, meaning it needs to be compiled against courier-authlib-devel