Hi all,
I have a fresh installation of a Vpopmail 5.4.33 + Dovecot 2.2.29.1 + SQL
As usual I followed the AuthDatabase/VPopMail wiki
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, \
pw_clear_passwd AS password \
FROM vpopmail \
WHERE pw_name = '%n' AND pw_domain = '%d'
user_query = SELECT pw_dir as home, \
89 AS uid, 89 AS gid \
FROM vpopmail \
WHERE pw_name = '%n' AND pw_domain = '%d'
For VPopMail, I prefer to have an individual table in the vpopmail database for each domain.
So my structure will be something like this
vpopmail.abc_com
vpopmail.xyz_com
To achieve this I add this configure when compiling VPopMail
--disable-many-domains
But dovecot will not read vpopmail.abc_com, instead it keep looking for vpopmail.vpopmail
auth-worker(8643): Warning: mysql: Query failed, retrying: Table 'vpopmail.vpopmail' doesn't exist
If I remove --disable-many-domains in the configuration, I have no issue.
Is there a new password and user query to have this working?
The last working version I had installed is Dovecot 2.2.15
Thank you
nic