Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- OLD:
- driver = mysql
- connect = host=127.0.0.1 dbname=mail user=mail password=mypass
- default_pass_scheme = CRAM-MD5
- password_query = SELECT email AS user, password, '/var/mail/vhosts/$d/$n' AS userdb_home, '5000' AS userdb_uid, '5000' AS userdb_gid FROM users WHERE email = '%u'
- user_query = SELECT email AS user, password, '/var/mail/vhosts/$d/$n' AS home, '5000' AS uid, '5000' AS gid FROM users WHERE email = '%u'
- NEW:
- driver = mysql
- connect = host=127.0.0.1 dbname=mail user=mail password=mypass
- default_pass_scheme = CRAM-MD5
- password_query = SELECT username AS user, password, CONCAT('/var/mail/vhosts/$d/',SUBSTRING_INDEX(email,'@',1)) AS userdb_home, '5000' AS userdb_uid, '5000' AS userdb_gid FROM users WHERE username = '%u'
- user_query = SELECT username AS user, password, CONCAT('/var/mail/vhosts/$d/',SUBSTRING_INDEX(email,'@',1)) AS home, '5000' AS uid, '5000' AS gid FROM users WHERE username = '%u'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement