CAS 6.1.3 jpa service registry doesn't work properly

50 views
Skip to first unread message

Maksim Kopeyka

unread,
Apr 2, 2020, 9:58:09 AM4/2/20
to CAS Community
Hi Guys,

I used CAS 6.0.3 with jpa service registry and I have seen records in database according to content of json files from /etc/cas/services.
After migration to CAS 6.1.3 I don't see any records in DB. 
I tried 
cas.serviceRegistry.jpa.ddlAuto=create-drop
and 
cas.serviceRegistry.jpa.ddlAuto=update

.I deleted tables from DB and CAS recreated it during startup but tables still empty. Seems to me it's a bug.

This is my properties
cas.serviceRegistry.json.location=file:/etc/cas/services
cas
.serviceRegistry.initFromJson=true
cas
.serviceRegistry.jpa.url=jdbc:mysql://${MYSQL_DATABASE_URL}:${MYSQL_DATABASE_PORT}/${MYSQL_DATABASE_NAME}
cas
.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL8Dialect
cas
.serviceRegistry.jpa.user=${MYSQL_USER}
cas
.serviceRegistry.jpa.password=${MYSQL_PASSWORD}
cas
.serviceRegistry.jpa.ddlAuto=update
cas
.serviceRegistry.jpa.driverClass=com.mysql.jdbc.Driver

Bob

unread,
Apr 2, 2020, 11:35:51 AM4/2/20
to CAS Community
Hi Maksim,

I had a similar issue with CAS 6.1.x.
The workaround from Michele worked for me. Please have a look at it:  https://groups.google.com/a/apereo.org/d/msg/cas-user/UZRwiZdgBAA/QixAg4q1AAAJ
Hope this helps.
Regards,

Bob

Maksim Kopeyka

unread,
Apr 2, 2020, 5:40:38 PM4/2/20
to CAS Community
Hi Bob,

Workaround with modification of CasServiceRegistryInitializationConfiguration.java works fine, thank you.
Is it possible to fix this issue via adding some additional dependency to build.gradle?
Reply all
Reply to author
Forward
0 new messages