Hi Fahmi,
We faced the same issue with managment console. In our case, that error
is not related to the database configuration or the saving action itself
but the GIT versioning functionalitiy of management console
(https://apereo.github.io/cas-management/5.3.x/installation/Installing-ServicesMgmt-Webapp.html#version-control).
I noticed you have "cas.serviceRegistry.jpa.ddlAuto = create-drop"
Using that configuration every time the server is stopped your DB schema
is dropped and of course your services.
Could this be your real issue?
Regards, Facundo
El miércoles, 20 de marzo de 2019, 9:09:59 (UTC-3), Fahmi L. Ramdhani
escribió:
>
> Hello,
>
> I am running CAS 5.3.6 and Management Webapp 5.3.6. The point of the
> problem is not saving to the MySQL Database. This is based on the settings
> below.
>
> *pom.xml (CAS)*
>
> <dependencies>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-webapp${app.server}</artifactId>
> <version>${cas.version}</version>
> <type>war</type>
> <scope>runtime</scope>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jdbc</artifactId>
> <version>${cas.version}</version>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jdbc-drivers</artifactId>
> <version>${cas.version}</version>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jpa-service-registry</artifactId>
> <version>${cas.version}</version>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jpa-ticket-registry</artifactId>
> <version>${cas.version}</version>
> </dependency>
> <!--
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-json-service-registry</artifactId>
> <version>${cas.version}</version>
> </dependency>
> -->
> <dependency>
> <groupId>org.springframework.security</groupId>
> <artifactId>spring-security-core</artifactId>
> <version>5.1.1.RELEASE</version>
> </dependency>
> <dependency>
> <groupId>org.springframework.security</groupId>
> <artifactId>spring-security-crypto</artifactId>
> <version>5.1.1.RELEASE</version>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-oauth-webflow</artifactId>
> <version>${cas.version}</version>
> </dependency>
> </dependencies>
>
> *pom.xml (CAS Management)*
>
> <dependencies>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-management-webapp</artifactId>
> <version>${cas-mgmt.version}</version>
> <type>war</type>
> </dependency>
> </dependencies>
>
> *cas.properties (json registry has disabled)*
>
> ## JSON Service Registry
> ## ================================================================
> ## cas.serviceRegistry.json.location = file:/etc/cas/services
>
>
> ## JPA Service Registry
> ## ================================================================
> cas.serviceRegistry.jpa.url = jdbc:mysql:
> //localhost:3306/registry?useLegacyDatetimeCode=false&serverTimezone=UTC
> cas.serviceRegistry.jpa.user = root
> cas.serviceRegistry.jpa.password = secret
> cas.serviceRegistry.jpa.ddlAuto = create-drop
> cas.serviceRegistry.jpa.driverClass = com.mysql.cj.jdbc.Driver
> cas.serviceRegistry.jpa.dialect = org.hibernate.dialect.MySQL5Dialect
>
> *management.properties (CAS Management)*
>
> cas.server.name = https://sso.example.com
> cas.server.prefix = ${cas.server.name}/cas
>
>
> mgmt.adminRoles[0] = ROLE_ADMIN
> mgmt.userPropertiesFile = file:/etc/cas/config/admusers-management.
> properties
> mgmt.serverName = https://sso.example.com:8443
>
>
> server.context-path=/cas-management
> server.port=8443
>
>
> cas.serviceRegistry.jpa.url = jdbc:mysql://localhost:3306/registry?
> useLegacyDatetimeCode=false&serverTimezone=UTC
> cas.serviceRegistry.jpa.user = root
> cas.serviceRegistry.jpa.password = secret
> cas.serviceRegistry.jpa.ddlAuto = create-drop
> cas.serviceRegistry.jpa.driverClass = com.mysql.cj.jdbc.Driver
> cas.serviceRegistry.jpa.dialect = org.hibernate.dialect.MySQL5Dialect
>
>
> *ERROR LOG (CAS-MANAGEMENT.LOG)*
>
> INFO [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] -
> Audit trail record BEGIN
> =============================================================
> WHO: superadmin
> WHAT: AbstractRegisteredService(serviceId=^https:\/\/portal.example.com(\\
> z|\/.*), name=Portal Example, theme=null, infor...
> ACTION: SAVE_SERVICE_SUCCESS
> APPLICATION: CAS_Management
> WHEN: Wed Mar 20 07:51:01 EDT 2019
> CLIENT IP ADDRESS: 107.121.112.220
> SERVER IP ADDRESS: 172.16.2.53
> =============================================================
>
>
> 2019-03-20 07:51:23,411 ERROR [org.apereo.cas.mgmt.services.web.
> ServiceRepositoryController] - null
> java.lang.NullPointerException: null
> at org.apereo.cas.mgmt.services.web.ServiceRepositoryController.
> isPublishedBehind(ServiceRepositoryController.java:259) ~[cas-management-
> webapp-support-5.3.6.jar:5.3.6]
> at org.apereo.cas.mgmt.services.web.ServiceRepositoryController.gitStatus(
> ServiceRepositoryController.java:331) [cas-management-webapp-support-5.3.
> 6.jar:5.3.6]
> at sun.reflect.GeneratedMethodAccessor368.invoke(Unknown Source) ~[?:?]
> 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.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:133) [spring-web-4.3.
> 17.RELEASE.jar:4.3.17.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]
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:738) [spring-webmvc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
> at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter
> .handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.3.
> 17.RELEASE.jar:4.3.17.RELEASE]
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(
> DispatcherServlet.java:967) [spring-webmvc-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.servlet.DispatcherServlet.doService(
> DispatcherServlet.java:901) [spring-webmvc-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:970) [spring-webmvc-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet
> .java:861) [spring-webmvc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) [servlet-
> api.jar:?]
> at org.springframework.web.servlet.FrameworkServlet.service(
> FrameworkServlet.java:846) [spring-webmvc-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-
> api.jar:?]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:231) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> [tomcat-websocket.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.
> doFilterInternal(ApplicationContextHeaderFilter.java:55) [spring-boot-1.5.
> 14.RELEASE.jar:1.5.14.RELEASE]
>
>
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.web.filter.HttpPutFormContentFilter.
> doFilterInternal(HttpPutFormContentFilter.java:109) [spring-web-4.3.
> 17.RELEASE.jar:4.3.17.RELEASE]
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(
> HiddenHttpMethodFilter.java:81) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.boot.actuate.autoconfigure.MetricsFilter.
> doFilterInternal(MetricsFilter.java:106) [spring-boot-actuator-1.5.
> 14.RELEASE.jar:1.5.14.RELEASE]
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal
> (CharacterEncodingFilter.java:197) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.springframework.boot.web.support.ErrorPageFilter.doFilter(
> ErrorPageFilter.java:130) [spring-boot-1.5.14.RELEASE.jar:1.5.14.RELEASE]
> at org.springframework.boot.web.support.ErrorPageFilter.access$000(
> ErrorPageFilter.java:66) [spring-boot-1.5.14.RELEASE.jar:1.5.14.RELEASE]
> at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal
> (ErrorPageFilter.java:105) [spring-boot-1.5.14.RELEASE.jar:1.5.14.RELEASE]
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(
> OncePerRequestFilter.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.
> 17.RELEASE]
> at org.springframework.boot.web.support.ErrorPageFilter.doFilter(
> ErrorPageFilter.java:123) [spring-boot-1.5.14.RELEASE.jar:1.5.14.RELEASE]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(
> Log4jServletFilter.java:71) [log4j-web-2.11.0.jar:2.11.0]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193) [catalina.jar:8.5.35]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166) [catalina.jar:8.5.35]
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:198) [catalina.jar:8.5.35]
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:96) [catalina.jar:8.5.35]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:493) [catalina.jar:8.5.35]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
> java:140) [catalina.jar:8.5.35]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
> java:81) [catalina.jar:8.5.35]
> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(
> AbstractAccessLogValve.java:650) [catalina.jar:8.5.35]
> at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685)
> [catalina.jar:8.5.35]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:87) [catalina.jar:8.5.35]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 342) [catalina.jar:8.5.35]
> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:
> 800) [tomcat-coyote.jar:8.5.35]
> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight
> .java:66) [tomcat-coyote.jar:8.5.35]
> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(
> AbstractProtocol.java:806) [tomcat-coyote.jar:8.5.35]
> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(
> NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.35]
> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.
> java:49) [tomcat-coyote.jar:8.5.35]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1149) [?:1.8.0_191]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> java:624) [?:1.8.0_191]
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61) [tomcat-util.jar:8.5.35]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
>
>
> Can you help me?
> Thank you.
>
--
- 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/cbc57f47-9e6d-470f-b0b6-0641692ce9d3%40apereo.org.
