Dovecot 2.2.29.1 + VPopMail 5.4.33

[Nicholas Chua]

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