View Single Post
  #9  
Old 24th April 2011, 15:54
d1sk0 d1sk0 is offline
Junior Member
 
Join Date: Mar 2011
Posts: 3
Thanks: 0
Thanked 3 Times in 3 Posts
Default Example Config

I'm not familiar with this forum stuff, so this post could look better… However this should get you going.

Your DB needs at least 2 tables and 1 view (can also be a table, but you want integration with ISPConfig, don't you?). Actually my system is based on PostgreSQL, but shouldn't be that different with MySQL.


Table "public.sogo_folder_info"
Column | Type | Modifiers
------------------+-------------------------+------------------------------------------------------------------------
c_folder_id | integer | not null default nextval('sogo_folder_info_c_folder_id_seq'::regcla ss)
c_path | character varying(255) | not null
c_path1 | character varying(255) | not null
c_path2 | character varying(255) |
c_path3 | character varying(255) |
c_path4 | character varying(255) |
c_foldername | character varying(255) | not null
c_location | character varying(2048) | not null
c_quick_location | character varying(2048) |
c_acl_location | character varying(2048) |
c_folder_type | character varying(255) | not null
Indexes:
"sogo_folder_info_pkey" PRIMARY KEY, btree (c_path)


Table "public.sogo_user_profile"
Column | Type | Modifiers
------------+------------------------+-----------
c_uid | character varying(255) | not null
c_defaults | text |
c_settings | text |
Indexes:
"sogo_user_profile_pkey" PRIMARY KEY, btree (c_uid)



Table "public.sogo_view"
Column | Type | Modifiers
------------+------------------------+-----------
c_uid | character varying(255) | not null
c_name | character varying(255) | not null
c_password | character varying(255) | not null
c_cn | character varying(255) | not null
mail | character varying(255) | not null


Contents of /home/sogo/GNUstep/Defaults/.GNUstepDefaults:

<?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/>
<key>sogod</key>
<dict>
<key>OCSFolderInfoURL</key>
<string>mysql://userass@host/db_name/sogo_folder_info</string>
<key>OCSSessionsFolderURL</key>
<string>mysql://userass@host/db_name/sogo_sessions_folder</string>
<key>SOGoACLsSendEMailNotifications</key>
<string>YES</string>
<key>SOGoAppointmentSendEMailNotifications</key>
<string>YES</string>
<key>SOGoDraftsFolderName</key>
<string>Drafts</string>
<key>SOGoFoldersSendEMailNotifications</key>
<string>YES</string>
<key>SOGoIMAPServer</key>
<string>localhost</string>
<key>SOGoLanguage</key>
<string>German</string>
<key>SOGoMailDomain</key>
<string>your-domain.tld</string>
<key>SOGoProfileURL</key>
<string>mysql://userass@host/db_name/sogo_user_profile</string>
<key>SOGoSentFolderName</key>
<string>Sent</string>
<key>SOGoTimeZone</key>
<string>Europe/Berlin</string>
<key>SOGoTrashFolderName</key>
<string>Trash</string>
<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/sogo_user_view</string>
</dict>
</array>
</dict>
</dict>
</plist>


HTH,

Andreas
Reply With Quote