Grouper Users - Open Discussion List

["Peter St. Onge" <>]

Just as a check, in the pg_hba.conf file, have you a line that allows
password-based authentication via 127.0.0.1 by chance? If I recall
correctly, I had to allow this explicitly:

host all all 127.0.0.1/32 md5

and this should come before the line ending in 'ident'

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             127.0.0.1/32            ident

Hope this helps.

Best, -- pete


On 2016-01-29 10:00 AM, Celine Dusset wrote:
> 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:*
> [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/*
> 
>  
> 
>  
> 


-- 
Peter St. Onge                           

Information Security Architect                     (416)978-5030
Business Continuity and Communications
Information + Technology Services          University of Toronto