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]> 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-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 [email protected]. >>> 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 [email protected]. > 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/CAMY5mideRzhfGJ0OEmihC6Op0vyXPBmPsHZv4VzZOi8tiG%3DuMw%40mail.gmail.com.
