[Postfixbuch-users] Postfix + MySql + Maildir - Mail wird nicht zugestellt...

Tim Weyand postfixbuch at weyand.biz
Mi Mär 30 06:06:20 CEST 2005 

So ich hab jetzt (nach 3 Wochen) mal die Ursache für diesen Fehler gefunden
- nachdem ich mittlerweile 3 mal den ganzen Server neuinstalliert habe!

Komischer Weise kommt der Fehler sobald ich den Hostnamen ändere? Ich meine
nicht in der main.cf sondern den eigentlichen hostnamen in /etc/hostname 

Kann das sein? *kopfschüttel*

Vielleicht hat ja jemand von euch einen einfall, wie ich meinen Hostnamen
ändern kann und weiterhin postfix benutzen kann ;-)

Gruß Tim

> -----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 17:19
> An: 'Eine Diskussionsliste rund um das Postfix-Buch.'
> Betreff: Re: [Postfixbuch-users] Postfix + MySql + Maildir - Mail
> wirdnichtzugestellt... [zusatz verbose output]
> 
> 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
> 
> 
> 
> --
> _______________________________________________
> 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