Hello Michele,
Finally managed to get it working by commenting out the code you mentioned.
Now it does read the JSON files and store it in MySQL database.
I exported the database records as a SQL script and then reinstated the
code so it should be good to go.
Thank you very much again!
Regards,
Bob
On Saturday, March 14, 2020 at 12:20:46 AM UTC+1, Michele Melluso wrote:
>
> Hi Bob,
>
> I had a similar regression from 6.0 to 6.1. The problem is that
> EmbeddedResourceBasedServiceRegistry is registered in the registries chain.
>
> So, when the ServiceRegistryInitializer.java checks at row 66 if the json
> service exists already, it is found from
> EmbeddedResourceBasedServiceRegistry and then it is not added to
> JpaTicketRegistry.
>
> I solved somehow by avoiding the
> "embeddedJsonServiceRegistryExecutionPlanConfigurer" bean, just commenting
> it away in CasServiceRegistryInitializationConfiguration.java
>
> // @Bean
> // @ConditionalOnMissingBean(name =
> "embeddedJsonServiceRegistryExecutionPlanConfigurer")
> // public ServiceRegistryExecutionPlanConfigurer
> embeddedJsonServiceRegistryExecutionPlanConfigurer() {
> // return plan ->
> plan.registerServiceRegistry(embeddedJsonServiceRegistry());
> // }
>
> I don't know if there will be any collateral problems, by the way now json
> services are correctly copied on JpaTicketRegistry.
> Wouldn't know how to fix it in a clean way as to make a pr.
>
> Hope it helps
> Regards
> Michele
>
>
> On Thursday, January 30, 2020 at 1:00:47 PM UTC+1, Bob wrote:
>>
>> Thanks Misagh and Ray,
>>
>> I cloned the cas-overlay-template in a new location and used the settings
>> Misagh suggested but I still have the same problem that my casdb still has
>> an empty regex_registered_service table.
>> Here's what I'm using:
>>
>> Here's what I'm using:
>>
>> CAS Version: 6.1.0
>> CAS Branch: 6.1.x
>> CAS Commit Id: c92590730249df0cf26fd1b4bebd8aea8447b256
>> CAS Build Date/Time: 2019-10-28T02:43:18Z
>> Spring Boot Version: 2.2.0.RELEASE
>> Spring Version: 5.2.0.RELEASE
>> Java Home: C:\Programs\Java\amazon-corretto\jdk11.0.3_7
>> Java Vendor: Amazon.com Inc.
>> Java Version: 11.0.3
>>
>>
>> My dependencies in build.gradle:
>>
>> dependencies {
>> // Other CAS dependencies/modules may be listed here...
>> compile
>> "org.apereo.cas:cas-server-support-ldap:${project.'cas.version'}"
>> compile
>> "org.apereo.cas:cas-server-support-jdbc-drivers:${project.'cas.version'}"
>> compile
>> "org.apereo.cas:cas-server-support-jpa-service-registry:${project.'cas.version'}"
>> }
>>
>>
>> My minimum cas.propertie (I omitted the LDAP part since that's working
>> fine):
>>
>> cas.server.name: https://localhost:8443
>> cas.server.prefix: ${cas.server.name}/cas
>>
>> logging.config: file:/etc/cas/config/log4j2.xml
>>
>> server.ssl.key-store=file:/etc/cas/keystore.jks
>> server.ssl.key-store-password=xxxxxxxx
>> server.ssl.key-password=xxxxxxx
>>
>> cas.serviceRegistry.initFromJson=true
>> cas.serviceRegistry.json.location=file:/etc/cas/config/services
>>
>> cas.serviceRegistry.jpa.user=xxxxxxxxxx
>> cas.serviceRegistry.jpa.password=xxxxxxxxxxx
>> cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver
>>
>> cas.serviceRegistry.jpa.url=jdbc:mysql://localhost:3306/casdb?allowPublicKeyRetrieval=true&characterEncoding=UTF-8&useSSL=FALSE
>> cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL57InnoDBDialect
>> cas.serviceRegistry.jpa.ddlAuto=update
>>
>>
>> When I run CAS 6.1.0 I see:
>>
>> [org.apereo.cas.services.AbstractServicesManager] - <Loaded [1]
>> service(s) from [EmbeddedResourceBasedServiceRegistry,JpaServiceRegistry].>
>>
>>
>> I can then use CAS to login to my application, but it does not insert any
>> Service Registry into the MySQL casdb.
>> Do you see anything wrong in my setup?
>> Thanks,
>>
>> Bob
>>
>> On Wednesday, January 29, 2020 at 11:21:24 AM UTC+1, Misagh Moayyed wrote:
>>>
>>>
>>> Something along the following lines should work:
>>>
>>> cas.serviceRegistry.initFromJson=true
>>> cas.serviceRegistry.json.location=file:/etc/cas/config/services
>>>
>>> - Then, make sure your JSON files are in the above noted directory.
>>> - Then, make sure your overlay contains a reference to the JPA service
>>> registry
>>>
>>> (You do not need to include the JSON service registry, IIRC, in the
>>> overlay)
>>>
>>> Then, on startup, CAS will import your JSON files from that directory
>>> over to the real (JPA) service registry.
>>>
>>> YMMV.
>>>
>>>
>>> On Wednesday, January 29, 2020 at 12:56:11 AM UTC+4, rbon wrote:
>>>>
>>>> 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]
>>>>
>>>> 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]
>>>>
>>>> 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]
>>>>
>>>> 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]
>>>>
>>>> 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/33cce2ed-7401-4b6e-a26d-dfa96f373f52%40apereo.org.
