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 [email protected].
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.
