Grouper Users - Open Discussion List

[Dominique Petitpierre <>]

Hello,
in the process of upgrading Grouper to version 2.4.0 I encounter some 
problems. Here is another one:

When the Grouper UI webapp is running there are periodic warning messages 
every 4 minutes in the log grouper_error.log:

2019-09-12 23:41:36,034: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(104) -  - shouldnt set driver for 
GrouperJdbcConnectionProvider: null, oracle.jdbc.driver.OracleDriver
2019-09-12 23:41:36,034: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(120) -  - shouldnt set dbUrl for 
GrouperJdbcConnectionProvider: null, 
jdbc:oracle:thin:@dbtst.unige.ch:1521:dbtst
2019-09-12 23:41:36,034: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(124) -  - shouldnt set dbUser for 
GrouperJdbcConnectionProvider: null, grouper
2019-09-12 23:41:36,035: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(128) -  - shouldnt set dbPassword for 
GrouperJdbcConnectionProvider: null
2019-09-12 23:45:36,193: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(104) -  - shouldnt set driver for 
GrouperJdbcConnectionProvider: null, oracle.jdbc.driver.OracleDriver
2019-09-12 23:45:36,194: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(120) -  - shouldnt set dbUrl for 
GrouperJdbcConnectionProvider: null, 
jdbc:oracle:thin:@dbtst.unige.ch:1521:dbtst
2019-09-12 23:45:36,194: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(124) -  - shouldnt set dbUser for 
GrouperJdbcConnectionProvider: null, grouper
2019-09-12 23:45:36,194: [Thread-11] WARN  
GrouperJdbcConnectionProvider.init(128) -  - shouldnt set dbPassword for 
GrouperJdbcConnectionProvider: null

This is written by the "init" method of GrouperJdbcConnectionProvider.
The "null" value corresponds to the parameter sourceId.

- How can one "not set" those values?
  They are configured only once in grouper.hibernate.properties.

Presumably it is linked to the c3p0 pool of JDBC connections which empties 
(after hibernate.c3p0.timeout = 100 seconds)
and it occurs when a new connection needs to be established.


For my understanding:
- Why does Grouper UI  connect to the database every 4 minutes while 
otherwise idle?
From a tcpdump, it looks like there is only one query
"select config_file_name, config_key, config_value from grouper_config where 
config_file_hierarchy = :1"
and eventually an error is returned:
"ORA-01403: no data found".


Thanks in advance for your help!

Regards.
-- 
Mr Dominique Petitpierre, user=Dominique.Petitpierre domain=unige.ch
IT Division, University of Geneva, Switzerland