Thank you very much Mathieu! That workaround fixed it for me and I now have CAS Management (6.1.0-RC4) saving the services in the MySQL database. Much appreciated! Regards,
Bob On Tuesday, March 24, 2020 at 5:13:09 PM UTC+1, Mathieu HETRU wrote: > > 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 <[email protected] <javascript:>> 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 [email protected] <javascript:>. >> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/25507c9d-54e8-4c95-9995-11b77564864c%40apereo.org.
