Thanks Mathieu,
I tried that also but never could get cas-management 6.1.x working (it kept
using the built-in git repo, despite having properties set not to use that)
with the MySQL data.
Finally I gave up on cas-management and have used the workaround from
Michele instead.
Thanks,
Bob
On Monday, March 23, 2020 at 4:06:08 PM UTC+1, Mathieu HETRU wrote:
>
> 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/85c1a43d-a4b1-4d91-9106-3ed8a4e9d92d%40apereo.org.
