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. > -- - 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/20119c0c-a639-46e1-ab21-3d97cbeae343%40apereo.org.
