AW: [Postfixbuch-users] SASL mit MySql Authentifizierung

[Windecker, Robert]

HI,

ja danke sieht schon besser aus ....... aber jetzt 

Jul 22 10:57:39 nemo postfix/smtpd[23494]: smtp_get: EOF
Jul 22 10:57:39 nemo postfix/smtpd[23494]: lost connection after AUTH from unknown[213.188.107.14]
Jul 22 10:57:39 nemo postfix/smtpd[23494]: disconnect from unknown[213.188.107.14]
Jul 22 10:57:39 nemo postfix/smtpd[23494]: master_notify: status 1
Jul 22 10:57:39 nemo postfix/smtpd[23494]: connection closed
Jul 22 10:57:39 nemo postfix/smtpd[23494]: watchdog_stop: 0x80a0058
Jul 22 10:57:39 nemo postfix/smtpd[23494]: watchdog_start: 0x80a0058
Jul 22 10:57:47 nemo postfix/smtpd[23494]: connection established
Jul 22 10:57:47 nemo postfix/smtpd[23494]: master_notify: status 0
Jul 22 10:57:47 nemo postfix/smtpd[23494]: name_mask: resource
Jul 22 10:57:47 nemo postfix/smtpd[23494]: name_mask: software
Jul 22 10:57:47 nemo postfix/smtpd[23494]: name_mask: noanonymous
Jul 22 10:57:47 nemo postfix/smtpd[23494]: connect from unknown[213.188.107.14]
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: unknown: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: xxx.xxx.107.14: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: unknown: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: xxx.xxx.107.14: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 220 nemo.pure-hosting.de ESMTP Postfix
Jul 22 10:57:47 nemo postfix/smtpd[23494]: watchdog_pat: 0x80a0058
Jul 22 10:57:47 nemo postfix/smtpd[23494]: < unknown[xxx.xxx.107.14]: EHLO robert
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250-nemo.pure-hosting.de
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xx.107.14]: 250-PIPELINING
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250-SIZE 10240000
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xx.xxx.107.14]: 250-VRFY
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250-ETRN
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250-AUTH LOGIN PLAIN DIGEST-MD5 CRAM-MD5
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250-AUTH=LOGIN PLAIN DIGEST-MD5 CRAM-MD5
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: unknown: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: match_list_match: xxx.xxx.107.14: no match
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 250 8BITMIME
Jul 22 10:57:47 nemo postfix/smtpd[23494]: watchdog_pat: 0x80a0058
Jul 22 10:57:47 nemo postfix/smtpd[23494]: < unknown[xxx.xxx.107.14]: AUTH LOGIN
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtpd_sasl_authenticate: sasl_method LOGIN
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtpd_sasl_authenticate: uncoded challenge: Username:
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 334 VXNlcm5hbWU6
Jul 22 10:57:47 nemo postfix/smtpd[23494]: < unknown[xxx.xxx.107.14]: dGVzdEBwdXJlLWhvc3RpbmcuZGU=
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtpd_sasl_authenticate: decoded response: test at pure-hosting.de
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtpd_sasl_authenticate: uncoded challenge: Password:
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 334 UGFzc3dvcmQ6
Jul 22 10:57:47 nemo postfix/smtpd[23494]: < unknown[xxx.xxx.107.14]: MTIzbml4
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtpd_sasl_authenticate: decoded response: 123xxx
Jul 22 10:57:47 nemo postfix/smtpd[23494]: warning: SASL authentication problem: unknown password verifier 
Jul 22 10:57:47 nemo postfix/smtpd[23494]: warning: unknown[xxx.xxx.107.14]: SASL LOGIN authentication failed
Jul 22 10:57:47 nemo postfix/smtpd[23494]: > unknown[xxx.xxx.107.14]: 535 Error: authentication failed
Jul 22 10:57:47 nemo postfix/smtpd[23494]: watchdog_pat: 0x80a0058
Jul 22 10:57:47 nemo postfix/smtpd[23494]: smtp_get: EOF
Jul 22 10:57:47 nemo postfix/smtpd[23494]: lost connection after AUTH from unknown[213.188.107.14]
Jul 22 10:57:47 nemo postfix/smtpd[23494]: disconnect from unknown[213.188.107.14]

Das Passwort steht in MD5 in der DB drin. Mach ich das noch was falsch in der Authentifizierung????

Robert

-----Ursprüngliche Nachricht-----
Von: Patrick Ben Koetter [mailto:p at state-of-mind.de] 
Gesendet: Donnerstag, 22. Juli 2004 10:44
An: postfixbuch-users at listi.jpberlin.de
Betreff: Re: [Postfixbuch-users] SASL mit MySql Authentifizierung

* 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/>
-- 
_______________________________________________
Postfixbuch-users mailingliste
JPBerlin - Mailbox und Politischer Provider
Postfixbuch-users at listi.jpberlin.de
http://listi.jpberlin.de/mailman/listinfo/postfixbuch-users