These are hibernate properties. See https://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#configurations-hbmddl for options available.
Von: Bergner, Arnold Gesendet: Freitag, 16. Juni 2017 09:56 An: '[email protected]' <[email protected]> Betreff: [cas-user] JPA Service Registry Persistence (CAS 5.0.6) Hi, I‘ve stumbled over this as well as a few others. It’s this property: 11 # cas.serviceRegistry.jpa.ddlAuto=create-drop https://apereo.github.io/cas/5.0.x/installation/Configuration-Properties.html#database-service-registry Says it’ll create the tables everytime CAS starts and drops when shutting down. You could for example set it to „create“, start once, then leave blank for further startups. Or take a look at the code for further options :/ Cheers Arnold Von: 'Iain Workman' via CAS Community [mailto:[email protected]] Gesendet: Donnerstag, 15. Juni 2017 23:33 An: CAS Community <[email protected]<mailto:[email protected]>> Betreff: [cas-user] JPA Service Registry Persistence (CAS 5.0.6) I am currently trying to configure the service registry for a CAS server (Maven Overlay, v5.0.6) using mysql as the persistent backend as per the information here<https://apereo.github.io/cas/5.0.x/installation/JPA-Service-Management.html>. The intention is to also have a cas-management application for the creation/updating etc. of the services. My current contents of pom.xml has the required dependency: <dependency> <groupId>org.apereo.cas</groupId> <artifactId>cas-server-support-jpa-service-registry</artifactId> <version>${cas.version}</version> </dependency> with the following settings in etc/cas/cas.properties # Service Registry Settings ########################### cas.serviceRegistry.jpa.healthQuery: SELECT 1 FROM INFORMATION_SCHEMA.TABLES cas.serviceRegistry.jpa.driverClass: com.mysql.cj.jdbc.Driver cas.serviceRegistry.jpa.url: jdbc:mysql://localhost:3306/cas_services cas.serviceRegistry.jpa.dialect: org.hibernate.dialect.MySQL5Dialect cas.serviceRegistry.jpa.user: *********** cas.serviceRegistry.jpa.password:********** This seems to work insofar as the tables are initialized and populated with the standard default entries. Unfortunately when the cas server process is shut down it drops all the tables which contain the service registry data. This doesn't seem particularly persistent to me and, if a cas-management application is running as the same time then it will crash when it finds its data tables no longer exist. The server outputs the following on exit: alter table RegisteredServiceImpl_Props drop foreign key FK1xan7uamsa94y2451jgksjkj4 Hibernate: alter table RegisteredServiceImpl_Props drop foreign key FK5ghaknoplphay7reury7n3vcm Hibernate: drop table if exists hibernate_sequence Hibernate: drop table if exists RegexRegisteredService Hibernate: drop table if exists RegexRegisteredServiceProperty Hibernate: drop table if exists RegisteredServiceImpl_Props Is there some element to the persistent storage of services which I am not understanding, or is there a configuration mistake which I have made? Thanks -- - 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/6db951e8-daff-4e76-bb18-f2a40e633334%40apereo.org<https://groups.google.com/a/apereo.org/d/msgid/cas-user/6db951e8-daff-4e76-bb18-f2a40e633334%40apereo.org?utm_medium=email&utm_source=footer>. -- - 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/c352b9b38f3f4677a6adf6844e88fb3c%40hrz.tu-darmstadt.de.
