Grouper Users - Open Discussion List

[Malathi Deenadayalan <>]

Hi,

I am also getting

===> docker exec -it -u tomcat grouper-ui bash

gives me following error and I am not getting gsh shell

grouper.hibernate.properties: /opt/grouper/grouperWebapp/WEB-INF/classes/grouper.hibernate.properties
grouper.hibernate.properties: :3306/grouper_v2_5?useSSL=false

Cannot determine the driver class from database URL: 172.17.0.4:3306/grouper_v2_5?useSSL=false
Grouper error: Error finding database driver class from grouper.hibernate.properties: null, perhaps you did not put the database driver jar in the /opt/grouper/grouperWebapp/WEB-INF/lib dir or lib dir, or you have the wrong driver listed: java.lang.RuntimeException: Problem loading class: null

please help me.

Regards,

Malathi

---

From: "Grouper Users" <>
To: "Chad Redman" <>
Cc: "Grouper Users" <>, "malathideenadayalan" <>
Sent: Tuesday, April 6, 2021 11:16:10 AM
Subject: Re: [grouper-users] Please do the needful, this was my third mail did not get any reply for my problem

Hi,

for your second query I have got

2) docker logs b2802e97b8bc | grep 'OpenEJB.startup- Deployed Application'
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-18 09:43:30,109 [localhost-startStop-1] INFO  OpenEJB.startup- Deployed Application(path=/opt/grouper/grouperWebapp)
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-18 09:44:34,443 [localhost-startStop-1] INFO  OpenEJB.startup- Deployed Application(path=/opt/tomee/webapps/ROOT)

for your third query I have got error

3)[root@grouper ~]# docker logs 66d45531152c | grep 'tomee;catalina.out' | grep -v 'INFO'

tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,882 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.LogTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,883 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.RequestTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,884 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.IsSecureTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,885 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.IsSessionFromCookieTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,886 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.IsSessionFromURLTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,888 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.IsSessionValidTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,889 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.IsUserInRoleTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,890 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.AttributeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,891 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.AttributesTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,891 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.EqualsAttributeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,892 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ExistsAttributeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,893 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.RemoveAttributeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,895 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.SetAttributeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,896 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.CookieTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,897 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.CookiesTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,898 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.EqualsCookieTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,899 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ExistsCookieTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,900 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.HeaderTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,902 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.HeadersTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,902 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.EqualsHeaderTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,903 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ExistsHeaderTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,904 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.HeaderValuesTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,906 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ParameterTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,907 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ParametersTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,908 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.EqualsParameterTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,909 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ExistsParameterTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,910 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ParameterValuesTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,912 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.QueryStringTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,913 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.QueryStringsTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,914 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.ExistsQueryStringTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,939 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.CurrentTimeTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,940 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.FormatTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,940 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.ParseTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,941 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.TimeZoneTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,949 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.TimeZonesTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,950 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.MonthsTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,951 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.WeekdaysTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,952 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.AmPmsTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,955 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.datetime.ErasTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:42,962 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: edu.internet2.middleware.grouper.ui.ELTileRecorderTag
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:58,685 [Thread-11] WARN  org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator- HHH000342: Could not obtain connection to query metadata : Connections could not be acquired from the underlying database!
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:59,659 [Thread-11] WARN  org.hibernate.id.UUIDHexGenerator- HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:59,731 [Thread-11] WARN  org.hibernate.mapping.RootClass- HHH000038: Composite-id class does not override equals(): edu.internet2.middleware.grouper.service.ServiceRoleView
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:17:59,731 [Thread-11] WARN  org.hibernate.mapping.RootClass- HHH000039: Composite-id class does not override hashCode(): edu.internet2.middleware.grouper.service.ServiceRoleView
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:01,240 [Thread-11] WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory- HHH020003: Could not find a specific ehcache configuration for cache named [edu.internet2.middleware.grouper.file.GrouperFile]; using defaults.
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:01,568 [Thread-11] WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory- HHH020003: Could not find a specific ehcache configuration for cache named [edu.internet2.middleware.grouper.pit.PITGrouperConfigHibernate]; using defaults.
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:12,197 [Thread-11] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper- SQL Error: 0, SQLState: null
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:12,197 [Thread-11] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- Connections could not be acquired from the underlying database!
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:25,334 [Thread-11] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper- SQL Error: 0, SQLState: null
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:25,335 [Thread-11] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- Connections could not be acquired from the underlying database!
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:35,354 [Thread-11] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper- SQL Error: 0, SQLState: null
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:35,354 [Thread-11] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- Connections could not be acquired from the underlying database!
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:45,381 [Thread-11] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper- SQL Error: 0, SQLState: null
tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-03-22 11:18:45,381 [Thread-11] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- Connections could not be acquired from the underlying database!

