powered by Jive Software

Win2003 - Upg from 2.1.5 > 2.2. b2?

Can this be done if I’'m using MS SQL and active directory/LDA authentication, if so what steps need to be taken (apart from backup everything first)

Will it handle any database schema changes automatically or do I need to update it manually?

thanks

Steve

Hey Steve,

JM will attempt to update the database automatically. It will print to the stdout any status message about the db process upgrade.

Let me know if you run into any trouble.

Regards,

– Gato

Hey Gato,i update my JM2.1.5 to JM2.2BETA2,

there is a error about database in admin console

"Found old database schema (2.1). Upgrading to latest schema.

Database upgrade failed. Please manually upgrade your database."

my database is ORACLE8.1.7,where can i find new datebase manually update process?

Thanks in advance.

–Tom

Compared to JM2.1.5 and JM2.2 database,it is missing ‘‘jiveExtComponentConf,jiveRemoteServerConf,mucRoomProp’’ three table,and three field about useReservedNick,canChangeNick,canRegister in MUCROOM table.i add these to my JM2.1.5,and update jiveVersion table’'s version info,whether it is will right to JM2.2 database?

Hey Tom,

Last Friday I sent you (twice) a reply to your email about this problem but I’'m getting a “Sorry, no mailbox here by that name” error message. So I send you a Private Message with the reply. Look at the upper right corner of this window, you should a the “Private Messages” in bold.

This is part of the transcript: “Regarding the Oracle problem I see that there is an ORA-00904 error. Restore the backup of the database (I hope you have one) :). Then locate the database\upgrade\2.1_to_2.2\messenger_oracle.sql file and run it from an SQL Console. Let me know which is the column/table that is having the problem.”. In the error log file you should get more detailed information about the problem in the update script. I don’'t have an Oracle to test the script so I would appreciate any information you may provide so we can fix this issue.

Regards,

– Gato

Hey Gato,thanks your reply,manual perform update script is normal,it isn’‘t anything error in SQL Console.I don’'t clarity what it is display error in auto update:)

Hey Tom,

Anything in the log files? Hopefully, you may find the database exception in the errro.log file.

Regards,

– Gato

Hey Gato,

i can’'t find anything error in error.log file,now i can run my JM2.2beta2 server when manual update my oracle database.maybe oracle only supply non automatic update it dababase:)

Hi,

I’'m pretty sure my upgrade failed to update the database schema and my attempt to manually update it has failed.

I’'ve noticed when I try to join a conference room from a pandion or soapbox client the client just sits there “connecting”.

The following also appears in the server error logs:

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2005.07.27 14:43:37 [org.jivesoftware.messenger.muc.spi.MUCPersistenceManager.loadFromDB(MUCPersist enceManager.java:283)

]

java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name ‘‘useReservedNick’’.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at org.jivesoftware.messenger.muc.spi.MUCPersistenceManager.loadFromDB(MUCPersiste nceManager.java:155)

at org.jivesoftware.messenger.muc.spi.MultiUserChatServerImpl.getChatRoom(MultiUse rChatServerImpl.java:434)

at org.jivesoftware.messenger.admin.muc_002droom_002dedit_002dform_jsp._jspService (muc_002droom_002dedit_002dform_jsp.java:162)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:78)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2005.07.27 14:47:38 [org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:145)

] Connection closed before session established

Socket[addr=/10.20.0.200,port=28453,localport=5269]

any ideas?

thanks

steve

Hey stevekdavis,

JM2.2 update muc table column,i view it maybe your database can’'t update new version,i suggest you update your database for jm method,this is link,you can try it whether it is right.

http://www.jivesoftware.org/fisheye/viewrep/cvs-org/messenger/src/database/upgra de/2.1_to_2.2/messenger_sqlserver.sql