[OGo-Users] Help getting clients to work
brian Austin
users@opengroupware.org
Thu, 19 Apr 2007 08:57:18 +1000
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
heres a copy of my records on how I did this, up to as far as I got
with it. Just got a nokia n73 to pursue the testng, time permitting.<br>
<h1><br>
</h1>
<h1> Opengroupware with Funambol pim connector </h1>
<p>
</p>
<h2><a name="References"></a><a name="References_"></a> References:<br>
</h2>
<a
href="http://mail.opengroupware.org/pipermail/users/2006-September/016806.html"
target="_top">http://mail.opengroupware.org/pipermail/users/2006-September/016806.html</a><br>
<a href="http://comalies.citadel.org/%7Ematt/funambol/pre-rc1/"
target="_top">http://comalies.citadel.org/~matt/funambol/pre-rc1/</a><br>
<p>
</p>
<p></p>
<h2><a name="Opengroupware_install"></a> Opengroupware install </h2>
<p>
vi /etc/apt/sources.list
</p>
<p>add
</p>
<p>deb <a
href="http://download.opengroupware.org/nightly/packages/debian"
target="_top">http://download.opengroupware.org/nightly/packages/debian</a>
sarge releases/opengroupware-1.1.6-yummy<br>
deb <a href="http://download.opengroupware.org/nightly/packages/debian"
target="_top">http://download.opengroupware.org/nightly/packages/debian</a>
sarge releases/sope-4.5.9-maple<br>
deb <a href="http://download.opengroupware.org/nightly/packages/debian"
target="_top">http://download.opengroupware.org/nightly/packages/debian</a>
sarge releases/ThirdParty<br>
</p>
<p>apt-get update<br>
apt-get install libsope-core4.5 libfoundation1.1<br>
apt-get dist-upgrade<br>
</p>
<p></p>
<p>some dependancies will be missing, as we are running on etch, not
sarge.<br>
</p>
<p>wget <a
href="http://http.us.debian.org/debian/pool/main/r/readline4/libreadline4_4.3-11_i386.deb"
target="_top">http://http.us.debian.org/debian/pool/main/r/readline4/libreadline4_4.3-11_i386.deb</a><br>
wget <a
href="http://http.us.debian.org/debian/pool/main/p/pilot-link/libpisock8_0.11.8-10_i386.deb"
target="_top">http://http.us.debian.org/debian/pool/main/p/pilot-link/libpisock8_0.11.8-10_i386.deb</a><br>
wget <a
href="http://security.debian.org/debian-security/pool/updates/main/p/postgresql/libpq3_7.4.7-6sarge4_i386.deb"
target="_top">http://security.debian.org/debian-security/pool/updates/main/p/postgresql/libpq3_7.4.7-6sarge4_i386.deb</a><br>
</p>
<p>dpkg -i libreadline4_4.3-11_i386.deb<br>
dpkg -i libpisock8_0.11.8-10_i386.deb <br>
dpkg -i libpq3_7.4.7-6sarge4_i386.deb<br>
</p>
<p>apt-get install postgresql libapache-mod-ngobjweb <br>
</p>
<p>apt-get install opengroupware.org1.1*<br>
</p>
<p> apt-get install libfoundation-tools<br>
</p>
<p>apt-get install daemon
</p>
<p>hacks to fix up the broken install
</p>
<p>1. get the create instance script, run it.<br>
wget <a
href="http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/ogo-create-instance?rev=1759"
target="_top">http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/ogo-create-instance?rev=1759</a><br>
chmod 700 ogo-create-instance?rev=1759<br>
./ogo-create-instance?rev=1759
</p>
<p>2. get the /etc/init.d/opengroupware file<br>
wget <a
href="http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/opengroupware.org-environment.opengroupware.org?rev=1759"
target="_top">http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/opengroupware.org-environment.opengroupware.org?rev=1759</a><br>
mv opengroupware.org-environment.opengroupware.org\?rev\=1759
opengroupware<br>
chmod 700 opengroupware <br>
mv opengroupware /etc/init.d/ </p>
<p>cd /etc/rc2.d<br>
ln -s ../init.d/opengroupware S92opengroupware<br>
cd ../rc3.d/<br>
ln -s ../init.d/opengroupware S92opengroupware<br>
cd ../rc4.d/<br>
ln -s ../init.d/opengroupware S92opengroupware<br>
cd ../rc5.d/<br>
ln -s ../init.d/opengroupware S92opengroupware
</p>
<p></p>
<p></p>
<h3><a name="Configure_postgress_to_allow_acc"></a> Configure postgress
to allow access to database. </h3>
<p>
need to allow local machine access to postgress
</p>
<p></p>
<h2><a name="Funombal_install"></a> Funombal install </h2>
<p>
This is not an apt-get install procedure.<br>
</p>
<p></p>
<h3><a name="Required_Files"></a> Required Files </h3>
<ul>
<li> <a
href="http://sourceforge.net/project/showfiles.php?group_id=22866&package_id=16942&release_id=416591"
target="_top">http://sourceforge.net/project/showfiles.php?group_id=22866&package_id=16942&release_id=416591</a>
jBoss 4.0.4GA Installer (jboss-4.0.4.GA-Patch1-installer.jar
</li>
<li> <a
href="http://www.funambol.com/opensource/download_form.html?file_id=funambol-ds-server-5.0.10.zip"
target="_top">http://www.funambol.com/opensource/download_form.html?file_id=funambol-ds-server-5.0.10.zip</a>
Funambol DS Server 5.0.10 archive
</li>
<li> <a href="http://comalies.citadel.org/%7Ematt/funambol/latest/"
target="_top">http://comalies.citadel.org/~matt/funambol/latest/</a> <br>
<span class="twikiNewLink">GroupDAV<a rel="nofollow"
href="http://192.168.41.24/twiki/bin/edit/Main/GroupDAV?topicparent=Main.OpenGroupware"
title="Create this topic"><sup>?</sup></a></span> Funambol s4j
(groupdav-1.x.xxxx.s4j)<br>
<span class="twikiNewLink">JGroupDAV<a rel="nofollow"
href="http://192.168.41.24/twiki/bin/edit/Main/JGroupDAV?topicparent=Main.OpenGroupware"
title="Create this topic"><sup>?</sup></a></span>.jar<br>
gdav_libs.tar.bz2<br>
</li>
<li> <a
href="http://www.funambol.com/opensource/download_form.html?file_id=funambol-admin-3.0.9.tgz"
target="_top">http://www.funambol.com/opensource/download_form.html?file_id=funambol-admin-3.0.9.tgz</a>
Funambol Administration Tool 3.0.9
</li>
<li> <a class="moz-txt-link-abbreviated" href="http://www.java.com">www.java.com</a> java5 sdk (bambam\apps\oe10) note - sdk, not jre
</li>
</ul>
<p></p>
<h3><a name="Install_java"></a> Install java </h3>
<p>
reference: <a href="http://192.168.41.24/twiki/bin/view/Main/LinuxJava"
class="twikiLink">LinuxJava</a>
</p>
<p>Get the java 5 sdk from <a class="moz-txt-link-abbreviated" href="http://www.java.com">www.java.com</a>
</p>
<p>extract the contents to (eg) /usr/lib/jdk1.5.0_11
</p>
<p>ln -s /usr/lib/jdk1.5.0_11 /usr/lib/java
</p>
<p>ln -s /usr/bin/java /usr/lib/java/bin/java
</p>
<p>add to /etc/profile and any scripts that need java
</p>
<p>export JAVA_HOME=/usr/lib/java
</p>
<p></p>
<p></p>
<h3><a name="Install_Jboss"></a> Install Jboss </h3>
<p>
References:<br>
<a
href="http://comalies.citadel.org/%7Ematt/funambol/pre-rc1/install-guide/x47.html"
target="_top">http://comalies.citadel.org/~matt/funambol/pre-rc1/install-guide/x47.html</a>
</p>
<p> Installing jBoss is fairly easy. The installer is a runable
java archive, and can be executed by double clicking on it in your GUI
or manually by:
</p>
<p> $ java -jar jboss-4.0.4.GA-Patch1-installer.jar
</p>
<p></p>
<p>If you don't have graphical access to your system and can't run
the installer, try either one of the other archives from the download
site, or perhaps a jBoss package from your system vendor
</p>
<p>Take note of the location on your system which you install jBoss to.
When asked, choose the default install profile </p>
<p>jboss installs to<br>
/usr/local/jboss-4.0.4.ga<br>
</p>
<p></p>
<p></p>
<p></p>
<h3><a name="Install_funambol"></a> Install funambol </h3>
<p>
cd ~<br>
unzip funambol-ds-server-5.0.10.zip<br>
this is an old version you want the latest version from Matts download
site.
</p>
<p>cd /usr/local<br>
mv ~/Funambol .
</p>
<p></p>
<p></p>
<p>4. Funambol DS Server
</p>
<p>Unzip the Funambol archive and move its contents to a permanent
place on your system. Then open up a terminal and export the following
environment variables:
</p>
<p> $ export JAVA_HOME=/usr/lib/java<br>
$ export J2EE_HOME=/usr/local/jboss-4.0.4.ga
</p>
<p></p>
<p>(Suggestion: save the exports as a shell script so you can source
them when needed)
</p>
<p>Copy the groupdav-1.x.xxxx.s4j archive to modules in the
Funambol/ds-server directory.
</p>
<p>I am using mysql for funambol, need the jdbc connector. My server
accepts login from localhost as root with a password </p>
<p>cd ~
<br>
wget <a href="http://dev.mysql.com/downloads/connector/j/5.0.html"
target="_top">http://dev.mysql.com/downloads/connector/j/5.0.html</a><br>
gunzip the file, untar it.<br>
find the file<br>
mysql-connector-java-5.0.4-bin.jar<br>
and copy it to the jboss default server lib folder<br>
cp mysql-connector-java-5.0.4-bin.jar
/usr/local/jboss-4.0.4.GA/server/default/lib
</p>
<p></p>
<p>Open up install.properties in Funambol/ds-server, </p>
<p>dbms=mysql
</p>
<p>further down... My server accepts login from localhost as root with
a password </p>
<p>
jdbc.classpath=/usr/local/jboss-4.0.4.GA/server/default/lib/mysql-connector-java-5.0.4-bin.jar<br>
jdbc.driver=com.mysql.jdbc.Driver<br>
jdbc.url=jdbc:mysql://localhost/funambol<br>
jdbc.user=root<br>
jdbc.password=......<br>
</p>
<p></p>
<p>Just below the SQL definitions there is a modules-to-install line:
</p>
<p>
modules-to-install=foundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.0.7
</p>
<p></p>
<p>Add the <span class="twikiNewLink">GroupDAV<a rel="nofollow"
href="http://192.168.41.24/twiki/bin/edit/Main/GroupDAV?topicparent=Main.OpenGroupware"
title="Create this topic"><sup>?</sup></a></span> connector to the end
of it, like so:
</p>
<p>
modules-to-install=foundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.0.7,groupdav-1.x.xxxx
</p>
<p></p>
<p>Next, make the install scripts executable, and install Funambol:
</p>
<p> $ chmod +x bin/install.sh $ chmod +x bin/install-modules.sh $
bin/install.sh jboss40
</p>
<p></p>
<p>The script will ask you if you wish to replace the database for each
module. Answer Y (yes) to each one.
</p>
<p>ATTENTION! If you already have services running on port 8080, edit
the jBoss tomcat configuration in <jboss>/server/default/deploy/jbossweb-tomcat55.sar/server.xml
</jboss></p>
<p>Before we start Funambol, the server needs all the dependencies for
the connector in its classpath. Copy <span class="twikiNewLink">JGroupDAV<a
rel="nofollow"
href="http://192.168.41.24/twiki/bin/edit/Main/JGroupDAV?topicparent=Main.OpenGroupware"
title="Create this topic"><sup>?</sup></a></span>.jar, and the
contents of gdav_libs.tar.bz2 to <jboss>/server/funambol/lib. Then,
start Funambol with:
</jboss></p>
<p> $ bin/start.sh
</p>
<p>prove the point, hitting the site...
</p>
<p><a href="http://barneyvm:8080/funambol/" target="_top">http://barneyvm:8080/funambol/</a>
</p>
<p></p>
<table class="twikiTable" border="0" cellpadding="1" cellspacing="1">
<tbody>
<tr>
<td class="twikiFirstCol" bgcolor="#eaeaea"> Build version: </td>
<td bgcolor="#eaeaea"> 5.0.10 </td>
</tr>
<tr>
<td class="twikiFirstCol" bgcolor="#ffffff"> Build date: </td>
<td bgcolor="#ffffff"> 20060908 </td>
</tr>
<tr>
<td class="twikiFirstCol" bgcolor="#eaeaea"> Source tag: </td>
<td bgcolor="#eaeaea"> serverds_5_0_10</td>
</tr>
</tbody>
</table>
<br>
<br>
-----Original Message -----<br>
From: Adam Tauno Williams<br>
Sent: 19/04/2007 12:08 AM <br>
<blockquote cite="mid:1176905319.4707.8.camel@aleph.whitemice.org"
type="cite">
<blockquote type="cite">
<pre wrap="">I have just installed opengroupware on Debian etch. The documentation
for opengroupware seems scattered and I'm finding it difficult to
follow.
</pre>
</blockquote>
<pre wrap=""><!---->
There is some organized documentation here -
<a class="moz-txt-link-freetext" href="http://docs.opengroupware.org/Members/whitemice/wmogag/file_view">http://docs.opengroupware.org/Members/whitemice/wmogag/file_view</a>
</pre>
<blockquote type="cite">
<pre wrap="">What I want to achieve is to be able to sync evolution,
</pre>
</blockquote>
<pre wrap=""><!---->
Do you mean "Sync" or "Connect". These are two quite different things.
The GroupDAV plugin works fairly well, but not perfectly. The code can
be gotten here - svn co
<a class="moz-txt-link-freetext" href="http://developer.opengroupware.org/OGoProjects/evolution-groupdav/trunk">http://developer.opengroupware.org/OGoProjects/evolution-groupdav/trunk</a>
- (I think). We really need a doc plone page on that one. That is
useful for *Connect*, but not [I think] for Sync. (Does it work
offline?). With a recent version of Evolution building and installing
the plugin is very straight-forward.
</pre>
<blockquote type="cite">
<pre wrap="">and possibly outlook
</pre>
</blockquote>
<pre wrap=""><!---->
You should be able to *Sync* via Funambol/GroupDAV; to *Connect* you
need Zidelook.
Via Funambol you can sync with just about anything -
<a class="moz-txt-link-freetext" href="http://docs.opengroupware.org/Members/whitemice/applications/syncml/funambol-setup/view?searchterm=funambol">http://docs.opengroupware.org/Members/whitemice/applications/syncml/funambol-setup/view?searchterm=funambol</a>
This link needs to be updated to reflect the latest version, but
otherwise should be correct.
If you want to *Connect* with Outlook then you should purchase a copy of
the ZideLook plugin; which also provides an Offline mode. ZideLook
works well and is inexpensive.
</pre>
<blockquote type="cite">
<pre wrap="">or Sunbird.
</pre>
</blockquote>
<pre wrap=""><!---->
Sunbird only supports iCalendar [AFIAK] and this is really only useful
to viewing/reading, writes don't work so well (which is a problem with
the iCalendar model, not OGo).
</pre>
<blockquote type="cite">
<pre wrap="">Whats the best way to go about this, I see Groupdav looks promising, is
this included in OpenGroupware? or is it still experimental seems
unclear (to me at least).
</pre>
</blockquote>
<pre wrap=""><!---->
It works quite well, client support is still a bit nascent.
</pre>
<blockquote type="cite">
<pre wrap="">If anyone has a good guide they could point me to, or explain their
setup solution if it's similar. I would be great-full! and you'd save me
loosing my hair!.
</pre>
</blockquote>
</blockquote>
</body>
</html>