date:20180513

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Lionel Samuel

Hi Manfredo:

Thank you again --- your questions guided me --- I changed the value of 
below from 'oracle.jdbc.driver.OracleDriver'. 

cas.ticket.registry.jpa.driverClass=oracle.jdbc.OracleDriver

For others that may have same issue --- here are the working JPA for the 
Ticket and Service Registry (I have other issues now --- but that is 
separate from the Oracle JDBC class not loading)


 CAS TICKET REGISTRY

cas.ticket.registry.jpa.jpaLockingTimeout=3600
cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.ticket.registry.jpa.isolateInternalQueries=false
cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.ticket.registry.jpa.failFast=true
cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
cas.ticket.registry.jpa.leakThreshold=10
cas.ticket.registry.jpa.
jpaLockingTgtEnabled=false
cas.ticket.registry.jpa.batchSize=1
#cas.ticket.registry.jpa.defaultCatalog=
cas.ticket.registry.jpa.defaultSchema=USER
cas.ticket.registry.jpa.user=USER
cas.ticket.registry.jpa.ddlAuto=create

cas.ticket.registry.jpa.password=SNIP
cas.ticket.registry.jpa.autocommit=false
cas.ticket.registry.jpa.driverClass=oracle.jdbc.OracleDriver
cas.ticket.registry.jpa.idleTimeout=5000

cas.ticket.registry.jpa.pool.suspension=false
cas.ticket.registry.jpa.pool.minSize=6
cas.ticket.registry.jpa.pool.maxSize=18
cas.ticket.registry.jpa.pool.maxWait=2000

# cas.ticket.registry.jpa.crypto.signing.key=
# cas.ticket.registry.jpa.crypto.signing.keySize=512
# cas.ticket.registry.jpa.crypto.encryption.key=
# cas.ticket.registry.jpa.crypto.encryption.keySize=16
# cas.ticket.registry.jpa.crypto.alg=AES


 CAS SERVICES REGISTRY
cas.serviceRegistry.watcherEnabled=true
cas.serviceRegistry.repeatInterval=12
cas.serviceRegistry.startDelay=15000
cas.serviceRegistry.initFromJson=true
cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.serviceRegistry.jpa.isolateInternalQueries=false
cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.serviceRegistry.jpa.failFast=true
cas.serviceRegistry.jpa.dialect=oracle.jdbc.driver.OracleDriver
cas.serviceRegistry.jpa.leakThreshold=10
cas.serviceRegistry.jpa.batchSize=1
cas.serviceRegistry.jpa.defaultCatalog=
cas.serviceRegistry.jpa.defaultSchema=USER
cas.serviceRegistry.jpa.user=USER
cas.serviceRegistry.jpa.ddlAuto=create
cas.serviceRegistry.jpa.password=SNIP
cas.serviceRegistry.jpa.autocommit=false
cas.serviceRegistry.jpa.driverClass=oracle.jdbc.OracleDriver
cas.serviceRegistry.jpa.idleTimeout=5000
cas.serviceRegistry.jpa.pool.suspension=false
cas.serviceRegistry.jpa.pool.minSize=6
cas.serviceRegistry.jpa.pool.maxSize=18
cas.serviceRegistry.jpa.pool.maxIdleTime=1000
cas.serviceRegistry.jpa.pool.maxWait=2000


On Sunday, May 13, 2018 at 2:30:03 PM UTC-7, Manfredo Hopp wrote:
>
> Your highlighted messages are warnings. Focus on error eg ddl error etc
>
> El domingo, 13 de mayo de 2018, Lionel Samuel  > escribió:
>
>> I have google this to kingdom come --- but still stumped.
>>
>> I have started to experiment with JPA for  both the service and ticket 
>> registries (starting with the ticket registry).
>>
>> I am receiving the 'oracle.jdbc.driver.OracleDriver was not found' 
>> message on tomcat startup --- I have added the OJDBC7.jar to the build.sh's 
>> pom, and for added measure also added to the /opt/tomcat/lib (after the 
>> build, the jar alo appears in 
>> /opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar).
>>
>> Any ideas on what I could have left our or an error that I missed?
>>
>>
>> *Error Message:*
>> 2018-05-13 12:03:08,172 INFO 
>> [org.apereo.cas.web.CasWebApplicationServletInitializer] - > profiles are active: standalone>
>> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > it.>
>> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > maxLifetime, disabling it.>
>> 2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > maxLifetime, disabling it.>
>> 2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>> > driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, 
>> trying direct instantiation.>
>> 2018-05-13 11:58:18,811 WARN 
>> [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] - 
>> > DDL via JDBC Statement>
>> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing 
>> DDL via JDBC Statement
>> ...
>>
>>
>>
>> *pom.xml*
>> 
>>  org.apereo.cas
>>  cas-server-support-ldap
>>  ${cas.version}
>>  
>>  
>>  org.apereo.cas
>>  
>> cas-server-support-json-service-registry
>>  ${cas.version}
>>  
>>  
>>  org.apereo.cas
>>  
>> cas-server-support-jpa-service-registry
>>  ${cas.version}
>>  
>>  
>>

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Man H

