<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.2.2">
</HEAD>
<BODY>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Am Friday 10 March 2006 11:22 schrieb <A HREF="mailto:erik.neuwirth@gmx.de">erik.neuwirth@gmx.de</A>:</FONT>
<FONT COLOR="#000000">> ich "baue" mir grad den ersten Mailserver und hab da 'n kleines</FONT>
<FONT COLOR="#000000">> Problemchen mit den Postfächern über MYSQL. Ohne MYSQL geht's.</FONT>
<FONT COLOR="#000000">> Hab natürlich auch des aktuelle Postfixbuch, da sind aber die Konfigs</FONT>
<FONT COLOR="#000000">> für Postfix älter 2.2.x drinnen [(oder ich hab's noch nicht gefunden</FONT>
<FONT COLOR="#000000">> ;-)) ] Meine Postfix-Version ist die = 2.2.8</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Die Fehlermeldung lautet:</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> [10/03/2006 11:08:10] crit mail postfix/trivial-rewrite[14133]: fatal:</FONT>
<FONT COLOR="#000000">> mysql:/etc/postfix/mailbox.mysql(0,100): table lookup problem</FONT>
<FONT COLOR="#000000">Und davor?</FONT>
</PRE>
</BLOCKQUOTE>
[11/03/2006 00:56:35] crit mail postfix/trivial-rewrite[19218]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:57:36] crit mail postfix/trivial-rewrite[19257]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:57:36] crit mail postfix/trivial-rewrite[19258]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:57:42] info mail postfix/smtpd[19259]: connect from mail.echte_domain.de[xxx.xxx.xxx.xxx]<BR>
[11/03/2006 00:57:42] info mail postfix/smtpd[19260]: connect from mail.echte_domain.de[xxx.xxx.xxx.xxx]<BR>
[11/03/2006 00:57:42] info mail postfix/smtpd[19261]: connect from mail.echte_domain.de[xxx.xxx.xxx.xxx]<BR>
[11/03/2006 00:57:42] info mail postfix/smtpd[19262]: connect from mail.echte_domain.de[xxx.xxx.xxx.xxx]<BR>
[11/03/2006 00:57:42] info mail postfix/smtpd[19263]: connect from mail.echte_domain.de[xxx.xxx.xxx.xxx]<BR>
[11/03/2006 00:58:37] crit mail postfix/trivial-rewrite[19302]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:58:37] crit mail postfix/trivial-rewrite[19303]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:58:37] crit mail postfix/trivial-rewrite[19304]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
[11/03/2006 00:58:37] crit mail postfix/trivial-rewrite[19305]: fatal: mysql:/etc/postfix/mailbox.mysql(0,100): table lookup<BR>
problem<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Zeig mal Deine master.cf.</FONT>
</PRE>
</BLOCKQUOTE>
hier die master.cf<BR>
cat /etc/postfix/master.cf<BR>
#<BR>
# Postfix master process configuration file. For details on the format<BR>
# of the file, see the Postfix master(5) manual page.<BR>
#<BR>
# ==========================================================================<BR>
# service type private unpriv chroot wakeup maxproc command + args<BR>
# (yes) (yes) (yes) (never) (100)<BR>
# ==========================================================================<BR>
smtp inet n - - - - smtpd<BR>
#submission inet n - - - - smtpd<BR>
# -o smtpd_etrn_restrictions=reject<BR>
# -o smtpd_client_restrictions=permit_sasl_authenticated,reject<BR>
smtps inet n - - - - smtpd<BR>
-o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes<BR>
#submission inet n - - - - smtpd<BR>
# -o smtpd_etrn_restrictions=reject<BR>
submission inet n - - - - smtpd<BR>
-o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes<BR>
#628 inet n - - - - qmqpd<BR>
pickup fifo n - - 60 1 pickup<BR>
cleanup unix n - - - 0 cleanup<BR>
#qmgr fifo n - n 300 1 qmgr<BR>
qmgr fifo n - - 300 1 oqmgr<BR>
tlsmgr unix - - - 1000? 1 tlsmgr<BR>
rewrite unix - - - - - trivial-rewrite<BR>
bounce unix - - - - 0 bounce<BR>
defer unix - - - - 0 bounce<BR>
trace unix - - - - 0 bounce<BR>
verify unix - - - - 1 verify<BR>
flush unix n - - 1000? 0 flush<BR>
proxymap unix - - n - - proxymap<BR>
smtp unix - - - - - smtp<BR>
# When relaying mail as backup MX, disable fallback_relay to avoid MX loops<BR>
relay unix - - - - - smtp<BR>
-o fallback_relay=<BR>
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5<BR>
showq unix n - - - - showq<BR>
error unix - - - - - error<BR>
discard unix - - - - - discard<BR>
local unix - n n - - local<BR>
virtual unix - n n - - virtual<BR>
lmtp unix - - - - - lmtp<BR>
anvil unix - - - - 1 anvil<BR>
scache unix - - - - 1 scache<BR>
#<BR>
# ====================================================================<BR>
# Interfaces to non-Postfix software. Be sure to examine the manual<BR>
# pages of the non-Postfix software to find out what options it wants.<BR>
#<BR>
# Many of the following services use the Postfix pipe(8) delivery<BR>
# agent. See the pipe(8) man page for information about ${recipient}<BR>
# and other message envelope options.<BR>
# ====================================================================<BR>
#<BR>
# maildrop. See the Postfix MAILDROP_README file for details.<BR>
# Also specify in main.cf: maildrop_destination_recipient_limit=1<BR>
#<BR>
maildrop unix - n n - - pipe<BR>
flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${recipient}<BR>
#<BR>
# See the Postfix UUCP_README file for configuration details.<BR>
#<BR>
uucp unix - n n - - pipe<BR>
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)<BR>
#<BR>
# Other external delivery methods.<BR>
#<BR>
ifmail unix - n n - - pipe<BR>
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)<BR>
bsmtp unix - n n - - pipe<BR>
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient<BR>
scalemail-backend unix - n n - 2 pipe<BR>
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop}${user} ${extension}<BR>
mailman unix - n n - - pipe<BR>
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py<BR>
${nexthop} ${user}<BR>
<BR>
<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">-- </FONT>
<FONT COLOR="#000000"> Andreas</FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>