Hello Bob,
You should install cas-management web interface because the service entry
in the db got java objects serialized in the db blob fields in the db
tables.
I have not use the initFromJson feature.
Sincerly,
Mathieu
Le mardi 28 janvier 2020 12:50:54 UTC+1, Bob a écrit :
>
> Hello,
>
> We are upgrading to CAS 6.1.x.
> Most things seem to work fine (LDAP and reading Service Registry from json
> file) but we cannot get it to save the Service Registry in a MySQL casdb.
> Is there a way to manually enter a Service Registry into a MySQL database?
>
> Running CAS has created 3 tables in our MySQL database:
>
> regex_registered_service
> regex_registered_service_regex_registered_service_property
> regex_registered_service_registered_service_impl_contact
>
>
> Table regex_registered_service has the following columns:
>
> +----------------------------------+
> | COLUMN_NAME |
> +----------------------------------+
> | access_strategy |
> | attribute_release |
> | description |
> | environments |
> | evaluation_order |
> | expiration_policy |
> | expression_type |
> | id |
> | information_Url |
> | logo |
> | logout_type |
> | logout_url |
> | mfa_policy |
> | name |
> | privacy_Url |
> | proxy_policy |
> | proxy_ticket_expiration_policy |
> | public_key |
> | required_handlers |
> | response_Type |
> | service_Id |
> | service_ticket_expiration_policy |
> | sso_participation_policy |
> | theme |
> | username_attr |
> +----------------------------------+
> 25 rows in set (0.00 sec)
>
> How would I get the following json into this table?
>
> {
> "@class" : "org.apereo.cas.services.RegexRegisteredService",
> "serviceId" : "https://localhost:9000/dashboard";,
> "name" : "My App",
> "id" : 10001000,
> "description" : "My Dashboard App",
> "attributeReleasePolicy" : {
> "@class" :
> "org.apereo.cas.services.ReturnMappedAttributeReleasePolicy",
> "allowedAttributes" : {
> "@class" : "java.util.TreeMap",
> "memberOf" : "authorities"
> }
> },
> "evaluationOrder" : 100,
> "accessStrategy" : {
> "@class" :
> "org.apereo.cas.services.DefaultRegisteredServiceAccessStrategy",
> "enabled" : true,
> "ssoEnabled" : true
> }
> }
>
> Thanks in advance!
>
> 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/313a436d-ea83-4643-b2ad-ac892192a76d%40apereo.org.