Your highlighted messages are warnings. Focus on error eg ddl error etc

El domingo, 13 de mayo de 2018, Lionel Samuel 
escribió:

> I have google this to kingdom come --- but still stumped.
>
> I have started to experiment with JPA for  both the service and ticket
> registries (starting with the ticket registry).
>
> I am receiving the 'oracle.jdbc.driver.OracleDriver was not found'
> message on tomcat startup --- I have added the OJDBC7.jar to the build.sh's
> pom, and for added measure also added to the /opt/tomcat/lib (after the
> build, the jar alo appears in /opt/tomcat/webapps/cas/WEB-
> INF/lib/ojdbc7.jar-12.1.0.1.jar).
>
> Any ideas on what I could have left our or an error that I missed?
>
>
> *Error Message:*
> 2018-05-13 12:03:08,172 INFO [org.apereo.cas.web.
> CasWebApplicationServletInitializer] -  active: standalone>
> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>  it.>
> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>  driver with driverClassName=oracle.jdbc.driver.OracleDriver was not
> found, trying direct instantiation.>
> 2018-05-13 11:58:18,811 WARN 
> [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl]
> -  executing DDL via JDBC Statement>
> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing
> DDL via JDBC Statement
> ...
>
>
>
> *pom.xml*
> 
>  org.apereo.cas
>  cas-server-support-ldap
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-json-service-registry<
> /artifactId>
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-jpa-service-registry artifactId>
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-jpa-ticket-registry artifactId>
>  ${cas.version}
>  
>  
>  com.oracle
>  ojdbc7.jar
>  12.1.0.1
>  
>
> *ojdbc locations*
> /opt/tomcat/lib/ojdbc7.jar
> /opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar
>
>
> *cas.properties*
> cas.ticket.registry.jpa.jpaLockingTimeout=3600
> cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
> cas.ticket.registry.jpa.isolateInternalQueries=false
> cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
> cas.ticket.registry.jpa.failFast=true
> cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
> cas.ticket.registry.jpa.leakThreshold=10
> cas.ticket.registry.jpa.jpaLockingTgtEnabled=true
> cas.ticket.registry.jpa.batchSize=1
> cas.ticket.registry.jpa.defaultCatalog=
> cas.ticket.registry.jpa.defaultSchema=
> cas.ticket.registry.jpa.user=USER
> cas.ticket.registry.jpa.ddlAuto=create-drop
> cas.ticket.registry.jpa.password=SNIP
> cas.ticket.registry.jpa.autocommit=false
> cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
> cas.ticket.registry.jpa.idleTimeout=5000
>
> cas.ticket.registry.jpa.pool.suspension=false
> cas.ticket.registry.jpa.pool.minSize=6
> cas.ticket.registry.jpa.pool.maxSize=18
> cas.ticket.registry.jpa.pool.maxWait=2000
>
>
> --
> - Website: https://apereo.github.io/cas
> - Gitter Chatroom: https://gitter.im/apereo/cas
> - List Guidelines: https://goo.gl/1VRrw7
> - Contributions: https://goo.gl/mh7qDG
> ---
> You received this message because you are subscribed to the Google Groups
> "CAS Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cas-user+unsubscr...@apereo.org.
> To view this discussion on the web visit https://groups.google.com/a/
> apereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-
> b874589990a0%40apereo.org
> 
> .
>

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mifTv%3DaXpjJwLcfcXo0GxSeHr3Bj_CVSePgFWJ%3D_UVhK-g%40mail.gmail.com.

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Lionel Samuel

Hi Manfredo:

'cas.properties' is at '/etc/cas' --- from the startup logs in 
'catalina.out':

2018-05-13 14:08:59,090 INFO 
[org.apereo.cas.configuration.config.CasCoreBootstrapStandaloneConfiguration] 
- 

