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