Hello all, We have CAS 5.3.9 up and running on Production and it's working fine (with Service Registries stored in a MySQL database).
Currently I'm trying out a clean installation of the cas-overlay-template (branch 6.1) and it's working ok with our existing JSON definitions for the Services but I cannot get the Auto Initialization working for the JPA Service Registry. It creates 3 new tables in my casdb database when I run CAS 6.1.0. but they're all empty: regex_registered_service regex_registered_service_regex_registered_service_property regex_registered_service_registered_service_impl_contact By the way, CAS 5.3.9 created the table name like: "regexregisteredservice" (with 44 columns). In CAS 6.1.0 I only have 25 columns in "regex_registered_service" Here's what I'm using: CAS Version: 6.1.0 CAS Branch: 6.1.x CAS Commit Id: c92590730249df0cf26fd1b4bebd8aea8447b256 CAS Build Date/Time: 2019-10-28T02:43:18Z Spring Boot Version: 2.2.0.RELEASE Spring Version: 5.2.0.RELEASE Java Home: C:\Programs\Java\amazon-corretto\jdk11.0.3_7 Java Vendor: Amazon.com Inc. Java Version: 11.0.3 My dependencies in build.gradle: dependencies { // Other CAS dependencies/modules may be listed here... compile "org.apereo.cas:cas-server-support-ldap:${project.'cas.version'}" compile "org.apereo.cas:cas-server-support-jdbc-drivers:${project.'cas.version'}" compile "org.apereo.cas:cas-server-support-jpa-service-registry:${project.'cas.version'}" } My minimum cas.propertie (I omitted the LDAP part since that's working fine): cas.server.name: https://localhost:8443 cas.server.prefix: ${cas.server.name}/cas logging.config: file:/etc/cas/config/log4j2.xml server.ssl.key-store=file:/etc/cas/keystore.jks server.ssl.key-store-password=xxxxxxxx server.ssl.key-password=xxxxxxx cas.serviceRegistry.initFromJson=true cas.serviceRegistry.json.location=file:/etc/cas/services cas.serviceRegistry.jpa.user=xxxxxxxxxx cas.serviceRegistry.jpa.password=xxxxxxxxxxx cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver cas.serviceRegistry.jpa.url=jdbc:mysql://localhost:3306/casdb?allowPublicKeyRetrieval=true&characterEncoding=UTF-8&useSSL=FALSE cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL57InnoDBDialect cas.serviceRegistry.jpa.ddlAuto=update When I run CAS 6.1.0 I see: [org.apereo.cas.services.AbstractServicesManager] - <Loaded [1] service(s) from [EmbeddedResourceBasedServiceRegistry,JpaServiceRegistry].> I can then use CAS to login to my application, but it does not insert any Service Registry into the MySQL casdb. Initially I had a similar issue with CAS 5.3.9 but after fiddling with some settings (enable/disable dependencies and initFromJson values in cas.properties) I somehow got that working. I'm using similar settings (although using gradle instead of maven now) in CAS 6.1.0 but I can't seem to get the Service Registries into the casdb. Does anybody have an idea what I'm missing (or maybe it's a known issue/bug))? Thanks in advance (I searched this forum but could not find a similar issue). Bob -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/9176b5d1-4815-454e-8cb5-f8db2c4be28a%40apereo.org.