|
Taille: 10223
Commentaire:
|
Taille: 4828
Commentaire: sogo vers bd funambol
|
| Texte supprimé. | Texte ajouté. |
| Ligne 1: | Ligne 1: |
| ## page was renamed from Projet/SOGo/ProcédureInstallationSOGo ## page was copied from Projet/SOGo/InstallationParis ## page was copied from Projet/SOGo/InstallationFunambol ## page was renamed from ZA/Montréal/SOGoVersion1.3/InstallationFunambol |
|
| Ligne 7: | Ligne 3: |
| = 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 == |
== Procédure d'installation du serveur Funambol == Source : Francis @Inverse.ca |
| Ligne 59: | Ligne 7: |
| -= Funambol =- | |
| Ligne 108: | Ligne 55: |
(NDLR : paramétrer databaseUsername et databasePassword dans les fichiers /opt/Funambol/config/sogo/sogo/sogo/sogo-*.xml) |
|
| Ligne 126: | Ligne 76: |
| -- config apache : ajoutée par NM -- |
|
| Ligne 136: | Ligne 88: |
-= 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'\'')"; } )' |
Sommaire
Procédure d'installation du serveur Funambol
Source : Francis @Inverse.ca
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) (NDLR : paramétrer databaseUsername et databasePassword dans les fichiers /opt/Funambol/config/sogo/sogo/sogo/sogo-*.xml) /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 -- config apache : ajoutée par NM -- 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 du client funambol sur un BlackBerry
télécharger le client (funambol_sync_plugin pour BB) ici : https://www.forge.funambol.org/download/#phone
décompresser l'archive et convertir le fichier .jad en .alx (utiliser par exemple l'outil GivemeYourJad sous M$ Windows)
- utiliser le BB Desktop Manager (sous M$ Windows) pour installer l'application :
- choisir l'option "chargeur d'applications"
- ensuite "ajouter-supprimer des applications"
- faire "parcourir" pour retrouver le fichier .alx précédemment créé
- enfin "suivant", "suivant" ... "terminer"
- 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 :
- ouvrir une application quelconque
- taper la touche "menu" et choisir "changer d'application", et là on a notre funambol BB sync
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.
- il ne reste plus qu'à accéder aux menus calendrier et carnet d'adresses.