HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Tips/Tricks/Mods (http://www.howtoforge.com/forums/forumdisplay.php?f=29)
-   -   ISPconfig3 + Sogo ? (http://www.howtoforge.com/forums/showthread.php?t=51162)

i-chat 27th January 2011 22:19

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, ????

falko 28th January 2011 14:44

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

i-chat 29th January 2011 09:26

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...

germinator 20th February 2011 19:26

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

beyerservice 2nd March 2011 22:41

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?

i-chat 3rd March 2011 21:42

Quote:

Originally Posted by beyerservice (Post 252538)
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...

d1sk0 23rd April 2011 17:13

Authentication against RDBMS *is* possible
 
Quote:

Originally Posted by beyerservice (Post 252538)
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://user:pass@host/db_name/table_or_view_name</string>
</dict>
</array>


HTH,

Andreas

beyerservice 24th April 2011 14:28

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 :-)

d1sk0 24th April 2011 14:54

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

beyerservice 24th April 2011 23:02

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


All times are GMT +2. The time now is 01:58.

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