2018-05-13 14:08:59,129 INFO 
[org.apereo.cas.configuration.config.CasCoreBootstrapStandaloneConfiguration] 
- 
2018-05-13 14:08:59,130 INFO 
[org.springframework.cloud.bootstrap.config.PropertySourceBootstrapConfiguration]
 
- 

On Sunday, May 13, 2018 at 1:43:23 PM UTC-7, Manfredo Hopp wrote:
>
> Where are your  cas properties. See where they are fetched from when cas 
> starts un Catalina.out
>
> El domingo, 13 de mayo de 2018, Lionel Samuel  > escribió:
>
>> Hi Manfredo:
>>
>> >Where are service registry properties?
>>
>> Thank you -- I did not have them initially ---  I had mistakenly thought 
>> that I could test the Ticket Registry Oracle DB connections independently 
>> to the Service Registry.
>>
>> After receiving your posted, I've added the Service Registry properties 
>> (listed below). Since then the error messages have changed (also listed 
>> below) --- however ' driverClassName=oracle.jdbc.driver.OracleDriver was 
>> not found, trying direct instantiation' remains.
>>
>> Is there anything else I am missing? 
>>
>>  CAS TICKET REGISTRY
>> cas.ticket.registry.jpa.jpaLockingTimeout=3600
>> cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
>> cas.ticket.registry.jpa.isolateInternalQueries=false
>> cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
>> cas.ticket.registry.jpa.failFast=true
>> cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
>> cas.ticket.registry.jpa.leakThreshold=10
>> cas.ticket.registry.jpa.jpaLockingTgtEnabled=false
>> cas.ticket.registry.jpa.batchSize=1
>> #cas.ticket.registry.jpa.defaultCatalog=
>> cas.ticket.registry.jpa.defaultSchema=USER
>> cas.ticket.registry.jpa.user=USER
>> cas.ticket.registry.jpa.ddlAuto=create
>> cas.ticket.registry.jpa.password=SNIP
>> cas.ticket.registry.jpa.autocommit=false
>> cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
>> cas.ticket.registry.jpa.idleTimeout=5000
>>
>> cas.ticket.registry.jpa.pool.suspension=false
>> cas.ticket.registry.jpa.pool.minSize=6
>> cas.ticket.registry.jpa.pool.maxSize=18
>> cas.ticket.registry.jpa.pool.maxWait=2000
>>
>> # cas.ticket.registry.jpa.crypto.signing.key=
>> # cas.ticket.registry.jpa.crypto.signing.keySize=512
>> # cas.ticket.registry.jpa.crypto.encryption.key=
>> # cas.ticket.registry.jpa.crypto.encryption.keySize=16
>> # cas.ticket.registry.jpa.crypto.alg=AES
>>
>>
>>  CAS SERVICES REGISTRY
>> cas.serviceRegistry.watcherEnabled=true
>> cas.serviceRegistry.repeatInterval=12
>> cas.serviceRegistry.startDelay=15000
>> cas.serviceRegistry.initFromJson=true
>> cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM DUAL
>> cas.serviceRegistry.jpa.isolateInternalQueries=false
>> cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@foo:bar
>> cas.serviceRegistry.jpa.failFast=true
>> cas.serviceRegistry.jpa.dialect=oracle.jdbc.driver.OracleDriver
>> cas.serviceRegistry.jpa.leakThreshold=10
>> cas.serviceRegistry.jpa.batchSize=1
>> cas.serviceRegistry.jpa.defaultCatalog=
>> cas.serviceRegistry.jpa.defaultSchema=USER
>> cas.serviceRegistry.jpa.user=USER
>> cas.serviceRegistry.jpa.ddlAuto=create
>> cas.serviceRegistry.jpa.password=SNIP
>> cas.serviceRegistry.jpa.autocommit=false
>> cas.serviceRegistry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
>> cas.serviceRegistry.jpa.idleTimeout=5000
>> cas.serviceRegistry.jpa.pool.suspension=false
>> cas.serviceRegistry.jpa.pool.minSize=6
>> cas.serviceRegistry.jpa.pool.maxSize=18
>> cas.serviceRegistry.jpa.pool.maxIdleTime=1000
>> cas.serviceRegistry.jpa.pool.maxWait=2000
>>
>>
>> 2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > it.>
>> 2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > maxLifetime, disabling it.>
>> 2018-05-13 12:58:43,096 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>> > not found, trying direct instantiation.>
>> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > it.>
>> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] - 
>> > maxLifetime, disabling it.>
>> 2018-05-13 12:58:53,867 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>> > not found, trying direct instantiation.>
>> 2018-05-13 12:58:54,556 WARN 
>> [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] - 
>> > construct requested dialect [oracle.jdbc.driver.OracleDriver]>
>> 2018-05-13 12:58:54,556 WARN 
>> [org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext]
>>  
>> - > attempt: org.springframework.beans.factory.BeanCreationException: Error 
>> creating bean with name 'serviceEntityManagerFactory' defined in class path 
>> resource [org/apereo/cas/config/JpaServiceRegistryConfiguration.class]: 
>> Invocation of init method failed; nested exception is 
>>

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Man H

