Koozali.org: home of the SME Server

Collaboration software on SME

Librarian

Collaboration software on SME
« 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

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Collaboration software on SME
« Reply #1 on: September 27, 2006, 01:32:26 PM »
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.

Offline calisun

  • *
  • 601
  • +0/-0
Collaboration software on SME
« Reply #2 on: September 28, 2006, 08:35:49 AM »
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
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

tveden

Collaboration software on SME
« Reply #3 on: September 28, 2006, 12:09:25 PM »
have a look at http://www.desknow.com

Offline calisun

  • *
  • 601
  • +0/-0
Collaboration software on SME
« Reply #4 on: September 28, 2006, 06:44:16 PM »
DeskNow is not a GPL software, it is a commercial distribution. After trial period they let you use it in "lite mode"
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline jonroberts

  • ***
  • 111
  • +0/-0
    • http://www.westcountrybusiness.com
Collaboration software on SME
« Reply #5 on: September 28, 2006, 09:01:37 PM »
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
......

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
Collaboration software on SME
« Reply #6 on: October 02, 2006, 09:11:01 PM »
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!
Sophie from Montréal

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Collaboration software on SME
« Reply #7 on: October 02, 2006, 09:22:21 PM »
Quote from: "soprom"
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. I found it in this thread: Looking for HowTo install MySQL 5.x and PHP 5.x
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
Collaboration software on SME
« Reply #8 on: October 03, 2006, 01:08:07 AM »
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...
Sophie from Montréal

Offline pwgsc1

  • ***
  • 93
  • +0/-0
Collaboration software on SME
« Reply #9 on: October 03, 2006, 09:05:16 PM »
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

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
Collaboration software on SME
« Reply #10 on: October 04, 2006, 12:14:56 AM »
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.
Sophie from Montréal

Offline soprom

  • *
  • 589
  • +0/-0
    • www.logiciel-libre.org
Collaboration software on SME
« Reply #11 on: October 04, 2006, 02:41:49 AM »
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:
Code: [Select]
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
Code: [Select]
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:

Code: [Select]
# -- 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
Code: [Select]
# 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...
Code: [Select]
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
Code: [Select]
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

Code: [Select]
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:
Code: [Select]
echo "mbstring.func_overload = 0" >> /etc/e-smith/templates-custom/etc/php.ini/30mbstring

Both sync tools needed this patch:
Code: [Select]
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:
Code: [Select]
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.
Sophie from Montréal