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.
