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 ...

• Et voici la 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)
    
    -= 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'\'')";
        }
    )'