Why I am getting this error ..

Regards,
Malathi

---

From: "Redman, Chad" <>
To: "Grouper Users" <>, "malathideenadayalan" <>
Sent: Monday, April 5, 2021 8:05:18 PM
Subject: Re: [grouper-users] Please do the needful, this was my third mail did not get any reply for my problem

The error is likely that the application failed to start, so it wasn't deployed at /grouper.

You can look at your TomEE logs for errors that would cause it to start.

1) Get the container name or id

docker ps

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                                     NAMES

436aa6f73f2d        f7b9af231f5e        "/usr/local/bin/entr…"   7 minutes ago       Up 7 minutes        80/tcp, 443/tcp, 0.0.0.0:8080->8080/tcp   stoic_wilson

2) Get the TomEE logs for it, see what contexts are deployed

docker logs 436aa6f73f2d | grep 'OpenEJB.startup- Deployed Application'

tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-04-05 14:22:13,240 [localhost-startStop-1] INFO  OpenEJB.startup- Deployed Application(path=/opt/grouper/grouperWebapp)

tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-04-05 14:22:44,474 [localhost-startStop-1] INFO  OpenEJB.startup- Deployed Application(path=/opt/tomee/webapps/ROOT)

3) Get the TomEE logs for it, and filter out INFO

docker logs 436aa6f73f2d | grep 'tomee;catalina.out' | grep -v 'INFO'

tomee;catalina.out;${env:ENV};${env:USERTOKEN};2021-04-05 14:22:12,255 [localhost-startStop-1] ERROR OpenEJB.startup- Unable to load tag library tag class: org.apache.taglibs.request.LogTag

... (you can ignore the tag library errors)

There should be some warnings after this, but any ERROR level message should be looked at.

-Chad

---

From: <> on behalf of Malathi Deenadayalan <>
Sent: Monday, April 5, 2021 4:30 AM
To: Vivek Sachdeva <>; <>
Subject: Re: [grouper-users] Please do the needful, this was my third mail did not get any reply for my problem

 

Hi Vivek,

I have got 404 not found error. Attached screenshot.

Please any help will be appreciated.

On Sat, Apr 3, 2021 at 8:41 AM Vivek Sachdeva <> wrote:

Hi Malathi,

Try going to https://172.17.0.3/grouper/ and please let me know what you see.

Vivek

On Thu, Apr 1, 2021 at 2:04 AM Malathi Deenadayalan <> wrote:

Hi,

I am not able to get grouper ui on browser , getting 404 not found error.

Here I have detailed my errors for your consideration.

1)   curl  --insecure 'https://172.17.0.3'

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>302 Found</title>
</head><body>
<h1>Found</h1>
<p>The document has moved <a href=""https://172.17.0.3/grouper/">here</a>.</p>
</body></html>
[root@grouper ~]#

2)docker logs of grouper ui

