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.