General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Adding an SQL Addressbook to an LDAP User-Resource


Chronological Thread 
  • From: Darko Hojnik < >
  • To:
  • Subject: [SOGo] Adding an SQL Addressbook to an LDAP User-Resource
  • Date: Tue, 27 Mar 2012 22:35:00 +0200

Hello List,

Currently I dont understand how I could add an SQL based Addressbook on
my LDAP User-Resource

Here my working configuration

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN"
"http://www.gnustep.org/plist-0_9.xml";>
<plist version="0.9">
<dict>
<key>NSGlobalDomain</key>
<dict>
</dict>
<key>sogod</key>
<dict>
<key>OCSEMailAlarmsFolderURL</key>

<string>postgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_alarms_folder</string>
<key>OCSFolderInfoURL</key>

<string>postgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_folder_info</string>
<key>OCSSessionsFolderURL</key>

<string>postgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_sessions_info</string>
<key>SOGoACLsSendEMailNotifications</key>
<string>YES</string>
<key>SOGoAppointmentSendEMailNotifications</key>
<string>YES</string>
<key>SOGoCalendarDefaultRoles</key>
<array>
<string>PublicViewer</string>
<string>ConfidentialDAndTViewer</string>
</array>
<key>SOGoEnableEMailAlarms</key>
<string>YES</string>
<key>SOGoFoldersSendEMailNotifications</key>
<string>YES</string>
<key>SOGoIMAPServer</key>
<string>127.0.0.1</string>
<key>SOGoLanguage</key>
<string>German</string>
<key>SOGoMailingMechanism</key>
<string>smtp</string>
<key>SOGoMemcachedHost</key>
<string>127.0.0.1</string>
<key>SOGoPasswordChangeEnabled</key>
<string>YES</string>
<key>SOGoProfileURL</key>

<string>postgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_user_profile</string>
<key>SOGoSMTPServer</key>
<string>127.0.0.1</string>
<key>SOGoSieveScriptsEnabled</key>
<string>YES</string>
<key>SOGoSieveServer</key>
<string>sieve://localhost:4190/?tls=NO</string>
<key>SOGoTimeZone</key>
<string>Europe/Berlin</string>
<key>domains</key>
<dict>
<key>hell.localdomain</key>
<dict>
<key>SOGoDraftsFolderName</key>
<string>Drafts</string>
<key>SOGoIMAPServer</key>
<string>127.0.0.1</string>
<key>SOGoMailDomain</key>
<string>hell.localdomain.de</string>
<key>SOGoSMTPServer</key>
<string>127.0.0.1</string>
<key>SOGoUserSources</key>
<array>
<dict>
<key>CNFieldName</key>
<string>cn</string>
<key>IDFieldName</key>
<string>cn</string>
<key>IMAPLoginFieldName</key>
<string>mail</string>
<key>MailFieldNames</key>
<array>
<string>mail</string>
<string>gosamailalternateaddress</string>
</array>
<key>UIDFieldName</key>
<string>uid</string>
<key>baseDN</key>
<string>ou=people,dc=hell</string>
<key>bindDN</key>
<string>cn=manager,dc=hell</string>
<key>bindFields</key>
<string>mail</string>
<key>bindPassword</key>
<string>freebsd</string>
<key>canAuthenticate</key>
<string>YES</string>
<key>displayName</key>
<string>ldap</string>
<key>hostname</key>
<string>localhost</string>
<key>id</key>
<string>ldap</string>
<key>port</key>
<string>389</string>
</dict>
</array>
</dict>
</dict>
</dict>
</dict>
</plist>
~
I want to have an public addressbok and private addressboks for each
user in PostgreSQL instead of LDAP. It would be the best if I could use
different tables for each handeled domain. Could anyone give me a hint
to get this funtionallity please?

cheers Darko






  • [SOGo] Adding an SQL Addressbook to an LDAP User-Resource, Darko Hojnik, 03/27/2012

Archive powered by MHonArc 2.6.18.

Top of page