Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th October 2008, 00:22
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 5 Times in 5 Posts
Default 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}
Reply With Quote
Sponsored Links
  #2  
Old 6th October 2008, 09:04
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

Moved this thread, as ISPCOnfig 3 is in development / beta stadium.
Reply With Quote
  #3  
Old 6th October 2008, 09:52
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Is the exact email address xxx@test.com listed in the database table mail_user ?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 6th October 2008, 19:31
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 5 Times in 5 Posts
Default

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
Reply With Quote
  #5  
Old 6th October 2008, 19:39
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 6th October 2008, 20:57
jaimie jaimie is offline
Junior Member
 
Join Date: Sep 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 by jaimie; 6th October 2008 at 21:03.
Reply With Quote
  #7  
Old 6th October 2008, 21:16
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 5 Times in 5 Posts
Default

Quote:
Originally Posted by jaimie View Post
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...
Reply With Quote
  #8  
Old 6th October 2008, 21:00
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 5 Times in 5 Posts
Default

thnx

ps. is pam_mysql not needed for ISPconfig-3 anymore? INSTALL_CENTOS_5.2.txt does not mention it.
Reply With Quote
  #9  
Old 6th October 2008, 21:16
jaimie jaimie is offline
Junior Member
 
Join Date: Sep 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote
  #10  
Old 6th October 2008, 21:21
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 5 Times in 5 Posts
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPconfig setup - DNS, router and general access problems ingvar Installation/Configuration 6 31st July 2010 13:13
OpenVZ alongside ISPConfig - networking issue kuckus HOWTO-Related Questions 8 29th October 2008 00:27
HELP: ispconfig startup issue..need help quickly csharp2a General 1 8th September 2006 11:31
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


All times are GMT +2. The time now is 06:08.


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