Where are your  cas properties. See where they are fetched from when cas
starts un Catalina.out

El domingo, 13 de mayo de 2018, Lionel Samuel 
escribió:

> Hi Manfredo:
>
> >Where are service registry properties?
>
> Thank you -- I did not have them initially ---  I had mistakenly thought
> that I could test the Ticket Registry Oracle DB connections independently
> to the Service Registry.
>
> After receiving your posted, I've added the Service Registry properties
> (listed below). Since then the error messages have changed (also listed
> below) --- however ' driverClassName=oracle.jdbc.driver.OracleDriver was
> not found, trying direct instantiation' remains.
>
> Is there anything else I am missing?
>
>  CAS TICKET REGISTRY
> cas.ticket.registry.jpa.jpaLockingTimeout=3600
> cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
> cas.ticket.registry.jpa.isolateInternalQueries=false
> cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
> cas.ticket.registry.jpa.failFast=true
> cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
> cas.ticket.registry.jpa.leakThreshold=10
> cas.ticket.registry.jpa.jpaLockingTgtEnabled=false
> cas.ticket.registry.jpa.batchSize=1
> #cas.ticket.registry.jpa.defaultCatalog=
> cas.ticket.registry.jpa.defaultSchema=USER
> cas.ticket.registry.jpa.user=USER
> cas.ticket.registry.jpa.ddlAuto=create
> cas.ticket.registry.jpa.password=SNIP
> cas.ticket.registry.jpa.autocommit=false
> cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
> cas.ticket.registry.jpa.idleTimeout=5000
>
> cas.ticket.registry.jpa.pool.suspension=false
> cas.ticket.registry.jpa.pool.minSize=6
> cas.ticket.registry.jpa.pool.maxSize=18
> cas.ticket.registry.jpa.pool.maxWait=2000
>
> # cas.ticket.registry.jpa.crypto.signing.key=
> # cas.ticket.registry.jpa.crypto.signing.keySize=512
> # cas.ticket.registry.jpa.crypto.encryption.key=
> # cas.ticket.registry.jpa.crypto.encryption.keySize=16
> # cas.ticket.registry.jpa.crypto.alg=AES
>
>
>  CAS SERVICES REGISTRY
> cas.serviceRegistry.watcherEnabled=true
> cas.serviceRegistry.repeatInterval=12
> cas.serviceRegistry.startDelay=15000
> cas.serviceRegistry.initFromJson=true
> cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM DUAL
> cas.serviceRegistry.jpa.isolateInternalQueries=false
> cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@foo:bar
> cas.serviceRegistry.jpa.failFast=true
> cas.serviceRegistry.jpa.dialect=oracle.jdbc.driver.OracleDriver
> cas.serviceRegistry.jpa.leakThreshold=10
> cas.serviceRegistry.jpa.batchSize=1
> cas.serviceRegistry.jpa.defaultCatalog=
> cas.serviceRegistry.jpa.defaultSchema=USER
> cas.serviceRegistry.jpa.user=USER
> cas.serviceRegistry.jpa.ddlAuto=create
> cas.serviceRegistry.jpa.password=SNIP
> cas.serviceRegistry.jpa.autocommit=false
> cas.serviceRegistry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
> cas.serviceRegistry.jpa.idleTimeout=5000
> cas.serviceRegistry.jpa.pool.suspension=false
> cas.serviceRegistry.jpa.pool.minSize=6
> cas.serviceRegistry.jpa.pool.maxSize=18
> cas.serviceRegistry.jpa.pool.maxIdleTime=1000
> cas.serviceRegistry.jpa.pool.maxWait=2000
>
>
> 2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] -
>  it.>
> 2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 12:58:43,096 WARN [com.zaxxer.hikari.util.DriverDataSource] -
>  was not found, trying direct instantiation.>
> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
>  it.>
> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 12:58:53,867 WARN [com.zaxxer.hikari.util.DriverDataSource] -
>  was not found, trying direct instantiation.>
> 2018-05-13 12:58:54,556 WARN 
> [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator]
> -  construct requested dialect [oracle.jdbc.driver.OracleDriver]>
> 2018-05-13 12:58:54,556 WARN [org.springframework.boot.context.embedded.
> AnnotationConfigEmbeddedWebApplicationContext] -  during context initialization - cancelling refresh attempt:
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'serviceEntityManagerFactory' defined in class path resource
> [org/apereo/cas/config/JpaServiceRegistryConfiguration.class]: Invocation
> of init method failed; nested exception is 
> org.hibernate.service.spi.ServiceException:
> Unable to create requested service [org.hibernate.engine.jdbc.
> env.spi.JdbcEnvironment]>
> 2018-05-13 12:58:54,561 WARN [com.ryantenney.metrics.
> spring.config.annotation.MetricsConfigurerAdapter] -  reporter>
> org.springframework.beans.factory.BeanCreationNotAllowedException: Error
> creating bean with name 'casMetricsConfiguration': Singleton bean creation
> not allowed while singletons of this factory are in destruction (Do not
> request a bean from a BeanFactory in a destroy method implementation!)
> at org.springframework.beans.factory.support.
>

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Lionel Samuel

