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 | w...@kictanet.or.ke | w...@kictanet.or.ke |
$1$XXXXXXXXXXXXXXXXXXX | Odhiambo WASHINGTON | w...@kictanet.or.ke |
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:XXXWWW@127.0.0.1:3306/exim4u/sogo_auth_view
";
}
);
On 26 June 2013 22:47, Ludovic Marcotte <lmarco...@inverse.ca> 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
> lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (
> http://packetfence.org)
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
"I can't hear you -- I'm using the scrambler."
--
users@sogo.nu
https://inverse.ca/sogo/lists
