Bob,
You can see what SQL is being created,
https://apereo.github.io/cas/6.1.x/configuration/Configuration-Properties-Common.html#hibernate--jdbc.
Also turn up logging, maybe for org.springframework.orm.jpa, or add an entry
for hibernate.
Ray
On Thu, 2020-01-30 at 04:00 -0800, 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<http://cas.server.name>: https://localhost:8443
cas.server.prefix: ${cas.server.name<http://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 | rb...@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.
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
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
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 | 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/4a54077ee21e5d8e901c60e41260394ee76d8ff2.camel%40uvic.ca.
