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, ????
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://userass@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'::regclass) 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
Hi, I´m also interested in combining sogo and ispconfig, at the moment i have a small sogo server with mysql user-db to get some experience with sogo... i used this howto http://wiki.debian.org/SOGo to set up the sogo server... there was a thread on the sogo mailing list https://inverse.ca/sogo/lists/arc/users/2010-11/msg00080.html it might be possible to build a sync script between the ispconfig mail-user-db and the sogo-user db or even use the ipconfig table directly in sogo... there might be a problem with the different md5 used by sogo and ispconfig.... a password-hash generated in ispconfig looks different than the hash for the same password in sogo... FlO
thank you so much! That did it. now i have to test some integration so ispconfig. but i thing we need some cron job whos updating sql tables in sogo/ispconfig. if got another problem here: Accessing https://sogo.vandervlis.nl/SOGo/dav/paul/Contacts/personal/ im getting wrong password message? my be that has something to to with this settings: i have to change my proxy settings so port:81. Update: changing port to something above 1024 worked now.
Hi, in the german forum there´s also a thread http://www.howtoforge.de/forum/allgemein-11/groupware-bzw-kalender-und-kontakt-funktion-4920/ i have looked at the latest sogo 1.3.9 install documentation, and sogo now seems to support sha as encryption algorithm. theres also a bug report for it http://www.sogo.nu/bugs/view.php?id=1014 and http://www.sogo.nu/bugs/view.php?id=1197 for changing passwd does anyone know if ispconfig uses also sha for its mailuserpasswords?? is there a documentation of the database-tables? mFg FlO
I dont know Horde, but you can use SOGo as an Exchange replacement. you can connect Outlook to a sogo server without any plugin in Exchange Mode either directly or via outlook over https... The setup for this exchange compatibility is a little bit complicated, you need to setup samb4 and the user database has to be inside the samba ldap directory....
Cheers FlobbyDisk (classic name)... I figured that would be the case. Would anyone be willing to make a How to for ISPConfig 3.0.5 and SOGo? That would be the ultimate setup.
Sctip to add SOGo to ISPConfig hey there i have created a small script to add SOGo into ispconfig. so fare all my test are good but only on debian, you can find it here. http://cmjscripter.net/files/scripts/ispc/ISPC-SOGO-debian.sh have say sice work with the new ISPConfig 3.0.5, nice to see multi php conf.. second sorry for my bad english.. now since SOGo have a LOT of possibilities, and option the script is by fare complete but it sets up what your need to use it.. when you run the script it wil add sogo mirror to your source.list install the gnupg key and install SOGo for use w. MySQL it give you a few options when running it, it wil also alter your ispconfig user to allow CREATE VIEW. it supports multi domains. creates i basic plugin for ispconfig to create the SOGo config file and creates the needed views in order to use your mail addr to login. one thing you need to know before running the script is that is NOT testing on a production server, AND SOGo automatic creates 3 tables per. user that login, so your ispconfig db will quickly become a large one (i'm working on a better solution for it.) besides installing SOGo you have the following files added /usr/local/ispconfig/server/plugins-available/sogo_config_plugin.php /usr/local/ispconfig/server/conf/sogo.conf-templ Adminitrator is [email protected]" if postmaster mail addr is not added go add it and login to SOGo to start administrat the domain Enable SOGo logins by update/delete or add a mail domain and the plugin wil do the rest... Regards. Christian ps. i love to here if the script is a piece of **** or something you can use but need some fixes
