Postfix + MySQL: Input/Output Error

Postfix, QMail, Sendmail, Dovecot, Cyrus, Courier, Anti-Spam
stice
Posts: 4
Joined: 2009-01-23 12:32
 

Postfix + MySQL: Input/Output Error

Post by stice »

Guten Tag,
leider macht mein Mailserver nicht das, was er tun soll.
Ich habe folgendes Tutorial gewissenhaft und nun auch schon zum zweiten mal abgearbeitet: klick

Über telnet localhost 25 kann ich von Hand eMails an root versenden, welche auch wie geplant ankommen

Code: Select all

/home/vmail/virtual.test/user/new/1234623741.V901I18b87c1M789283.myserver
sobald ich allerdings versuche diese Extern abzurufen bekomme ich folgenden Fehler:

/var/log/mail.err

Code: Select all

Feb 14 16:03:52 stice pop3d: authentication error: Input/output error
Feb 14 16:04:01 stice pop3d: authentication error: Input/output error
Feb 14 16:06:10 stice imapd: authentication error: Input/output error
Feb 14 16:10:01 stice pop3d: authentication error: Input/output error
/var/mail/mail.log

Code: Select all

Feb 14 16:29:32 stice pop3d: Connection, ip=[::ffff:84.154.225.163]
Feb 14 16:29:38 stice pop3d: LOGIN FAILED, user=user@virtual.test, ip=[::ffff:84.154.225.163]
Feb 14 16:29:38 stice pop3d: authentication error: Input/output error
Leider finde ich in keinem Log, was den Fehler verursacht.

Meine aktuelle Konfiguration:

ps aux | grep postfix

Code: Select all

root     22109  0.0  0.0  37024  2208 ?        Ss   16:29   0:00 /usr/lib/postfix/master
postfix  22112  0.0  0.0  39080  2108 ?        S    16:29   0:00 pickup -l -t fifo -u -c
postfix  22113  0.0  0.0  39128  2152 ?        S    16:29   0:00 qmgr -l -t fifo -u
root     22888  0.0  0.0   7452   884 pts/0    S+   16:49   0:00 grep postfix
mysql-virtual_domains.cf / mysql-virtual_forwardings.cf / mysql-virtual_mailboxes.cf / mysql-virtual_email2email.cf

Code: Select all

user = provider_admin
password = ...
dbname = provider
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1

user = provider_admin
password = ...
dbname = provider
table = forwardings
select_field = destination
where_field = source
hosts = 127.0.0.1

user = provider_admin
password = ...
dbname = provider
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = 127.0.0.1

user = provider_admin
password = ...
dbname = provider
table = users
select_field = email
where_field = email
hosts = 127.0.0.1
/etc/postfix/sasl/smtpd.conf

Code: Select all

pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: provider_admin
sql_passwd: meinpw
sql_database: provider
sql_select: select password from users where email='%u@%r'
log_level: 7
postconf -n

Code: Select all

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
html_directory = /usr/share/doc/postfix/html
inet_interfaces = all
mailbox_size_limit = 0
mydestination = xxx.org, localhost.org, , localhost
myhostname = xxx.org
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
myorigin = /etc/mailname
readme_directory = /usr/share/doc/postfix
recipient_delimiter = +
relayhost =
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtpd_use_tls = yes
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_uid_maps = static:5000


Die Zertifikate existieren, ebenso der User vmail:5000 und die Gruppe vmail:5000

Bin jetzt schon eine ganze weile auf der Suche, und habe weder hier im Forum noch mit Google eine Antwort gefunden :/

Falls ich irgendwas vergessen habe zu posten, einfach sagen und ich liefer die Infos nach :)

Danke schonmal, stice
Last edited by stice on 2009-02-23 19:43, edited 1 time in total.
User avatar
daemotron
Administrator
Administrator
Posts: 2641
Joined: 2004-01-21 17:44
 

Re: Postfix + MySQL: Input/Output Error

Post by daemotron »

Läuft der saslauthd, und sind die Rechte des Sockets so gesetzt, dass Postfix darauf zugreifen darf?
stice
Posts: 4
Joined: 2009-01-23 12:32
 

Re: Postfix + MySQL: Input/Output Error

Post by stice »

saslauthd läuft, und auf welche Sockets genau benötigt Postfix zugriff?

edit:\ aber ich denke wenn es an sasl liegen würde, würde eher soetwas rauskommen

Code: Select all

Apr 16 12:32:05 h81916 postfix/smtpd[10911]: smtpd_sasl_authenticate: decoded response: xxxxxxxxxxx
Apr 16 12:32:05 h81916 postfix/smtpd[10911]: warning: SASL authentication failure: cannot connect to saslauthd server: Permission denied
Apr 16 12:32:05 h81916 postfix/smtpd[10911]: warning: <<clientname[client-ip]>>: SASL LOGIN authentication failed
Apr 16 12:32:05 h81916 postfix/smtpd[10911]: > <<clientname[client-ip]>>: 535 Error: authentication failed
Apr 16 12:32:05 h81916 postfix/smtpd[10911]: smtp_get: EOF
User avatar
Joe User
Project Manager
Project Manager
Posts: 11184
Joined: 2003-02-27 01:00
Location: Hamburg
 

Re: Postfix + MySQL: Input/Output Error

Post by Joe User »

Was hat Postfix mit POP3 oder IMAP zu tun?
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
stice
Posts: 4
Joined: 2009-01-23 12:32
 

Re: Postfix + MySQL: Input/Output Error

Post by stice »

Stimmt :/
Also Courier.
Dann werde ich morgen meine Configs von Courier/authdaemon etc. hochladen, aber vorweg schonmal eine Frage: wo befinden sich die Logs von Courier?
User avatar
daemotron
Administrator
Administrator
Posts: 2641
Joined: 2004-01-21 17:44
 

Re: Postfix + MySQL: Input/Output Error

Post by daemotron »

Courier loggt gegen das Syslog-Target "mail", genau wie Postfix. Du hast oben doch schon einen Auszug zitiert...
User avatar
mattis
Posts: 41
Joined: 2008-12-30 17:44
Location: Bayern
 

Re: Postfix + MySQL: Input/Output Error

Post by mattis »

Was spricht denn das mySQL Log?
stice
Posts: 4
Joined: 2009-01-23 12:32
 

Re: Postfix + MySQL: Input/Output Error

Post by stice »

Sry, mir ist rl technisch was dazwischen gekommen.
Habe Courier durch Dovecot ersetzt und mittlerweile funktioniert alles.

Trotzdem danke für die Hilfe :)