Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Did you create the database in postgres and a user/pass and set the permissions correctly?  J  Can you login to the database with a GUI tool and create/delete a table there?

 

Thanks,

chris

 

From: [mailto:] On Behalf Of Celine Dusset
Sent: Friday, January 29, 2016 6:58 AM
To:
Subject: [grouper-users] New to Grouper 2.2.2

 

Hello,

 

We're new to Grouper and we are trying to do a fresh install of version 2.2.2.

We're encountering un problem when we want to initialize the Groups Registry and install tables  (gsh), the database is not found.

Here is the message :

 

Couldnt startup grouper: Problems with db: DB: user: grouper, url: jdbc:postgresql://localhost:5432/grouper , driver: org.postgresql.Driver
java.lang.RuntimeException: Problems with db: DB: user: grouper, url: jdbc:postgresql://localhost:5432/grouper , driver: org.postgresql.Driver
        at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:57)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:424)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:328)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:251)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:151)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
Caused by: org.postgresql.util.PSQLException: FATAL: la base de donn��es �� grouper  �� n'existe pas
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:572)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:177)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:215)
        at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:54)
        ... 5 more

We are on CentOS Linux release 7.2.1511 (Core) and PostgreSQL 9.2.

We've put the jdbc Postgres driver for hibernate in lib/custom.

 

 

Thank you in advance for any help and assistance.

 

 

 

 

**************

Céline Dusset

Université de Nice Sophia-Antipolis

DSI  - Service Transverse

Pôle Référentiels, outils de pilotage et de fiabilisation