[Postfixbuch-users] SASL mit MySql Authentifizierung

[Patrick Ben Koetter]

* Windecker, Robert <R.Windecker at peak-networks.de> [040722 10:23]:
> Hallo Liste,
> 
> ich komme hier an dieser Stell nicht weiter was ich auch mach er
> findet den MySql server wohl nicht:

> mysqlname_parse: /etc/postfix/mysql_virtual_mailbox_maps.cf: adding
> host '127.0.0.1' to list of mysql server hosts

> Ich habe auch schon ein Link des mysql.sock in das
> /var/spool/postfix/var/run alles kein Erfolg.
> 
> Habt ihr noch eine Idee was ich machen könnte?

Richtig: Sobald Du 127.0.0.1 oder localhost angibst, wird Postfix
versuchen über den Socket mit MySQL zu kommunizieren.

Spontan habe ich keine Antwort außer dieser: 

Vereinfache! Nimm Postfix erst mal aus dem chroot raus. Es bringt eh
nichts, wenn Du nicht einen gehärteten Server betreibst.

Zitat vom Meister selbst: "The chroot feature adds just another barrier
against intrusion; that barrier is meaningful only when the host is
already running in a hardened configuration."

virtual betreibst Du aber nicht chrooted, oder?

p at rick




> Jul 22 10:13:39 nemo postfix/master[22924]: daemon started -- version 2.1.1
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: mynetworks ~? debug_peer_list
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: mynetworks ~? fast_flush_domains
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: mynetworks ~? mynetworks
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? debug_peer_list
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? fast_flush_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? mynetworks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? permit_mx_backup_networks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? qmqpd_authorized_clients
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: relay_domains ~? relay_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: permit_mx_backup_networks ~? debug_peer_list
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: permit_mx_backup_networks ~? fast_flush_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: permit_mx_backup_networks ~? mynetworks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: permit_mx_backup_networks ~? permit_mx_backup_networks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: connect to subsystem private/proxymap
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: send attr request = open
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: send attr table = unix:passwd.byname
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: send attr flags = 64
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: private/proxymap socket: wanted attribute: status
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: input attribute name: status
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: input attribute value: 0
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: private/proxymap socket: wanted attribute: flags
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: input attribute name: flags
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: input attribute value: 80
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: private/proxymap socket: wanted attribute: (list terminator)
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: input attribute name: (end)
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_proxy_open: connect to map=unix:passwd.byname status=0 server_flags=0120
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_open: proxy:unix:passwd.byname
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_open: hash:/etc/aliases
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_open: hash:/etc/postfix/canonical
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: user = xxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: password = xxxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: dbname = xxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: table = xxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: select_field = goto
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: where_field = address
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: additional_conditions = 
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: hosts = 127.0.0.1
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: mysqlname_parse: /etc/postfix/mysql_virtual_alias_maps.cf: adding host '127.0.0.1' to list of mysql server hosts
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_open: mysql:/etc/postfix/mysql_virtual_alias_maps.cf
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: user = xxxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: password = xxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: dbname = xxxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: table = xxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: select_field = xxxx
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: where_field = username
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: additional_conditions = 
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: cfg_get_str: /etc/postfix/mysql_virtual_mailbox_maps.cf: hosts = 127.0.0.1
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: mysqlname_parse: /etc/postfix/mysql_virtual_mailbox_maps.cf: adding host '127.0.0.1' to list of mysql server hosts
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: dict_open: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? debug_peer_list
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? fast_flush_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? mynetworks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? permit_mx_backup_networks
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? qmqpd_authorized_clients
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? relay_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: smtpd_access_maps ~? smtpd_access_maps
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: smtpd_sasl_initialize: SASL config file is smtpd.conf
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: fast_flush_domains ~? debug_peer_list
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: match_string: fast_flush_domains ~? fast_flush_domains
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: watchdog_create: 0x80a0058 18000
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: watchdog_stop: 0x80a0058
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: watchdog_start: 0x80a0058
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: connection established
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: master_notify: status 0
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: name_mask: resource
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: name_mask: software
> 
> Jul 22 10:13:48 nemo postfix/smtpd[22967]: name_mask: noanonymous
> 
>  
> 
> Mfg
> 
>  
> 
> robert
> 
>  
> 

> -- 
> _______________________________________________
> Postfixbuch-users mailingliste
> JPBerlin - Mailbox und Politischer Provider
> Postfixbuch-users at listi.jpberlin.de
> http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users

-- 
Ich behalte mir vor Nachrichten, die nicht an die Liste zurückgesendet
werden, zu ignorieren. Open Source Software verlangt auch offenen Zugang
zu Wissen, das schildert wie man sie einsetzt.
Entzieht den anderen dieses Wissen nicht, indem ihr unaufgefordert auf
einen privaten Kanal wechselt!

SMTP AUTH HOWTO: <http://postfix.state-of-mind.de/patrick.koetter/>