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 <lionel.samue...@gmail.com>
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=120000
> 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] -
> <HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling
> it.>
> 2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] -
> <HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
> maxLifetime, disabling it.>
> 2018-05-13 12:58:43,096 WARN [com.zaxxer.hikari.util.DriverDataSource] -
> <Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver
> was not found, trying direct instantiation.>
> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
> <HikariPool-2 - idleTimeout is close to or more than maxLifetime, disabling
> it.>
> 2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
> <HikariPool-2 - leakDetectionThreshold is less than 2000ms or more than
> maxLifetime, disabling it.>
> 2018-05-13 12:58:53,867 WARN [com.zaxxer.hikari.util.DriverDataSource] -
> <Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver
> was not found, trying direct instantiation.>
> 2018-05-13 12:58:54,556 WARN
> [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator]
> - <HHH000342: Could not obtain connection to query metadata : Unable to
> construct requested dialect [oracle.jdbc.driver.OracleDriver]>
> 2018-05-13 12:58:54,556 WARN [org.springframework.boot.context.embedded.
> AnnotationConfigEmbeddedWebApplicationContext] - <Exception encountered
> 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] - <Problem stopping
> 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.
> 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 <lionel....@gmail.com>
>> 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-IN
>>> F/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]
>>> - <The following profiles are active: standalone>
>>> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>>> <HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling
>>> it.>
>>> 2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
>>> <HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
>>> maxLifetime, disabling it.>
>>> 2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] -
>>> <HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
>>> maxLifetime, disabling it.>
>>> 2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource]
>>> - <Registered 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.int
>>> ernal.ExceptionHandlerLoggedImpl] - <GenerationTarget encountered
>>> exception accepting command : Error executing DDL via JDBC Statement>
>>> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error
>>> executing DDL via JDBC Statement
>>> ...
>>>
>>>
>>>
>>> *pom.xml*
>>> <dependency>
>>> <groupId>org.apereo.cas</groupId>
>>> <artifactId>cas-server-support-ldap</artifactId>
>>> <version>${cas.version}</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>org.apereo.cas</groupId>
>>> <artifactId>cas-server-support
>>> -json-service-registry</artifactId>
>>> <version>${cas.version}</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>org.apereo.cas</groupId>
>>> <artifactId>cas-server-support
>>> -jpa-service-registry</artifactId>
>>> <version>${cas.version}</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>org.apereo.cas</groupId>
>>> <artifactId>cas-server-support
>>> -jpa-ticket-registry</artifactId>
>>> <version>${cas.version}</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>com.oracle</groupId>
>>> <artifactId>ojdbc7.jar</artifactId>
>>> <version>12.1.0.1</version>
>>> </dependency>
>>>
>>> *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+u...@apereo.org.
>>> To view this discussion on the web visit https://groups.google.com/a/ap
>>> ereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-b874589990
>>> a0%40apereo.org
>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-b874589990a0%40apereo.org?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> - 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/06a2d3a2-458b-4103-9aeb-
> ad7099b890d3%40apereo.org
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/06a2d3a2-458b-4103-9aeb-ad7099b890d3%40apereo.org?utm_medium=email&utm_source=footer>
> .
>
--
- 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/CAMY5mideRzhfGJ0OEmihC6Op0vyXPBmPsHZv4VzZOi8tiG%3DuMw%40mail.gmail.com.
