Did you try mysql/maria DB for ticket storage as well? MySQL is something we are interested in for both service and ticket registry. Can you share the table structure details for this? Thanks
On Saturday, February 18, 2017 at 2:17:41 PM UTC-5, Ayé Rayé wrote: > > 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 > <http://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/69919531-4b89-4277-bc0b-98209e2bee68%40apereo.org.
