Hi Ludovic, In that case, I now modify my VIEW:
mysql> CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which then gives the output below mysql> select * from exim4u.sogo_auth_view where c_name like '%wash%'; +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+---------------------+ | sogo_id | c_uid | c_name | c_password | c_cn | mail | displayName | +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+---------------------+ | 3 | [email protected] | [email protected] | $1$XXXXXXXXXXXXXXXXXXX | Odhiambo WASHINGTON | [email protected] | Odhiambo WASHINGTON | +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+---------------------+ So c_uid == c_name as you've suggested. My config has the below and still I cannot find anything inside the "Staff Members" addressbook folder. Anything unusual?? Also tell me, why is it that SOGo treats such password as crypt and not md5-crypt?? SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = "Staff Members"; id = users; isAddressBook = YES; userPasswordAlgorithm = crypt; //userPasswordAlgorithm = none; viewURL ="mysql://exim4u:[email protected]:3306/exim4u/sogo_auth_view "; } ); On 26 June 2013 22:47, Ludovic Marcotte <[email protected]> wrote: > On 2013-06-26 3:43 PM, Odhiambo Washington wrote: > >> Since I have isAddressBook = YES; , shouldn't SOGo populate my global >> addressbook by default? Mine remains empty... >> > Search in it. > > Also, c_name should be equal in most situation to c_uid. Right now you've > set it to the user's real name, which is far from ideal. c_cn should be the > user's realname. > > -- > Ludovic Marcotte > [email protected] :: +1.514.755.3630 :: http://inverse.ca > Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( > http://packetfence.org) > > -- > [email protected] > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 "I can't hear you -- I'm using the scrambler." -- [email protected] https://inverse.ca/sogo/lists
