Relution MDM zickt rum

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

Guten Tag Rei,

konnte Ihnen bereits geholfen werden? Falls nicht, können Sie sich jederzeit an uns wenden.

Beste Grüße
Team Relution

Vielen Dank für das Angebot - ich habe nach der Niederlage am 1. April die Segel gestrichen und das MDM Projekt auf unbestimmte Zeit auf Eis gelegt.

Mir scheint, dass ich mir da wohl oder übel meinen eigenen Container dazu stricken darf, damit nicht die oben erwähnten Komplikationen auftreten.

lg
Rei

Um die Sache hier für nachfolgende Besucher etwas klarer zu halten:

Der von Univention mit installierte MySQL-Server scheint nicht den Vorgaben von Relution zu entsprechen. Ich habe mir die Freiheit genommen einen aktuellen MariaDB Server zu verwenden und die mysql_send_long_data auf 1 GB zu setzen. Somit lief es.

Mastodon