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]
- <Configuration files found at [/etc/cas/config] are
[[/etc/cas/config/application.yml, /etc/cas/config/cas.properties]]>
2018-05-13 14:08:59,129 INFO
[org.apereo.cas.configuration.config.CasCoreBootstrapStandaloneConfiguration]
- <Found and loaded [80] setting(s) from [/etc/cas/config]>
2018-05-13 14:08:59,130 INFO
[org.springframework.cloud.bootstrap.config.PropertySourceBootstrapConfiguration]
- <Located property source: PropertiesPropertySource
{name='standaloneCasConfigService'}>
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 <[email protected]
> <javascript:>> 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 <[email protected]>
>>> 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] - <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.internal.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 [email protected].
>>>> 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
>>>>
>>>> <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 [email protected] <javascript:>.
>> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/0ceb835e-8a9d-4095-8c9a-f4bb33c954fe%40apereo.org.
