On 05/06/2011 09:28 AM, [email protected] wrote: > Ispend all the day to try to configure funambol connector on my centos 5.5 x64 > server , Funambol ver 9.0 and sogo conector 1.0.8 > I use LDAP to authenticate user for Sogod and Mysql for database sogo > First Is that such information is still valid? > > https://wikit.firewall-services.com/doku.php?id=connecteur_funambol_sogo > > http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,33/func,view/id,24885/#24885 > > with Funambol admin tools I can see the users > I replace dbms=hypersonic with dbms=mysql and reconfigure MySQL settings with: > jdbc.classpath=/opt/Funambol/tools/jre-1.6.0/jre/lib/ext/mysql-connector-java-5.1.15-bin.jar > jdbc.driver=com.mysql.jdbc.Driver > jdbc.url=jdbc:mysql://localhost/funambol?characterEncoding=UTF-8 > jdbc.user=funambol > jdbc.password=funambolpwd > > but I can't see the user I always see only 2 users , I remove them , restart > Funambol admin tools and these 2 users come back .... > I need to delete them in phpmyadmin for a right erase...
Greg, I can probably not solve your exact problem, but maybe I can provide more details. First, I am using - CentOS 5.4 (32 bit) - OpenJDK 1.6.0.0-1.7.b09.el5 (from repo) - MySQL 5.0.77 - mysql-connector-java 5.1.12 - Funambol 8.0.2 - (Funambol) ldap-connector 7.0.0 (compiled from source, authentication only, no syncsource) - funambol-sogo-connector 1.0.8 - SOGo 1.3.6 I can confirm that it works with MySQL. Also, I briefly read over the installation links you gave and they look very similar to our set up process (except that we had to change the Java version from the one provided by this Funambol bundle - 1.5.0 - to the one from CentOS - 1.6.0 -). The two users your are seeing in table fnbl_user, are they "admin" and "guest"? If yes then it is my understanding that they are default accounts created automatically by Funambol. When saying "I use LDAP to authenticate user for Sogod" you refer to the GNUstep .Defaults file,correct? It looks to me as if your setup missed the UserProvisioning (=creating Funambol user accounts) step in Funambol?! This could be done automatically (every user who knows the URL can use the Funambol server's services) which is not what we wanted. Therefore we rely on the ldap-connector for Funambol by Roberto Polli so that an account in fnbl_user is created only if the submitted credentials can be verified against our LDAP directory. Regards, Wolf -- [email protected] https://inverse.ca/sogo/lists
