Grouper Users - Open Discussion List

["Gettes, Michael" <>]

Hi Les,

We are on MariaDB 10.4.12 image from docker hub.

The driver config we have:

hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class = com.mysql.cj.jdbc.Driver

And the driver itself we use is mysql-connector-java-8.0.16.jar obtained from https://dev.mysql.com/downloads/connector/j/ (platform independent)

I see 8.0.19 is there and I am going to switch to using that version very soon (maybe today).

To install into the container - my Docker file building a grouper container does this:

RUN rm -f /opt/grouper/grouperWebapp/WEB-INF/lib/mysql-connector-java*.jar

COPY mysql-connector-java*.jar /opt/grouper/grouperWebapp/WEB-INF/lib

If at all possible - run grouper 2.5

I hope this helps.

/mrg

I am attempting to install on Centos 7.  In Centos, I have most familiarity with MySQL/MariaDB, and no familiarity with Postgres or Oracle.  (I am actually much more familiar with MS SQL than MySQL, but I didn't see any references to that in the Grouper installation guides.)  Also, I know a lot of programming languages, but know virtually nothing about actually using Java.  Finally, we don't use AWS yet; all of our cloud adventures have been in GCP or Azure.

 

I installed MariaDB 10.4.12, and I don't think the Grouper container is talking to it.  With "manually" the grouper.log starts with a Communications link failure.  With "using installer", the docker_logs_init_db*.log file ends with "############## Running static SQL".  And in neither case are there any tables in the grouper database.

 

If I want to run the container without adding drivers to it, what MySQL/MariaDB should I install on my Centos 7 host?  If I want to use MariaDB 10.4.12, what driver should I install into the container, and how would I do that?  (Maybe if I knew more about Java I'd be able to answer these questions myself?)