grouper-users - [grouper-users] RE: New to Grouper 2.2.2

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: New to Grouper 2.2.2

From: "Hyzer, Chris" <>
To: Celine Dusset <>, "" <>
Subject: [grouper-users] RE: New to Grouper 2.2.2
Date: Wed, 10 Feb 2016 16:25:10 +0000
Accept-language: en-US
Authentication-results: unice.fr; dkim=none (message not signed) header.d=none;unice.fr; dmarc=none action=none header.from=isc.upenn.edu;
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:23

Celine, was this resolved? Thanks, Chris

From: Celine Dusset [mailto:]
Sent: Friday, January 29, 2016 10:01 AM
To: Hyzer, Chris <>;
Subject: RE: New to Grouper 2.2.2

Yes we have the database with user/pwd and we can create tables in it (phpPgAdmin).

     Liste des bases de données

    Nom    | Propriétaire | Encodage | Collationnement | Type caract. |    Droits d'accès

-----------+--------------+----------+-----------------+--------------+-----------------------

 grouper   | grouper      | UTF8     | fr_FR.UTF-8     | fr_FR.UTF-8  | =Tc/grouper          +

           |              |          |                 |              | grouper=CTc/grouper

 postgres  | postgres     | UTF8     | fr_FR.UTF-8     | fr_FR.UTF-8  |

 template0 | postgres     | UTF8     | fr_FR.UTF-8     | fr_FR.UTF-8  | =c/postgres          +

           |              |          |                 |              | postgres=CTc/postgres

 template1 | postgres     | UTF8     | fr_FR.UTF-8     | fr_FR.UTF-8  | =c/postgres          +

           |              |          |                 |              | postgres=CTc/postgres

(4 lignes)

Thanks

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

Céline Dusset

Université de Nice Sophia-Antipolis

DSI - Service Transverse

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

Tel. 1.6731/04.92.07.67.31

De : Hyzer, Chris <>
Envoyé : vendredi 29 janvier 2016 14:40
À : Celine Dusset;
Objet : RE: New to Grouper 2.2.2

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: [] 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.