Hi Leute,
Ich hab’ irgendwie Pech mit dem Relution MDM, welches ich hier gerade evaluiere und dabei grausam auf die Schnauze falle.
Erstmal ein SQL Problem:
Call: INSERT INTO `mdm_dvc_instlld_app` (`uuid`, `bundle_size`, `dynamic_size`, `first_installation_date`, `flags`, `identifier`, `is_validated`, `last_update_date`, `managed`, `name`, `publisher`, `short_version`, `version`, `version_code`, `device_uuid`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [D692302F-9224-48BA-9592-AD00BD1B418B, null, null, ***censored*** , 948485701, com.nb.aging, null, ***censored***, false, 老化测试, null, null, 1.0, 1, FD202A96-A8F8-4AA5-A298-7800CF257E29]
Query: InsertObjectQuery(InstalledApp [uuid=D692302F-9224-48BA-9592-AD00BD1B418B, deviceUuid=FD202A96-A8F8-4AA5-A298-7800CF257E29, name=老化测试, identifier=com.nb.aging, versionCode=1, firstInstallDate=1468209191000, lastUpdateDate=1468209191000, version=1.0, managed=false, flags=948485701, publisher=null])
Das Ding lies sich dadurch halbwegs in den Griff kriegen, indem man die Datenbank auf UTF-8 umbaut.
Nächstes Problem ist etwas größer und sieht wie folgt in den Logs aus:
2018-03-21 22:21:46,646 WARN - Error fetching file content (authorization=6FD794FB-A6DE-45C9-97FB-7074845D7A92; request=00000162-4aa3-d938-0000-000000000279)
org.eclipse.jetty.io.EofException: timeout
at org.eclipse.jetty.http.AbstractGenerator.blockForOutput(AbstractGenerator.java:527)
at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:170)
at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:107)
at com.sun.jersey.spi.container.servlet.WebComponent$Writer.write(WebComponent.java:300)
at com.sun.jersey.spi.container.ContainerResponse$CommittingOutputStream.write(ContainerResponse.java:135)
at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:1793)
at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:1769)
at org.apache.commons.io.IOUtils.copy(IOUtils.java:1744)
at com.mwaysolutions.relution.common.resource.service.impl.SQLResourceStreamingImpl.fetchFileContent(SQLResourceStreamingImpl.java:128)
at com.mwaysolutions.relution.common.resource.service.impl.ResourceRepositoryImpl.fetchFileContent(ResourceRepositoryImpl.java:222)
at com.mwaysolutions.relution.common.resource.service.impl.ResourceServiceImpl.fetchFileContent(ResourceServiceImpl.java:246)
at com.mwaysolutions.relution.common.resource.ccl.impl.ResourceResource.lambda$handleGetRequest$6(ResourceResource.java:401)
at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:71)
at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:57)
at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:302)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
at com.mwaysolutions.gofer2.rest.filter.SwaggerFilter.doFilter(SwaggerFilter.java:188)
at com.mwaysolutions.gofer2.rest.filter.SwaggerFilter.doFilter(SwaggerFilter.java:146)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.atmosphere.AtmosphereFilterImpl.doFilter(AtmosphereFilterImpl.java:343)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.file.upload.TempFileFilter.doFilter(TempFileFilter.java:69)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.filter.HttpOptionsFilter.doFilter(HttpOptionsFilter.java:150)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.filter.AccessSecurityFilter.doFilter(AccessSecurityFilter.java:232)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.filter.TenantOrganizationFilter.doFilter(TenantOrganizationFilter.java:83)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:54)
at com.mwaysolutions.gofer2.security.filter.AccessPreconditionFilter.doFilter(AccessPreconditionFilter.java:98)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:50)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:54)
at com.mwaysolutions.gofer2.security.filter.AccessTokenFilter.doFilter(AccessTokenFilter.java:111)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:50)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.filter.BasicHttpAuthSecurityFilter.doFilter(BasicHttpAuthSecurityFilter.java:168)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.filter.HttpSessionAuthSecurityFilter.handleNoAuthorization(HttpSessionAuthSecurityFilter.java:225)
at com.mwaysolutions.gofer2.security.filter.HttpSessionAuthSecurityFilter.doFilter(HttpSessionAuthSecurityFilter.java:190)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.security.oauth.server.filter.OAuthSecurityFilter.doFilter(OAuthSecurityFilter.java:153)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:54)
at com.mwaysolutions.relution.common.filter.RelutionSecurityFilter.access$001(RelutionSecurityFilter.java:70)
at com.mwaysolutions.relution.common.filter.RelutionSecurityFilter.lambda$doAsUser$1(RelutionSecurityFilter.java:227)
at com.mwaysolutions.gofer2.security.service.impl.SecurityServiceImpl.runAs(SecurityServiceImpl.java:1128)
at com.mwaysolutions.relution.common.filter.RelutionSecurityFilter.doAsUser(RelutionSecurityFilter.java:225)
at com.mwaysolutions.relution.common.filter.RelutionSecurityFilter.doAsDeviceRequest(RelutionSecurityFilter.java:207)
at com.mwaysolutions.relution.common.filter.RelutionSecurityFilter.doFilter(RelutionSecurityFilter.java:118)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:50)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.HttpServletRequestHolderFilter.doFilter(HttpServletRequestHolderFilter.java:262)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.ServerVersionInfoFilter.doFilter(ServerVersionInfoFilter.java:198)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:54)
at com.mwaysolutions.gofer2.jetty.filter.LegacyRedirectFilter.doFilter(LegacyRedirectFilter.java:104)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:50)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:54)
at com.mwaysolutions.gofer2.jetty.filter.HttpResponseHeaderFilter.doFilter(HttpResponseHeaderFilter.java:124)
at com.mwaysolutions.gofer2.web.utils.HttpFilter.doFilter(HttpFilter.java:50)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.DateFilter.doFilter(DateFilter.java:67)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.CharsetFilter.doFilter(CharsetFilter.java:83)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.CORSFilter.doFilter(CORSFilter.java:88)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.AutoFillFilter.doFilter(AutoFillFilter.java:66)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at com.mwaysolutions.gofer2.jetty.filter.AccessLogFilter.doFilter(AccessLogFilter.java:82)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:82)
at com.mwaysolutions.gofer2.jetty.filter.GzipFilter.doFilter(GzipFilter.java:306)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:69)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:219)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:77)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:370)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:748)
2018-03-21 22:21:46,648 INFO - Fall through to SQL storage for resource 3859B314-6A65-4CAD-BC96-1CA56F18D031 (authorization=6FD794FB-A6DE-45C9-97FB-7074845D7A92; request=00000162-4aa3-d938-0000-000000000279)
und äußert sich dadurch, dass man keine Dateien aus dem Relution “App-Store” runterladen kann bzw auch keine APK Dateien (zB F-Droid) damit verteilen kann.
Weiters zickt der Mailversand, was ich auf ein Blockieren von Port 25 nach Außen zurückführe. Grüße von Iptables.
Alles in Allem scheint mir da ein bisschen mehr quer zu schießen als für den einwandfreien Betrieb von Nöten ist. Bin ich die Einzige mit den Problemen oder kennt jemand bereits die Thematik?
lg
Rei
P.S.:
Ich verwende hier UCS 4.2.3 - errata313