Hi Manfredo:

>Where are service registry properties?

Thank you -- I did not have them initially ---  I had mistakenly thought 
that I could test the Ticket Registry Oracle DB connections independently 
to the Service Registry.

After receiving your posted, I've added the Service Registry properties 
(listed below). Since then the error messages have changed (also listed 
below) --- however ' driverClassName=oracle.jdbc.driver.OracleDriver was 
not found, trying direct instantiation' remains.

Is there anything else I am missing? 

 CAS TICKET REGISTRY
cas.ticket.registry.jpa.jpaLockingTimeout=3600
cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.ticket.registry.jpa.isolateInternalQueries=false
cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.ticket.registry.jpa.failFast=true
cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
cas.ticket.registry.jpa.leakThreshold=10
cas.ticket.registry.jpa.jpaLockingTgtEnabled=false
cas.ticket.registry.jpa.batchSize=1
#cas.ticket.registry.jpa.defaultCatalog=
cas.ticket.registry.jpa.defaultSchema=USER
cas.ticket.registry.jpa.user=USER
cas.ticket.registry.jpa.ddlAuto=create
cas.ticket.registry.jpa.password=SNIP
cas.ticket.registry.jpa.autocommit=false
cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
cas.ticket.registry.jpa.idleTimeout=5000

cas.ticket.registry.jpa.pool.suspension=false
cas.ticket.registry.jpa.pool.minSize=6
cas.ticket.registry.jpa.pool.maxSize=18
cas.ticket.registry.jpa.pool.maxWait=2000

# cas.ticket.registry.jpa.crypto.signing.key=
# cas.ticket.registry.jpa.crypto.signing.keySize=512
# cas.ticket.registry.jpa.crypto.encryption.key=
# cas.ticket.registry.jpa.crypto.encryption.keySize=16
# cas.ticket.registry.jpa.crypto.alg=AES


 CAS SERVICES REGISTRY
cas.serviceRegistry.watcherEnabled=true
cas.serviceRegistry.repeatInterval=12
cas.serviceRegistry.startDelay=15000
cas.serviceRegistry.initFromJson=true
cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.serviceRegistry.jpa.isolateInternalQueries=false
cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.serviceRegistry.jpa.failFast=true
cas.serviceRegistry.jpa.dialect=oracle.jdbc.driver.OracleDriver
cas.serviceRegistry.jpa.leakThreshold=10
cas.serviceRegistry.jpa.batchSize=1
cas.serviceRegistry.jpa.defaultCatalog=
cas.serviceRegistry.jpa.defaultSchema=USER
cas.serviceRegistry.jpa.user=USER
cas.serviceRegistry.jpa.ddlAuto=create
cas.serviceRegistry.jpa.password=SNIP
cas.serviceRegistry.jpa.autocommit=false
cas.serviceRegistry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
cas.serviceRegistry.jpa.idleTimeout=5000
cas.serviceRegistry.jpa.pool.suspension=false
cas.serviceRegistry.jpa.pool.minSize=6
cas.serviceRegistry.jpa.pool.maxSize=18
cas.serviceRegistry.jpa.pool.maxIdleTime=1000
cas.serviceRegistry.jpa.pool.maxWait=2000


2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 12:58:43,096 WARN [com.zaxxer.hikari.util.DriverDataSource] - 

2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 12:58:53,867 WARN [com.zaxxer.hikari.util.DriverDataSource] - 

2018-05-13 12:58:54,556 WARN 
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] - 

2018-05-13 12:58:54,556 WARN 
[org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext]
 
- 
2018-05-13 12:58:54,561 WARN 
[com.ryantenney.metrics.spring.config.annotation.MetricsConfigurerAdapter] 
- 
org.springframework.beans.factory.BeanCreationNotAllowedException: Error 
creating bean with name 'casMetricsConfiguration': Singleton bean creation 
not allowed while singletons of this factory are in destruction (Do not 
request a bean from a BeanFactory in a destroy method implementation!)
at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:216)
 
~[spring-beans-4.3.16.RELEASE.jar:4.3.16.RELEASE]
at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
 
~[spring-beans-4.3.16.RELEASE.jar:4.3.16.RELEASE]



On Sunday, May 13, 2018 at 12:40:48 PM UTC-7, Manfredo Hopp wrote:
>
> Where are service registry properties?
>
> El domingo, 13 de mayo de 2018, Lionel Samuel  > escribió:
>
>> I have google this to kingdom come --- but still stumped.
>>
>> I have started to experiment with JPA for  both the service and ticket 
>> registries (starting with the ticket registry).
>>
>> I am receiving the 'oracle.jdbc.driver.OracleDriver was not found' 
>> message on tomcat startup --- I have added the OJDBC7.jar to the build.sh's 
>> pom, and for added measure also added to the /opt/tomcat/lib (after the 
>> build, the jar alo appears in 
>> /opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar).
>>
>> Any ideas on what I could have

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Man H

Where are service registry properties?

El domingo, 13 de mayo de 2018, Lionel Samuel 
escribió:

> I have google this to kingdom come --- but still stumped.
>
> I have started to experiment with JPA for  both the service and ticket
> registries (starting with the ticket registry).
>
> I am receiving the 'oracle.jdbc.driver.OracleDriver was not found'
> message on tomcat startup --- I have added the OJDBC7.jar to the build.sh's
> pom, and for added measure also added to the /opt/tomcat/lib (after the
> build, the jar alo appears in /opt/tomcat/webapps/cas/WEB-
> INF/lib/ojdbc7.jar-12.1.0.1.jar).
>
> Any ideas on what I could have left our or an error that I missed?
>
>
> *Error Message:*
> 2018-05-13 12:03:08,172 INFO [org.apereo.cas.web.
> CasWebApplicationServletInitializer] -  active: standalone>
> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>  it.>
> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] -
>  maxLifetime, disabling it.>
> 2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>  driver with driverClassName=oracle.jdbc.driver.OracleDriver was not
> found, trying direct instantiation.>
> 2018-05-13 11:58:18,811 WARN 
> [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl]
> -  executing DDL via JDBC Statement>
> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing
> DDL via JDBC Statement
> ...
>
>
>
> *pom.xml*
> 
>  org.apereo.cas
>  cas-server-support-ldap
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-json-service-registry<
> /artifactId>
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-jpa-service-registry artifactId>
>  ${cas.version}
>  
>  
>  org.apereo.cas
>  cas-server-support-jpa-ticket-registry artifactId>
>  ${cas.version}
>  
>  
>  com.oracle
>  ojdbc7.jar
>  12.1.0.1
>  
>
> *ojdbc locations*
> /opt/tomcat/lib/ojdbc7.jar
> /opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar
>
>
> *cas.properties*
> cas.ticket.registry.jpa.jpaLockingTimeout=3600
> cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
> cas.ticket.registry.jpa.isolateInternalQueries=false
> cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
> cas.ticket.registry.jpa.failFast=true
> cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
> cas.ticket.registry.jpa.leakThreshold=10
> cas.ticket.registry.jpa.jpaLockingTgtEnabled=true
> cas.ticket.registry.jpa.batchSize=1
> cas.ticket.registry.jpa.defaultCatalog=
> cas.ticket.registry.jpa.defaultSchema=
> cas.ticket.registry.jpa.user=USER
> cas.ticket.registry.jpa.ddlAuto=create-drop
> cas.ticket.registry.jpa.password=SNIP
> cas.ticket.registry.jpa.autocommit=false
> cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
> cas.ticket.registry.jpa.idleTimeout=5000
>
> cas.ticket.registry.jpa.pool.suspension=false
> cas.ticket.registry.jpa.pool.minSize=6
> cas.ticket.registry.jpa.pool.maxSize=18
> cas.ticket.registry.jpa.pool.maxWait=2000
>
>
> --
> - Website: https://apereo.github.io/cas
> - Gitter Chatroom: https://gitter.im/apereo/cas
> - List Guidelines: https://goo.gl/1VRrw7
> - Contributions: https://goo.gl/mh7qDG
> ---
> You received this message because you are subscribed to the Google Groups
> "CAS Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cas-user+unsubscr...@apereo.org.
> To view this discussion on the web visit https://groups.google.com/a/
> apereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-
> b874589990a0%40apereo.org
> 
> .
>

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mif7HS5uuZ%2Bj6QTGUaWZ1HuZmQKRqmcV6tF7Y6Pg5P53kA%40mail.gmail.com.

[cas-user] oracle.jdbc.driver.OracleDriver was not found

2018-05-13 Thread Lionel Samuel

I have google this to kingdom come --- but still stumped.

I have started to experiment with JPA for  both the service and ticket 
registries (starting with the ticket registry).

I am receiving the 'oracle.jdbc.driver.OracleDriver was not found' message 
on tomcat startup --- I have added the OJDBC7.jar to the build.sh's pom, 
and for added measure also added to the /opt/tomcat/lib (after the build, 
the jar alo appears in 
/opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar).

Any ideas on what I could have left our or an error that I missed?


*Error Message:*
2018-05-13 12:03:08,172 INFO 
[org.apereo.cas.web.CasWebApplicationServletInitializer] - 
2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] - 

2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource] - 

2018-05-13 11:58:18,811 WARN 
[org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] - 

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing 
DDL via JDBC Statement
...



*pom.xml*

 org.apereo.cas
 cas-server-support-ldap
 ${cas.version}
 
 
 org.apereo.cas
 
cas-server-support-json-service-registry
 ${cas.version}
 
 
 org.apereo.cas
 
cas-server-support-jpa-service-registry
 ${cas.version}
 
 
 org.apereo.cas
 
cas-server-support-jpa-ticket-registry
 ${cas.version}
 
 
 com.oracle
 ojdbc7.jar
 12.1.0.1
 

*ojdbc locations*
/opt/tomcat/lib/ojdbc7.jar
/opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar


*cas.properties*
cas.ticket.registry.jpa.jpaLockingTimeout=3600
cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.ticket.registry.jpa.isolateInternalQueries=false
cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.ticket.registry.jpa.failFast=true
cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
cas.ticket.registry.jpa.leakThreshold=10
cas.ticket.registry.jpa.jpaLockingTgtEnabled=true
cas.ticket.registry.jpa.batchSize=1
cas.ticket.registry.jpa.defaultCatalog=
cas.ticket.registry.jpa.defaultSchema=
cas.ticket.registry.jpa.user=USER
cas.ticket.registry.jpa.ddlAuto=create-drop
cas.ticket.registry.jpa.password=SNIP
cas.ticket.registry.jpa.autocommit=false
cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
cas.ticket.registry.jpa.idleTimeout=5000

cas.ticket.registry.jpa.pool.suspension=false
cas.ticket.registry.jpa.pool.minSize=6
cas.ticket.registry.jpa.pool.maxSize=18
cas.ticket.registry.jpa.pool.maxWait=2000


-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-b874589990a0%40apereo.org.

Re: [cas-user] cas.authn.ldap[0].poolPassivator=NONE|CLOSE|BIND

2018-05-13 Thread Lionel Samuel

Thank you :)

