lucienk49140
28/09/2014, 08h24
Up !
INSERT INTO mailbox (`email`, `password`, ..... ) VALUES ('toto@trucmuche.com',ENCRYPT('monpass'), ..... );
auth required pam_mysql.so user=postfix passwd=1234 verbose=0 host=127.0.0.1 db=postfix table=mailbox usercolumn=username passwdcolumn=password md5=1
account sufficient pam_mysql.so user=postfix passwd=1234 verbose=0 host=127.0.0.1 db=postfix table=mailbox usercolumn=username passwdcolumn=password md5=1
pwcheck_method: saslauthd auxprop
mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5
#log_level: 25
#allow_plaintext: true
password_format: md5
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: postfix
sql_database: postfix
sql_passwd: 1234
sql_select: SELECT password FROM mailbox WHERE username = '%u@%r' AND active = 1
Sep 15 21:31:42 lucienkhebergement postfix/master[29353]: warning: process /usr/lib/postfix/smtpd pid 29619 exit status 1
Sep 15 21:31:42 lucienkhebergement postfix/master[29353]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Sep 15 21:32:42 lucienkhebergement postfix/smtpd[29640]: fatal: Invalid TLS level "md5"
auth required pam_mysql.so user=postfix passwd=df48erHT56af host=localhost db=postfix table=mailbox usercolumn=email passwdcolumn=password md5=1 account sufficient pam_mysql.so user=postfix passwd=df48erHT56af host=localhost db=postfix table=mailbox usercolumn=email passwdcolumn=password md5=1