[Postfixbuch-users] Probleme mit Postfix und MySQL

[Alexander Dalloz]

Online-WebService24 - Postfix schrieb:
> hallo Liste,
>  
> ich habe nen kleines Problem, mit meinem Postfix ...
>  
> der zickt zur Zeit etwas rum ...
>  
> hier mal nen auszug aus der err :
>  
> Nov  4 12:32:20 srv1 postfix/trivial-rewrite[31694]: fatal:
> mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table
> lookup problem
> Nov  4 12:32:21 srv1 postfix/trivial-rewrite[31696]: fatal:
> mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table
> lookup problem
> Nov  4 12:32:21 srv1 postfix/trivial-rewrite[31698]: fatal:
> mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table
> lookup problem
> Nov  4 12:32:21 srv1 postfix/trivial-rewrite[31699]: fatal:
> mysql:/etc/postfix/mysql-virtual_alias_maps.cf(0,lock|fold_fix): table
> lookup problem

Schau Dir Dein MySQL Setup an. Analysiere dessen Funktion und
Performance. Das mysqltuner Script - http://blog.mysqltuner.com/ -
könnte dabei hilfreich sein.
Prüfe die Nutzung der proxymap(8) Funktion in Postfix.

> Nov  4 13:00:29 srv1 dovecot: Time just moved backwards by 1 seconds. I'll
> sleep now until we're back in present.
> http://wiki.dovecot.org/TimeMovedBackwards
> Nov  4 16:00:28 srv1 dovecot: Time just moved backwards by 3 seconds. I'll
> sleep now until we're back in present.
> http://wiki.dovecot.org/TimeMovedBackwards
> Nov  4 16:00:32 srv1 dovecot: auth(default): Time just moved backwards by 2
> seconds. I'll sleep now until we're back in present.
> http://wiki.dovecot.org/TimeMovedBackwards
> Nov  4 20:00:28 srv1 dovecot: Time just moved backwards by 3 seconds. I'll
> sleep now until we're back in present.
> http://wiki.dovecot.org/TimeMovedBackwards
> Nov  4 20:00:32 srv1 dovecot: auth(default): Time just moved backwards by 2
> seconds. I'll sleep now until we're back in present.
> http://wiki.dovecot.org/TimeMovedBackwards
> Nov  5 00:00:14 srv1 dovecot: Time just moved backwards by 17 seconds. This
> might cause a lot of problems, so I'll just kill myself now.
> http://wiki.dovecot.org/TimeMovedBackwards

Andere Baustelle. Das Thema findet sich auf der dovecot Mailingliste.
Auf die Wiki Dokumentation bist Du ja direkt hingewiesen.

Ist das ein virtueller Server? NTP Updates cronjob gesteuert über ntpdate?

> postconf -e
>  
> alias_database = hash:/etc/aliases
> alias_maps = $alias_database
> biff = no
> bounce_size_limit = 51200000
> broken_sasl_auth_clients = yes
> command_directory = /usr/sbin
> config_directory = /etc/postfix
> content_filter = smtp-amavis:[127.0.0.1]:10024
> daemon_directory = /usr/lib/postfix
> default_destination_concurrency_limit = 20
> default_process_limit = 50
> delay_warning_time = 1d
> deliver_lock_attempts = 10
> disable_vrfy_command = yes
> fork_delay = 120s
> invalid_hostname_reject_code = 554
> local_destination_concurrency_limit = 2
> local_destination_recipient_limit = 1
> local_recipient_maps = unix:passwd.byname $alias_database
> local_transport = local
> mail_spool_directory = /var/mail
> mailbox_command = procmail -a "$EXTENSION"
> mailbox_size_limit = 153800000
> message_size_limit = 51200000
> mydomain = srv1.online-webservice24.de
> mynetworks = 127.0.0.1 , 85.88.6.105
> mynetworks_style = host
> sendmail_path = /usr/sbin/sendmail
> smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
> smtpd_client_restrictions =
> smtpd_helo_required = yes
> smtpd_helo_restrictions =
> smtpd_recipient_restrictions = permit_sasl_authenticated,
> permit_mynetworks,    reject_non_fqdn_helo_hostname,
> reject_unlisted_recipient,    reject_unknown_sender_domain,
> reject_unknown_recipient_domain,    reject_non_fqdn_recipient,
> reject_unauth_destination,    reject_unauth_pipelining,
> check_recipient_access hash:/etc/postfix/recipient_checks,
> check_sender_mx_access cidr:/etc/postfix/bogus_mx,
> reject_non_fqdn_hostname,    check_policy_service inet:127.0.0.1:60000,
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_local_domain = online-webservice24.de 
> smtpd_sasl_security_options = noanonymous
> smtpd_sender_restrictions =
> strict_rfc821_envelopes = yes
> unknown_local_recipient_reject_code = 554
> virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_alias_maps.cf
> virtual_gid_maps = static:2000
> virtual_mailbox_base = /var/kunden/mail/
> virtual_mailbox_domains =
> mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailbox_maps.cf
> virtual_uid_maps = static:2000
> 
>  
> vielleicht habr ihr je ne idee, was ich verbessern kann bzw woran es liegt
> ...
>  
> mal gleich noch ne andere frage, ich bekomme 80% rejected, kann man bei
> zuvielen rejected die server für ne zeit sperren,
> oder macht das keinen sinn ???

Ist Dein Server durch die Rejects an der Lastgrenze? Was gewinnst Du
durch Rejecting der Verbindung vor dem Postfix, außer
Verwaltungsoverhead und pozentielle Fehlerquellen?

> danke
>  
> mfg

Alexander