View Single Post
  #4  
Old 6th October 2008, 19:31
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 76
Thanks: 1
Thanked 6 Times in 6 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