Up to Discussions in Clearspace
10 Replies Last post: May 5, 2008 11:28 PM by Noman Nadeem  
Click to view dillera's profile Novice
dillera
33 posts since
Aug 13, 2007

Apr 18, 2008 3:11 PM

Looking for 1.6 -> 2.0 upgrade documentation

I'm looking for a link to a 1.6 to 2.0.1 upgrade doc.

 

I have a running 1.6.x clearspace and I want to try a quick upgrade on a test server to see what 2.0 does.

 

I'm using the standalone war with Apache tomcat on linux.

 

Is it as easy as deploying the new war and copying over my mysql database and Jivehome?

 

Is there nothing else I need to do?

 

 

thanks,

andy

Tags: upgrade, 2.0
Click to view rickpalmer's profile Novice
rickpalmer
12 posts since
Nov 14, 2007
Apr 18, 2008 3:17 PM in response to: dillera
Re: Looking for 1.6 -> 2.0 upgrade documentation

Here's a good reference doc that explains the migration-related issues you should be aware of:

 

http://www.jivesoftware.com/builds/docs/clearspace/latest/UpgradingExtensionstoV ersion2.html

 

Level of difficulty will depend on how many customizations you've made, but if you haven't made customizations than it should be about as easy as you described.

Click to view dillera's profile Novice
dillera
33 posts since
Aug 13, 2007
Apr 18, 2008 3:33 PM in response to: rickpalmer
Re: Looking for 1.6 -> 2.0 upgrade documentation

ok, that seems targeted to the developer/plugin level, but thanks for the link.

 

I'm wondering most about the system-admin level, I'm just deplying the new 2.0 war with my 1.6 mysql database and jivehome but getting a mysql errors,

 

Apr 18, 2008 6:30:14 PM com.jivesoftware.community.impl.DbJiveProperties loadProperties
SEVERE: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to retrieve connection from DriverManager
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to retrieve connection from DriverManager

 

there are no known issues re: database schema updates or mysql drivers?

Click to view dillera's profile Novice
dillera
33 posts since
Aug 13, 2007
Apr 18, 2008 3:42 PM in response to: dillera
Re: Looking for 1.6 -> 2.0 upgrade documentation

ah, nevermind, forgot to install my mysql driver:

 

cp mysql-connector-java-5.1.5-bin.jar /usr/local/apache-tomcat-5.5.26_old/shared/lib/

 

 

It works and comes up now, there are some wierd database errors, we'll see.

Click to view dillera's profile Novice
dillera
33 posts since
Aug 13, 2007
Apr 18, 2008 3:34 PM in response to: rickpalmer
Re: Looking for 1.6 -> 2.0 upgrade documentation

My database is up, I can connect to it via the command line with the user/pass that I have set in jive_startup.xml.

Click to view rickpalmer's profile Novice
rickpalmer
12 posts since
Nov 14, 2007
Apr 18, 2008 3:43 PM in response to: dillera
Re: Looking for 1.6 -> 2.0 upgrade documentation

Oh, gotcha. You might just need to rerun setup to make sure your database is upgraded to support the new 2.0 features.

 

Try setting the setup element value in jive_startup.xml to false, like this:

 


  <!-- When setup is false, you can access the setup tool. -->  
  <setup>false</setup>

 

Then restart the server and try to access the app through the browser. You'll be taken through the setup screens (jiveHome, database, etc) and then when you restart one last time it will upgrade your database.

Click to view dillera's profile Novice
dillera
33 posts since
Aug 13, 2007
Apr 18, 2008 3:43 PM in response to: dillera
Re: Looking for 1.6 -> 2.0 upgrade documentation

Here is the output I get now:

 

pr 18, 2008 6:42:44 PM com.jivesoftware.base.Log info
INFO: Using com.jivesoftware.base.database.DbGroupManager as a group manager
Apr 18, 2008 6:42:44 PM com.jivesoftware.community.impl.dao.UserDAOImpl getUserByUsername
SEVERE: Failure attempting to load user by username 'openfire_SHRJKZCNU53'.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT userID, username, passwordHash, name, nameVisible, email, emailVisible, userEnabled, creationDate, modificationDate, lastLoggedIn, email, isExternal, federated FROM jiveUser WHERE username=?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'isExternal' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(S QLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:582)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:653)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:696 )
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJd bcTemplate.java:169)
at com.jivesoftware.base.database.dao.JiveJdbcOperationsTemplate.queryForObject(Ji veJdbcOperationsTemplate.java:168)
at com.jivesoftware.community.impl.dao.UserDAOImpl.getUserByUsername(UserDAOImpl.j ava:294)
at com.jivesoftware.base.profile.MultiProviderUserManager.getUser(MultiProviderUse rManager.java:295)
at com.jivesoftware.base.profile.MultiProviderUserManager.getUser(MultiProviderUse rManager.java:243)
at com.jivesoftware.community.impl.DbPermissionsManager.init(DbPermissionsManager. java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)

 

