<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal style='margin-bottom:12.0pt'><span class=postbody>Ich bin
gerade am Rumexperimentieren mit Postfix + MySQL so das ich es irgendwann mit
einen POP3/IMAP Server auf einen "Produktiv" rechner schieben kann. </span><br>
<br>
<span class=postbody>Ich habe die Anleitung <a
href="http://www.workaround.org/articles/ispmail-sarge/" target="_blank">http://www.workaround.org/articles/ispmail-sarge/</a>
benutzt. Das System ist Debian Sarge. </span><br>
<br>
<span class=postbody>Ich hab alles nach der Anleitung eingerichtet und das
email delivern funktioniert auch, aber nur solange ich nicht das maildir format
verwende </span><br>
<span class=postbody>Sobald ich ein '/' hinter die einzelnen mailbox_map
einträgen in der datenbank schreibe (oder per Select concat(email,'/') abfrage)
- kommen folgende fehler : </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal>Mar 14 22:06:04 sam postfix/smtpd[6831]: connect from
fmmailgate04.web.de[217.72.192.242] <br>
Mar 14 22:06:04 sam postfix/smtpd[6831]: 845B8800F52:
client=fmmailgate04.web.de[217.72.192.242] <br>
Mar 14 22:06:04 sam postfix/cleanup[6834]: 845B8800F52:
message-id=<268153704@web.de> <br>
Mar 14 22:06:04 sam postfix/qmgr[6822]: 845B8800F52:
from=<tim@domainname.biz>, size=735, nrcpt=1 (queue active) <br>
Mar 14 22:06:04 sam postfix/smtpd[6831]: disconnect from
fmmailgate04.web.de[217.72.192.242] <br>
Mar 14 22:06:45 sam postfix/virtual[6845]: fatal: gethostbyname: Success <br>
Mar 14 22:06:46 sam postfix/master[6820]: warning: process
/usr/lib/postfix/virtual pid 6845 exit status 1 <br>
Mar 14 22:06:46 sam postfix/master[6820]: warning: /usr/lib/postfix/virtual:
bad command startup -- throttling <br>
Mar 14 22:06:46 sam postfix/qmgr[6822]: warning: premature end-of-input on
private/virtual socket while reading input attribute name <br>
Mar 14 22:06:46 sam postfix/qmgr[6822]: warning: private/virtual socket:
malformed response <br>
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<o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><br>
<br>
<span class=postbody>Wenn gar nix gehen würde, würde ich es ja verstehen - aber
mailbox ja und maildir nicht? Vielleicht hatte ja einer von euch mal ähnliche
Probleme. </span><br>
<br>
<span class=postbody>Hänge mal vorsichtshalber die configs an. </span><br>
<br>
<span class=postbody>Meine main.cf sieht folgender maßen aus : </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal># See /usr/share/postfix/main.cf.dist for a commented,
more complete version <br>
<br>
smtpd_banner = $myhostname ESMTP $mail_name <br>
biff = no <br>
<br>
# appending .domain is the MUA's job. <br>
append_dot_mydomain = no <br>
<br>
# Uncomment the next line to generate "delayed mail" warnings <br>
#delay_warning_time = 4h <br>
<br>
myhostname = sam.domain.tld <br>
mydestination = sam.domain.tld <br>
mynetworks = 127.0.0.0/8 <br>
virutal_alias_domains = <br>
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
<br>
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf <br>
virtual_mailbox_maps =
mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf <br>
virtual_mailbox_base = /home/vmail <br>
virtual_uid_maps = static:5000 <br>
virtual_gid_maps = static:5000 <br>
virtual_transport = virtual <br>
<br>
alias_maps = <br>
alias_database = <br>
<br>
virtual_mailbox_limit = 1073741824 <br>
mailbox_size_limit = 1073741824 <br>
message_size_limit = 104857600 <br>
recipient_delimiter = + <br>
inet_interfaces = all <br>
<br>
smtpd_recipient_restrictions =permit_mynetworks <br>
,permit_sasl_authenticated <br>
,permit_mx_backup <br>
,reject_unauth_destination <br>
<br>
<br>
<br>
<br>
smtpd_sasl_auth_enable = yes <br>
broken_sasl_auth_clients = yes <br>
smtpd_use_tls = yes <br>
smtpd_tls_cert_file = /etc/postfix/smtpd.cert <br>
smtpd_tls_key_file = /etc/postfix/smtpd.key <o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><br>
<br>
<span class=postbody>mysql_virtual_alias_maps.cf </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal>user = postfix <br>
password = passwort <br>
hosts = localhost <br>
dbname = mail <br>
table = forwardings <br>
select_field = destination <br>
where_field = source <o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><br>
<br>
<span class=postbody>mysql_virtual_domain_maps.cf </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal>user = postfix <br>
password = passwort <br>
hosts = localhost <br>
dbname = mail <br>
table = domains <br>
select_field = 'virtual' <br>
where_field = domain <o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><br>
<br>
<span class=postbody>mysql_virtual_mailbox_maps.cf </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal>user = postfix <br>
password = passwort <br>
hosts = localhost <br>
dbname = mail <br>
table = users <br>
select_field = user <br>
where_field = email <o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><br>
<br>
<span class=postbody>MySQL DB (in XML) </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b>Code:</b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><br>
<!--- Datenbank: `mail`--> <br>
<mail> <br>
<!-- Tabelle domains --> <br>
<domains> <br>
<domain>bla.de</domain> <br>
</domains> <br>
<domains> <br>
<domain>domain.de</domain> <br>
</domains> <br>
<!-- Tabelle forwardings --> <br>
<forwardings> <br>
<source>@domain.de</source> <br>
<destination>tim@domain.de</destination>
<br>
</forwardings> <br>
<!-- Tabelle users --> <br>
<users> <br>
<user>tim@domain.de/</user> <br>
<password>secret</password> <br>
<email>tim@domain.de</email> <br>
</users> <br>
<users> <br>
<user>tim@bla.de/</user> <br>
<password>secret</password> <br>
<email>tim@bla.de</email> <br>
</users> <br>
</mail> <o:p></o:p></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></p>
</div>
</body>
</html>