[Postfixbuch-users] Mails werden nicht angenommen

[Stoffel Armin]

Patrick Ben Koetter schrieb:

>* Stoffel Armin <postfixbuch-users at listi.jpberlin.de>:
>  
>
>>Ich bin an postfix mit mysql dran. leider nimmt es keine E-mail 
>>entgegen. Im Mysql Log file sehe ich:
>>
>>SELECT maildir FROM users WHERE email='domain.ch' and postfix= 'Y'
>>
>>Wieso kommt der domain name und nicht die email als where clausel eingefügt?
>>Wo kann ich das anpassen?
>>    
>>
>
>In Deiner Konfiguration.
>Wenn Du Hilfe dabei benötigst, dann poste sie in diese Liste. Für
>Postfix-Parameter bitte nur "postconf -n". Die MySQL-Abfrage-Konfigurationen
>einfach separat posten.
>
>p at rick
>
>
>  
>

Hallo hier die daten:
Postconf -n

alias_maps = proxy:mysql:/etc/postfix/aliases.mysql
biff = no
broken_sasl_auth_clients = yes
canonical_maps = hash:/etc/postfix/canonical
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/lib/postfix
debug_peer_level = 2
defer_transports =
disable_dns_lookups = no
disable_mime_output_conversion = no
html_directory = /usr/share/doc/packages/postfix/html
inet_interfaces = all
inet_protocols = all
local_recipient_maps = $alias_maps $virtual_mailbox_maps unix:passwd.byname
mail_owner = postfix
mail_spool_directory = /var/mail
mailbox_command =
mailbox_size_limit = 0
mailbox_transport =
mailq_path = /usr/bin/mailq
manpage_directory = /usr/share/man
masquerade_classes = envelope_sender, header_sender, header_recipient
masquerade_domains =
masquerade_exceptions = root
message_size_limit = 10240000
mydestination = $myhostname, $transport_maps
myhostname = ewriedbach.ch
mynetworks_style = subnet
newaliases_path = /usr/bin/newaliases
proxy_read_maps = proxy:mysql:/etc/postfix/recipient.mysql        
proxy:mysql:/etc/postfix/client.mysql        
proxy:mysql:/etc/postfix/sender.mysql        
proxy:mysql:/etc/postfix/aliases.mysql        
proxy:mysql:/etc/postfix/relocated.mysql        
proxy:mysql:/etc/postfix/transport.mysql        
proxy:mysql:/etc/postfix/virtual.mysql        
proxy:mysql:/etc/postfix/virtual-maps.mysql        
proxy:mysql:/etc/postfix/virtual-uid.mysql        
proxy:mysql:/etc/postfix/virtual-gid.mysql
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/packages/postfix/README_FILES
relayhost =
relocated_maps = proxy:mysql:/etc/postfix/relocated.mysql
sample_directory = /usr/share/doc/packages/postfix/samples
sender_canonical_maps = hash:/etc/postfix/sender_canonical
sendmail_path = /usr/sbin/sendmail
setgid_group = maildrop
smtp_sasl_auth_enable = no
smtp_use_tls = no
smtpd_client_restrictions = 
permit_sasl_authenticated,permit_mynetworks,     \  check_client_access 
proxy:mysql:/etc/postfix/client.mysql
smtpd_helo_required = no
smtpd_helo_restrictions =
smtpd_recipient_restrictions = permit_mynetworks, 
permit_sasl_authenticated, \  check_recipient_access 
proxy:mysql:/etc/postfix/recipient.mysql,     \  
reject_unauth_destination, permit
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_sender_restrictions = check_sender_access 
proxy:mysql:/etc/postfix/sender.mysql, \        
reject_non_fqdn_sender,reject_unknown_sender_domain
smtpd_tls_received_header = yes
smtpd_use_tls = no
strict_8bitmime = no
strict_rfc821_envelopes = no
transport_maps = proxy:mysql:/etc/postfix/transport.mysql
unknown_local_recipient_reject_code = 550
virtual_alias_domains = hash:/etc/postfix/virtual
virtual_alias_maps = hash:/etc/postfix/virtual
virtual_gid_maps = proxy:mysql:/etc/postfix/virtual-gid.mysql
virtual_mailbox_base = /var/spool/vmail
virtual_mailbox_maps = proxy:mysql:/etc/postfix/virtual-maps.mysql
virtual_uid_maps = proxy:mysql:/etc/postfix/virtual-uid.mysql

recipient.mysql:
user = user
password = xxxxxx
dbname = mail
table = access
select_field = access
where_field = source
additional_conditions = and type = 'recipient'
hosts = 127.0.0.1

relocated.mysql:
user = user
password = xxxxxx
dbname = mail
table = relocated
select_field = destination
where_field = email
hosts = 127.0.0.1

sender.mysql:
user = user
password = xxxxxx
dbname = mail
table = access
select_field = access
where_field = source
additional_conditions = and type = 'sender'
hosts = 127.0.0.1

transport.mysql:
user = user
password = xxxxxx
dbname = mail
table = transport
select_field = destination
where_field = domain
hosts = 127.0.0.1

virtual-gid.mysql:
user = user
password = xxxxxx
dbname = mail
table = users
select_field = gid
where_field = email
additional_conditions

virtual-maps.mysql:
user = user
password = xxxxxx
dbname = mail
table = users
select_field = maildir
where_field = email
additional_conditions = and postfix= 'Y'
hosts = 127.0.0.1

virtual.mysql:
user = user
password = xxxxxx
dbname = mail
table = virtual
select_field = destination
where_field = email
hosts = 127.0.0.1

virtual-uid.mysql
user = user
password = xxxxxx
dbname = mail
table = users
select_field = uid
where_field = email
additional_conditions = and postfix = 'Y'
hosts = 127.0.0.1