Modifications entre les versions 2 et 3
⇤ ← Version 2 à la date du 2011-05-04 16:15:32 →
Taille: 7802
Éditeur: MoussaNombre
Commentaire: procédure install funambol et sogo from Francis
← Version 3 à la date du 2011-05-06 22:16:24 → ⇥
Taille: 8054
Éditeur: MoussaNombre
Commentaire:
Texte supprimé. Texte ajouté.
Ligne 120: Ligne 120:
(modifier /etc/apache2/conf.d/SOGo.conf) 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>
******

Installation de Funambol pour SOGo

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

Documentations

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 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'\'')";
    }
)'

Projet/SOGo/InstallationFunambolParis (dernière édition le 2011-05-13 15:21:13 par MoussaNombre)