Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th January 2011, 22:19
i-chat i-chat is offline
Member
 
Join Date: Jan 2011
Posts: 31
Thanks: 3
Thanked 0 Times in 0 Posts
Arrow 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, ????
Reply With Quote
Sponsored Links
  #2  
Old 28th January 2011, 14:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

I haven't tried Sogo, so I can't tell anything about it...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 29th January 2011, 09:26
i-chat i-chat is offline
Member
 
Join Date: Jan 2011
Posts: 31
Thanks: 3
Thanked 0 Times in 0 Posts
Default

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...
Reply With Quote
  #4  
Old 20th February 2011, 19:26
germinator germinator is offline
Member
 
Join Date: Nov 2010
Location: /root
Posts: 51
Thanks: 7
Thanked 16 Times in 9 Posts
Default

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
Reply With Quote
The Following 2 Users Say Thank You to germinator For This Useful Post:
beyerservice (2nd March 2011), falko (21st February 2011)
  #5  
Old 2nd March 2011, 22:41
beyerservice beyerservice is offline
Member
 
Join Date: Feb 2011
Location: /dev/null
Posts: 30
Thanks: 10
Thanked 6 Times in 5 Posts
Default

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?
Reply With Quote
The Following User Says Thank You to beyerservice For This Useful Post:
i-chat (3rd March 2011)
  #6  
Old 3rd March 2011, 21:42
i-chat i-chat is offline
Member
 
Join Date: Jan 2011
Posts: 31
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by beyerservice View Post
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...
Reply With Quote
  #7  
Old 23rd April 2011, 17: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
The Following User Says Thank You to d1sk0 For This Useful Post:
beyerservice (24th April 2011)
  #8  
Old 24th April 2011, 14:28
beyerservice beyerservice is offline
Member
 
Join Date: Feb 2011
Location: /dev/null
Posts: 30
Thanks: 10
Thanked 6 Times in 5 Posts
Default

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 :-)
Reply With Quote
  #9  
Old 24th April 2011, 14: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
The Following User Says Thank You to d1sk0 For This Useful Post:
beyerservice (24th April 2011)
  #10  
Old 24th April 2011, 23:02
beyerservice beyerservice is offline
Member
 
Join Date: Feb 2011
Location: /dev/null
Posts: 30
Thanks: 10
Thanked 6 Times in 5 Posts
 
Default

thank. you. i am testing this with ZEG in virtualbox.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 + SOGo kmh General 1 5th November 2010 14:46
Problems with installing SSL-certifates on ISPConfig3 slaveservers Hans General 4 5th October 2010 12:22
amavis rejects all inbound emails aclhkaclhk Installation/Configuration 5 28th February 2010 04:24
ISPConfig3 FTP problem karazy-k Server Operation 6 3rd September 2009 16:03
Questions about ISPConfig3 vs. ISPConfig2 atjensen11 General 1 14th March 2009 23:59


All times are GMT +2. The time now is 16:54.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.