AW: [Postfixbuch-users] Courier nimmt keine Verbindung zu Mysql auf

Sonja Linsi sonja at pondus.ch
Fr Dez 10 15:05:46 CET 2004


Peer Heinlein wrote:
> Am Freitag, 10. Dezember 2004 14:19 schrieb Sonja Linsi:
> 
> 
>>In welcher conf-Datei? In der authmysqlrc war hinter
>>MYSQL_SERVER	localhost
>>ein Tab drin, den habe rausgenommen, den ganzen courier und auch
>>Mysql neu gestartet, hat aber nichts genützt :-(.
> 
> 
> Kristallkugel ist in Reperatur, darum auf manuellem Wege:
> 
> 1) Die Config-Dateien von Courier (sowohl POP3, als auch IMAP als auch 
> AUTHMYSQLRC). Wie sonst soll man sehen, ob da was verdreht ist?

authmysqlrc:

##NAME: LOCATION:0
#
# The server name, userid, and password used to log in.

MYSQL_SERVER            localhost
MYSQL_USERNAME          postfix
MYSQL_PASSWORD          xxxxxxx
##NAME: MYSQL_SOCKET:0
#

#MYSQL_SOCKET           /var/lib/mysql/mysql.sock

##NAME: MYSQL_PORT:0


MYSQL_PORT              3306

##NAME: MYSQL_OPT:0

MYSQL_OPT               0

##NAME: MYSQL_DATABASE:0


MYSQL_DATABASE          mailbase

##NAME: MYSQL_USER_TABLE:0

MYSQL_USER_TABLE        mailusers

##NAME: MYSQL_CRYPT_PWFIELD:0


# MYSQL_CRYPT_PWFIELD   crypt

##NAME: MYSQL_CLEAR_PWFIELD:0
#
#
MYSQL_CLEAR_PWFIELD     passwort

##NAME: MYSQL_DEFAULT_DOMAIN:0

#
DEFAULT_DOMAIN          hostinghouse.ch
##NAME: MYSQL_UID_FIELD:0
#
# Other fields in the mysql table:
#
# MYSQL_UID_FIELD - contains the numerical userid of the account
#
#MYSQL_UID_FIELD                uid

##NAME: MYSQL_GID_FIELD:0
#
# Numerical groupid of the account

#MYSQL_GID_FIELD                gid

##NAME: MYSQL_LOGIN_FIELD:0
#

#

#MYSQL_LOGIN_FIELD      account

##NAME: MYSQL_HOME_FIELD:0
#

#MYSQL_HOME_FIELD       home

##NAME: MYSQL_NAME_FIELD:0
#
# The user's name (optional)

#MYSQL_NAME_FIELD       name

##NAME: MYSQL_MAILDIR_FIELD:0
#

#
MYSQL_MAILDIR_FIELD     maildir

Von da an keine Änderungen mehr.

**************************

pop3:


#  Courier POP3 daemon configuration
#
##NAME: PIDFILE:0
#

PIDFILE=/var/run/pop3d.pid

##NAME: MAXDAEMONS:0
#
#  Maximum number of POP3 servers started
#

MAXDAEMONS=40

##NAME: MAXPERIP:4
#
#  Maximum number of connections to accept from the same IP address

MAXPERIP=4

##NAME: AUTHMODULES:0
#


AUTHMODULES="authdaemon"


##NAME: AUTHMODULES_ORIG:0
#
# This setting is for use with webadmin

AUTHMODULES_ORIG="authdaemon"

##NAME: DEBUG_LOGIN:0


DEBUG_LOGIN=0

##NAME: POP3AUTH:1
#
# To advertise the SASL capability, per RFC 2449, uncomment the POP3AUTH
# variable:
#
# POP3AUTH="LOGIN"
#
# If you have configured the CRAM-MD5 or CRAM-SHA1, set POP3AUTH to 
something
# like this:
#
# POP3AUTH="LOGIN CRAM-MD5 CRAM-SHA1"

POP3AUTH=""

##NAME: POP3AUTH_ORIG:0
#
# For use by webadmin

POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1"

##NAME: POP3AUTH_TLS:1
#
# To also advertise SASL PLAIN if SSL is enabled, uncomment the
# POP3AUTH_TLS environment variable:
#
# POP3AUTH_TLS="LOGIN PLAIN"

POP3AUTH_TLS=""

##NAME: POP3AUTH_TLS_ORIG:0
#
# For use by webadmin

POP3AUTH_TLS_ORIG="LOGIN PLAIN"
##NAME: PORT:1
#


