Hello Clement, Thanks for the advice. So I used the tool u suggested and it worked to import the csv file ☺ Need to dig a little bit to keep my database clean because csv file will be the master but .. I’m on a good way ☺ Still have to see now if I can synchronize my database with my ldap ;) Thanks very much for your help Kind Regards
Arnaud Forster De : lsc-users <[email protected]> De la part de Clément OUDOT Envoyé : vendredi, 11 octobre 2019 15:01 À : [email protected] Objet : Re: [lsc-users] Problem trying to use JAVA MariaDB connector Le 11/10/2019 à 14:43, Forster Arnaud, Gymnase francais a écrit : Hello all, I work for a school and I'm trying to user LSC to syncronize a csv file with my local OpenLDAP Server (ClearOS). My server already run a MariaDB server and I'd like to use it for my syncronization. I already have installed the mariadb java package. Everynight, I receive a csv file from a Microsoft Active Directory system. This file should contain the unique ID, full names, login and email addresses of users. So I'd like to first 'inject' the content of that file in a Database of my MariaDB server and then syncronize it with my OpenLDAP server (both Database and LDAP are running in the same server) I was able to configure the connections with the OpenLDAP and the MariaDB server :) [root@ad /]# /bin/lsc --validate oct. 11 14:03:31 - INFO - Logging configuration successfully loaded from /etc/lsc/logback.xml oct. 11 14:03:31 - INFO - LSC configuration successfully loaded from /etc/lsc/ oct. 11 14:03:31 - INFO - Configuration and environment successfully checked ! Now, I duplicated the /bin/hsqldb file and changed the HSQLDB_LIB with the following : # HSQLDB jar file # HSQLDB_LIB=$LIB_DIR/hsqldb*.jar # MariaDB jar file MARIADB_LIB=$LIB_DIR/mariadb*.jar (the mariadb.jar file is on my server; I tried with different ones) but now, when I try to import csv file, I get the following error : [root@ad /]# /bin/importMariaDB --import tutorial.csv aucun attribut manifest principal dans /usr/lib/lsc/mariadb-java-client2.jar [root@ad /]# /bin/importMariaDB --import tutorial.csv aucun attribut manifest principal dans /usr/lib/lsc/mariadb-java-client.jar As I can't edit the JAR file, if someone has an idea on what I could do... Hello, the LSC script was done for HSQLDB, I think you should better use a standard way to import CSV into MariaDB, see for example: https://www.simplified.guide/mysql-mariadb/import-csv -- Clément Oudot | Identity Solutions Manager [email protected]<mailto:[email protected]> Worteks | https://www.worteks.com
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users
