Hello hello, I did a CAS 5.0.2 installation with Cas Services Management installed with persistent services on MariaDB database. It seems to me that everything works well except that: Each time the Tomcat is stopped, the tables in the database containing the services registry are deleted. When I start the Tomcat, the tables are recreated and of course my previous additions of services are lost.
What did I miss in my setup? Thanks for your help. *In cas.properties* cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES # cas.serviceRegistry.jpa.isolateInternalQueries=false cas.serviceRegistry.jpa.url=jdbc:mysql://127.0.0.1:3307/cas-service-registry # cas.serviceRegistry.jpa.failFast=true cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect # cas.serviceRegistry.jpa.leakThreshold=10 # cas.serviceRegistry.jpa.batchSize=1 # cas.serviceRegistry.jpa.defaultCatalog= # cas.serviceRegistry.jpa.defaultSchema= cas.serviceRegistry.jpa.user=root # cas.serviceRegistry.jpa.ddlAuto=create-drop cas.serviceRegistry.jpa.password=root cas.serviceRegistry.jpa.autocommit=true cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver 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 in *management.properties* *cas.serviceRegistry.initFromJson=falsecas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES# cas.serviceRegistry.jpa.isolateInternalQueries=false cas.serviceRegistry.jpa.url=jdbc:mysql://127.0.0.1:3307/cas-service-registry# cas.serviceRegistry.jpa.failFast=true cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect# cas.serviceRegistry.jpa.leakThreshold=10# cas.serviceRegistry.jpa.batchSize=1# cas.serviceRegistry.jpa.defaultCatalog=# cas.serviceRegistry.jpa.defaultSchema= cas.serviceRegistry.jpa.user=root cas.serviceRegistry.jpa.ddlAuto= cas.serviceRegistry.jpa.password=root cas.serviceRegistry.jpa.autocommit=true cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver 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* -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- 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/368d3011-07ab-4f83-879d-d7674cc2dab1%40apereo.org.
