ISPconfig3 + Sogo ?
 

Hi has anyone ever tried to intergrate Sogo: 'http://www.sogo.nu' with ISPconfig 'preferable with as mutch intergration as possible' Sogo is a reather neat opensource groupware solution running on both rpm and deb based distributions and it intergrates nicely with lots of email/pim clients like thunderbird and MS Outlook.

I feal that it would grately benefit any 'budget or not-so-budget webhoster to be able to provide any superb alternative Microsoft Exchange by either hosting there own, (or leasing from another service provider).

I feel that this could end up being a feature that diferents you from many other webhosts (specialy those off the shelve plesk hosts you get today).

since im not experience in running isp config im starting this thread to talk bout this and maybe toghether find 'the perfect' debian ispconfig dns imap smtp (i have not installed pop3 since ages) and sogo install....


what do you guys think, ????

I haven't tried Sogo, so I can't tell anything about it...

basicly is a set of data providers wih a online frontend client for webmail calendaring and other 'exchange-like' stuf it is based on ical (aple, mozilla others) and groepdav, syncML (via plugins) etc .... basis authentication seems to be mail based (courier and maybe others) and it used potgres or other db's (also mysql) of its data storage...

iirc it can auth against ldap

thats as mutch usefull info i can find about now as ive worked with it be fore but never implemented it myself...

SOGo seems like a very nice piece of software ... i am going to set it up on my development machine sometime next week at get back with a test result

hey. i have tried that too, but it didn't work like i expected.
configuration is done with strange config files (GNustep) and authentication only works with LDAP and i don't what to install another authentication server (mysql DB works fine for me). so i skipped that.
Can you tell us, how it works or maybe write some nice howto?

well in trueth ive only yet used it as part of Ebox (now called zentyal) so i cant really share all to mutch info as to how and iff its fully cmpatible with ISPconfig,

the fact of the matter ist that a 'groupware' addon will be a verry outstanding feature that many other pannels dont have.

wheter it be sogo, egroupware or other matters not that mutch at all as long as its well-intergrated and proficiently compatible with the most used clients both desktop (outlook / thunderbird / evolution) webbased (ajax) and mobile (android / symbian / iphoneOS )

so if this particular thing isn't going to work (or work easily thatn lets move on to somthing else... ?) i dont know,

im hoping to get my hands on a decent testmachine pretty soon...

Authentication against RDBMS *is* possible
 

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://user:pass@host/db_name/table_or_view_name</string>
</dict>
</array>


HTH,

Andreas

thank you. thats something im searching for. ill try that.
can you post me your hole settings? im not happy with that config-tool...
(want one *.conf file :-)

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://user:pass@host/db_name/sogo_folder_info</string>
<key>OCSSessionsFolderURL</key>
<string>mysql://user:pass@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://user:pass@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://user:pass@host/db_name/sogo_user_view</string>
</dict>
</array>
</dict>
</dict>
</plist>


HTH,

Andreas

thank. you. i am testing this with ZEG in virtualbox.