[RCU] MySQL Global Address Book?

Zhang Huangbin zhbmaillistonly at gmail.com
Tue May 6 14:53:30 CEST 2008


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 at a.cn | a.cn   |
| www at a.cn        | a.cn   |
+-----------------+--------+

Is it possible to display 'username' and/or other fields in roundcubemail
address book area?

Thanks very much. :)

-- 
Best Regards.

Zhang Huangbin

- OpenBSD 4.2 -release, i386.
- RHEL 5.1 Client


_______________________________________________
List info: http://lists.roundcube.net/users/



More information about the users mailing list