Displaying 1 result from an estimated 1 matches for "mail_senders_other".
2013 Jul 18
0
Password encryption type for dovecot & postfix saslauthd with mysql
...t is username + password. To that end we have created a view table in mysql that merges the two.. tables + view look a little like this:
table: mail_users (for dovecot)
email,password
test at test1.com,CRAM-MD5_PASSWORD
test2 at test1.com,CRAM-MD5_PASSWORD
bla at bla.com,CRAM-MD5_PASSWORD
table: mail_senders_other
username,password
username1,CRAM-MD5_PASSWORD
something_else,CRAM-MD5_PASSWORD
view: mail_senders (for postfix)
username,password
test at test1.com,CRAM-MD5_PASSWORD
test2 at test1.com,CRAM-MD5_PASSWORD
bla at bla.com,CRAM-MD5_PASSWORD
username1,CRAM-MD5_PASSWORD
something_else,CRAM-MD5_PASSWOR...