Forums

Resolved
0 votes
Hello all,
i started my project to synchronize openldap using a csv file. There's a great software to do that : https://www.lsc-project.org. This project works with a database. It fist import the csv file into the databse and than synchronize OpenLdap with the database.
To have a better view of the process (using phpmyadmin), I decided to work with MariaDB instead of hsqldb wich is installed with the lsc-project.
The only thing to work with MariadB is that I need to install the java connector for MariaDB. I found it here (https://downloads.mariadb.org/connector-java/) but .. because of my poor english, I'm not sure of the best way to install it.

It seems I just have to download the jfar file and extract it there ...
To make the connector available to all server profiles;
Extract the mysql-connector-java-<version>.jar file to <JBOSS_HOME>/server/common/lib.

To make the connector available to selected profiles only;


An then create, after having created a new database on MariaDB, create the a config file in the same way that this one (made for mysql) :
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jboss</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>jboss</user-name>
<password>password</password>
<metadatda>
<type-mapping>mySQL</type-mapping>
</metadata>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</local-tx-datasource>
</datasources>



So, can someone telle me if my understanding was correct ?
Per advance, I thank you for your help and wish you a very nice week-end :)
Friday, October 04 2019, 08:42 PM
Share this post:
Responses (2)
  • Accepted Answer

    Saturday, October 05 2019, 08:50 AM - #Permalink
    Resolved
    0 votes
    I don't know if it is of any help but there is a rh-mariadb103-mariadb-java-client.noarch 2.4.1-2.el7 package in the various clearos sclo repos.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, October 07 2019, 08:26 PM - #Permalink
    Resolved
    0 votes
    Hello Nick,
    Great, I'm going to try that.
    Thanks for your help
    Best Regards
    :)
    The reply is currently minimized Show
Your Reply