replication and backend vpopmail

Havrla havrla at lhotkanet.cz
Tue Dec 13 11:56:59 UTC 2016


Heloo, please

I need "replicate" dovecot / dsync.

Prerequisite:
doveadm  user   '*'

[Root @ joe ~] # doveadm user '' '
Error: User listing Returned failure
Fatal: user listing failed

It probably does not work because I have:
userdb{
    args = cache_key =% u quota_template quota_rule = = *: backend = q%
    driver = vpopmail
}

The manual is written:
iterate_query = SELECT email as user FROM mail_user

But does not specify how to connect to MySQL database if vpopmail

How to do it ?

To make it simple, vpopmail domain = DB table example domain example.com 
= table example_com

[root at franta ~]# mysql vpopmail
MariaDB [vpopmail]> desc lhotkanet_cz;
+-----------------+-----------+------+-----+---------+-------+
| Field           | Type      | Null | Key | Default | Extra |
+-----------------+-----------+------+-----+---------+-------+
| pw_name         | char(32)  | NO   | PRI |         |       |
| pw_passwd       | char(40)  | YES  |     | NULL    |       |
| pw_uid          | int(11)   | YES  |     | NULL    |       |
| pw_gid          | int(11)   | YES  |     | NULL    |       |
| pw_gecos        | char(48)  | YES  |     | NULL    |       |
| pw_dir          | char(160) | YES  |     | NULL    |       |
| pw_shell        | char(20)  | YES  |     | NULL    |       |
| pw_clear_passwd | char(16)  | YES  |     | NULL    |       |
+-----------------+-----------+------+-----+---------+-------+
8 rows in set (0.00 sec)

MariaDB [vpopmail]>



Thank you.

Havrla



More information about the dovecot mailing list