Guest User

Untitled

a guest
Oct 30th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. cat /etc/postfix/mysql-email.cf
  2. user = mailadmin
  3. password = xxx
  4. dbname = mail
  5. query = SELECT email FROM users WHERE email='%s'
  6. hosts = 127.0.0.1
  7.  
  8. cat /etc/postfix/mysql-forwards.cf
  9. user = mailadmin
  10. password = xxx
  11. dbname = mail
  12. query = SELECT destination FROM forwards WHERE source='%s'
  13. hosts = 127.0.0.1
  14.  
  15. at /etc/postfix/mysql-domains.cf
  16. user = mailadmin
  17. password = xxx
  18. dbname = mail
  19. query = SELECT domain AS virtual FROM domains WHERE domain='%s'
  20. hosts = 127.0.0.1
  21.  
  22. cat /etc/postfix/mysql-mailboxes.cf
  23. user = mailadmin
  24. password = xxx
  25. dbname = mail
  26. query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
  27. hosts = 127.0.0.1
  28.  
  29. cat /etc/postfix/sasl/smtpd.conf
  30. pwcheck_method: auxprop
  31. auxprop_plugin: sql
  32. mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5 NTLM
  33. sql_engine: mysql
  34. sql_hostnames: 127.0.0.1
  35. sql_user: mailadmin
  36. sql_passwd: xxx
  37. sql_database: mail
  38. sql_select: select password from users where email = '%u'
Add Comment
Please, Sign In to add comment