Bob, We are using the 5.1.5 version of cas management. You only need to upgrade it if you want newer features, etc. I also have grumblings about the 6.x version. I put off upgrading cas management until it settles.
Ray On Tue, 2020-01-28 at 12:34 -0800, Bob wrote: Hi Ray, No, I'm currently just using the cas overlay (6.1.x). I did try to get cas management working but had some issue with a pre-defined service registry in some kind of git repo. Whenever I tried to enter a service via cas management, there was no option to save it to my database. All it ever did was show this 1 entry from a git repo. SInce I did get it working (reading my json file and store it in MySQL database) without cas management for version 5.3.9, I assumed it would work for version 6 as well. Do you think cas management is the only way to get it stored in the database? I might have another look at it then. Thanks, Bob On Tuesday, January 28, 2020 at 8:31:44 PM UTC+1, rbon wrote: Bob, Are you using the cas management server, https://github.com/apereo/cas-management-overlay? If you are, what do the logs say when you try to save? Ray On Tue, 2020-01-28 at 03:50 -0800, Bob wrote: 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 -- Ray Bon Programmer Analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected]<javascript:> I respectfully acknowledge that my place of work is located within the ancestral, traditional and unceded territory of the Songhees, Esquimalt and WSÁNEĆ Nations. On Tuesday, January 28, 2020 at 8:31:44 PM UTC+1, rbon wrote: Bob, Are you using the cas management server, https://github.com/apereo/cas-management-overlay? If you are, what do the logs say when you try to save? Ray On Tue, 2020-01-28 at 03:50 -0800, Bob wrote: 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 -- Ray Bon Programmer Analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected]<javascript:> I respectfully acknowledge that my place of work is located within the ancestral, traditional and unceded territory of the Songhees, Esquimalt and WSÁNEĆ Nations. On Tuesday, January 28, 2020 at 8:31:44 PM UTC+1, rbon wrote: Bob, Are you using the cas management server, https://github.com/apereo/cas-management-overlay? If you are, what do the logs say when you try to save? Ray On Tue, 2020-01-28 at 03:50 -0800, Bob wrote: 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 -- Ray Bon Programmer Analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected]<javascript:> I respectfully acknowledge that my place of work is located within the ancestral, traditional and unceded territory of the Songhees, Esquimalt and WSÁNEĆ Nations. -- Ray Bon Programmer Analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected]<mailto:[email protected]> I respectfully acknowledge that my place of work is located within the ancestral, traditional and unceded territory of the Songhees, Esquimalt and WSÁNEĆ Nations. -- - 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/64855648beb25aa7ceeabb160b6dfabd2c4c0a2a.camel%40uvic.ca.
