OX Fehler in den Filterregeln gelöst

MHoener · November 11, 2019, 10:00am

Hallo zusammen,

ich habe zwei Server ein Master und ein Slave.
Der Slave ist etwas später hinzugekommen und beinhaltet die OX Installation.
Dies User sind alle im ersten Schritt auf dem Master angelegt worden und der läuft seit einem Jahr.
Jetzt soll die Emaillösung über OX auf der zweiten Maschine laufen.

Soweit alles gut, nur bekomme ich wenn die alten User in die Filterregeln wollen “Einstellungen für Mailfilterregeln konnte nicht geladen werden.”

Lege ich einen neuen User an und gebe ihm die APP OX ist alles in Ordnung und er kann Filterregeln erstellen.

Woran kann das bitte liegen und wie kann ich es beheben?

Gruß
Michael

troeder · November 11, 2019, 1:47pm

OX schreibt sich den zu verwendenden IMAP-Server (der auch für Sieve genutzt wird) in die eigene MySQL-Datenbank. Der Wert dort kann entweder direkt über /opt/open-xchange/sbin/changeuser geändert werden (Doku: http://oxpedia.org/wiki/index.php?title=AppSuite:User_management) oder durch das Auslösen einer Aktivität des Listener Moduls. Dazu bedarf es einer Änderung am User, z.B. der Änderung des Vornames/Geburtsdatums/Anschrift. Wenn letzteres klappt, ist es dem händischen Anwenden von changeuser zu bevorzugen.

Verwenden Sie zum Anschauen der in der OX-Datenbank gespeicherten Werte des Users USERNAME:

/opt/open-xchange/sbin/listuser -c 10 -A oxadmin -P "$(</etc/ox-secrets/context10.secret)" -s USERNAME --csv

MHoener · November 11, 2019, 5:22pm

Ich habe das jetzt zwischen zwei Usern verglichen und habe leider keine Abweichung feststellen können. die IMAP Server sind beide gleich.
Auch wenn ich z.b. Abwesenheitsbenachrichtigung einstellen will kommt diese Meldung

Auf Mailfilter-Backend konnte nicht zugegriffen werden was ja drauf deutet das er nicht auf die Mailfilter Einstellungen zugreifen kann.

troeder · November 12, 2019, 7:25am

Steht im Logfile von OX (/var/log/open-xchange/open-xchange.log.0) etwas?

MHoener · November 12, 2019, 8:32am

2019-11-12T09:27:26,291+0100 INFO [OXWorker-0001230] com.openexchange.login.internal.LoginPerformer.logLoginRequest(LoginPerformer.java:705)
Login:KSurmund IP:10.0.0.1 AuthID:d94681ea424440c9b3e71c0681e7ba4d Agent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36 Client:open-xchange-appsuite(7.10.2-7) Interface:HTTP_JSON Context:10(10,cohausz-leuchten.de,cohausz-leuchten.int,context10) User:53(KSurmund) Session:e4eb0c9460cb453a9d62ab7d668998b1 Random:afb42b3544214f9e9bc6b36d72612402 Transient:false
com.openexchange.database.schema=localhost_5
com.openexchange.grizzly.method=POST
com.openexchange.grizzly.queryString=
com.openexchange.grizzly.remoteAddress=10.0.0.1
com.openexchange.grizzly.remotePort=45036
com.openexchange.grizzly.requestURI=/ajax/login
com.openexchange.grizzly.serverName=10.0.10.70
com.openexchange.grizzly.servletPath=/ajax/login
com.openexchange.grizzly.session=1130114761102084696.OX0
com.openexchange.grizzly.threadName=OXWorker-0001230
com.openexchange.grizzly.userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36
com.openexchange.localhost.ipAddress=10.0.10.70
com.openexchange.localhost.version=7.10.2-Rev9
com.openexchange.login.authId=d94681ea424440c9b3e71c0681e7ba4d
com.openexchange.login.client=open-xchange-appsuite
com.openexchange.login.clientIp=10.0.0.1
com.openexchange.login.login=KSurmund
com.openexchange.login.resolvedLogin=KSurmund
com.openexchange.login.userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36
com.openexchange.login.version=7.10.2-7
com.openexchange.request.trackingId=1861695518-930858855
com.openexchange.session.authId=d94681ea424440c9b3e71c0681e7ba4d
com.openexchange.session.clientId=open-xchange-appsuite
com.openexchange.session.contextId=10
com.openexchange.session.loginName=KSurmund
com.openexchange.session.sessionId=e4eb0c9460cb453a9d62ab7d668998b1
com.openexchange.session.userId=53
com.openexchange.session.userName=KSurmund
2019-11-12T09:27:28,436+0100 ERROR [OXWorker-0001235] com.openexchange.ajax.requesthandler.DispatcherServlet.logException(DispatcherServlet.java:731)
Error processing request.
com.openexchange.ajax.action=list
com.openexchange.ajax.module=mailfilter/v2
com.openexchange.grizzly.method=GET
com.openexchange.grizzly.queryString=action=list&flag=vacation&session=e4eb0c9460cb453a9d62ab7d668998b1
com.openexchange.grizzly.remoteAddress=10.0.0.1
com.openexchange.grizzly.remotePort=45076
com.openexchange.grizzly.requestURI=/ajax/mailfilter/v2
com.openexchange.grizzly.serverName=10.0.10.70
com.openexchange.grizzly.servletPath=/ajax/mailfilter/v2
com.openexchange.grizzly.threadName=OXWorker-0001235
com.openexchange.grizzly.userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36
com.openexchange.hostname=hansolo.cohausz-leuchten.int
com.openexchange.localhost.ipAddress=10.0.10.70
com.openexchange.localhost.version=7.10.2-Rev9
com.openexchange.request.trackingId=1861695518-930858868
com.openexchange.session.authId=d94681ea424440c9b3e71c0681e7ba4d
com.openexchange.session.clientId=open-xchange-appsuite
com.openexchange.session.contextId=10
com.openexchange.session.loginName=KSurmund
com.openexchange.session.sessionId=e4eb0c9460cb453a9d62ab7d668998b1
com.openexchange.session.userId=53
com.openexchange.session.userName=KSurmund
com.openexchange.exception.OXException: MAIL_FILTER-0015 Categories=ERROR Message=‘Error while communicating with the sieve server hansolo.cohausz-leuchten.int at port 4190 for user KSurmund in context 10’ exceptionID=1861695518-4663
com.openexchange.exception.locale: de_DE
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:182)
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:172)
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:145)
at com.openexchange.mailfilter.exceptions.MailFilterExceptionCode.create(MailFilterExceptionCode.java:321)
at com.openexchange.mailfilter.exceptions.MailFilterExceptionCode.handleParsingException(MailFilterExceptionCode.java:365)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:516)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:479)
at com.openexchange.mail.filter.json.v2.actions.ListMailFilterAction.perform(ListMailFilterAction.java:108)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.doCallAction(DefaultDispatcher.java:600)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.callAction(DefaultDispatcher.java:576)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.doPerform(DefaultDispatcher.java:544)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.perform(DefaultDispatcher.java:261)
at com.openexchange.ajax.requesthandler.DispatcherServlet.handle(DispatcherServlet.java:482)
at com.openexchange.ajax.requesthandler.DispatcherServlet.doGet(DispatcherServlet.java:376)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:686)
at com.openexchange.ajax.AJAXServlet.doService(AJAXServlet.java:570)
at com.openexchange.ajax.SessionServlet.doService(SessionServlet.java:173)
at com.openexchange.ajax.requesthandler.DispatcherServlet.service(DispatcherServlet.java:276)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:124)
at com.openexchange.http.grizzly.servletfilter.RequestReportingFilter.doFilter(RequestReportingFilter.java:138)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at com.openexchange.http.grizzly.servletfilter.WrappingFilter.doFilter(WrappingFilter.java:223)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at com.openexchange.http.grizzly.service.http.OSGiAuthFilter.doFilter(OSGiAuthFilter.java:139)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at org.glassfish.grizzly.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:83)
at org.glassfish.grizzly.servlet.ServletHandler.doServletService(ServletHandler.java:202)
at org.glassfish.grizzly.servlet.ServletHandler.service(ServletHandler.java:154)
at com.openexchange.http.grizzly.service.http.OSGiMainHandler.service(OSGiMainHandler.java:302)
at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:200)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$MDCProvidingRunnable.run(CustomThreadPoolExecutor.java:2615)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.runTask(CustomThreadPoolExecutor.java:841)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:868)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.openexchange.jsieve.export.exceptions.OXSieveHandlerException: Currently active script “default” is not the expected one “Open-Xchange”
at com.openexchange.jsieve.export.SieveHandler.getActiveScript(SieveHandler.java:951)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.getScript(MailFilterServiceImpl.java:263)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:490)
… 29 common frames omitted
2019-11-12T09:27:28,582+0100 ERROR [OXWorker-0001234] com.openexchange.ajax.requesthandler.DispatcherServlet.logException(DispatcherServlet.java:731)
Error processing request.
com.openexchange.ajax.action=list
com.openexchange.ajax.module=mailfilter/v2
com.openexchange.grizzly.method=GET
com.openexchange.grizzly.queryString=action=list&flag=autoforward&session=e4eb0c9460cb453a9d62ab7d668998b1
com.openexchange.grizzly.remoteAddress=10.0.0.1
com.openexchange.grizzly.remotePort=45072
com.openexchange.grizzly.requestURI=/ajax/mailfilter/v2
com.openexchange.grizzly.serverName=10.0.10.70
com.openexchange.grizzly.servletPath=/ajax/mailfilter/v2
com.openexchange.grizzly.threadName=OXWorker-0001234
com.openexchange.grizzly.userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36
com.openexchange.hostname=hansolo.cohausz-leuchten.int
com.openexchange.localhost.ipAddress=10.0.10.70
com.openexchange.localhost.version=7.10.2-Rev9
com.openexchange.request.trackingId=1861695518-930858869
com.openexchange.session.authId=d94681ea424440c9b3e71c0681e7ba4d
com.openexchange.session.clientId=open-xchange-appsuite
com.openexchange.session.contextId=10
com.openexchange.session.loginName=KSurmund
com.openexchange.session.sessionId=e4eb0c9460cb453a9d62ab7d668998b1
com.openexchange.session.userId=53
com.openexchange.session.userName=KSurmund
com.openexchange.exception.OXException: MAIL_FILTER-0015 Categories=ERROR Message=‘Error while communicating with the sieve server hansolo.cohausz-leuchten.int at port 4190 for user KSurmund in context 10’ exceptionID=1861695518-4664
com.openexchange.exception.locale: de_DE
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:182)
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:172)
at com.openexchange.exception.OXExceptionFactory.create(OXExceptionFactory.java:145)
at com.openexchange.mailfilter.exceptions.MailFilterExceptionCode.create(MailFilterExceptionCode.java:321)
at com.openexchange.mailfilter.exceptions.MailFilterExceptionCode.handleParsingException(MailFilterExceptionCode.java:365)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:516)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:479)
at com.openexchange.mail.filter.json.v2.actions.ListMailFilterAction.perform(ListMailFilterAction.java:108)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.doCallAction(DefaultDispatcher.java:600)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.callAction(DefaultDispatcher.java:576)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.doPerform(DefaultDispatcher.java:544)
at com.openexchange.ajax.requesthandler.DefaultDispatcher.perform(DefaultDispatcher.java:261)
at com.openexchange.ajax.requesthandler.DispatcherServlet.handle(DispatcherServlet.java:482)
at com.openexchange.ajax.requesthandler.DispatcherServlet.doGet(DispatcherServlet.java:376)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:686)
at com.openexchange.ajax.AJAXServlet.doService(AJAXServlet.java:570)
at com.openexchange.ajax.SessionServlet.doService(SessionServlet.java:173)
at com.openexchange.ajax.requesthandler.DispatcherServlet.service(DispatcherServlet.java:276)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:124)
at com.openexchange.http.grizzly.servletfilter.RequestReportingFilter.doFilter(RequestReportingFilter.java:138)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at com.openexchange.http.grizzly.servletfilter.WrappingFilter.doFilter(WrappingFilter.java:223)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at com.openexchange.http.grizzly.service.http.OSGiAuthFilter.doFilter(OSGiAuthFilter.java:139)
at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)
at org.glassfish.grizzly.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:83)
at org.glassfish.grizzly.servlet.ServletHandler.doServletService(ServletHandler.java:202)
at org.glassfish.grizzly.servlet.ServletHandler.service(ServletHandler.java:154)
at com.openexchange.http.grizzly.service.http.OSGiMainHandler.service(OSGiMainHandler.java:302)
at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:200)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$MDCProvidingRunnable.run(CustomThreadPoolExecutor.java:2615)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.runTask(CustomThreadPoolExecutor.java:841)
at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:868)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.openexchange.jsieve.export.exceptions.OXSieveHandlerException: Currently active script “default” is not the expected one “Open-Xchange”
at com.openexchange.jsieve.export.SieveHandler.getActiveScript(SieveHandler.java:951)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.getScript(MailFilterServiceImpl.java:263)
at com.openexchange.mailfilter.internal.MailFilterServiceImpl.listRules(MailFilterServiceImpl.java:490)
… 29 common frames omitted

troeder · November 12, 2019, 10:44am

com.openexchange.exception.OXException: MAIL_FILTER-0015 Categories=ERROR Message=‘Error while communicating with the sieve server hansolo.cohausz-leuchten.int at port 4190 for user KSurmund in context 10’ exceptionID=1861695518-4663
[..]
Caused by: com.openexchange.jsieve.export.exceptions.OXSieveHandlerException: Currently active script “default” is not the expected one “Open-Xchange”

OX erwartet unter /var/spool/dovecot/private/DOMAIN/USER/sieve eine Datei namens Open-Xchange.sieve, findet aber den Standard default.sieve vor.
Diese Datei wurde von der UCS-Dovecot-Integration angelegt, bevor OX installiert wurde. Löschen Sie sie einfach (backup vorher, falls der User etwas eigenes rein geschrieben hat?) und dann sollte OX glücklich sein.

Gruß
Daniel Tröder

MHoener · November 12, 2019, 10:59am

Super hat funktioniert, habe es jetzt bei allen Usern gelöscht.

Herzlichen Dank