Email/Postfix funktoniert nicht richtig.

Sunnboy96 · 31. Oktober 2010

Hallo,
Ich habe folgendes Problem wenn ich ein Email Account anlegen möchte dann bekomme ich eine Fehlermeldung: Das Versenden der Nachricht schlug fehl.
Fehlermeldungen:
mail.err

Code

Oct 31 13:00:25 v220100350192763 postfix/trivial-rewrite[2668]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:00:25 v220100350192763 postfix/trivial-rewrite[2669]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:00:25 v220100350192763 postfix/trivial-rewrite[2670]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:00:25 v220100350192763 postfix/trivial-rewrite[2672]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:00:27 v220100350192763 postfix/trivial-rewrite[2684]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:01:26 v220100350192763 postfix/trivial-rewrite[6373]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:01:26 v220100350192763 postfix/trivial-rewrite[6374]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:01:26 v220100350192763 postfix/trivial-rewrite[6375]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:01:26 v220100350192763 postfix/trivial-rewrite[6376]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:02:27 v220100350192763 postfix/trivial-rewrite[12520]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:02:27 v220100350192763 postfix/trivial-rewrite[12524]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:02:27 v220100350192763 postfix/trivial-rewrite[12525]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:02:27 v220100350192763 postfix/trivial-rewrite[12526]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:03:28 v220100350192763 postfix/trivial-rewrite[16327]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:03:28 v220100350192763 postfix/trivial-rewrite[16328]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:03:28 v220100350192763 postfix/trivial-rewrite[16329]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:03:28 v220100350192763 postfix/trivial-rewrite[16330]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:06:12 v220100350192763 postfix/trivial-rewrite[30116]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:06:14 v220100350192763 postfix/trivial-rewrite[30289]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:07:15 v220100350192763 postfix/trivial-rewrite[1974]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:08:16 v220100350192763 postfix/trivial-rewrite[6501]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:09:17 v220100350192763 postfix/trivial-rewrite[11023]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:10:18 v220100350192763 postfix/trivial-rewrite[17456]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup

Alles anzeigen

mail.warn

Code

Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E49224244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E4A4C4244C9E: message has been queued for 7 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E4A4C4244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E4BB64244C9E: message has been queued for 5 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E4BB64244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E4D2A4244C9E: message has been queued for 9 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E4D2A4244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E4E734244C9E: message has been queued for 6 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E4E734244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E4FA34244C9E: message has been queued for 6 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E4FA34244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E51274244C9E: message has been queued for 7 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E51274244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:23 v220100350192763 postfix/pickup[17293]: warning: E52764244C9E: message has been queued for 7 days
Oct 31 13:15:23 v220100350192763 postfix/cleanup[7201]: warning: E52764244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:24 v220100350192763 postfix/smtpd[30112]: warning: problem talking to service rewrite: Success
Oct 31 13:15:24 v220100350192763 postfix/master[17284]: warning: process /usr/lib/postfix/trivial-rewrite pid 7194 exit status 1
Oct 31 13:15:24 v220100350192763 postfix/pickup[17293]: warning: E56EE4244C9E: message has been queued for 7 days
Oct 31 13:15:24 v220100350192763 postfix/cleanup[7201]: warning: E56EE4244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:25 v220100350192763 postfix/trivial-rewrite[7198]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 31 13:15:25 v220100350192763 postfix/trivial-rewrite[7198]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:15:25 v220100350192763 postfix/pickup[17293]: warning: E5CBA4244C9E: message has been queued for 5 days
Oct 31 13:15:25 v220100350192763 postfix/cleanup[7201]: warning: E5CBA4244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:26 v220100350192763 postfix/smtpd[30112]: warning: problem talking to service rewrite: Success
Oct 31 13:15:26 v220100350192763 postfix/master[17284]: warning: process /usr/lib/postfix/trivial-rewrite pid 7198 exit status 1
Oct 31 13:15:26 v220100350192763 postfix/pickup[17293]: warning: E60C24244C9E: message has been queued for 9 days
Oct 31 13:15:26 v220100350192763 postfix/cleanup[7201]: warning: E60C24244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:27 v220100350192763 postfix/trivial-rewrite[7594]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 31 13:15:27 v220100350192763 postfix/trivial-rewrite[7594]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
Oct 31 13:15:27 v220100350192763 postfix/pickup[17293]: warning: E66774244C9E: message has been queued for 7 days
Oct 31 13:15:27 v220100350192763 postfix/cleanup[7201]: warning: E66774244C9E: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 31 13:15:28 v220100350192763 postfix/smtpd[30112]: warning: problem talking to service rewrite: Success
Oct 31 13:15:28 v220100350192763 postfix/master[17284]: warning: process /usr/lib/postfix/trivial-rewrite pid 7594 exit status 1
Oct 31 13:15:28 v220100350192763 postfix/master[17284]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 31 13:15:28 v220100350192763 postfix/pickup[17293]: warning: E6C024244C9E: message has been queued for 6 days

Alles anzeigen

mfg Sunnyboy

stachi · 31. Oktober 2010

Die einfachste Möglichkeit ist es in den /etc/postfix/mysql-*.cf Scripten localhost gegen 127.0.0.1 zu ersetzen.
Mann könnte zwar auch den MySQL Socket in das postfix chroot jail linken, aber warum kompliziert wenn es einfach auch geht:D

Sunnboy96 · 31. Oktober 2010

Hat sich nichts getan bis auf das ich jetzt eine Nachricht im Terminal bekomme.
you have a email in /var/root/mail oder so:)

stachi · 31. Oktober 2010

Theoretisch sollte mindestens diese Fehlermeldung weg sein:

Zitat

warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Vielleicht hängt es ja noch woanders?

slukas · 31. Oktober 2010

blöde frage, aber rennt der mysql-server?

Sunnboy96 · 31. Oktober 2010

Jop rennt alles.
Ok jetzt hat sich was getan er leitet die mail jetzt weiter ich probiere gleich mal ein Account anzulegen:)

Sunnboy96 · 31. Oktober 2010

Verbindung mit POP-Server 78.47.62.51 konnte nicht hergestellt werden.
Fehler beim Übermitteln des Passworts: Die Operation ist jetzt in Bearbeitung
Bekomme folgende Meldung beim Abrufen von Email:)

stachi · 31. Oktober 2010

Dann scheint der Tipp mit postfix ja schon mal geholfen zu haben.

Was sagen die Logs zu dovecot/courier?

Sunnboy96 · 31. Oktober 2010

Ich finde keine logs von courier oder dovecot

stachi · 31. Oktober 2010

Wenn denn hast du nur ein von beiden.

Die Logs sind die gleichen wie für Postfix, also mail.err mail.warn mail.info. Die mail.info spuckt in der Regel am meisten aus.

Sunnboy96 · 5. November 2010

Hallo,
Selbst php Scripts können keine Mails verschiken bzw keine kommen an.
Hier ist der Log

Code

Oct 30 03:50:50 v220100350192763 postfix/pickup[11645]: 2BEE5424419B: uid=33 from=<www-data>
Oct 30 03:50:50 v220100350192763 postfix/cleanup[10374]: warning: 2BEE5424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:51 v220100350192763 postfix/pickup[11645]: warning: 2C4A2424419B: message has been queued for 5 days
Oct 30 03:50:51 v220100350192763 postfix/pickup[11645]: 2C4A2424419B: uid=33 from=<www-data>
Oct 30 03:50:51 v220100350192763 postfix/cleanup[10374]: warning: 2C4A2424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:52 v220100350192763 postfix/pickup[11645]: warning: 2CAE5424419B: message has been queued for 7 days
Oct 30 03:50:52 v220100350192763 postfix/pickup[11645]: 2CAE5424419B: uid=33 from=<www-data>
Oct 30 03:50:52 v220100350192763 postfix/cleanup[10374]: warning: 2CAE5424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:53 v220100350192763 postfix/pickup[11645]: warning: 2CD8B424419B: message has been queued for 4 days
Oct 30 03:50:53 v220100350192763 postfix/pickup[11645]: 2CD8B424419B: uid=33 from=<www-data>
Oct 30 03:50:53 v220100350192763 postfix/cleanup[10374]: warning: 2CD8B424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:54 v220100350192763 postfix/pickup[11645]: warning: 2D55D424419B: message has been queued for 6 days
Oct 30 03:50:54 v220100350192763 postfix/pickup[11645]: 2D55D424419B: uid=33 from=<www-data>
Oct 30 03:50:54 v220100350192763 postfix/cleanup[10374]: warning: 2D55D424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:55 v220100350192763 postfix/pickup[11645]: warning: 2DA9B424419B: message has been queued for 5 days
Oct 30 03:50:55 v220100350192763 postfix/pickup[11645]: 2DA9B424419B: uid=33 from=<www-data>
Oct 30 03:50:55 v220100350192763 postfix/cleanup[10374]: warning: 2DA9B424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:56 v220100350192763 postfix/cleanup[10374]: warning: 2E198424419B: virtual_alias_maps map lookup problem for www-data@v220100350192763
Oct 30 03:50:56 v220100350192763 postfix/pickup[11645]: warning: 2E198424419B: message has been queued for 6 days
Oct 30 03:50:56 v220100350192763 postfix/pickup[11645]: 2E198424419B: uid=33 from=<www-data>

