Displaying 1 result from an estimated 1 matches for "dovecot_authmap".
2008 Sep 01
1
usernames with/without domain - my solution
...vpopmail table and the new table
The SQL query is as follows:
SELECT
IF('%d' = '',dovecot.domain,'%d') AS authdomain,
CONCAT(pw_name, '@', pw_domain) AS user,
pw_passwd AS password, pw_dir AS userdb_home, 89 AS userdb_uid, 89 AS userdb_gid
FROM vpopmail, dovecot_authmap AS dovecot
WHERE pw_name = '%n'
AND dovecot.local_ip = SUBSTRING_INDEX('%l', ':', -1)
GROUP BY pw_domain HAVING pw_domain = authdomain
NOTE: I'm prefetching userdb info
This works, however I'd like to know what others think of this approach, and whether th...