[Postfixbuch-users] Postfix + MySql + Maildir - Mail wird nichtzugestellt... [zusatz verbose output]
Tim Weyand
postfixbuch at weyand.biz
Sa Mär 26 17:18:32 CET 2005
Hier noch mal der Verbose Output, vielleicht hilft es ja ...
Mar 26 01:33:09 sam postfix/smtpd[9086]: connect from
fmmailgate04.web.de[217.72.192.242]
Mar 26 01:33:09 sam postfix/smtpd[9086]: 71592800271:
client=fmmailgate04.web.de[217.72.192.242]
Mar 26 01:33:09 sam postfix/cleanup[9089]: 71592800271:
message-id=<273616441 at web.de>
Mar 26 01:33:09 sam postfix/qmgr[9076]: 71592800271: from=<tim at sender.biz>,
size=834, nrcpt=1 (queue active)
Mar 26 01:33:09 sam postfix/smtpd[9086]: disconnect from
fmmailgate04.web.de[217.72.192.242]
Mar 26 01:33:42 sam postfix/virtual[9094]: match_string: fast_flush_domains
~? debug_peer_list
Mar 26 01:33:42 sam postfix/virtual[9094]: match_string: fast_flush_domains
~? fast_flush_domains
Mar 26 01:33:42 sam postfix/virtual[9094]: set_eugid: euid 102 egid 104
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: user = postfix
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: password = password
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: dbname = mail
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: table = users
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: select_field = user
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: where_field = email
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: additional_conditions =
Mar 26 01:33:42 sam postfix/virtual[9094]: cfg_get_str:
/etc/postfix/mysql_virtual_mailbox_maps.cf: hosts = 127.0.0.1
Mar 26 01:33:42 sam postfix/virtual[9094]: mysqlname_parse:
/etc/postfix/mysql_virtual_mailbox_maps.cf: adding host '127.0.0.1' to list
of mysql server hosts
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_open:
mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_open: static:5000
Mar 26 01:33:42 sam postfix/virtual[9094]: name_mask: fcntl
Mar 26 01:33:42 sam postfix/virtual[9094]: watchdog_create: 0x8054508 18000
Mar 26 01:33:42 sam postfix/virtual[9094]: watchdog_stop: 0x8054508
Mar 26 01:33:42 sam postfix/virtual[9094]: watchdog_start: 0x8054508
Mar 26 01:33:42 sam postfix/virtual[9094]: connection established
Mar 26 01:33:42 sam postfix/virtual[9094]: master_notify: status 0
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_request_initial: send
initial status
Mar 26 01:33:42 sam postfix/virtual[9094]: send attr status = 0
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
flags
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: flags
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 3
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
queue_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: queue_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: active
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
queue_id
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: queue_id
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
71592800271
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 306
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
size
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: size
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 834
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
nexthop
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: nexthop
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
hanseknight.de
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
encoding
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: encoding
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: (end)
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
sender
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: sender
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
tim at sender.biz
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
errors-to
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: errors-to
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
tim at sender.biz
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
return-receipt
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name:
return-receipt
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: (end)
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
time
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: time
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 1111797189
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
client_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: client_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
fmmailgate04.web.de
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
client_address
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name:
client_address
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
217.72.192.242
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
protocol_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name:
protocol_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: ESMTP
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
helo_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: helo_name
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
fmmailgate04.web.de
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 284
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
original_recipient
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name:
original_recipient
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
weyand at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
recipient
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: recipient
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value:
tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: virtual socket: wanted attribute:
offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute name: offset
Mar 26 01:33:42 sam postfix/virtual[9094]: input attribute value: 0
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_request_get: file
active/7/71592800271
Mar 26 01:33:42 sam postfix/virtual[9094]: local_deliver: 71592800271 from
tim at receiver.biz
Mar 26 01:33:42 sam postfix/virtual[9094]: local_deliver[0]: reset user_attr
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_recipient[1]: recip
tim at receiver.de deliver
Mar 26 01:33:42 sam postfix/virtual[9094]: level: 0
Mar 26 01:33:42 sam postfix/virtual[9094]: path: active/7/71592800271
Mar 26 01:33:42 sam postfix/virtual[9094]: fp: 0x8054e88
Mar 26 01:33:42 sam postfix/virtual[9094]: queue_name: active
Mar 26 01:33:42 sam postfix/virtual[9094]: queue_id: 71592800271
Mar 26 01:33:42 sam postfix/virtual[9094]: offset: 306
Mar 26 01:33:42 sam postfix/virtual[9094]: sender: tim at sender.biz
Mar 26 01:33:42 sam postfix/virtual[9094]: recipient: tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: user: tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: delivered: tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: relay: virtual
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_mailbox[2]: recip
tim at receiver.de deliver tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_mysql_lookup using sql
query: select user from users where email = 'tim at receiver.de'
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_mysql_get_active: attempting
to connect to host 127.0.0.1
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_mysql: successful connection
to host 127.0.0.1
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_mysql: successful query from
host 127.0.0.1
Mar 26 01:33:42 sam postfix/virtual[9094]: dict_mysql_lookup: retrieved 1
rows
Mar 26 01:33:42 sam postfix/virtual[9094]: maps_find: virtual_mailbox_maps:
mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf(0,34100):
tim at hanseknight.de = mailbox1/
Mar 26 01:33:42 sam postfix/virtual[9094]: mail_addr_find: tim at receiver.de
-> mailbox1/
Mar 26 01:33:42 sam postfix/virtual[9094]: maps_find: virtual_uid_maps:
static:5000(0,34100): tim at receiver.de = 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: mail_addr_find:
tim at hanseknight.de -> 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: maps_find: virtual_gid_maps:
static:5000(0,34100): tim at hanseknight.de = 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: mail_addr_find: tim at receiver.de
-> 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_mailbox[2]: set
user_attr: /home/vmail/mailbox1/, uid = 5000, gid = 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: deliver_maildir[3]: recip
tim at receiver.de deliver tim at receiver.de
Mar 26 01:33:42 sam postfix/virtual[9094]: set_eugid: euid 5000 egid 5000
Mar 26 01:33:42 sam postfix/virtual[9094]: fatal: gethostbyname: Success
Mar 26 01:33:43 sam postfix/master[9074]: warning: process
/usr/lib/postfix/virtual pid 9094 exit status 1
Mar 26 01:33:43 sam postfix/master[9074]: warning: /usr/lib/postfix/virtual:
bad command startup -- throttling
Mar 26 01:33:43 sam postfix/qmgr[9076]: warning: premature end-of-input on
private/virtual socket while reading input attribute name
Mar 26 01:33:43 sam postfix/qmgr[9076]: warning: private/virtual socket:
malformed response
Mar 26 01:33:43 sam postfix/qmgr[9076]: warning: transport virtual failure
-- see a previous warning/fatal/panic logfile record for the problem
description
> -----Ursprüngliche Nachricht-----
> Von: postfixbuch-users-bounces at listi.jpberlin.de [mailto:postfixbuch-
> users-bounces at listi.jpberlin.de] Im Auftrag von Tim Weyand
> Gesendet: Samstag, 26. März 2005 00:57
> An: postfixbuch-users at listi.jpberlin.de
> Betreff: [Postfixbuch-users] Postfix + MySql + Maildir - Mail wird
> nichtzugestellt...
>
> Vielleicht wird es ja zu Ostern was -
> Sorry dass ich noch mal schreibe, letztes Mal gab es leider keine Lösung.
> Deshalb dachte ich probiere ich es noch mal.
>
> Ich bin gerade am Rumexperimentieren mit Postfix + MySQL so das ich den
> Server mit POP3/IMAP "Produktiv" einsetzen kann.
>
> Die Anleitung http://www.workaround.org/articles/ispmail-sarge/
> Diente mir als vorlage für die Konfiguration.
>
> Es funktioniert auch mit dem mbox format, aber komischer weise nicht mit
> dem
> maildir format.
> Sobald ich ein '/' hinter die einzelnen mailbox_map einträgen in der
> datenbank schreibe (oder per Select concat(email,'/') abfrage) - kommen
> folgende fehler in der mail.log:
>
> Code:
>
> Mar 14 22:06:04 sam postfix/smtpd[6831]: connect from
> fmmailgate04.web.de[217.72.192.242]
> Mar 14 22:06:04 sam postfix/smtpd[6831]: 845B8800F52:
> client=fmmailgate04.web.de[217.72.192.242]
> Mar 14 22:06:04 sam postfix/cleanup[6834]: 845B8800F52:
> message-id=<268153704 at web.de>
> Mar 14 22:06:04 sam postfix/qmgr[6822]: 845B8800F52:
> from=<tim at domainname.biz>, size=735, nrcpt=1 (queue active)
> Mar 14 22:06:04 sam postfix/smtpd[6831]: disconnect from
> fmmailgate04.web.de[217.72.192.242]
> Mar 14 22:06:45 sam postfix/virtual[6845]: fatal: gethostbyname: Success
> Mar 14 22:06:46 sam postfix/master[6820]: warning: process
> /usr/lib/postfix/virtual pid 6845 exit status 1
> Mar 14 22:06:46 sam postfix/master[6820]: warning:
> /usr/lib/postfix/virtual:
> bad command startup -- throttling
> Mar 14 22:06:46 sam postfix/qmgr[6822]: warning: premature end-of-input on
> private/virtual socket while reading input attribute name
> Mar 14 22:06:46 sam postfix/qmgr[6822]: warning: private/virtual socket:
> malformed response
> Mar 14 22:06:46 sam postfix/qmgr[6822]: warning: transport virtual failure
> -- see a previous warning/fatal/panic logfile record for the problem
> Description
>
> Wenn gar nix gehen würde, würde ich es ja verstehen - aber mbox ja und
> maildir nicht? Vielleicht hatte ja einer von euch mal ähnliche Probleme.
>
> Wenn ich den befehl aufrufe
> #postmap -v -q
> 'tim at domain.de'mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
>
>
> Bekomme ich folgendes zurück :
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: user =
> postfix
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: password
> =
> passwort
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: dbname =
> mail
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: table =
> users
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf:
> select_field = user
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf:
> where_field = email
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf:
> additional_conditions =
> postmap: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: hosts =
> localhost
> postmap: mysqlname_parse: /etc/postfix/mysql_virtual_mailbox_maps.cf:
> adding
> host 'localhost' to list of mysql server hosts
> postmap: dict_open: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
> postmap: dict_mysql_lookup using sql query: select user from users where
> email = 'tim at domain.de'
> postmap: dict_mysql_get_active: attempting to connect to host localhost
> postmap: dict_mysql: successful connection to host localhost
> postmap: dict_mysql: successful query from host localhost
> postmap: dict_mysql_lookup: retrieved 1 rows
> mailbox1/
> sam:~#
>
>
> In der Hoffnung das mir jemand auf die Sprünge helfen kann, wünsche ich
> schon mal Frohe Ostern
> Tim
>
> Ich hänge mal vorsichtshalber die configs an.
> Meine main.cf sieht folgender maßen aus :
> sam:/etc/postfix# postconf -n
> alias_database =
> alias_maps =
> append_dot_mydomain = no
> biff = no
> broken_sasl_auth_clients = yes
> config_directory = /etc/postfix
> debug_peer_level = 1
> inet_interfaces = all
> mailbox_size_limit = 1073741824
> message_size_limit = 104857600
> mydestination = sam.server-project.info
> myhostname = sam.server-project.info
> mynetworks = 127.0.0.0/8
> recipient_delimiter = +
> relayhost =
> smtpd_banner = $myhostname ESMTP $mail_name
> smtpd_recipient_restrictions = permit_mynetworks
> ,permit_sasl_authenticated ,permit_mx_backup
> ,reject_unauth_destination
> smtpd_sasl_auth_enable = yes
> smtpd_tls_cert_file = /etc/postfix/smtpd.cert
> smtpd_tls_key_file = /etc/postfix/smtpd.key
> smtpd_use_tls = yes
> virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
> virtual_gid_maps = static:5000
> virtual_mailbox_base = /home/vmail
> virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
> virtual_mailbox_limit = 1073741824
> virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
> virtual_uid_maps = static:5000
>
> mysql_virtual_alias_maps.cf
>
>
> Code:
>
>
> user = postfix
> password = passwort
> hosts = localhost
> dbname = mail
> table = forwardings
> select_field = destination
> where_field = source
>
>
>
> mysql_virtual_domain_maps.cf
>
>
> Code:
>
>
> user = postfix
> password = passwort
> hosts = localhost
> dbname = mail
> table = domains
> select_field = 'virtual'
> where_field = domain
>
>
>
> mysql_virtual_mailbox_maps.cf
>
>
> Code:
>
>
> user = postfix
> password = passwort
> hosts = localhost
> dbname = mail
> table = users
> select_field = user
> where_field = email
>
>
>
> MySQL DB (in XML)
>
>
> Code:
> <!--- Datenbank: `mail`-->
> <mail>
> <!-- Tabelle domains -->
> <domains>
> <domain>bla.de</domain>
> </domains>
> <domains>
> <domain>domain.de</domain>
> </domains>
> <!-- Tabelle forwardings -->
> <forwardings>
> <source>@domain.de</source>
> <destination>tim at domain.de</destination>
> </forwardings>
> <!-- Tabelle users -->
> <users>
> <user>tim at domain.de/</user>
> <password>secret</password>
> <email>tim at domain.de</email>
> </users>
> <users>
> <user>tim at bla.de/</user>
> <password>secret</password>
> <email>tim at bla.de</email>
> </users>
> </mail>
>
>
>
>
>
> --
> _______________________________________________
> Postfixbuch-users mailingliste
> Heinlein Professional Linux Support GmbH
>
> Postfixbuch-users at listi.jpberlin.de
> http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users
Mehr Informationen über die Mailingliste Postfixbuch-users