ISPconfig 3, dropmail issue

Discussion in 'Developers' Forum' started by Justin Albstmeijer, Oct 6, 2008.

  1. Justin Albstmeijer

    Justin Albstmeijer New Member

    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}
     
  2. Ben

    Ben ISPConfig Developer ISPConfig Developer

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

    till Super Moderator Staff Member ISPConfig Developer

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

    Justin Albstmeijer New Member

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

    till Super Moderator Staff Member ISPConfig Developer

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

    jaimie New Member

    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?
     
    Last edited: Oct 6, 2008
  7. Justin Albstmeijer

    Justin Albstmeijer New Member

    thnx

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

    jaimie New Member

    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.
     
  9. Justin Albstmeijer

    Justin Albstmeijer New Member

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

    jaimie New Member

    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.
     
  11. Justin Albstmeijer

    Justin Albstmeijer New Member

    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
     

Share This Page