Alles anzeigen

Die log hat schon an die 200 MB erreicht-.-

KB19 · 5. November 2010

Zeig uns doch bitte einmal deine Postfix Konfiguration (inklusive dem SQL-Teil)

MfG Christian

Sunnboy96 · 5. November 2010

main.cf

Code

## General Postfix configuration
# should be the default domain from your provider eg. "server100.provider.tld"
mydomain = v220100350192763




# should be different from $mydomain eg. "mail.$mydomain"
myhostname = v220100350192763




mydestination = $myhostname,
	$mydomain,
	localhost.$myhostname,
	localhost.$mydomain,
	localhost
mynetworks = 127.0.0.0/8
inet_interfaces = all
append_dot_mydomain = no
biff = no




# Postfix performance settings
default_destination_concurrency_limit = 20
local_destination_concurrency_limit = 2




# SMTPD Settings
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
smtpd_helo_required = yes
smtpd_recipient_restrictions = permit_mynetworks,
	permit_sasl_authenticated,
	reject_unauth_destination,
	reject_unauth_pipelining,
	reject_non_fqdn_recipient
smtpd_sender_restrictions = permit_mynetworks,
	reject_sender_login_mismatch,
	permit_sasl_authenticated, 
	reject_unknown_helo_hostname, 
	reject_unknown_recipient_domain, 
	reject_unknown_sender_domain
smtpd_client_restrictions = permit_mynetworks,
	permit_sasl_authenticated,
	reject_unknown_client_hostname
# Maximum size of Message in bytes (50MB)
message_size_limit = 52428800




## SASL Auth Settings
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
broken_sasl_auth_clients = yes




# Virtual delivery settings
virtual_mailbox_base = /var/customers/mail/
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailbox_maps.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_alias_maps.cf
smtpd_sender_login_maps = mysql:/etc/postfix/mysql-virtual_sender_permissions.cf
virtual_uid_maps = static:2000
virtual_gid_maps = static:2000




# Local delivery settings
local_transport = local
alias_maps = $alias_database




# Default Mailbox size, is set to 0 which means unlimited!
mailbox_size_limit = 0
virtual_mailbox_limit = 0




### TLS settings
###
## TLS for outgoing mails from the server to another server
#smtp_tls_security_level = may
#smtp_tls_note_starttls_offer = yes
## TLS for email client
#smtpd_tls_security_level = may
#smtpd_tls_cert_file = /etc/ssl/server/v220100350192763.pem
#smtpd_tls_CAfile = /etc/ssl/certs/ca-certificates.crt
#smtpd_tls_loglevel = 1
#smtpd_tls_received_header = yes




debugger_command =
         PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
         ddd $daemon_directory/$process_name $process_id & sleep 5

Alles anzeigen

virtual_alias_maps dingsda

Code

user = froxlor
password = wasdunichtweißtsmachdichauchnichtheiß
dbname = froxlor
table = mail_virtual
select_field = destination
where_field = email
additional_conditions = and TRIM(destination) <> ''
hosts = 127.0.0.1

Janny82 · 5. November 2010

Hm, was fält dir hier auf?

Zitat

# should be the default domain from your provider eg. "server100.provider.tld"
mydomain = v220100350192763

# should be different from $mydomain eg. "mail.$mydomain"
myhostname = v220100350192763

Hast du die Froxlor Installation in allen Teilen durchgeführt? Insb. die Mail-Teile?

Sunnboy96 · 5. November 2010

Habe die Konfrugration in Froxlor genau abgearbeitet.
Aufallen tut mir jetzt nichts so?

Janny82 · 5. November 2010

"v220100350192763" ist kein ordnungsgemässer Domainname.
"mailserver.sunnyboy96.de wäre z.b. eine ordnungsgemässe.

Sunnboy96 · 5. November 2010

Arr ja richtig stimmt:D

Sunnboy96 · 5. November 2010

Habe ich geändert in v220100350192763.yourvserver.net
geändert hat sich aber nichts.-.-

Janny82 · 5. November 2010

Gibts die Datei denn?
/var/run/mysqld/mysqld.sock

Deine ganzen Errors sind die Folge davon, daß Froxlor nicht auf seine Tabellen zugreifen kann.

Sunnboy96 · 5. November 2010

Ja datei ist vorhanden