Grouper Users - Open Discussion List

[Celine Dusset <>]

Hi Chris !

Sorry to have taken so long to answer !

Yes it is resolved... We've made an investisment in glasses ...

In fact, there was a blank space at the end of the db url in the hibernate properties...

We've detected it when we tried a mysql db. The error message was more readable.

We've learned one lesson: don't forget to OPEN OUR EYES !

Thank you all for the answers.

Céline

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

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é : mercredi 10 février 2016 17:25
À : Celine Dusset;
Objet : RE: New to Grouper 2.2.2

 

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.

 

 

 

 

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

Céline Dusset

Université de Nice Sophia-Antipolis

DSI  - Service Transverse

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