On Saturday, May 12, 2018 at 7:50:24 PM UTC-7, David Curry wrote:
>
> See this link. 
> https://apereo.github.io/cas/5.2.x/installation/Configuration-Properties.html#passivators
>
>
>
> David A. Curry,  CISSP
> Director of Information Security
> The New School - Information Technology
> 71 Fifth Ave., 9th Fl. ~ New York, NY 10003
> +1 212 229-5300 x4728 ~ david...@newschool.edu 
> Sent from my phone; please excuse typos and inane auto-corrections.
> 
>
> On Sat, May 12, 2018, 22:37 Lionel Samuel  > wrote:
>
>> Hi Lists:
>>
>> We are testing out CAS 5.2.4 -- we would like to leverage LDAP connection 
>> pooling (LDAP auth working --- big thanks to David from New School).
>>
>> I have searched but can't quite tell what is 
>> 'cas.authn.ldap[0].poolPassivator=NONE|CLOSE|BIND' -- and the siiference 
>> between the options.
>>
>> Would a kind soul be able to describe or suggest a link?
>>
>> # LDAP Connection Pooling (default values from Apareo's site)
>> cas.authn.ldap[0].poolPassivator=NONE|CLOSE|BIND
>> cas.authn.ldap[0].minPoolSize=3
>> cas.authn.ldap[0].maxPoolSize=10
>> cas.authn.ldap[0].validateOnCheckout=true
>> cas.authn.ldap[0].validatePeriodically=true
>> cas.authn.ldap[0].validatePeriod=600
>> cas.authn.ldap[0].validateTimeout=5000
>>
>> cas.authn.ldap[0].failFast=true
>> cas.authn.ldap[0].idleTime=5000
>> cas.authn.ldap[0].prunePeriod=5000
>> cas.authn.ldap[0].blockWaitTime=5000
>>
>> -- 
>> - Website: https://apereo.github.io/cas
>> - Gitter Chatroom: https://gitter.im/apereo/cas
>> - List Guidelines: https://goo.gl/1VRrw7
>> - Contributions: https://goo.gl/mh7qDG
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "CAS Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to cas-user+u...@apereo.org .
>> To view this discussion on the web visit 
>> https://groups.google.com/a/apereo.org/d/msgid/cas-user/d5f9613b-7c97-46ff-a19f-2227c3e74e12%40apereo.org
>>  
>> 
>> .
>>
>

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/23998bde-eccf-4913-9abd-8ac14b71b1c2%40apereo.org.

Re: [cas-user] 5.2.X Service Registry

2018-05-13 Thread David Curry

There are a whole bunch of options, from JSON/YAML to JPA (multiple
databases) to REST-ful web interfaces. Go to the CAS documentation (
https://apereo.github.io/cas/5.2.x/index.html) and then on the right-hand
side menu, click on "Services" and then "Storage" to see the whole list.

We have been using MongoDB in production for a couple of months now
(service registry and ticket registry), and it's been working quite well.
(If you're using my how-to guide, there are sections there on setting up
both of these.) I know there are several people on the list using JPA with
various backend databases, and I think there's someone out there using
Couchbase, as well.

--Dave

--

DAVID A. CURRY, CISSP
*DIRECTOR OF INFORMATION SECURITY*
INFORMATION TECHNOLOGY

71 FIFTH AVE., 9TH FL., NEW YORK, NY 10003
+1 212 229-5300 x4728 • david.cu...@newschool.edu

[image: The New School]

On Sun, May 13, 2018 at 1:11 AM, josbrodie  wrote:

> We are upgrading from v3X. There is quite a big learning curve going to
> v5.2x
>
> For the Service Registry in v5.2 -- https://apereo.github.io/cas/
> 5.2.x/installation/AutoInitialization-Service-Management.html
>
> Is there a Database option as with v3? Or is JSON is the only way (where
> is it store if only on JSON)?
>
> Apologies if my questions are very newbie.
>
> --
> - Website: https://apereo.github.io/cas
> - Gitter Chatroom: https://gitter.im/apereo/cas
> - List Guidelines: https://goo.gl/1VRrw7
> - Contributions: https://goo.gl/mh7qDG
> ---
> You received this message because you are subscribed to the Google Groups
> "CAS Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cas-user+unsubscr...@apereo.org.
> To view this discussion on the web visit https://groups.google.com/a/
> apereo.org/d/msgid/cas-user/66a310b0-0a7b-4d74-ab3d-
> 103d35ab1f3f%40apereo.org
> 
> .
>

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/CA%2Bd9XAPNhbxngL1MLXzx4wsRrZgtrzQ9SkzmMVUNa27asU_4VA%40mail.gmail.com.

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] oracle.jdbc.driver.OracleDriver was not found

[cas-user] oracle.jdbc.driver.OracleDriver was not found

Re: [cas-user] cas.authn.ldap[0].poolPassivator=NONE|CLOSE|BIND

Re: [cas-user] 5.2.X Service Registry

9 matches

Site Navigation

Mail list logo

Footer information