PORT=110

##NAME: ADDRESS:0
#
# IP address to listen on.  0 means all IP addresses.

ADDRESS=0

##NAME: TCPDOPTS:0
#
# Other couriertcpd(1) options.  The following defaults should be fine.
#

TCPDOPTS="-nodnslookup -noidentlookup"

##NAME: POP3DSTART:0
#
# POP3DSTART is not referenced anywhere in the standard Courier programs
# or scripts.  Rather, this is a convenient flag to be read by your system
# startup script in /etc/rc.d, like this:
#
#  . ${sysconfdir}/pop3d
#  case x$POP3DSTART in
#  x[yY]*)
#        /usr/lib/courier-imap/pop3d.rc start
#        ;;
#  esac
#
# The default setting is going to be NO, until Courier is shipped by default
# with enough platforms so that people get annoyed with having to flip it to
# YES every time.

POP3DSTART=YES

**********************
imap

##NAME: ADDRESS:0
#
#  Address to listen on, can be set to a single IP address.
#
# ADDRESS=127.0.0.1

ADDRESS=0

##NAME: PORT:1
#


PORT=143

##NAME: AUTHSERVICE:0
#

##NAME: MAXDAEMONS:0
#
#  Maximum number of IMAP servers started
#

MAXDAEMONS=40

##NAME: MAXPERIP:0
#
#  Maximum number of connections to accept from the same IP address

MAXPERIP=4

##NAME: PIDFILE:0
#
#  File where couriertcpd will save its process ID
#

PIDFILE=/var/run/imapd.pid

##NAME: TCPDOPTS:0
#
# Miscellaneous couriertcpd options that shouldn't be changed.
#

TCPDOPTS="-nodnslookup -noidentlookup"

##NAME: AUTHMODULES:0
#
# Authentication modules.  Here's the default list:
#
#    authdaemon
#
# The default is set during the initial configuration.
#

AUTHMODULES="authdaemon"

##NAME: AUTHMODULES_ORIG:0
#
# For use by webadmin

AUTHMODULES_ORIG="authdaemon"

##NAME: DEBUG_LOGIN:0
#
# Dump additional login diagnostics to syslog
#
# DEBUG_LOGIN=0   - turn off login debugging
# DEBUG_LOGIN=1   - turn on login debugging
# DEBUG_LOGIN=2   - turn on login debugging + log passwords too

DEBUG_LOGIN=0

##NAME: IMAP_CAPABILITY:1
#

IMAP_CAPABILITY="IMAP4rev1 UIDPLUS CHILDREN NAMESPACE 
THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE"

##NAME: KEYWORDS_CAPABILITY:0
#
# IMAP_KEYWORDS=1 enables custom IMAP keywords.  Set this option to 0 to
# disable custom keywords.

IMAP_KEYWORDS=1

##NAME: SMAP1_CAPABILITY:0
#

##NAME: IMAP_CAPABILITY_ORIG:1
#
# For use by webadmin

IMAP_CAPABILITY_ORIG="IMAP4rev1 UIDPLUS CHILDREN NAMESPACE 
THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA AUTH=CRAM-MD5 
AUTH=CRAM-SHA1 IDLE"

##NAME: IMAP_IDLE_TIMEOUT:0
#

IMAP_IDLE_TIMEOUT=60

##NAME: IMAP_CAPABILITY_TLS:0
#


IMAP_CAPABILITY_TLS="$IMAP_CAPABILITY AUTH=PLAIN"

##NAME: IMAP_TLS_ORIG:0
#

IMAP_CAPABILITY_TLS_ORIG="$IMAP_CAPABILITY_ORIG AUTH=PLAIN"

##NAME: IMAP_DISABLETHREADSORT:0
#IMAP_DISABLETHREADSORT=0

##NAME: IMAP_CHECK_ALL_FOLDERS:0
#


IMAP_CHECK_ALL_FOLDERS=0

##NAME: IMAP_OBSOLETE_CLIENT:0
#
# Set IMAP_OBSOLETE_CLIENT if your IMAP client expects \\NoInferiors to mean
# what \\HasNoChildren really means.

IMAP_OBSOLETE_CLIENT=0

##NAME: IMAP_ULIMITD:0
#

IMAP_ULIMITD=65536

##NAME: IMAP_USELOCKS:0


IMAP_USELOCKS=0

##NAME: IMAP_ENHANCEDIDLE:0
#


IMAP_ENHANCEDIDLE=0

