Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1648

Upgrading from 4.2.3 to 4.3.0-beta may not migrate properties to ofPubSub

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: Database
    • Labels:
      None

      Description

      The following error message was reported in the forums;

      Found old database version 26 for openfire. Upgrading to version 29…
      11:23:35.824 [main] ERROR org.jivesoftware.util.JiveProperties - user lacks privilege or object not found: IV in statement [SELECT name, propValue, encrypted, iv FROM ofProperty]
      java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: IV in statement [SELECT name, propValue, encrypted, iv FROM ofProperty]
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
      at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
      at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
      at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292) ~[commons-dbcp2-2.5.0.jar:2.5.0]
      at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292) ~[commons-dbcp2-2.5.0.jar:2.5.0]
      at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:439) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:90) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:66) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:556) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.database.bugfix.OF1515.transform(OF1515.java:118) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.database.bugfix.OF1515.executeFix(OF1515.java:63) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:276) [xmppserver-4.3.0-beta.jar:4.3.0-beta]
      

      What appears to be happening is that OF1515 is being called before the DB upgrade script that creates column "iv" is called.

      This prevents JiveGlobals.loadProperties() from working, which means the incorrect xmpp domain may be used when migrating the properties.

        Attachments

          Activity

            People

            Assignee:
            gdt Greg Thomas
            Reporter:
            gdt Greg Thomas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: