SOGo configuration for use with Kolab 2

Aus MHC-Wiki

Database

First you have to create a database for SOGo. For PostgreSQL you may want to do some thing like this:

su – postgres
createuser sogo
createdb -O sogo sogo

You should then adjust the access rights to the database. To do so, modify the /var/lib/pgsql/data/pg_hba.conf file in order to add the following line at the very beginning of the file or as the first line of the active lines in the file:

host    sogo     sogo     127.0.0.1/32        trust

If your SOGo and PostgreSQL server are not located on the same machine you can add some thing like this:

host    sogo     sogo     192.168.1.99/32        trust

to you pg_hba.conf where 192.168.1.99 has to be replaced with the IP of your SOGo Server. Don't forget to restart PostgreSQL daemon after this so you modifications take effect.

SOGo Configuration

To make use of the LDAP directory of Kolab 2 SOGo could be configured like this:

su - sogo

defaults write sogod SOGoServerTimeZone "Europe/Berlin"
defaults write sogod WOParsersUseUTF8 YES
defaults write sogod WOMessageUseUTF8 YES
defaults write sogod SOGoDefaultMailDomain "mhcsoftware.de"
defaults write sogod NGUseUTF8AsURLEncoding YES
defaults write sogod WOUseRelativeURLs NO
defaults write sogod SOGoDefaultLanguage German
defaults write sogod SOGoAppointmentSendEMailNotifications YES
defaults write sogod SOGoFoldersSendEMailNotifications YES
defaults write sogod SOGoACLsSendEMailNotifications YES
defaults write sogod WOPort 20000

defaults write sogod SOGoAuthenticationMethod LDAP
defaults write sogod SOGoLDAPSources '({
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName = uid;
bindFields = uid;
baseDN = "dc=mhcsoftware,dc=de"; 
canAuthenticate = YES; 
displayName = "Interne Adressen";
hostname = "server.mhc.loc"; 
id = shared;
isAddressBook = YES; 
filter="objectClass=kolabInetOrgPerson";
port=389;
scope="SUB";
})'

defaults write sogod SOGoProfileURL 'postgresql://sogo:sogo@server.mhc.loc:5432/sogo/sogo_user_profile'
defaults write sogod OCSFolderInfoURL 'postgresql://sogo:sogo@server.mhc.loc:5432/sogo/sogo_folder_info'

defaults write sogod SOGoMailingMechanism smtp
defaults write sogod SOGoSMTPServer server.mhc.loc

defaults write sogod SOGoDraftsFolderName Drafts
defaults write sogod SOGoSentFolderName Sent
defaults write sogod SOGoTrashFolderName Trash
defaults write sogod SOGoOtherUsersFolderName "Other Users"
defaults write sogod SOGoSharedFolderName "Shared Folders"
defaults write sogod SOGoFallbackIMAP4Server server.mhc.loc

defaults write sogod WOApplicationRedirectURL http://sogoserver.mhc.loc

Every where where you see a host name with "mhc" you should replace the host name with your values. For Details refer to the SOGo documentation. The important part for Kolab is the "SOGoLDAPSources" property. The following line of the "SOGoLDAPSources" property is extremely important to make SOGo use indirect LDAP binds:

bindFields = uid;

Without this LDAP bind to Kolab will fail.

The last line of the is very important too. It is not mentioned in the documentation but you can find it in the FAQ:

http://www.scalableogo.org/support/faq/article/when-logging-in-to-sogo-the-url-becomes-http127001.html

.GNUstepDefaults

For some odd reason I'm unable to write defaults for my LDAP source this is because I've dumped my .GNUstepDefaults file here:

{
    NSGlobalDomain = {
    };
    gdnc = {
    };
    sogod = {
	NGUseUTF8AsURLEncoding = YES;
	OCSFolderInfoURL = "postgresql://sogo:sogo@server.mhc.loc:5432/sogo/sogo_folder_info";
	SOGoACLsSendEMailNotifications = YES;
	SOGoAppointmentSendEMailNotifications = YES;
	SOGoAuthenticationMethod = LDAP;
	SOGoDefaultLanguage = German;
	SOGoDefaultMailDomain = mhcsoftware.de;
	SOGoDraftsFolderName = Drafts;
	SOGoFallbackIMAP4Server = server.mhc.loc;
	SOGoFoldersSendEMailNotifications = YES;
	SOGoLDAPSources = (
	    {
		CNFieldName = cn;
		IDFieldName = cn;
		UIDFieldName = uid;
		baseDN = "dc=mhcsoftware,dc=de";
		bindFields = uid;
		canAuthenticate = YES;
		displayName = "Interne Adressen";
		filter = "objectClass=kolabInetOrgPerson";
		hostname = server.mhc.loc;
		id = shared;
		isAddressBook = YES;
		port = 389;
		scope = SUB;
	    }
	);
	SOGoMailingMechanism = smtp;
	SOGoOtherUsersFolderName = "Other Users";
	SOGoProfileURL = "postgresql://sogo:sogo@server.mhc.loc:5432/sogo/sogo_user_profile";
	SOGoSMTPServer = server.mhc.loc;
	SOGoSentFolderName = Sent;
	SOGoServerTimeZone = Europe/Berlin;
	SOGoSharedFolderName = "Shared Folders";
	SOGoTrashFolderName = Trash;
	WOApplicationRedirectURL = "http://sogoserver.mhc.loc";
	WOMessageUseUTF8 = YES;
	WOParsersUseUTF8 = YES;
	WOPort = 20000;
	WOUseRelativeURLs = NO;
    };
}

Just cut&paste it to /home/sogo/GNUstep/Defaults/.GNUstepDefaults and make your modifications.