Sasl med postfix og mysql
Er der nogen der har fået SASL til at virke med postfix og mysql?
Jeg får dette i loggen:
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin create statement from userPassword user domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin doing query SELECT password FROM users WHERE address='user@domain.dk';
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin create statement from cmusaslsecretPLAIN user domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin doing query SELECT password FROM users WHERE address='user@domain.dk';
Jun 16 15:14:01 loke postfix/smtpd[9075]: commit transaction
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin Parse the username user@domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin try and connect to a host
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin trying to open db 'maildb' on host 'localhost'
smtpd.conf filen fra sasl:
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
mech_list: plain login cram-md5 digest-md5
sql_hostnames: localhost
sql_user: postfix
sql_passwd: xxxxx
sql_database: maildb
sql_select: SELECT password FROM users WHERE address='%u@%r'
mysql_verbose: yes
Tilføjet til main.cf:
smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
Jeg får dette i loggen:
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin create statement from userPassword user domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin doing query SELECT password FROM users WHERE address='user@domain.dk';
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin create statement from cmusaslsecretPLAIN user domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin doing query SELECT password FROM users WHERE address='user@domain.dk';
Jun 16 15:14:01 loke postfix/smtpd[9075]: commit transaction
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin Parse the username user@domain.dk
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin try and connect to a host
Jun 16 15:14:01 loke postfix/smtpd[9075]: sql plugin trying to open db 'maildb' on host 'localhost'
smtpd.conf filen fra sasl:
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
mech_list: plain login cram-md5 digest-md5
sql_hostnames: localhost
sql_user: postfix
sql_passwd: xxxxx
sql_database: maildb
sql_select: SELECT password FROM users WHERE address='%u@%r'
mysql_verbose: yes
Tilføjet til main.cf:
smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
Kommentarer1
Re: Sasl med postfix og mysql
Nogen der ved hvordan man får auxprop til at kører med et mysql encryptet password ?