installer with mysql does not work

From: grouper-users-request grouper-users-request On Behalf Of Kevin M. Hildebrand
Sent: Thursday, April 13, 2017 7:53 AM
To: John Gasper
Cc: grouper-users
Subject: Re: [grouper-users] Fwd: Problem with grouperInstaller and mysql?

It looks like the problem is with the MySQL connector that's provided with Grouper. I discovered yesterday that if I install the RedHat version of the connector and replace the one provided with Grouper, the problem goes away.

yum install mysql-connector-java
cd /opt/grouper/grouper.apiBinary-2.3.0/lib/jdbcSamples/
rm mysql-connector-java.jar
ln -s /usr/share/java/mysql-connector-java.jar
Kevin

On Wed, Apr 12, 2017 at 6:44 PM, John Gasper <jgasper@unicon.net> wrote:
I’m working with a client that is having the same issue.

–
John Gasper
IAM Consultant
Unicon, Inc.
PGP/GPG Key: 0xbafee3ef

From: <grouper-users-request> on behalf of "Kevin M. Hildebrand"
Date: Wednesday, April 12, 2017 at 9:32 AM
To: <grouper-users>
Subject: [grouper-users] Fwd: Problem with grouperInstaller and mysql?

Hi, I'm testing out an installation of Grouper and I'm not getting very far. When running grouperInstaller, I'm getting an error (see below) right after specifying the database connection information.
This is on a RedHat 7 machine, with OpenJDK Java 1.7.0. (I've also tested it with Oracle Java, with the same result.)
I have verified that the MySQL database exists, and is accessible by the specified user.
Any thoughts on what I'm doing wrong?
Thanks,
Kevin

–
Kevin Hildebrand
University of Maryland, College Park

Enter the database URL [jdbc:mysql://localhost:3306/grouper?CharSet=utf8&useUnicode=true&characterEncoding=utf8]:
Database user [grouper]:
Database password (note, you aren't setting the pass here, you are using an existing pass, this will be echoed back) [XXXXXXXXXXXXX]:
Editing /opt/grouper/grouper.apiBinary-2.3.0/conf/grouper.hibernate.properties:

• property hibernate.connection.url already was set to: jdbc:mysql://localhost:3306/grouper?CharSet=utf8&useUnicode=true&characterEncoding=utf8, not changing file
• property hibernate.connection.username already was set to: grouper, not changing file
• property hibernate.connection.password already was set to: XXXXXXXXXXXXX, not changing file
  Checking database with query: select 1
  Exception in thread "main" java.lang.IllegalAccessError: tried to access method com.mysql.jdbc.ConnectionImpl.getInstance(Ljava/lang/String;ILjava/util/Properties;Ljava/lang/String;Ljava/lang/String;)Lcom/mysql/jdbc/Connection; from class com.mysql.jdbc.NonRegisteringDriver
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
  at edu.internet2.middleware.grouperInstaller.driverShim.DatabaseShimBase.connect(DatabaseShimBase.java:65)
  at java.sql.DriverManager.getConnection(DriverManager.java:571)
  at java.sql.DriverManager.getConnection(DriverManager.java:215)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:399)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:457)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:416)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.select(GiDbUtils.java:427)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.checkConnection(GiDbUtils.java:567)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnection(GrouperInstaller.java:9957)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:8177)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$400(GrouperInstaller.java:82)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$2.logic(GrouperInstaller.java:1307)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1530)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:549)