Announcement

Collapse
No announcement yet.

Problem creating mail after upgrade to 7.10.2Rev3

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem creating mail after upgrade to 7.10.2Rev3

    Hi,

    today i get the info from an user that he can not create mails after the last update.
    He can login in and see all his mails, but if pushes the "compose" button the mailwindow comes up and disappears in the same moment..

    The logfiles shows this:
    2019-05-22T20:35:06,901+0200 [OXWorker-0000051] com.openexchange.ajax.requesthandler.DispatcherSer vlet.logException(DispatcherServlet.java:731)
    Error processing request.
    com.openexchange.ajax.action=open
    com.openexchange.ajax.module=mailcompose
    com.openexchange.database.schema=oxdatabase_6
    com.openexchange.grizzly.method=POST
    com.openexchange.grizzly.queryString=type=new&vcar d=false&session=4287c1d58590426e985aa61895e4efa3
    com.openexchange.grizzly.remoteAddress=xxxxxxxxxxx xxxxxxx
    com.openexchange.grizzly.remotePort=43258
    com.openexchange.grizzly.requestURI=/ajax/mail/compose
    com.openexchange.grizzly.serverName=xxxx.xxxxx.com
    com.openexchange.grizzly.servletPath=/ajax/mail/compose
    com.openexchange.grizzly.threadName=OXWorker-0000051
    com.openexchange.grizzly.userAgent=Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0
    com.openexchange.hostname=xxx.xxxx.com
    com.openexchange.localhost.ipAddress=xxxxxxxxxxxx
    com.openexchange.localhost.version=7.10.2-Rev4
    com.openexchange.request.trackingId=454167072-227083724
    com.openexchange.session.authId=eeaf2cec942e4827b1 512ac66b5c301f
    com.openexchange.session.clientId=open-xchange-appsuite
    com.openexchange.session.contextId=1
    com.openexchange.session.loginName=username
    com.openexchange.session.sessionId=4287c1d58590426 e985aa61895e4efa3
    com.openexchange.session.userId=4
    com.openexchange.session.userName=username
    com.openexchange.exception.OXException: MSGCS-0002 Categories=ERROR Message='An SQL error occurred: Table 'oxdatabase_6.compositionSpace' doesn't exist' exceptionID=454167072-96
    com.openexchange.exception.locale: en_US
    at com.openexchange.exception.OXExceptionFactory.crea te(OXExceptionFactory.java:182)
    at com.openexchange.exception.OXExceptionFactory.crea te(OXExceptionFactory.java:172)
    at com.openexchange.exception.OXExceptionFactory.crea te(OXExceptionFactory.java:145)
    at com.openexchange.mail.compose.CompositionSpaceErro rCode.create(CompositionSpaceErrorCode.java:197)
    at com.openexchange.mail.compose.impl.storage.db.Comp ositionSpaceDbStorage.handleException(CompositionS paceDbStorage.java:578)
    at com.openexchange.mail.compose.impl.storage.db.Comp ositionSpaceDbStorage.countAll(CompositionSpaceDbS torage.java:124)
    at com.openexchange.mail.compose.impl.storage.db.RdbC ompositionSpaceStorageService.openCompositionSpace (RdbCompositionSpaceStorageService.java:201)
    at com.openexchange.mail.compose.impl.storage.securit y.CryptoCompositionSpaceStorageService.openComposi tionSpace(CryptoCompositionSpaceStorageService.jav a:207)
    at com.openexchange.mail.compose.impl.CompositionSpac eServiceImpl.openCompositionSpace(CompositionSpace ServiceImpl.java:1229)
    at com.openexchange.mail.compose.impl.CryptoCompositi onSpaceService.openCompositionSpace(CryptoComposit ionSpaceService.java:148)
    at com.openexchange.mail.compose.json.action.OpenComp ositionSpaceAction.doPerform(OpenCompositionSpaceA ction.java:214)
    at com.openexchange.mail.compose.json.action.Abstract MailComposeAction.perform(AbstractMailComposeActio n.java:492)
    at com.openexchange.ajax.requesthandler.DefaultDispat cher.doCallAction(DefaultDispatcher.java:600)
    at com.openexchange.ajax.requesthandler.DefaultDispat cher.callAction(DefaultDispatcher.java:576)
    at com.openexchange.ajax.requesthandler.DefaultDispat cher.doPerform(DefaultDispatcher.java:544)
    at com.openexchange.ajax.requesthandler.DefaultDispat cher.perform(DefaultDispatcher.java:261)
    at com.openexchange.ajax.requesthandler.DispatcherSer vlet.handle(DispatcherServlet.java:482)
    at com.openexchange.ajax.requesthandler.DispatcherSer vlet.doPost(DispatcherServlet.java:386)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:706)
    at com.openexchange.ajax.AJAXServlet.doService(AJAXSe rvlet.java:570)
    at com.openexchange.ajax.SessionServlet.doService(Ses sionServlet.java:173)
    at com.openexchange.ajax.requesthandler.DispatcherSer vlet.service(DispatcherServlet.java:276)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:791)
    at org.glassfish.grizzly.servlet.FilterChainImpl.doFi lter(FilterChainImpl.java:124)
    at com.openexchange.http.grizzly.servletfilter.Reques tReportingFilter.doFilter(RequestReportingFilter.j ava:138)
    at org.glassfish.grizzly.servlet.FilterChainImpl.doFi lter(FilterChainImpl.java:114)
    at com.openexchange.http.grizzly.servletfilter.Wrappi ngFilter.doFilter(WrappingFilter.java:223)
    at org.glassfish.grizzly.servlet.FilterChainImpl.doFi lter(FilterChainImpl.java:114)
    at com.openexchange.http.grizzly.service.http.OSGiAut hFilter.doFilter(OSGiAuthFilter.java:139)
    at org.glassfish.grizzly.servlet.FilterChainImpl.doFi lter(FilterChainImpl.java:114)
    at org.glassfish.grizzly.servlet.FilterChainImpl.invo keFilterChain(FilterChainImpl.java:83)
    at org.glassfish.grizzly.servlet.ServletHandler.doSer vletService(ServletHandler.java:202)
    at org.glassfish.grizzly.servlet.ServletHandler.servi ce(ServletHandler.java:154)
    at com.openexchange.http.grizzly.service.http.OSGiMai nHandler.service(OSGiMainHandler.java:302)
    at org.glassfish.grizzly.http.server.HttpHandler$1.ru n(HttpHandler.java:200)
    at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$MDCProvidingRunnable.run(CustomThreadP oolExecutor.java:2615)
    at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:841)
    at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:868)
    at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'oxdatabase_6.compositionSpace' doesn't exist
    at sun.reflect.GeneratedConstructorAccessor103.newIns tance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Construc tor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:42 5)
    at com.mysql.jdbc.Util.getInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:944)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3914)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:25 30)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2683)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2495)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1903)
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:2011)
    at com.openexchange.database.internal.wrapping.JDBC4P reparedStatementWrapper.executeQuery(JDBC4Prepared StatementWrapper.java:135)
    at com.openexchange.mail.compose.impl.storage.db.Comp ositionSpaceDbStorage.countAll(CompositionSpaceDbS torage.java:440)
    at com.openexchange.mail.compose.impl.storage.db.Comp ositionSpaceDbStorage.countAll(CompositionSpaceDbS torage.java:122)


    The system is an old CentOS6 based installation which runs since more then 6years.
    I can see that OX looks for non existing tables but i dont know if this is the reason for this error and if yes, how can i upgrade the db and the tables to the new DB schema.

    Systeminfo:
    CentOS release 6.10 (Final)

    MySQL:
    mysql Ver 14.14 Distrib 5.6.44, for Linux (x86_64)

    Java:
    openjdk version "1.8.0_212"
    OpenJDK Runtime Environment (build 1.8.0_212-b04)
    OpenJDK 64-Bit Server VM (build 25.212-b04, mixed mode)

    OX packages:
    open-xchange-gui-loading-theme-default-6.22.13-5_5.1.noarch
    open-xchange-gui-wizard-plugin-gui-6.22.13-5_5.1.noarch
    open-xchange-online-help-en-us-6.22.13-5_5.1.noarch
    open-xchange-hazelcast-community-7.10.2-4_4.1.noarch
    open-xchange-oauth-7.10.2-4_4.1.noarch
    open-xchange-subscribe-7.10.2-4_4.1.noarch
    open-xchange-pop3-7.10.2-4_4.1.noarch
    open-xchange-appsuite-backend-7.10.2-4_4.1.noarch
    open-xchange-appsuite-l10n-de-de-7.10.2-3_3.1.noarch
    open-xchange-meta-singleserver-7.10.2-4_4.1.noarch
    open-xchange-gui-l10n-6.22.13-5_5.1.noarch
    open-xchange-online-help-de-de-6.22.13-5_5.1.noarch
    open-xchange-admin-7.10.2-4_4.1.noarch
    open-xchange-calendar-printing-7.10.2-4_4.1.noarch
    open-xchange-unifiedmail-7.10.2-4_4.1.noarch
    open-xchange-themes-default-7.10.2-4_4.1.noarch
    open-xchange-gui-l10n-en-us-6.22.13-5_5.1.noarch
    open-xchange-gui-wizard-plugin-6.22.13-5_5.1.noarch
    open-xchange-gui-themes-default-6.22.13-5_5.1.noarch
    open-xchange-l10n-de-de-7.10.2-4_4.1.noarch
    open-xchange-smtp-7.10.2-4_4.1.noarch
    open-xchange-authorization-standard-7.10.2-4_4.1.noarch
    open-xchange-meta-server-7.10.2-4_4.1.noarch
    open-xchange-passwordchange-database-7.10.2-4_4.1.noarch
    open-xchange-gui-6.22.13-5_5.1.noarch
    open-xchange-online-help-fr-fr-6.22.13-5_5.1.noarch
    open-xchange-xerces-7.10.2-4_4.1.noarch
    open-xchange-appsuite-l10n-en-us-7.10.2-3_3.1.noarch
    open-xchange-halo-7.10.2-4_4.1.noarch
    open-xchange-report-client-7.10.2-4_4.1.noarch
    open-xchange-meta-pubsub-7.10.2-4_4.1.noarch
    open-xchange-grizzly-7.10.2-4_4.1.noarch
    open-xchange-appsuite-help-common-7.10.2-3_3.1.noarch
    open-xchange-mailfilter-7.10.2-4_4.1.noarch
    open-xchange-manage-group-resource-7.10.2-4_4.1.noarch
    open-xchange-configjump-generic-gui-6.22.13-5_5.1.noarch
    open-xchange-authentication-database-7.10.2-4_4.1.noarch
    open-xchange-gui-l10n-de-de-6.22.13-5_5.1.noarch
    open-xchange-l10n-en-us-7.10.2-4_4.1.noarch
    open-xchange-imap-7.10.2-4_4.1.noarch
    open-xchange-spamhandler-spamassassin-7.10.2-4_4.1.noarch
    open-xchange-meta-messaging-7.10.2-4_4.1.noarch
    open-xchange-rest-7.10.2-4_4.1.noarch
    open-xchange-appsuite-7.10.2-3_3.1.noarch
    open-xchange-gui-login-theme-default-6.22.13-5_5.1.noarch
    open-xchange-osgi-7.10.2-4_4.1.noarch
    open-xchange-core-7.10.2-4_4.1.noarch
    open-xchange-messaging-7.10.2-4_4.1.noarch
    open-xchange-7.10.2-4_4.1.noarch
    open-xchange-system-7.10.2-4_4.1.noarch
    open-xchange-meta-admin-7.8.0-27_29.1.noarch
    open-xchange-appsuite-manifest-7.10.2-3_3.1.noarch
    open-xchange-appsuite-help-de-de-7.10.2-3_3.1.noarch
    open-xchange-dataretrieval-7.10.2-4_4.1.noarch
    open-xchange-meta-backend-ox6-7.10.2-4_4.1.noarch
    open-xchange-meta-gui-6.22.1-13_13.1.noarch

    Silvio



  • #2
    We have the same problem, Debian Stretch, UI version: 7.10.2 Rev3, Server version: 7.10.2-Rev4 (version difference, but apt dist-upgrade says this is latest), but we don't see these log entries, not even in TRACE everything.
    Last edited by in4; 2 weeks ago.

    Comment


    • #3
      Further info: openjdk-8-jre-headless:amd64 8u212-b01-1~deb9u1, mysql-server-5.6 5.6.30-1. All current browsers like Safari 12.x, Chromium 7x etc. have this problem, with cleared caches.

      First try after login, the compose window is closed without a trace, second try and after, it just hangs with a loading icon in its main pane. Last network action is a compose request /appsuite/api/mail/compose?type=new&vcard=false&sessi on=..., which returns with 200.

      I can post ox package versions and requests/response in detail, if necessary, but I don't want to spam-hijack this thread even more.

      Comment


      • #4
        Please look at this documentation and try to find out if your update tasks have performed correctly.
        https://documentation.open-xchange.c...datetasks.html

        Comment


        • #5
          ListExecutedUpdateTasks is all true. Most tasks were executed a long time ago, not with the last major OX update. Checkdatabase shows no issues.
          Last edited by in4; 2 weeks ago.

          Comment


          • #6
            We're also experiencing this issue.

            Only appears to be effecting Internet Explorer 11 users.

            There is a javascript error when you click compose for the first time:

            Code:
            require.js: "define" for io.ox/core/tk/image-util TypeError: Unable to get property '1' of undefined or null reference
               at Anonymous function (eval code:2:395)
               at a.collect (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:104335)
               at a.prototype[b] (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:119378)
               at r (eval code:2:351)
               at Anonymous function (eval code:2:1324)
               at Anonymous function (eval code:2:1012)
               at f.execCb (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:1231973)
               at W.prototype.check (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:1225694)
               at Anonymous function (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:1228152)
               at Anonymous function (http://mailgate.*******.net/appsuite/v=7.10.2-3.20190510.080521/boot.js:1:1219925)
            We're using UI version: 7.10.2 Rev3 & Server version: 7.10.2-Rev4

            Has anyone had any luck with this? this is impacting a lot of users.
            Last edited by HeavenCore; 1 week ago.

            Comment


            • #7
              I dont have this issue.
              Tested with all Browsers. I'm using UI version: 7.10.2 Rev3 & Server version: 7.10.2-Rev4, on CentOS7 - 7.6 with OpenJDK java-1.8.0-openjdk-1.8.0.212

              Comment


              • #8
                This solved the issue on Apache level:
                Header set Content-Security-Policy "default-src 'self' https://*.host.tld 'unsafe-eval' 'unsafe-inline'; child-src 'self' blob:"
                Setting it in server.properties only affects X-Content-Security-Policy.

                BTW, we are now members of a very elite group: https://uselesscsp.com
                Last edited by in4; 4 days ago.

                Comment

                Working...
                X