Hi, all.
Is it possible to implement MySQL global address book?
I heard many users expect this feature.
We store virtual mail users in MySQL as bellow (SQL structure is based on PostfixAdmin):
mysql> desc mailbox; +----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | NULL | | | password | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | NULL | | | quota | bigint(20) | NO | | 0 | | | domain | varchar(255) | NO | | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +----------+--------------+------+-----+---------------------+-------+
mysql> select username,domain from mailbox; +-----------------+--------+ | username | domain | +-----------------+--------+ | postmaster@a.cn | a.cn | | www@a.cn | a.cn | +-----------------+--------+
Is it possible to display 'username' and/or other fields in roundcubemail address book area?
Thanks very much. :)