AW: [Postfixbuch-users] Postfix, Courier-imap und Mysql

hansluebken at de-facto.de hansluebken at de-facto.de
Mo Sep 9 16:55:29 CEST 2002


Hier die Configdateien )die Kommentare hab ich rausgelöscht!

authdeamonrc
##VERSION: $Id: authdaemonrc.in,v 1.8 2001/10/07 02:16:22 mrsam Exp $
authmodulelist="authmysql"
authmodulelistorig="authmysql"
daemons=5
version=""
authdaemonvar=/usr/lib/courier-imap/var/authdaemon

authmysqlrc
##VERSION: $Id: authmysqlrc,v 1.10 2002/04/02 23:41:41 mrsam Exp $
MYSQL_SERVER		192.168.99.113
MYSQL_USERNAME		mailsystem
MYSQL_PASSWORD		vagl1a
MYSQL_PORT		3306
MYSQL_OPT		0
MYSQL_DATABASE		mailbase
MYSQL_USER_TABLE	mailbase
MYSQL_CRYPT_PWFIELD	crypt
MYSQL_CLEAR_PWFIELD	password
DEFAULT_DOMAIN		luebken.de
MYSQL_UID_FIELD		uid
MYSQL_GID_FIELD		gid
MYSQL_LOGIN_FIELD	id
MYSQL_HOME_FIELD	home
MYSQL_NAME_FIELD	name
MYSQL_MAILDIR_FIELD	maildir

imapd:
##VERSION: $Id: imapd.dist.in,v 1.15 2002/08/11 20:00:20 mrsam Exp $
ADDRESS=192.168.99.113
PORT=143
MAXDAEMONS=40
MAXPERIP=4
PIDFILE=/var/run/imapd.pid
TCPDOPTS="-nodnslookup -noidentlookup"
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
IMAP_CAPABILITY="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT
THREAD=REFERENCES SORT QUOTA"
IMAP_CAPABILITY_ORIG="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT
THREAD=REFERENCES SORT AUTH=CRAM-MD5 AUTH=CRAM-SHA1 IDLE"
IMAP_IDLE_TIMEOUT=60
IMAP_CAPABILITY_TLS="$IMAP_CAPABILITY AUTH=PLAIN"
IMAP_CAPABILITY_TLS_ORIG="$IMAP_CAPABILITY_ORIG AUTH=PLAIN"
IMAP_DISABLETHREADSORT=0
IMAP_CHECK_ALL_FOLDERS=0
IMAP_OBSOLETE_CLIENT=0
IMAP_ULIMITD=65536
IMAP_USELOCKS=0
IMAP_EMPTYTRASH=Trash:7
IMAP_MOVE_EXPUNGE_TO_TRASH=0
SENDMAIL=/usr/sbin/sendmail
HEADERFROM=X-IMAP-Sender
IMAPDSTART=NO

pop3d:
##VERSION: $Id: pop3d.dist.in,v 1.5 2002/08/11 20:00:20 mrsam Exp $
PIDFILE=/var/run/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
POP3AUTH=""
POP3AUTH_TLS=""
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
PORT=110
ADDRESS=192.168.99.113
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=NO

