Grouper Users - Open Discussion List

["Kevin M. Hildebrand" <>]

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 <> wrote:

I’m working with a client that is having the same issue.

 

-- 

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

 

 

From: <> on behalf of "Kevin M. Hildebrand" <>
Date: Wednesday, April 12, 2017 at 9:32 AM
To: <>
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)