Grouper Developers Forum

["Peter St. Onge" <>]

Hello Andres,

I usually forget to add the line in pg_hba.conf to allow IP connections
via localhost since the application does not use domain sockets for
access and the default PostgreSQL configs in my distro don't make it
available at install time -- the second line might be helpful for you
(place it after the local socket line as below)

# TYPE  DATABASE        USER            ADDRESS                 METHOD

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


Best, -- pete



On 2017-01-11 11:46 AM, 

 wrote:
> Hey everyone, I am from Ecuador and at the university we are implementing
> grouper, so when I run the grouperInstaler.jar, I want it to use a 
> postgresql
> database that is already created and empty, and I get this error from the
> installer:
> 
> Enter the database URL [jdbc:postgresql://localhost:5432/grouperdb]:
> Database user [grouperdb]:
> Database password (note, you aren't setting the pass here, you are using an
> existing pass, this will be echoed back) [XXXXXXXXX]:
> Editing
> /programas/grouper/grouper.installer-2.3.0/grouper.apiBinary-2.3.0/conf/groupe
> r.hibernate.properties:
>  - property hibernate.connection.url already was set to:
> jdbc:postgresql://localhost:5432/grouperdb, not changing file
>  - property hibernate.connection.username already was set to: grouperdb, not
> changing file
>  - property hibernate.connection.password already was set to: XXXXXXXXX, not
> changing file
> Checking database with query: select 1
> Exception in thread "main" java.lang.IllegalAccessError: tried to access 
> class
> org.postgresql.Driver$1 from class org.postgresql.Driver
>         at org.postgresql.Driver.getDefaultProperties(Driver.java:86)
>         at org.postgresql.Driver.connect(Driver.java:237)
>         at
> edu.internet2.middleware.grouperInstaller.driverShim.DatabaseShimBase.connect(
> DatabaseShimBase.java:65)
>         at java.sql.DriverManager.getConnection(DriverManager.java:664)
>         at java.sql.DriverManager.getConnection(DriverManager.java:247)
>         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(GiDbU
> tils.java:567)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnec
> tion(GrouperInstaller.java:9957)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(Gr
> ouperInstaller.java:8177)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$400(GrouperI
> nstaller.java:82)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMai
> nFunction$2.logic(GrouperInstaller.java:1307)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperIn
> staller.java:1530)
>         at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstall
> er.java:549)
> 
> 
> 
> I have java jdk1.8.0_111 installed.
> 
> 
> Thanks
> 
> Andres de los Reyes
> 


-- 
Peter St. Onge                           

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