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/33bd23b5-1921-4c6a-bd49-3f6e3554af4d%40apereo.org.

Reply via email to