Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: Librarian on September 27, 2006, 10:31:44 AM
-
Hi there
I have a client who wants to have collaboration software on SME - is this possible?
Basically he/she wants to add an appointment to the calendar, and be able to see what the appointment is about, while the secretary will only see the appointment and not know what it's about.
Regards
Libs
-
hello,
Lots of soft can do that for example :
Moregroupware,
eGroupware,
OpenXchange,
...
Normally for all three I've give you, you can find howto for sme installation.
Regards.
-
Since SME already uses Horde for email, why not use other Horde modules to make it a complete system. See following posting for more info:
http://forums.contribs.org/index.php?topic=31018.0
-
have a look at http://www.desknow.com
-
DeskNow is not a GPL software, it is a commercial distribution. After trial period they let you use it in "lite mode"
-
If your client is happy with a web based option, then Horde looks the best choice. However, if he is using Outlook for his calendaring, you could consider using the Cyrus-Imap contrib in conjuction with the Totlec connector.
This is a commercial solution - at least the Toltec connector part carries a licence fee, the cyrus-imap contrib doesn't. If your client isn't using Outlook, then this option's probably not for you, but if like many of my clients, to him Calendar = Outlook (& no alternative will do) then its probably worth a look.
Search the forums or see the HowTo at www.westcountrybusiness.com
-
For a web-based app, EGroupware is one of the leading software.
For an Outlook-based situation, choices are limited to GPL on a server and a proprietary connector between the server and the client (Outlook).
I've tried OpenXchange on SME7 with little luck. It needs a connector.
EGroupware on SME7 cannot sync with Outlook because it needs php5.
I've also tried successfully Kolab with Outlook connector, but not on SME7
Until SME7 goes with php5, the only working solution on SME7 with Outlook is Cyrus-imap with Toltec. This works extremely well. The only non-GPL parts is the connector ... and Outlook !
The cyrus addon is working fine with horde, Egroupware... but you have to decide between Outlook and non-Outlook base setup. Since Outlook will manage the folders, other client may not understand the elements known to Outlook only (ie: todo, calendar)
Cyrus is so well suited for Offices needing to share mail folders that it should be incorporated into SME7's core!
-
EGroupware on SME7 cannot sync with Outlook because it needs php5.
Have you tried this as well: How-To upgrade to MySQL 5 and PHP 5 (http://no.longer.valid/phpwiki/index.php/How-To%20upgrade%20to%20MySQL%205%20and%20PHP%205). I found it in this thread: Looking for HowTo install MySQL 5.x and PHP 5.x (http://forums.contribs.org/index.php?topic=33434.0)
-
I'll give a look to these links but it seems that php5 is far from production quality and represents a security risk for now...
-
I'll throw my vote in for Conflux. http://www.conflux.ee I've mucked with their demo and it's very nice with a lot of features. There is an install howto in SME7HowTo
Craig
-
Conflux is free for 5 users. exchange4linux is an other product with the same licencing. This is not suitable for me since I draw the line at the connector level if I have to pay something.
Cyrus-imap can be used with other mail clients to share folders, and it's GPL.
-
I just finished testing the howto about php5. After applying this patch, I installed egroupware in an Ibay and I tested sync with Funambol (rpc.php) and eGWOSync (xmlrpc.php).
A patch was also needed in egroupware:
edit /egroupware/phpgwapi/inc/xml_functions.inc.php
Change:
$GLOBALS['xmlrpc_defencoding'] = 'UTF-8';
To:
$GLOBALS['xmlrpc_defencoding'] = '';
Also, for Funambol to work it needs /etc/e-smith/templates-custom/etc/php.ini/30mbstring
mbstring.func_overload = 0
Funambul needs these settings (re: egroupware.org)
Contact = ./sifcontacts
Calendar = ./sifcalendar
Task = ./siftasks
Note = n/a
It seems to be working fine ! I'm impressed...
Funambul has a timer option and does not trigger Outlook alarm about external program using it.
Unfortunatly, it does not seem possible to have categories of contacts in Outlook or more that one address book. This is possible with Toltec.
All in all, my first impression is very good. Funambol is great, the php5 howto did not break SME7 but a few reboots were necessary.
Here's what I did...
From http://no.longer.valid/phpwiki/index.php/How-To%20upgrade%20to%20MySQL%205%20and%20PHP%205
, Stephane's howto (http://serviceinfosg.com:8185/dmdocuments/HowTo%20Installer%20eGroupWare%201.2%20sue%20SME%20Serveur%207.0%20English.html) about Egroupware and my own notes:
I started by creating an ibay egroupware and then I did:
# -- during these processes, download egroupware on a client
download http://users.ugent.be/~bpuype/cgi-bin/fetch.pl?dl=wget/wget.exe --> output-document="c:\windows"
wget http://switch.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-1.2-105.zip
wget http://easynews.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-contrib-1.2-105.zip
wget http://easynews.dl.sourceforge.net/sourceforge/egroupware/eGWOSyncSetup_0.4.0.msi
Phase I
# 1-- on the console:
/sbin/e-smith/db accounts setprop egroupware PHPBaseDir /home/e-smith/files/ibays/egroupware:/tmp:/usr/bin:/usr/share/pear
/sbin/e-smith/db accounts setprop egroupware PHPBaseDir /home/e-smith/files/ibays/egroupware:/tmp:/usr/share/pear
/sbin/e-smith/signal-event ibay-modify egroupware
rpm -e --nodeps php-domxml
mysqldump -Aec >backupdump.sql
/etc/rc.d/init.d/mysqld stop
yum -y --enablerepo=centosplus update mysql
signal-event post-upgrade
signal-event reboot
Phase II
Edit the line with the password...
mysql
GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';
CREATE DATABASE egroupware;
GRANT ALL ON egroupware.* TO egroupware@localhost IDENTIFIED BY '%%%%%%%';
FLUSH PRIVILEGES;
\q
Phase III
wget http://magicwilly.webhostingpal.com/SME7%20How%20To%20Files/MySQL5/mysql.sql
wget http://magicwilly.webhostingpal.com/SME7%20How%20To%20Files/PHP5/50PathsDirectories
wget http://magicwilly.webhostingpal.com/SME7%20How%20To%20Files/PHP5/20LoadModule80PHP
wget http://mirror.contribs.org/smeserver/releases/7/updates/i386/RPMS/php-domxml-4.3.9-3.15.i386.rpm
mysql mysql < mysql.sql
yum -y --enablerepo=centosplus update php
mkdir -p /etc/e-smith/templates-custom/etc/php.ini
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
cp 50PathsDirectories /etc/e-smith/templates-custom/etc/php.ini/50PathsDirectories
cp 20LoadModule80PHP /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/20LoadModule80PHP
expand-template /etc/php.ini
expand-template /etc/httpd/conf/httpd.conf
/etc/rc.d/init.d/httpd restart
rpm -Uvh --nodeps php-domxml-4.3.9-3.15.i386.rpm
yum -y install --enablerepo=base subversion mod_dav_svn
signal-event post-upgrade
signal-event reboot
Phase IV
rpm -Uvh http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm
Follow Stephane's howto but beware of this: Funambol needs this:
echo "mbstring.func_overload = 0" >> /etc/e-smith/templates-custom/etc/php.ini/30mbstring
Both sync tools needed this patch:
edit /egroupware/phpgwapi/inc/xml_functions.inc.php
Change:
$GLOBALS['xmlrpc_defencoding'] = 'UTF-8';
To:
$GLOBALS['xmlrpc_defencoding'] = '';
I added an automatic update of egroupware with this:
echo "#!/bin/sh" > /etc/cron.daily/svn_egroupware.sh
echo "cd /home/e-smith/files/ibays/egroupware/html" >> /etc/cron.daily/svn_egroupware.sh
echo "svn update *" >> /etc/cron.daily/svn_egroupware.sh
chmod u+x /etc/cron.daily/svn_egroupware.sh
The automatic update would overwrite the above patch, though...
I don't know how long I'll resist before applying this patch to a production SME7, but it appears to be running Ok.