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 | r...@uvic.ca -- - 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/1553127119.3399.68.camel%40uvic.ca.