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

[Tim Weyand]

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>