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 | rb...@uvic.ca<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 | rb...@uvic.ca<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 | rb...@uvic.ca<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 | r...@uvic.ca<mailto:r...@uvic.ca> 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/64855648beb25aa7ceeabb160b6dfabd2c4c0a2a.camel%40uvic.ca.
