same here

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.

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

Hrm.  I've attached a copy of the last released gateway.jar before this one.

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

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

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, I've identified the script that is failing for you.  Annoyingly, it's only part of a script that's failing so we'll have to have you try a partial script run to get going.  However I think it would be best to wait for 3.6.0a at this point to get you at least to a starting point.  (ideally, downgrade your db back to what it was before you upgraded, go back to 3.5.2, and upgrade to 3.6.0a from there when it's released)

All, see: http://www.igniterealtime.org/community/message/177972#177972

Se voce nao usa um servidor de banco, voce usa o HSQLDB. O Openfire sempre usa um banco de dados....

( If you do not use a database server, you use the HSQLDB. The Openfire always uses a database... )

Bom, a mensagem que aparece é sempre que o sistema identifica um banco anterior ao que deveria ser e começa um processo de upgrade. Essa identificação da versao do banco ele encontra na tabela jiveversion.

( Well, the message that appears is where the system identifies a bank up to what should be and begins a process of upgrading. This identification Release of the bank he finds in the table jiveversion. )

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.

will send via email.

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:

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

Daniel obrigado pela resposta, mas nao estou achando os plugins compatívels com 3.5.2 ai preciso demais deles...

se puder manda o link pra mim baixar zolotujin@gmail.com

grato,

Hrm.  Assuming that is Spanish.  I looked at it again and I'm not sure it is.  Is it?

hi,

Where can I old version download link 3.5.2?

my 3.6 db upgrade fail and back to old version.

I back to 3.5.2 no problem.

ok found it, bu I can't delete the this message. super forum permission.

Same problem here. I'm not using LDAP, but I am using MSSQL 2005. Fortunately it seems the database was not modified by the upgrade. The upgrade process itself completed, but after that Openfire  doesn't seem to be able to access the database and the server (and thus the admin) won't start. Backing out to 3.5.2 fixed the problem without having to restore the database from a backup.

It might be a good idea to include a warning next to the d/l links... or even suspend the distribution of 3.6 until the 3.6a is released.

*sigh* ... I suppose I'll restore the database.  At least I have a backup.

There're probably too many conversations going on at once in this comment thread... I just skimmed them over and missed the note that the db has been impacted (I suppose I would've found it out when trying to install 3.6a).

None taken. It was good that you pointed it out as I would have found out that there was a problem on upgrade to 3.6.0a. Thanks to Genie Backup Manager restore of MSSQL database was a breeze.

'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.

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.

If u need the hardware open the donation system. We support them.

But yours pay it cool features we cannot use and support (donation) them.

Daniel,

Just tried an upgrade from 3.5.2 to 3.6.0a and experianced the same MUC reference problem and the upgrade failed.

You mentioned 3.6.0a with instructions on how to "fix your db".

Should the upgrade from 3.5.2 to 3.6.0a work straight out of the box or will your "fix your db" be necessary?

If the "fix your db" step is required, can you help with a link to these notes.

At the moment we have rolled back to 3.5.2 after restoring the openfire SQL database.

Thanks in advance.

Best Regards
Alan

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

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.