httpd;access_log;-;-;10.10.30.254 - - [28/Mar/2021:13:21:41 +0000] "GET / HTTP/1.1" 302 214 "-" "Mozilla/5.0 zgrab/0.x"
httpd;access_log;-;-;10.10.30.254 - - [28/Mar/2021:15:42:36 +0000] "SSTP_DUPLEX_POST /sra_{BA195980-CD49-458b-9E23-C84EE0ADCD75}/ HTTP/1.1" 400 226 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:01:36:34 +0000] "GET / HTTP/1.1" 302 214 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:02:47:39 +0000] "GET /login HTTP/1.1" 404 203 "-" "Mozilla/5.0 zgrab/0.x"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:09:18:45 +0000] "GET / HTTP/1.1" 302 214 "-" "Mozilla/5.0 zgrab/0.x"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:09:24:27 +0000] "GET / HTTP/1.1" 302 214 "-" "Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:09:24:27 +0000] "GET /grouper/ HTTP/1.1" 404 779 "https://103.117.200.9/" "Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:16:06:23 +0000] "GET / HTTP/1.1" 302 214 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:16:06:23 +0000] "GET /grouper/ HTTP/1.1" 404 779 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:16:06:24 +0000] "GET / HTTP/1.1" 302 214 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:16:06:25 +0000] "GET /grouper/ HTTP/1.1" 404 779 "-" "-"
httpd;access_log;-;-;10.10.30.254 - - [29/Mar/2021:23:26:31 +0000] "GET /remote/login HTTP/1.1" 404 210 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36"
httpd;access_log;-;-;10.10.30.254 - - [30/Mar/2021:03:20:51 +0000] "GET /owa/auth/logon.aspx?url="https%3a%2f%2f1%2fecp%2f" HTTP/1.1" 404 217 "-" "Mozilla/5.0 zgrab/0.x"
httpd;access_log;-;-;172.17.0.1 - - [30/Mar/2021:08:31:30 +0000] "GET /grouper HTTP/1.1" 404 774 "-" "curl/7.29.0"
httpd;access_log;-;-;172.17.0.1 - - [30/Mar/2021:08:34:30 +0000] "GET / HTTP/1.1" 302 211 "-" "curl/7.29.0"

3) getting grouper shell without any error

[root@grouper ~]# docker exec -it -u tomcat grouper-ui bash
[tomcat@b2802e97b8bc WEB-INF]$ cd bin
[tomcat@b2802e97b8bc bin]$ ./gsh.sh
Detected Grouper directory structure 'webapp' (valid is api, apiMvn, webapp)
Using GROUPER_HOME:           /opt/grouper/grouperWebapp/WEB-INF
Using GROUPER_CONF:           /opt/grouper/grouperWebapp/WEB-INF/classes
Using JAVA:                   /usr/lib/jvm/java-1.8.0-amazon-corretto/bin/java
Using CLASSPATH:              /opt/grouper/grouperWebapp/WEB-INF/classes:/opt/grouper/grouperWebapp/WEB-INF/lib/*
using MEMORY:                 64m-750m
Grouper starting up: version: 2.5.43, build date: 2021/02/24 07:47:06 +0000, env: <no label configured>
grouper.properties read from: /opt/grouper/grouperWebapp/WEB-INF/classes/grouper.properties
Grouper current directory is: /opt/grouper/grouperWebapp/WEB-INF/bin
log4j.properties read from:   /opt/grouper/grouperWebapp/WEB-INF/classes/log4j.properties
Grouper is logging to file:   /tmp/logpipe, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
grouper.hibernate.properties: /opt/grouper/grouperWebapp/WEB-INF/classes/grouper.hibernate.properties
grouper.hibernate.properties: grouper_v2_5@jdbc:mysql://172.17.0.2:3306/grouper_v2_5?useSSL=false

subject.properties read from: /opt/grouper/grouperWebapp/WEB-INF/classes/subject.properties
sources configured in:        subject.properties
subject.properties internalsource id:g:isa
subject.properties groupersource id: g:gsa
subject.properties groupersource id: grouperEntities
subject.properties jdbc2 source id:   grouperExternal: GrouperJdbcConnectionProvider
subject.properties jdbc source id:   jdbc: GrouperJdbcConnectionProvider
Type help() for instructions
Groovy Shell (2.5.0-beta-2, JVM: 1.8.0_282)
Type ':help' or ':h' for help.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
groovy:000> :load '/opt/grouper/grouperWebapp/WEB-INF/classes/groovysh.profile'
groovy:000>


4) getting null value for adding user and password

groovy:000> new GrouperPasswordSave().assignApplication(GrouperPassword.Application.UI).assignUsername("GrouperSystem").assignPassword("pass").save();
===> null
groovy:000>

5) Please help me to solve this issue.

Regards,
Malathi