Thank you for the response. This solved my issue. On Friday, June 16, 2017 at 5:40:14 AM UTC-6, Bergner, Arnold wrote: > > 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] <javascript:>' <[email protected] <javascript:> > > > *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] > <javascript:>] > *Gesendet:* Donnerstag, 15. Juni 2017 23:33 > *An:* CAS Community <[email protected] <javascript:>> > *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] <javascript:>. > 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/14f4bb63-d7c1-4a64-bbff-f0660a6bbd0a%40apereo.org.
