View Single Post
  #7  
Old 23rd April 2011, 18:13
d1sk0 d1sk0 is offline
Junior Member
 
Join Date: Mar 2011
Posts: 3
Thanks: 0
Thanked 3 Times in 3 Posts
Default Authentication against RDBMS *is* possible

Quote:
Originally Posted by beyerservice View Post
configuration is done with strange config files (GNustep) and authentication only works with LDAP.
Not true. I'm using authentication against a view in PostgreSQL. Just use something like


<key>SOGoUserSources</key>
<array>
<dict>
<key>canAuthenticate</key>
<string>YES</string>
<key>id</key>
<string>directory</string>
<key>isAddressBook</key>
<string>YES</string>
<key>type</key>
<string>sql</string>
<key>userPasswordAlgorithm</key>
<string>md5</string>
<key>viewURL</key>
<string>mysql://userass@host/db_name/table_or_view_name</string>
</dict>
</array>


HTH,

Andreas
Reply With Quote