Postfix/Courier & MySQL Problem beim abholen von Mails
Hallo Liste.
Ich habe schon diverse Archive nach einer Lösung für das folgende
Problem durchforstet nun probiere ich es einfach mal hier.
Ich habe auf meinem Debian woody System Postfix und Courier mit MySQL
Unterstützung installiert.
Das versenden von Mails funktioniert, doch das abholen, sei es über POP3
oder IMAP funktioniert nicht.
Fehlermeldung in /var/log/mail.err
Aug 10 02:33:25 xxxx pop3d-ssl: LOGIN FAILED, ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 02:47:54 xxxx pop3d-ssl: LOGIN FAILED, ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 02:51:35 xxxx pop3d-ssl: LOGIN FAILED, ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 02:52:09 xxxx courierpop3login: LOGIN FAILED,
ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 02:53:01 xxxx courierpop3login: LOGIN FAILED,
ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 03:10:30 xxxx pop3d-ssl: LOGIN FAILED, ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 03:11:37 xxxx courierpop3login: LOGIN FAILED,
ip=[::ffff:XXX.XXXX.XXX.XXX]
Aug 10 03:13:46 xxxx pop3d-ssl: LOGIN FAILED, ip=[::ffff:XXX.XXXX.XXX.XXX]
bzw.
Aug 10 03:13:59 xxxx imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1]
Aug 10 03:13:59 xxxx imaplogin: DISCONNECTED, ip=[::ffff:127.0.0.1],
headers=0, body=0
wenn ich es per Squirrel Mail versuche.
Die SQL Abfrage funktioniert, denke ich, da in der mysql.log ein
postiver EIntrag auftaucht.
Der Fehler, das in der /etc/courier/authmysqlrc Leerzeichen an manchen
Stellen dürfte es auch nicht sein, da ich diese Datei darauf überprüft habe.
################# /etc/postfix/main.cf ###################
# basic settings
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
program_directory = /usr/lib/postfix
myorigin = DOMAINNAME
mydomain = DOMAINNAME
mydestination = $myhostname, localhost.$mydomain, $mydomain, $transport_maps
mynetworks = 127.0.0.0/8
# virtual domain and delivery settings
virtual_mailbox_limit = 10000000
virtual_mailbox_base = /home/vmail/
virtual_uid_maps = static:1002
virtual_gid_maps = static:1002
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf
alias_maps = mysql:/etc/postfix/mysql-aliases.cf
relocated_maps = mysql:/etc/postfix/mysql-relocated.cf
transport_maps = mysql:/etc/postfix/mysql-transport.cf
virtual_maps = mysql:/etc/postfix/mysql-virtual.cf
# define which email is accepted for delivery only
# alias_maps means: addresses in the MySQL aliase table
# virtual_mailbox_maps: addresses in the MySQL virtual table
# unix:passwd.byname: addresses of local users in /etc/passwd (optional)
local_recipient_maps = $alias_maps $virtual_mailbox_maps unix:passwd.byname
# settings for authenticated SMTP
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated, ch$
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
# some other options
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
setgid_group = postdrop
biff = no
# appending .domain is the MUA's job.
append_dot_mydomain = no
relayhost =
mailbox_size_limit = 0
recipient_delimiter = +
message_size_limit = 10000000
content_filter = amavis:[127.0.0.1]:10024
##################### /etc/postfix/master.cf ###################
# ==========================================================================
smtp inet n - - - - smtpd
#628 inet n - - - - qmqpd
pickup fifo n - - 60 1 pickup
cleanup unix n - - - 0 cleanup
qmgr fifo n - - 300 1 qmgr
#qmgr fifo n - - 300 1 nqmgr
rewrite unix - - - - - trivial-rewrite
bounce unix - - - - 0 bounce
defer unix - - - - 0 bounce
flush unix n - - 1000? 0 flush
smtp unix - - - - - smtp
showq unix n - - - - showq
error unix - - - - - error
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
#
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
# The Cyrus deliver program has changed incompatibly.
#
cyrus unix - n n - - pipe
flags=R user=cyrus argv=/usr/sbin/cyrdeliver -e -m ${extension} ${user}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail
($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -d -t$nexthop -f$sender
$recip$
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store
${nexthop}$
# only used by postfix-tls
#smtps inet n - n - - smtpd -o
smtpd_tls_wrap$
#587 inet n - n - - smtpd -o
smtpd_enforce_$
amavis unix - - n - 2 smtp
-o smtp_data_done_timeout=1200
-o disable_dns_lookups=yes
127.0.0.1:10025 inet n - n - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
-o strict_rfc821_envelopes=yes
##############/etc/courier/authmysqlrc ###############
MYSQL_SERVER localhost
MYSQL_USERNAME vmail
MYSQL_PASSWORD XXXXXXXXX
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE provider
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD homedir
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
Bin für jeden Tipp dankbar.
MfG
Thomas Flohr
Reply to: