Installation de Funambol pour SOGo

• NB : ce sont plus des notes ... pas vraiment une procédure structurée ..

Documentations

• http://doc.ubuntu-fr.org/funambol

• http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf

Installation sur le sogo-paris

• pré-requis :
  • mysql avec un compte pour funambol

  • un utilisateur système funambol dont le hone sera le dossier de base de funambol (ici : var/lib/funambol/Funambol), avec tous les droits sur le dossier

  • java bin et jre (chez canonical lucid/partner : "deb http://archive.canonical.com/ lucid partner")

• version installée : funambol bundle 8.7 dans le dossier var/lib/funambol/Funambol

  • placer funambol dans init.d : cp /var/lib/funambol/Funambol/bin/funambol /etc/init.d/ ; update-rc funambol defaults ; rm /var/lib/funambol/Funambol/bin/funambol ; ln -s /etc/init.d/funambol  /var/lib/funambol/Funambol/bin/

    • Petit soucis pas grave :

      root@sogo-paris:/var/lib/funambol/Funambol# /etc/init.d/funambol stop
      java.sql.SQLException: socket creation error
      
      ==> il est quand même arrêté
      root@sogo-paris:/var/lib/funambol/Funambol# netstat -tlnup | grep java
      root@sogo-paris:/var/lib/funambol/Funambol#

  • home de funambol et path pour jre défini dans /etc/init.d/funambol

  • mysql-connector-java-xxx-bin.jar ("For MySQL, please refer to the following site : http://dev.mysql.com/usingmysql/java/")

    • le mettre conforment au path spécifié ici "jdbc.classpath=/var/lib/funambol/Funambol/mysql-connector-java-5.1.15-bin.jar" dans /var/lib/funambol/Funambol/ds-server/install.properties
• connexion avec SOGo : lire le pdf de chez sogo

  • funambol-sogo (http://www.sogo.nu/downloads/backend.html)

  • json.simple

  • NB : pour installer les modules et initialiser la BD pour la première fois, il faut lancer bin/install et non bin/install-modules tel que dit dans la doc ; sinon on tombe sur l'erreur :

    •       [sql] Failed to execute:    create table fnbl_email_cache ( guid       varchar(200) binary not null, source_uri varchar(128) binary not null, principal  bigint       not null, last_crc   bigint, invalid    char, internal   char, messageid  varchar(700) binary, headerdate varchar(20)  binary, received   varchar(20)  binary, subject    varchar(700) binary, sender     varchar(300) binary, isemail    char, constraint pk_cache primary key (guid, source_uri, principal), constraint fk_principal_email_cache foreign key (principal) references fnbl_principal (id) on delete cascade )ENGINE = InnoDB CHARACTER SET utf8
      
      BUILD FAILED
      /var/lib/funambol/Funambol/ds-server/install/install.xml:238: The following error occurred while executing this line:
      /var/lib/funambol/Funambol/ds-server/install/install-modules.xml:120: The following error occurred while executing this line:
      /var/lib/funambol/Funambol/ds-server/install/install-modules.xml:168: The following error occurred while executing this line:
      /var/lib/funambol/Funambol/ds-server/install/install-modules.xml:240: The following error occurred while executing this line:
      /var/lib/funambol/Funambol/ds-server/install/install-modules.xml:285: The following error occurred while executing this line:
      /var/lib/funambol/Funambol/ds-server/install/install-modules.xml:369: java.sql.SQLException: Ne peut créer la table 'funambol.fnbl_email_cache' (Errcode: 150)

  • selon la doc "configure the data sources for SOGo. To do so, start the Funambol Administration Tool

using the following command : /opt/Funambol/admin/bin/funamboladmin "

• Mais c'est un truc graphique ! je fais comment là ???? ... à suivre ...

Procédure transmise par Francis, de chez Inverse

• -= Funambol =-
  
  mysql -pxxxxxxxxxxxxxx
  > > create database funambol;
  > > use funambol;
  > > grant all privileges on funambol.* to 'funambol'@'localhost' identified by 'xxxxxxxxxxxxxxxx';
  > > \q
  mkdir /tmp/funambol
  cd /tmp/funambol
  
  wget http://download.forge.objectweb.org/sync4j/funambol-8.7.0.bin
  wget http://json-simple.googlecode.com/files/json_simple.jar
  wget http://www.sogo.nu/uploads/Funambol/funambol-sogo-1.0.8.s4j
  wget http://mysql.mirror.iweb.ca/Downloads/Connector-J/mysql-connector-java-5.1.15.tar.gz
  wget http://mirror.olnevhost.net/pub/apache//commons/configuration/binaries/commons-configuration-1.6.tar.gz
  wget http://apache.imghat.com//commons/lang/binaries/commons-lang-2.6-bin.tar.gz
  wget http://www.ecoficial.com/apachemirror//commons/logging/binaries/commons-logging-1.1.1-bin.tar.gz
  wget http://www.trieuvan.com/apache//commons/collections/binaries/commons-collections-3.2.1-bin.tar.gz
  
  (extraire les .jar)
  
  sh funambol-8.7.0.bin
  ...
  /opt/Funambol/bin/funambol stop
  
  cp *.jar /opt/Funambol/tools/tomcat/lib/
  cp funambol-sogo-1.0.8.s4j /opt/Funambol/ds-server/modules/
  
  (modifier /opt/Funambol/ds-server/install.properties)
  
  groupadd funambol
  useradd -g funambol -d /opt/Funambol funambol
  chmod 770 /opt/Funambol/
  
  cd /opt/Funambol/
  yes | ./bin/install
  
  chown -R funambol:funambol /opt/Funambol/
  
  mysql -h localhost -u funambol funambol -p
  > > INSERT INTO fnbl_sync_source (uri, config, name, sourcetype) VALUES
  ('sogo-cal', 'sogo/sogo/sogo/sogo-cal.xml', 'sogo-cal', 'sogo'),
  ('sogo-card', 'sogo/sogo/sogo/sogo-card.xml', 'sogo-card', 'sogo'),
  ('sogo-todo', 'sogo/sogo/sogo/sogo-todo.xml', 'sogo-todo', 'sogo');
  > > \q
  export CLASSPATH=$CLASSPATH:/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.15-bin.jar
  /opt/Funambol/bin/admin-passwd
  (sa => xxxxxxxxxx)
  
  /opt/Funambol/bin/funambol start
  ln -s /opt/Funambol/bin/funambol /etc/init.d/funambol
  ln -s /etc/init.d/funambol /etc/rc2.d/S20funambol
  
  patch -p0 <<EOF
  --- /opt/Funambol/bin/funambol.orig     2010-11-16 21:24:36.599675745 +0000
  +++ /opt/Funambol/bin/funambol  2010-11-16 21:24:45.630909962 +0000
  @@ -1,7 +1,6 @@
   #!/bin/sh
   
  -cd \`dirname \$0\`
  -FUNAMBOL_HOME=\`(cd .. ; pwd)\`
  +FUNAMBOL_HOME=/opt/Funambol
   DS_SERVER_HOME=\$FUNAMBOL_HOME/ds-server
   
   if [ ! -d \$FUNAMBOL_HOME/config ]; then
  EOF
  
  modifier /etc/apache2/conf.d/SOGo.conf en ajoutant
  ******
  # Pour funambol
  ProxyPass /funambol http://127.0.0.1:8080/funambol retry=1
  ProxyPassReverse /funambol http://127.0.0.1:8080/funambol
  <Proxy http://127.0.0.1:8080/funambol>
      Order allow,deny
    Allow from all
  </Proxy>
  ******
  
  -= SOGo =-
  
  mysql -pxxxxxxxxxxx
  > > create database sogo;
  > > grant all privileges on sogo.* to 'sogo'@'localhost' identified by 'xxxxxxxxxx';
  > > grant all privileges on sogo.* to 'sogo'@'sogo.xx.auf.org'  identified by 'xxxxxxxxxxxxxxx';
  > > grant all privileges on sogo.* to 'sogo'@'sogo.ca.auf.org'  identified by 'xxxxxxxxxxxxxxx';
  > > \q
  defaults -u sogo write sogod SOGoMailDomain xx.auf.org
  defaults -u sogo write sogod SOGoMailingMechanism smtp
  defaults -u sogo write sogod SOGoSMTPServer smtp.xx.auf.org
  defaults -u sogo write sogod SOGoLanguage French
  defaults -u sogo write sogod SOGoTimeZone America/Montreal
  defaults -u sogo write sogod SOGoEnableEMailAlarms YES
  defaults -u sogo write sogod OCSSessionsFolderURL mysql://sogo:xxxxxxxx@sogo.xx.auf.org:3306/sogo/sogo_sessions_folder
  defaults -u sogo write sogod OCSFolderInfoURL mysql://sogo:xxxxxxxxx@sogo.xx.auf.org:3306/sogo/sogo_folder_info
  defaults -u sogo write sogod SOGoProfileURL mysql://sogo:xxxxxxx@sogo.xx.auf.org:3306/sogo/sogo_user_profile
  defaults -u sogo write sogod OCSEMailAlarmsFolderURL mysql://sogo:xxxxxxxx@sogo.xx.auf.org:3306/sogo/sogo_alarms_folder
  defaults -u sogo write sogod SOGoIMAPServer imap.xx.auf.org
  defaults -u sogo write sogod SOGoUserSources '(
      {   
          canAuthenticate = YES;
          displayName = AUF;
          id = users;
          isAddressBook = YES;
          type = sql;
          userPasswordAlgorithm = md5;
          viewURL = "mysql://sogo:xxxxxx@sogo.xx.auf.org:3306/sogo/auf_users";
          IMAPLoginFieldName = mail_pays;
          authenticationFilter = "(mail_pays like '\''%@xx.auf.org'\'')";
      }
  )'

Installation du client funambol sur un BlackBerry

1. télécharger le client (funambol_sync_plugin pour BB) ici : https://www.forge.funambol.org/download/#phone

2. décompresser l'archive et convertir le fichier .jad en .alx (utiliser par exemple l'outil GivemeYourJad sous M$ Windows)

3. utiliser le BB Desktop Manager (sous M$ Windows) pour installer l'application :
   1. choisir l'option "chargeur d'applications"
   2. ensuite "ajouter-supprimer des applications"
   3. faire "parcourir" pour retrouver le fichier .alx précédemment créé
   4. enfin "suivant", "suivant" ... "terminer"
4. sur le BB, après l'installation, l'application n'apparait pas dans la liste des appli dispo. L'astuce que j'ai découverte :
   1. ouvrir une application quelconque
   2. taper la touche "menu" et choisir "changer d'application", et là on a notre funambol BB sync

5. la suite : (extrait de la documentation SOGo : http://www.sogo.nu/files/docs/SOGo%20Mobile%20Devices%20Configuration.pdf)

   •  From the Tools menu, choose Options...:
     ❏ Specify the Location. If your SOGo server is sogo.domain.com, the location should be
     http://sogo.domain.com/funambol/ds
     ❏ Specify your username and password
     ❏ Check the Contacts check box and click on the Details button. The synchronization type is two-
     way and the Remote name is 'sogo-card'. The data format is vCard.
     ❏ Check the Calendar check box and click on the Details button. The synchronization type is two-
     way and the Remote name is 'sogo-cal'. The data format is vCalendar.
     ❏ Check the Tasks check box and click on the Details button. The synchronization type is two-way
     and the Remote name is 'sogo-todo'. The data format is SIF.
     ❏ Save the preferences.

6. il ne reste plus qu'à accéder aux menus calendrier et carnet d'adresses.