Skip navigation
Up to Discussions in Openfire Support
17903 Views 56 Replies Latest reply: Jan 8, 2010 10:06 AM by scott RSS
David Thor Bronze
David Thor
23 posts since
Apr 16, 2007
Currently Being Moderated

Aug 27, 2008 5:43 AM

Openfire Upgrade from 3.5.2.  to 3.6 Fails

This is the Startup log:

 

Found old database version 16 for openfire. Upgrading to version 20...
SchemaManager: Failed to execute SQL:
CREATE TABLE mucService (   serviceID           INT           NOT NULL,   subdomain           NVARCHAR(255) NOT NULL,   description         NVARCHAR(255),   CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
java.sql.SQLException: There is already an object named 'mucService' in the database.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Wrapper$$EnhancerByProxool$$d0d7356b.execute(<generated>)
    at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
    at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
    at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
    at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
    at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
    at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
    at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
    at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
    at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
    at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
    at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)

java.sql.SQLException: Invalid object name 'ofProperty'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery(<generate d>)
    at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:337)
    at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
    at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
    at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
    at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
    at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
Database could not be accessed
java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery(<generate d>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)

java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name 'ofID'.
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery(<generate d>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    ... 16 more
java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name 'ofID'.
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery(<generate d>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    ... 16 moEre

rror starting the server. Please check the log files for more information.
Server halted

  • sixthring KeyContributor
    sixthring
    3,789 posts since
    Apr 2, 2007
    Currently Being Moderated
    Aug 27, 2008 5:52 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Are you using LDAP?  Even if you are not try this:

    • stop your server
    • edit your openfire.xml file setup tag to read <setup>false</setup>.
    • start server
    • go to admin page and step throught the config again.
  • Daniel Henninger Gold
    Daniel Henninger
    2,953 posts since
    Aug 10, 2005
    Currently Being Moderated
    Aug 27, 2008 8:00 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Good lord, it sounds like there are some leftover tables hanging around that it's conflicting with.  You downgraded and it's working fine?  Did you restore your db from a previous version?  I would think the db would be in a fairly confused state at the moment if you partially upgraded and then stopped.

    • Daniel Henninger Gold
      Daniel Henninger
      2,953 posts since
      Aug 10, 2005
      Currently Being Moderated
      Aug 27, 2008 8:01 AM (in response to Daniel Henninger)
      Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

      So both of you are using the embedded db and seeing this?

    • kero Bronze
      kero
      3 posts since
      Aug 27, 2008
      Currently Being Moderated
      Aug 27, 2008 8:06 AM (in response to Daniel Henninger)
      Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

      Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

       

       

      greetings

       

      kero

      • David Thor Bronze
        David Thor
        23 posts since
        Apr 16, 2007
        Currently Being Moderated
        Aug 27, 2008 8:09 AM (in response to kero)
        Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

        We use LDAP via Active Direcotyr... i just dropped back to 3.5.2 and used the DB backup and most everything seems fins.   I ca'nt find the old version of rhte gateway .jar.. the new one says it only works with 3.6

      • Daniel Henninger Gold
        Daniel Henninger
        2,953 posts since
        Aug 10, 2005
        Currently Being Moderated
        Aug 27, 2008 8:36 AM (in response to kero)
        Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

        kero wrote:

         

        Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

         

         

        greetings

         

        kero

        Interesting.  It sounds like the old tables are still present, or nothing got renamed, or something.  *scratch head*

        • David Thor Bronze
          David Thor
          23 posts since
          Apr 16, 2007
          Currently Being Moderated
          Aug 27, 2008 8:40 AM (in response to Daniel Henninger)
          Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

          SQL Server.... Microsoft SQL

          • Daniel Henninger Gold
            Daniel Henninger
            2,953 posts since
            Aug 10, 2005
            Currently Being Moderated
            Aug 27, 2008 9:17 AM (in response to David Thor)
            Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

            dthor wrote:

             

            SQL Server.... Microsoft SQL

            I've been told that there's a bug in script 19 for SQL server:

             

            In upgrade script 19
                    Line 60         - ofUserFlag should be ofRoster
                    Line 140        - mucRoom__pk should be mucRoom_pk

            • Artur Nowak Bronze
              Artur Nowak
              3 posts since
              Feb 18, 2007
              Currently Being Moderated
              Aug 27, 2008 9:59 AM (in response to Daniel Henninger)
              Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

              But it doesn't help to problem with upgrade and error:

               

              SchemaManager: Failed to execute SQL:
              CREATE TABLE mucService (   serviceID           INT           NOT NULL,   subdomain           NVARCHAR(255) NOT NULL,   description         NVARCHAR(255),   CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
              java.sql.SQLException: There is already an object named 'mucService' in the database.
              ....

               

               

              i'am using Widows version of OpenFire and MSSQL

               

              Please help

              • Daniel Henninger Gold
                Daniel Henninger
                2,953 posts since
                Aug 10, 2005
                Currently Being Moderated
                Aug 27, 2008 10:01 AM (in response to Artur Nowak)
                Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

                Hrm.  It looks like one of the upgrades partially succeeded and so now there are conflicting tables.  Can you get a list of the tables in your db and paste them here (not the contents, just the table names)

                • Artur Nowak Bronze
                  Artur Nowak
                  3 posts since
                  Feb 18, 2007
                  Currently Being Moderated
                  Aug 27, 2008 10:05 AM (in response to Daniel Henninger)
                  Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

                  yes, there is list of openfire database tables:

                   

                  Name    Owner    Type    Create Date
                  dtproperties    dbo    System    2006-07-26 10:42:23
                  jiveExtComponentConf    dbo    User    2006-07-25 17:45:33
                  jiveGroup    dbo    User    2006-07-25 17:45:33
                  jiveGroupProp    dbo    User    2006-07-25 17:45:33
                  jiveGroupUser    dbo    User    2006-07-25 17:45:33
                  jiveID    dbo    User    2006-07-25 17:45:33
                  jiveOffline    dbo    User    2006-07-25 17:45:33
                  jivePresence    wildfire    User    2007-02-13 18:36:55
                  jivePrivacyList    dbo    User    2006-07-25 17:45:33
                  jivePrivate    dbo    User    2006-07-25 17:45:33
                  jiveProperty    dbo    User    2006-07-25 17:45:33
                  jiveRemoteServerConf    dbo    User    2006-07-25 17:45:33
                  jiveRoster    dbo    User    2006-07-25 17:45:33
                  jiveRosterGroups    dbo    User    2006-07-25 17:45:33
                  jiveSASLAuthorized    dbo    User    2006-07-25 17:45:33
                  jiveSecurityAuditLog    wildfire    User    2008-04-23 17:32:33
                  jiveUser    dbo    User    2006-07-25 17:45:33
                  jiveUserFlag    wildfire    User    2008-04-23 17:32:33
                  jiveUserProp    dbo    User    2006-07-25 17:45:33
                  jiveVCard    dbo    User    2006-07-25 17:45:33
                  jiveVersion    dbo    User    2006-07-25 17:45:33
                  mucAffiliation    dbo    User    2006-07-25 17:45:33
                  mucConversationLog    dbo    User    2006-07-25 17:45:33
                  mucMember    dbo    User    2006-07-25 17:45:33
                  mucRoom    dbo    User    2006-07-25 17:45:33
                  mucRoomProp    dbo    User    2006-07-25 17:45:33
                  mucService    wildfire    User    2008-08-27 18:37:25
                  mucServiceProp    wildfire    User    2008-08-27 18:37:25
                  pubsubAffiliation    dbo    User    2006-07-25 17:45:33
                  pubsubDefaultConf    dbo    User    2006-07-25 17:45:33
                  pubsubItem    dbo    User    2006-07-25 17:45:33
                  pubsubNode    dbo    User    2006-07-25 17:45:33
                  pubsubNodeGroups    dbo    User    2006-07-25 17:45:33
                  pubsubNodeJIDs    dbo    User    2006-07-25 17:45:33
                  pubsubSubscription    dbo    User    2006-07-25 17:45:33
                  syscolumns    dbo    System    2000-08-06 01:29:12
                  syscomments    dbo    System    2000-08-06 01:29:12
                  sysdepends    dbo    System    2000-08-06 01:29:12
                  sysfilegroups    dbo    System    2000-08-06 01:29:12
                  sysfiles    dbo    System    2000-08-06 01:29:12
                  sysfiles1    dbo    System    2000-08-06 01:29:12
                  sysforeignkeys    dbo    System    2000-08-06 01:29:12
                  sysfulltextcatalogs    dbo    System    2000-08-06 01:29:12
                  sysfulltextnotify    dbo    System    2000-08-06 01:29:12
                  sysindexes    dbo    System    2000-08-06 01:29:12
                  sysindexkeys    dbo    System    2000-08-06 01:29:12
                  sysmembers    dbo    System    2000-08-06 01:29:12
                  sysobjects    dbo    System    2000-08-06 01:29:12
                  syspermissions    dbo    System    2000-08-06 01:29:12
                  sysproperties    dbo    System    2000-08-06 01:29:12
                  sysprotects    dbo    System    2000-08-06 01:29:12
                  sysreferences    dbo    System    2000-08-06 01:29:12
                  systypes    dbo    System    2000-08-06 01:29:12
                  sysusers    dbo    System    2000-08-06 01:29:12

  • Andre Lima Bronze
    Andre Lima
    6 posts since
    Aug 27, 2008
    Currently Being Moderated
    Aug 27, 2008 10:13 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Hello guys,

     

    Here i don't have any database server (MySQL or SQL Server).  The openfire server works into the AD Server but don't use him for user authetication, but te error "Found old database version 16 for openfire. Upgrading to version 20..." happens here.

     

    Sorry my poor english.

     

    Se houver que possa me ajudar em português eu agradeço também.

  • Andre Lima Bronze
    Andre Lima
    6 posts since
    Aug 27, 2008
    Currently Being Moderated
    Aug 27, 2008 10:30 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Isso mesmo, só queria saber se alguém consegue me explicar o que deve ser feito. Se é que já existe uma solução.

     

    Obrigado pelo retorno.

     

    Correct, i want to know if anybody here can explain me what i do, if the solution exist.

     

    Thanks.

  • Mike Weissman Bronze
    Mike Weissman
    3 posts since
    Aug 27, 2008
    Currently Being Moderated
    Aug 27, 2008 11:28 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Hello, i am sure what is goin on with my upgrade.

     

    Setup is MacOSx 10.4.11 Server

    MYSQL-5

    LDAP authentication

     

    Steps i took to upgrade:

    1.stop server

    2. Backup

    3. Run Upgrade Installer

    4. Edited to openfire.xml to enable setup again

    5. Ran through setup

    6. Everything worked.

     

    Then when  i clicked on Login to Admin Console, it takes me back to Setup.

     

    So i stopped the server, edited the openfire.xml again to disable setup. Restart Server, and boom setup wizard again...

     

    The only error in the logs are complaining about Line 57 in the xml file not having a closed tag.

     

    </defaultProvider>

     

    But it's there. So i have no idea where to go from here.

    • Daniel Henninger Gold
      Daniel Henninger
      2,953 posts since
      Aug 10, 2005
      Currently Being Moderated
      Aug 27, 2008 11:45 AM (in response to Mike Weissman)
      Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

      weisso5 wrote:

       

      Hello, i am sure what is goin on with my upgrade.

       

      Setup is MacOSx 10.4.11 Server

      MYSQL-5

      LDAP authentication

       

      Steps i took to upgrade:

      1.stop server

      2. Backup

      3. Run Upgrade Installer

      4. Edited to openfire.xml to enable setup again

      5. Ran through setup

      6. Everything worked.

       

      Then when  i clicked on Login to Admin Console, it takes me back to Setup.

       

      So i stopped the server, edited the openfire.xml again to disable setup. Restart Server, and boom setup wizard again...

       

      The only error in the logs are complaining about Line 57 in the xml file not having a closed tag.

       

      </defaultProvider>

       

      But it's there. So i have no idea where to go from here.

      Hrm.  Can you paste your file somewhere?  Maybe private message or email to me?  hide passwords?

  • steve Bronze
    steve
    14 posts since
    May 24, 2007
    Currently Being Moderated
    Aug 27, 2008 2:04 PM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    same deal here... integrated DB, I don't use AD, w2k3, i'm about to try to roll back with the last version of the installer i have... wonder if it will downgrade like you can in linux..... the thing i did notice is the first time i tried to install it i had a corrupt installer issue so i re downloaded the installer... i wonder if there is a connection.

  • Rubens Zolotujin Bronze
    Rubens Zolotujin
    12 posts since
    Dec 12, 2005
    Currently Being Moderated
    Aug 27, 2008 6:23 PM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    I'm having the same problem, had the version 3.5 with MSSQL database and LDAP directory with active, to do the upgrade made the error below:

     

     

    I am with my system stopped ... please help me.

     

     

     

    Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
    java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name 'ofID'.
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    Caused by: java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown SouErro iniciando o esrce)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$773eee98.executeQuery(<generate d>)
    at org.jivesoftwaerrvidor. Por favor verifique os arquivos de log para mais informações.
    .openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    ... 16 more
    Server halted

  • gregor Bronze
    gregor
    8 posts since
    Oct 31, 2007
    Currently Being Moderated
    Aug 28, 2008 12:49 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    some problem here

     

     

    openfire windows version 3.5.2

    with embedded databse engine

    no ad connection

     

    when i upgrade to 3.6 i became same problem, i can´t start openfire

     

    when i downgrade to 3.5.2 it works fine,

     

    database are not restored

  • Rubens Zolotujin Bronze
    Rubens Zolotujin
    12 posts since
    Dec 12, 2005
    Currently Being Moderated
    Aug 28, 2008 3:30 AM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    'm having to plug problem with the version 3.5, after trying to make the upgrade to version 3.6 which not satisfied, I returned to installation to version 3.5 and can not plug up all that before, when I try to do the update to plug it always tells me that there is a new version 3.6 and it must import the plugins that the version 3.5 that I am using.

    someone help me?

    after everything is complicated version 3.6.

    • Daniel Henninger Gold
      Daniel Henninger
      2,953 posts since
      Aug 10, 2005
      Currently Being Moderated
      Aug 28, 2008 7:50 AM (in response to Rubens Zolotujin)
      Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

      Does no one actually back up before upgrading? 

       

      You can still build the plugins from SVN if you check out https://svn.igniterealtime.org/svn/repos/openfire/branches/openfire_3_5_2

       

      My concern about downgrading to 3.5.2 without restoring your database is that you've partially upgraded to 3.6.0 at that point.  Now, I've identified where the problem was and fixed it, so I'm going to publish 3.6.0a with instructions on how to "fix your db" so the upgrade will perform correctly, but right now your db is "sorta kinda" corrupted.  (not too bad that 3.5.2 won't work obviously)

      • rculpepper Bronze
        rculpepper
        51 posts since
        Jun 24, 2008
        Currently Being Moderated
        Aug 28, 2008 8:02 AM (in response to Daniel Henninger)
        Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

        Testing upgrades in a test environment is good, too...

         

        Thanks for the quick work on this, Daniel. I'm looking forward to the 3.6.0a install, it (3.6.0 in generall...) sounds like it's going to solve some key issues.

        • Daniel Henninger Gold
          Daniel Henninger
          2,953 posts since
          Aug 10, 2005
          Currently Being Moderated
          Aug 28, 2008 8:08 AM (in response to rculpepper)
          Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

          rculpepper wrote:

           

          Testing upgrades in a test environment is good, too...

           

          Unfortunately my test environment failed me big time.  In some cases I'm not sure how it even worked!

           

          I actually have 4 live servers I run, and test against all of the supported DBs except for Sybase, which I don't seem to be able to locate something I can use for.  (and I'm not even convinced anyone is using it for Openfire)

           

          Of course, wanna know what did me in the most this time?

           

          I tested a -fresh- setup, instead of testing something that had a lot of data in it.  Specifically, I hadn't created any MUC rooms and having some is what caused the upgrade to fail.  Lesson learned  =(  Unfortunately this was also a "quick release" instead of having proper QA time and even putting out a beta first.  =/

           

          Just a couple of factors came together to screw things over.  I think I've fixed all of the most important issues at the moment and am testing in a number of DBs before pushing it out.  I think after this is over I'm going to build a Wildfire install with a lot of data in it that is my "base" setup that will get copied and upgraded every time to the latest to make sure things work right.  VMs for the win.  =)

           

          Not a shining day for my confidence for sure.

  • deems Bronze
    deems
    1 posts since
    Nov 17, 2008
    Currently Being Moderated
    Nov 17, 2008 6:18 PM (in response to David Thor)
    Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

    Hello everybody,

     

    I'm trying to to upgrade from 3.5.2 to 3.6.1 using Microsoft SQL Server for the database.  3.6.1 detects an older version of the database, and then it fails to upgrade.  Can anyone please help? The following is in my error.log file:

     

    2008.11.18 05:49:32 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:38 3)] SchemaManager: Failed to execute SQL:
    CREATE TABLE mucService (   serviceID           INT           NOT NULL,   subdomain           NVARCHAR(255) NOT NULL,   description         NVARCHAR(255),   CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
    2008.11.18 05:49:32 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:273)]
    java.sql.SQLException: There is already an object named 'mucService' in the database.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Statement$$EnhancerByProxool$$5ffe209.execute(<generated>)
    at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:378 )
    at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:270)
    at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
    at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
    at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
    at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
    at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
    at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
    at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
    at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
    at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    2008.11.18 05:49:32 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
    java.sql.SQLException: Invalid object name 'ofProperty'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Statement$$EnhancerByProxool$$82283445.executeQuery(<generated>)
    at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:337)
    at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
    at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
    at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
    at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
    at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    2008.11.18 05:49:32 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:709)] Database could not be accessed
    java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Statement$$EnhancerByProxool$$82283445.executeQuery(<generated>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    2008.11.18 05:49:32 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)]
    java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name 'ofID'.
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
    at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
    at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
    at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    Caused by: java.sql.SQLException: Invalid object name 'ofID'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.Statement$$EnhancerByProxool$$82283445.executeQuery(<generated>)
    at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
    ... 16 more

    • Daryl Herzmann KeyContributor
      Daryl Herzmann
      849 posts since
      Mar 12, 2005
      Currently Being Moderated
      Nov 17, 2008 9:33 PM (in response to deems)
      Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

      Hi,

       

      Thanks for posting your tracebacks.  How comfortable are you with MsSQL and running commands manually?  Would you be willing to try running each database upgrade script manually and then post which SQL commands it fails on?  You can find these sql commands in the resources/database/upgrade folder, one numbered for each schema revision bump.  You are probably at #16 now...

       

      My guess is that your database is not in the expected state #16, due to previous uncaught upgrade bugs....

       

      daryl

      • Jeff Bronze
        Jeff
        24 posts since
        Jan 22, 2006
        Currently Being Moderated
        Nov 23, 2008 1:37 AM (in response to Daryl Herzmann)
        Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

        I had the same upgrade failures in trying to go from 3.5.2 to 3.62.

         

        I looked at the 19 and 20 directories as indicated and ran the SQL manually against my MYSQL database.

         

        Looks like there were problems with a couple indexes. Indexes simply didn't exist for a couple tables, when it ran into problems trying to drop an index that didn't exist, the script stopped.

         

        I just didn't attempt to remove the missing indexes, and all was well.

         

        If you'd like a copy  of my original DB, I believe I can make that available.

        • scott Bronze
          scott
          4 posts since
          Jan 8, 2010
          Currently Being Moderated
          Jan 8, 2010 10:06 AM (in response to Jeff)
          Re: Openfire Upgrade from 3.5.2. to 3.6 Fails

          I'm having trouble finding a solution to this same problem.

           

          I just installed Openfire 3.6.4 with local SQL and AD LDAP, installed some Plugins. Everything worked awesome, until i quit and relaunch the app. Now i get errors when trying to start the service debug.log access denied, java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@f7...

           

          Files\Openfirew\embedded-db\openfire.lck,exists=true, locked=false valid=false, fl=null]: java.io.FileNotFoundException: C:\Program Files\Openfire\embedded-db\openfire.lck(Access is denied) .... If i reinstall the software over the top of my current install, it works again, until i quit and relaunch the application.
          scott94583 has joined the room.

           

          I've rebooted which did not help. I previously had ejabberd installed, but its gone now. I granted the openfire ldap account admin rights to the server, but that did not do anything, either. Scratching my head..

           

          Thanks!

More Like This

  • Retrieving data ...

Incoming Links

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points