hello Bob,
i have the solution : remove the git feature from the war file (produced by
gradlew) in order to cas-management 6.1.x works fine :

add this line in the build.gradle (in the bootWar step) :
---
excludes = ["**/cas-mgmt-config-version-control*.jar",
"**/cas-mgmt-config-delegated*.jar", "**/HikariCP-java7-2.4.13.jar"]
---

Sincerly,

Mathieu

Le mar. 24 mars 2020 à 16:04, Bob <bugsy...@gmail.com> a écrit :

> 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 cas-user+unsubscr...@apereo.org.
> 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
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/85c1a43d-a4b1-4d91-9106-3ed8a4e9d92d%40apereo.org?utm_medium=email&utm_source=footer>
> .
>

-- 
- 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/CAHNwO5maybN1prurCk8g73_PbEVpk8tDQnVgbKfeXTmAZDdk5g%40mail.gmail.com.

Reply via email to