##NAME: IMAP_TRASHFOLDERNAME:0


IMAP_TRASHFOLDERNAME=Trash

##NAME: IMAP_EMPTYTRASH:0
#

# IMAP_EMPTYTRASH=Trash:7,Sent:30
IMAP_EMPTYTRASH=Trash:7

##NAME: IMAP_MOVE_EXPUNGE_TO_TRASH:0
#

IMAP_MOVE_EXPUNGE_TO_TRASH=0


##NAME: OUTBOX:0
#
# The next set of options deal with the "Outbox" enhancement.
# Uncomment the following setting to create a special folder, named
# INBOX.Outbox
#
# OUTBOX=.Outbox

##NAME: SENDMAIL:0
#

SENDMAIL=/usr/sbin/sendmail

##NAME: HEADERFROM:0
#
HEADERFROM=X-IMAP-Sender

##NAME: IMAPDSTART:0
#
# IMAPDSTART is not used directly.  Rather, this is a convenient flag to
# be read by your system startup script in /etc/rc.d, like this:
#
#  . ${sysconfdir}/imapd
#
#  case x$IMAPDSTART in
#  x[yY]*)
#        /usr/lib/courier-imap/imapd.rc start
#        ;;
#  esac
#
# The default setting is going to be NO, so you'll have to manually flip
# it to yes.

IMAPDSTART=YES


> 2) Die passenden Auszüge aus Deinem Log von MySQL

Da passiert nichts mit Courier

> 3) Der Output von "lsof -i"
lsof -i
COMMAND     PID   USER   FD   TYPE DEVICE SIZE NODE NAME
sshd        886   root    5u  IPv6   3887       TCP *:ssh (LISTEN)
amavisd    1135  vscan    6u  IPv4   4305       TCP localhost:10024 (LISTEN)
amavisd    1199  vscan    6u  IPv4   4305       TCP localhost:10024 (LISTEN)
httpd2-pr  1244   root    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1244   root    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1254 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1254 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1255 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1255 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1256 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1256 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1257 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1257 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1258 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1258 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
httpd2-pr  1381 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr  1381 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
amavisd    1615  vscan    6u  IPv4   4305       TCP localhost:10024 (LISTEN)
couriertc  9797   root    5u  IPv6 430734       TCP *:imap (LISTEN)
mysqld     9879  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9880  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9881  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9882  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9883  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9884  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9885  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9886  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9887  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9888  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
mysqld     9932  mysql    3u  IPv4 431261       TCP *:mysql (LISTEN)
sshd      10085   root    6u  IPv6 433302       TCP 
web2.hostinghouse.ch:ssh->163-120.adsl.ch.inter.net:elatelink (ESTABLISHED)
sshd      10085   root   12u  IPv6 433329       TCP localhost:x11 (LISTEN)
sshd      10085   root   13u  IPv4 433330       TCP localhost:x11 (LISTEN)
sshd      10086   root    6u  IPv6 433302       TCP 
web2.hostinghouse.ch:ssh->163-120.adsl.ch.inter.net:elatelink (ESTABLISHED)
sshd      10086   root   12u  IPv6 433329       TCP localhost:x11 (LISTEN)
sshd      10086   root   13u  IPv4 433330       TCP localhost:x11 (LISTEN)
couriertc 10213   root    5u  IPv6 433945       TCP *:pop3 (LISTEN)
httpd2-pr 23106 wwwrun    5u  IPv4   6641       TCP 
web2.hostinghouse.ch:http (LISTEN)
httpd2-pr 23106 wwwrun    6u  IPv4   6642       TCP 
web2.hostinghouse.ch:https (LISTEN)
master    29280   root   15u  IPv4 329762       TCP localhost:smtp (LISTEN)
master    29280   root   16u  IPv4 329763       TCP 
web2.hostinghouse.ch:smtp (LISTEN)
master    29280   root   19u  IPv4 329768       TCP localhost:10025 (LISTEN)
master    29280   root   20u  IPv6 329769       TCP localhost:10025 (LISTEN)


> 4) Steht was in /var/log/mail oder /var/log/messages, was dazu passen 
> könnte?

/var/log/mail

Dec 10 14:14:34 essen043 pop3d: Connection, ip=[::ffff:212.59.163.120]
Dec 10 14:14:48 essen043 pop3d: LOGIN FAILED, ip=[::ffff:212.59.163.120]

in messages nichts, was dazu passen würde.

Vielen Dank und Gruss

Sonja



Mehr Informationen über die Mailingliste Postfixbuch-users