Mailserver - Postfix mit Courier und mySQL

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)



readme_directory = /usr/share/doc/postfix

smtpd_tls_cert_file=/etc/ssl/certs/postfix.pem
smtpd_tls_key_file=/etc/ssl/private/postfix.pem
smtpd_use_security_level = may
smtp_tls_security_level = may
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_use_tls = yes
smtp_tls_note_starttls_offer = yes
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s

tls_random_source = dev:/dev/urandom
tls_random_prng_update_period = 3600s

mydomain = example1.com
myhostname = carnival2.example1.com
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
virtual_mailbox_base = /home/mailusers/Maildir
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_aliases_maps = hash:/etc/postfix/virtual_mailbox_aliases
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf
alias_maps = hash:/etc/aliases
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
alias_database = hash:/etc/aliases
myorigin = $mydomain
mydestination = $myhostname, localhost
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

carnival2 = carnival2.example1.com
relayhost =
relay_domains = example4.com
html_directory = /usr/share/doc/postfix/html

smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes

smtpd_recipient_restrictions =
        reject_non_fqdn_sender,
        reject_non_fqdn_recipient,
        reject_unknown_sender_domain,
        reject_unknown_recipient_domain,
        permit_sasl_authenticated,
        permit_mynetworks,
        reject_rbl_client zen.spamhaus.org,
        reject_rbl_client ix.dnsbl.maintu.net,
        reject_unauth_destination,
        permit

inet_protocols = ipv4

smtpd_helo_required = yes
strict_rfc821_envelopes = yes
home_mailbox = Maildir/

mailbox_command = procmail -a "$EXTENSION"  

Jun 21 04:42:31 carnival2 imapd: Connection, ip=[::ffff:xx.xxx.xxx.38]
Jun 21 04:42:31 carnival2 authdaemond: received auth request, service=imap, authtype=login
Jun 21 04:42:31 carnival2 authdaemond: authmysql: trying this module
Jun 21 04:42:31 carnival2 authdaemond: authmysqllib: connected. Versions: header 50149, client 50157, server 50157
Jun 21 04:42:31 carnival2 authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/mailusers", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", name, "" FROM virtual_users WHERE email = 'name_des_benutzers'  
Jun 21 04:42:31 carnival2 authdaemond: mysql_query failed, reconnecting: Unknown column 'name' in 'field list'  
Jun 21 04:42:31 carnival2 authdaemond: authmysqllib: connected. Versions: header 50149, client 50157, server 50157
Jun 21 04:42:32 carnival2 authdaemond: mysql_query failed second time, giving up: Unknown column 'name' in 'field list'  
Jun 21 04:42:32 carnival2 authdaemond: authmysql: TEMPFAIL - no more modules will be tried
Jun 21 04:42:32 carnival2 imapd: LOGIN FAILED, method=PLAIN, ip=[::ffff:xx.xxx.xxx.38]
Jun 21 04:42:32 carnival2 imapd: authentication error: Input/output error

CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", name, "" FROM virtual_users WHERE email = 'name_des_benutzers'  

grep -ir "CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", name, "" FROM virtual_users WHERE email =" /etc/*  
grep: /etc/fonts/conf.d/30-defoma.conf: No such file or directory
grep: /etc/ssl/certs/f4bfcc1a.0: No such file or directory
grep: /etc/ssl/certs/0f745fd5.0: No such file or directory

MYSQL_NAME_FIELD        name

'id'  
'domain_id'  
'passwort'  
'email'  

'id'  
'name'  

'id'  
'domain_id'  
'source'  
'destination'