Fahmi,
ddlAuto should be set to 'none' or 'update'.
You can also set cas.jdbc.showSql=true to see queries in the logs.
There is also a health query healthQuery='select ...'
Are you running CAS and management server on the same tomcat at the same time
or do you shut one down and start the other?
The create-drop will drop the database during tomcat shutdown.
After you create a service, check to see that it is there with mysql command
line tool.
This might give some info in the logs:
<!-- INFO Loaded [#] service(s) from [???ServiceRegistryDAO]
DEBUG Adding registered service [service URL] -->
<AsyncLogger name="org.apereo.cas.services.AbstractServicesManager"
level="debug" />
Ray
On Wed, 2019-03-20 at 14:33 -0700, Fahmi L. Ramdhani wrote:
Thanks for your replies.
I added the service via CAS Service Manangement
(https://sso.example.com/cas-management/manage.html), but it was not saved in
the database. Please help review my CAS configuration (in attachment).
Can you help me please. Thank you.
Pada Rabu, 20 Maret 2019 23.01.06 UTC+7, Facundo Mateo menulis:
I am assuming you don't have version control enabled.
After you add the service through console, is your service shown in Management
console list? If so it should be in your service registry database.
I have the same exception you describe if version control is not enabled but I
am still able to save the registry to database.
May be you could increase console log level to debug and set
"cas.jdbc.showSql=true" to see whats really happening.
--
Ray Bon
Programmer analyst
Development Services, University Systems
2507218831 | CLE 019 | [email protected]
--
- 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/1553127119.3399.68.camel%40uvic.ca.