Und ein Auszug aus  /var/log/mail
Sep  9 14:14:21 inet postfix/postfix-script: warning:
/var/spool/postfix/etc/hosts and /etc/hosts differ
Sep  9 14:14:21 inet postfix/postfix-script: warning:
/var/spool/postfix/etc/passwd and /etc/passwd differ
Sep  9 14:14:24 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:14:24 inet postfix/master[2480]: daemon started
Sep  9 14:14:24 inet postfix/nqmgr[2482]: warning: database
/etc/postfix/virtual.db is older than source file /etc/postfix/virtual
Sep  9 14:16:54 inet postfix/master[2480]: reload configuration
Sep  9 14:17:11 inet postfix/postfix-script: stopping the Postfix mail
system
Sep  9 14:17:11 inet postfix/master[2480]: terminating on signal 15
Sep  9 14:17:27 inet postfix/postfix-script: warning:
/var/spool/postfix/etc/hosts and /etc/hosts differ
Sep  9 14:17:27 inet postfix/postfix-script: warning:
/var/spool/postfix/etc/passwd and /etc/passwd differ
Sep  9 14:17:27 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:17:27 inet postfix/master[2671]: daemon started
Sep  9 14:25:55 inet postfix/postfix-script: stopping the Postfix mail
system
Sep  9 14:25:55 inet postfix/master[2671]: terminating on signal 15
Sep  9 14:26:02 inet postfix/postfix-script: warning:
/var/spool/postfix/etc/hosts and /etc/hosts differ
Sep  9 14:26:02 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:26:02 inet postfix/master[2835]: daemon started
Sep  9 14:27:08 inet postfix/postfix-script: stopping the Postfix mail
system
Sep  9 14:27:08 inet postfix/master[2835]: terminating on signal 15
Sep  9 14:27:14 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:27:14 inet postfix/master[2991]: daemon started
Sep  9 14:27:23 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 14:27:43 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 14:34:57 inet postfix/master[2991]: terminating on signal 15
Sep  9 14:36:06 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:36:07 inet postfix/master[918]: daemon started
Sep  9 14:49:12 inet postfix/master[918]: terminating on signal 15
Sep  9 14:50:13 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:50:13 inet postfix/master[918]: daemon started
Sep  9 14:55:16 inet postfix/postfix-script: stopping the Postfix mail
system
Sep  9 14:55:16 inet postfix/master[918]: terminating on signal 15
Sep  9 14:55:20 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:55:20 inet postfix/master[1398]: daemon started
Sep  9 14:56:00 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 14:56:05 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 14:57:10 inet postfix/master[1398]: terminating on signal 15
Sep  9 14:58:08 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 14:58:09 inet postfix/master[918]: daemon started
Sep  9 15:03:18 inet postfix/master[918]: terminating on signal 15
Sep  9 15:04:20 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 15:04:20 inet postfix/master[918]: daemon started
Sep  9 15:06:35 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:06:40 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:10:22 inet postfix/master[918]: terminating on signal 15
Sep  9 15:11:20 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 15:11:20 inet postfix/master[906]: daemon started
Sep  9 15:14:59 inet postfix/postfix-script: stopping the Postfix mail
system
Sep  9 15:14:59 inet postfix/master[906]: terminating on signal 15
Sep  9 15:15:03 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 15:15:03 inet postfix/master[1387]: daemon started
Sep  9 15:17:02 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:17:07 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:18:00 inet postfix/smtpd[1397]: warning: database
/etc/postfix/canonical.db is older than source file /etc/postfix/canonical
Sep  9 15:18:00 inet postfix/smtpd[1397]: connect from localhost[127.0.0.1]
Sep  9 15:18:00 inet postfix/smtpd[1397]: 7001322CD7:
client=localhost[127.0.0.1]
Sep  9 15:18:00 inet postfix/smtpd[1397]: disconnect from
localhost[127.0.0.1]
Sep  9 15:18:00 inet postfix/cleanup[1399]: warning: database
/etc/postfix/canonical.db is older than source file /etc/postfix/canonical
Sep  9 15:18:00 inet postfix/cleanup[1399]: warning: database
/etc/postfix/canonical_sender.db is older than source file
/etc/postfix/canonical_sender
Sep  9 15:18:00 inet postfix/pickup[1388]: 949F422CD8: uid=0
from=<root at inet.luebken.name>
Sep  9 15:18:00 inet postfix/cleanup[1399]: 949F422CD8:
message-id=<Pine.LNX.4.44.0209091517340.1396-100000 at inet.luebken.name>
Sep  9 15:18:00 inet postfix/nqmgr[1389]: 949F422CD8:
from=<root at inet.luebken.name>, size=633, nrcpt=1 (queue active)
Sep  9 15:18:00 inet postfix/nqmgr[1389]: 949F422CD8:
to=<hansel at luebken.de>, relay=none, delay=0, status=bounced (unknown user:
"hansel at luebken.de")
Sep  9 15:18:00 inet postfix/cleanup[1399]: C86A022CDC:
message-id=<20020909131800.C86A022CDC at inet.luebken.name>
Sep  9 15:18:00 inet postfix/nqmgr[1389]: C86A022CDC: from=<>, size=2294,
nrcpt=1 (queue active)
Sep  9 15:18:00 inet postfix/local[1402]: C86A022CDC:
to=<hansln at inet.luebken.name>, relay=local, delay=0, status=sent (mailbox)
Sep  9 15:18:05 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:18:10 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:25:10 inet postfix/master[1387]: terminating on signal 15
Sep  9 15:26:14 inet postfix/postfix-script: starting the Postfix mail
system
Sep  9 15:26:14 inet postfix/master[906]: daemon started
Sep  9 15:29:19 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:29:24 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:31:37 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:31:42 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:31:53 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:32:55 inet pop3d: Connection, ip=[::ffff:192.168.99.114]
Sep  9 15:33:00 inet pop3d: LOGIN FAILED, ip=[::ffff:192.168.99.114]
Sep  9 15:33:18 inet last message repeated 2 times


-----Ursprüngliche Nachricht-----
Von: Peer Heinlein [mailto:p.heinlein at jpberlin.de] 
Gesendet: Montag, 9. September 2002 10:25
An: postfixbuch-users at listi.jpberlin.de
Betreff: Re: [Postfixbuch-users] Postfix, Courier-imap und Mysql


Am Montag, 9. September 2002 08:38 schrieb hansluebken at de-facto.de:

> funktionieren. Ich erhalte beim Zugriff meines Clients über imap oder 
> pop einen Authentifizierungsfehler. Hat jemand ein paar Tips, woran 
> das liegen kann!?

An einer falschen Konfiguration...?

Nee, im Ernst: Schick mal die Config-Dateien rüber, sonst kann man ohne 
hellseherische Fähigkeiten dazu gar nix sagen. Maile als erste mal die 
Config-Dateien von Courier-IMAP und schau mal, ob in /var/log/mail 
etwas dazu geloggt wird.

Wenn Du etwas fitter darin bist schaltest Du MySQL vielleicht nochmal 
in den Debug-Modus und schaust/sendest mal, was Courier da überhaupt 
für eine MySQL-Abfrage produziert.

Ansonsten halt die üblichen Fragen:

a) Stimmen die Zugangsdaten zur MySQL-Datenbank (Username, Kennwort, 
Datenbankhost)?
b) Hast Du irgendwo einen Tippfehler in den Tabellennamen?
c) Läuft MySQL überhaupt :-)
d) Stimmt das Passwort überhaupt (blöde Frage, aber berechtigt!)

Lieben Gruß,

Peer







_______________________________________________
Postfixbuch-users mailingliste
JPBerlin - Mailbox und Politischer Provider
Postfixbuch-users at listi.jpberlin.de
http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users
-------------- nächster Teil --------------
Ein Dateianhang mit Binärdaten wurde abgetrennt...
Dateiname   : nicht verfügbar
Dateityp    : application/ms-tnef
Dateigröße  : 5612 bytes
Beschreibung: nicht verfügbar
URL         : <https://listi.jpberlin.de/pipermail/postfixbuch-users/attachments/20020909/2fee20f4/attachment.bin>


Mehr Informationen über die Mailingliste Postfixbuch-users