Hello Ray, thank for your reply. I changed the configuration: - Adding cas.jdbc.showSql=true to cas.properties and management.properties - Adding healthQuery to cas.properties and management.properties - Change ddlAuto to update - Rebuilding project cas and management
Log showing (*cas.log*) 2019-03-20 22:51:33,260 INFO [org.apereo.cas.services.AbstractServicesManager] - <Loaded [1] service(s) from [JpaServiceRegistry].> 2019-03-20 22:51:43,276 DEBUG [org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <Attempting to acquire ticket cleanup lock.> 2019-03-20 22:51:43,314 DEBUG [org.apereo.cas.ticket.registry.support.JpaLockingStrategy] - <Creating [cas-ticket-registry-cleaner] lock initially held by [web-01].> 2019-03-20 22:51:43,364 DEBUG [org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <Acquired lock. Proceeding with cleanup.> 2019-03-20 22:51:43,378 DEBUG [org.apereo.cas.ticket.DefaultTicketCatalog] - <Located all registered and known sorted ticket definitions [[DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.ServiceTicketImpl, prefix=ST, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=null, storageTimeout=0, storagePassword=null), order=-2147483648), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.ProxyTicketImpl, prefix=PT, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=null, storageTimeout=0, storagePassword=null), order=-2147483648), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.TicketGrantingTicketImpl, prefix=TGT, properties=DefaultTicketDefinitionProperties(cascade=true, storageName=null, storageTimeout=0, storagePassword=null), order=2147483647), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.refreshtoken.RefreshTokenImpl, prefix=RT, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=oauthRefreshTokensCache, storageTimeout=2592000, storagePassword=null), order=2147483647), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.accesstoken.AccessTokenImpl, prefix=AT, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=oauthAccessTokensCache, storageTimeout=28800, storagePassword=null), order=2147483647), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.TransientSessionTicketImpl, prefix=TST, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=null, storageTimeout=0, storagePassword=null), order=2147483647), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.code.OAuthCodeImpl, prefix=OC, properties=DefaultTicketDefinitionProperties(cascade=false, storageName=oauthCodesCache, storageTimeout=30, storagePassword=null), order=2147483647), DefaultTicketDefinition(implementationClass=class org.apereo.cas.ticket.ProxyGrantingTicketImpl, prefix=PGT, properties=DefaultTicketDefinitionProperties(cascade=true, storageName=null, storageTimeout=0, storagePassword=null), order=2147483647)]]> 1. Adding 2 initial service registry using MySQL Workbench 2. I am login successfully to Services Management (screen shoot in attachment). 3. I am try to add an service registry, then save it. 4. Successfully added an service registry, but it is not stored in the database. 5. The table still displays 2 rows (not 3 rows, 1 added in service management) Log show (*cas-management.log*, not showing SQL QUERIES) ============================================================= WHO: superadmin WHAT: AbstractRegisteredService(serviceId=^https:\/\/portal. example.com(\\z|\/.*), name=Asia, theme=null, informationU... ACTION: SAVE_SERVICE_SUCCESS APPLICATION: CAS_Management WHEN: Wed Mar 20 23:03:24 EDT 2019 CLIENT IP ADDRESS: 103.xxx.1x8.xxx SERVER IP ADDRESS: 172.16.2.53 ============================================================= 2019-03-20 23:04:04,149 ERROR [org.apereo.cas.mgmt.GitUtil] - Git repository not found/initialized at [/etc/cas/services-repo/.git] 2019-03-20 23:04:04,149 ERROR [org.apereo.cas.mgmt.services.web. ServiceRepositoryController] - repository not found: /etc/cas/services-repo /.git java.lang.RuntimeException: repository not found: /etc/cas/services-repo/. git at org.apereo.cas.mgmt.GitUtil.initializeGitRepository(GitUtil.java:1225) ~[ cas-management-webapp-support-5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.GitUtil.<init>(GitUtil.java:100) ~[cas-management- webapp-support-5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.services.web.factory.RepositoryFactory.buildGitUtil( RepositoryFactory.java:81) ~[cas-management-webapp-support-5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.services.web.factory.RepositoryFactory. masterRepository(RepositoryFactory.java:70) ~[cas-management-webapp-support- 5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.services.web.factory.RepositoryFactory.from( RepositoryFactory.java:53) ~[cas-management-webapp-support-5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.services.web.factory.RepositoryFactory.from( RepositoryFactory.java:40) ~[cas-management-webapp-support-5.3.6.jar:5.3.6] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191 ] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java :62) ~[?:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191] at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils. java:216) ~[spring-core-4.3.17.RELEASE.jar:4.3.17.RELEASE] at org.springframework.cloud.context.scope. GenericScope$LockedScopedProxyFactoryBean.invoke(GenericScope.java:470) ~[ spring-cloud-context-1.3.0.RELEASE.jar:1.3.0.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.18.RELEASE.jar:4.3. 18.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor .intercept(CglibAopProxy.java:671) ~[spring-aop-4.3.18.RELEASE.jar:4.3. 18.RELEASE] at org.apereo.cas.mgmt.services.web.factory. RepositoryFactory$$EnhancerBySpringCGLIB$$892cee48.from(<generated>) ~[cas- management-webapp-support-5.3.6.jar:5.3.6] at org.apereo.cas.mgmt.services.web.ServiceRepositoryController.gitStatus( ServiceRepositoryController.java:322) [cas-management-webapp-support-5.3. 6.jar:5.3.6] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_191 ] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java :62) ~[?:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( InvocableHandlerMethod.java:205) [spring-web-4.3.18.RELEASE.jar:4.3. 18.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod. invokeForRequest(InvocableHandlerMethod.java:133) [spring-web-4.3.18.RELEASE .jar:4.3.18.RELEASE] at org.springframework.web.servlet.mvc.method.annotation. ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod. java:97) [spring-webmvc-4.3.17.RELEASE.jar:4.3.17.RELEASE] at org.springframework.web.servlet.mvc.method.annotation. RequestMappingHandlerAdapter.invokeHandlerMethod( RequestMappingHandlerAdapter.java:827) [spring-webmvc-4.3.17.RELEASE.jar:4.3 .17.RELEASE] I set ddlAuto = create-drop because it knows the table structure used by CAS. Or is there another way to find out the structure of the table? Now I change it to update. Yes, I run a server and management on the same server. I don't understand about this problem. Log displays do not match the configuration. Can someone solve this problem? Thank you. Pada Kamis, 21 Maret 2019 07.12.05 UTC+7, rbon menulis: > > 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 > > -- > Ray Bon > Programmer analyst > Development Services, University Systems > 2507218831 | CLE 019 | [email protected] <javascript:> > > -- - 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/6071e7e2-4c5d-4f0d-898f-234ce53444af%40apereo.org.
