There are some or at least one configuration keys named $BLAH.jpa.ddlAuto or $BLAH.jpa.ddl.auto that if are set to (or defaulting to) 'create-drop' might be causing those table dropping.
> On 15 Jun 2017, at 23:32, 'Iain Workman' via CAS Community > <[email protected]> wrote: > > 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. 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]. > 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. -- - 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/C9D0851F-7F7A-4F78-ABEE-C862EE59E5D1%40madiva.com.
