Hi,

I would like to use SOGo with my existing user base (MySQL). The main problem is that the login name (user@domain) is splitted over 2 fields:

+-----------------+-----------+------+-----+---------+-------+
| Field           | Type      | Null | Key | Default | Extra |
+-----------------+-----------+------+-----+---------+-------+
| pw_name         | char(32)  | NO   | PRI | NULL    |       |
| pw_domain       | char(96)  | NO   | PRI | NULL    |       |
| pw_passwd       | char(40)  | YES  |     | NULL    |       |
+-----------------+-----------+------+-----+---------+-------+

The query should be like that:

"SELECT CONCAT(pw_name, '@', pw_domain) AS c_uid"

Can SOGo be customized for using a database schema like this?

Thanks
--
Alessio Cecchi is:
@ ILS -> http://www.linux.it/~alessice/
on LinkedIn -> http://www.linkedin.com/in/alessice
Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/
@ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it
@ LOLUG -> Socio http://www.lolug.net
--
[email protected]
https://inverse.ca/sogo/lists

Reply via email to