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].
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.
