Am 12.01.2012 15:45, schrieb Brian KREULEN:
How do I do this? Is there something I’m missing? Thanks…..
1. Create DB-Table with Auth-Infos like this table (the fields IMHO
needed):
CREATE TABLE sogo_auth
(
c_uid varchar(100) NOT NULL,
mail varchar(255) NOT NULL,
c_name varchar(255) NOT NULL,
c_password varchar(100) NOT NULL,
c_cn varchar(255) NOT NULL,
c_ou varchar(255) NOT NULL,
PRIMARY KEY (c_uid)
)
2. Configure SOGo
{authtable} == tablename from (1.)
userPasswordAlgorithm => set as you wish, but plain is not good.
<key>SOGoUserSources</key>
<array>
<dict>
<key>canAuthenticate</key>
<string>YES</string>
<key>displayName</key>
<string>database_auth</string>
<key>id</key>
<string>database</string>
<key>isAddressBook</key>
<string>NO</string>
<key>type</key>
<string>sql</string>
<key>userPasswordAlgorithm</key>
<string>md5</string>
<key>viewURL</key>
<string>mysql://{username}:{password}@localhost:3306/{database}/{authtable}</string>
</dict>
</array>
Should run ...
--
Greetings,
Martin Rabl
--
[email protected]
https://inverse.ca/sogo/lists