....

Click to view Long's profile Expert
Long
1,093 posts since
Apr 1, 2008
Apr 21, 2008 8:29 AM in response to: dillera
Re: Looking for 1.6 -> 2.0 upgrade documentation

Hello Andrew,

 

I get this output myself for upgrades to 2.0. It appears to be normal for upgrades at the moment (although not ideal), a MySQL SELECT statement is being run referencing the column "isExternal" before it's actually been created in the upgrade console/process.

 

 

So if this is the only error your receiving, your upgrade should be fine! Let us know otherwise

Long

Click to view Noman Nadeem's profile Novice
Noman Nadeem
2 posts since
Nov 26, 2007
May 4, 2008 6:07 AM in response to: Long
Re: Looking for 1.6 -> 2.0 upgrade documentation

Hi everyone. Any updates on this issue. I'm facing the same myself, upgrading from 1.10.5 -> 2.0.

 

My settings are:

 

O/S: Win2k3

Tomcat 6.0

Oracle Database 10gR2 (10.2.0.1)

Using Active Directory for user authentication

 

Getting stuck at the Upgrade Console. (unable to login)

 

extracts from the jive.error.log:

 

2008.05.04 15:47:13 [getUserByUsername] Failure attempting to load user by username 'openfire_SHRJKZCNU53'.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT userID, username, passwordHash, name, nameVisible, email, emailVisible, userEnabled, creationDate, modificationDate, lastLoggedIn, email, isExternal, federated FROM jiveUser WHERE username=?]; nested exception is java.sql.SQLException: ORA-00904: "FEDERATED": invalid identifier

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(S QLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:582)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:653)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:696 )
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJd bcTemplate.java:169)

...

...

Caused by: java.sql.SQLException: ORA-00904: "FEDERATED": invalid identifier

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

...

...

2008.05.04 15:47:26 [error] Failed to initialize Activity and Popularity:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(S QLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:582)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)

...

...

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

 

 

any help here would be greatly appreciated

Click to view Vinh's profile Expert
Vinh
1,601 posts since
Apr 1, 2008
May 5, 2008 8:02 AM in response to: Noman Nadeem
Re: Looking for 1.6 -> 2.0 upgrade documentation

If you're using Active Directory, make sure that your port is set to 3268 when you run through setup (and not whatever is the default). Using this port will allow you to log in correctly.

Click to view Noman Nadeem's profile Novice
Noman Nadeem
2 posts since
Nov 26, 2007
May 5, 2008 11:28 PM in response to: Vinh
Re: Looking for 1.6 -> 2.0 upgrade documentation

Thanks for the reply. The port is already set to 3268. Still the same. Unable to login.

I manually inserted the "admin" record in the jiveuser table and was able to login with admin user and complete the upgrade console. However, still unable to login with any active directory user.

 

Note: If I change the password of the user from the Admin Page (using admin user), I'm able to login with the user but it is not authenticated from AD anymore.

 

These errors appeared:

2008.05.04 16:46:12 [error] Coult not execute SQLGen xml file: com/jivesoftware/community/upgrade/scripts/CommunityToContainerTaskA.xml
java.sql.SQLException: ORA-01418: specified index does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
...

...

2008.05.04 16:46:13 [error] Coult not execute SQLGen xml file: com/jivesoftware/community/upgrade/scripts/CommunityToContainerTaskD.xml
java.sql.SQLException: ORA-01418: specified index does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
...

...

2008.05.04 16:47:48 [error] Object is not a JiveContentObject.
2008.05.04 16:47:48 [error] Object is not a JiveContentObject.
java.lang.IllegalArgumentException: Object is not a JiveContentObject.
at com.jivesoftware.community.impl.JiveObjectLoaderImpl.getJiveContentObject(JiveO bjectLoaderImpl.java:136)
at com.jivesoftware.community.impl.search.LocalSearchManager.buildContainerFields( LocalSearchManager.java:1097)

...

...

 

The same things happen with 2.0.1 version. I know this is not the right way to proceed with the upgrade but I wanted to go forward and see if the upgrade console finished successfully.

More Like This

  • Retrieving data ...