Return to Jive Software

Up to Discussions in Supportal Information & Feedback
356 Views 7 Replies Last post: Oct 15, 2009 10:55 AM by Curtis Gross RSS
frankfang Novice
frankfang
59 posts since
Aug 18, 2008
Currently Being Moderated

Oct 1, 2009 2:15 PM

Problems with reading comprehension

Hi guys,

 

I've gone through the installation and upgrade guide 4 times now, trying different permutations and am still getting stuck.

 

I am upgrading our Windows 2003 R2 based ClearSpace 2.5.6 instance to a CentOS based PC.

 

The steps I've taken in different permutations to date are :

 

- Download 3.0.7 x86 RPM from you guys

- Do a yum install bash-3.2 systat (to fulfill dependencies)

- Run : rpm -ivh <rpm file downloaded>

- do an appstop on the Src server

- Backup JiveHome dir on Src Win x86 machine.

- Perform mysqldump of clearspace and openfire MySQL db schemas to mysqldumpfiles.sql

- Copy export.jar from target x86 CentOS machine to Src Win x86 machine.

- Run java -jar export.jar <path to jiveHome on Src> jh.zip

- Run appstop on target srv

- mv /usr/local/jive/applications/sbs/home to /usr/local/jive/applications/sbs/home.bkp

- create a new home dir

- unzip jh.zip transferred from the Src machine

- Restored the mysql schemas using: mysql -u root -p < mysqldumpfiles.sql

- Run appstart (regardless of documentation since I just get the jive is temporarily unavailable screen if I dont do an appstart)

- Fill out the setup screens (shouldn't these be upgrade screens?)

- appstop

- appstart

 

When I log in to the new box none of the old docs are there. None of the customizations are there (logo, etc). It looks as if I skipped all the upgrade steps and went from installing the rpm to configuring the setup.

 

Please call me when you get a chance.

 

Frank 650.799.8828

Curtis Gross Jive Employee
Curtis Gross
4,164 posts since
Aug 2, 2007
Currently Being Moderated
Oct 1, 2009 5:26 PM in response to: frankfang
Re: Problems with reading comprehension

Frank,

 

Can you provide me the following?

/usr/local/jive/applications/sbs/home/jive_startup.xml

as well as the output from

ps aux|grep jive

and any log files from

/usr/local/jive/var/logs

I believe with these 3 pieces we can figure out what is going on.

 

-Curtis

frankfang Novice
frankfang
59 posts since
Aug 18, 2008
Currently Being Moderated
Oct 2, 2009 12:17 PM in response to: Curtis Gross
Re: Problems with reading comprehension

Curtis,

 

Here's the data you requested.

Attachments:
Curtis Gross Jive Employee
Curtis Gross
4,164 posts since
Aug 2, 2007
Currently Being Moderated
Oct 2, 2009 2:39 PM in response to: frankfang
Re: Problems with reading comprehension

Hi Frank,

 

Few things here

1) Can you get an updated license for your install from your account page?

2) What version of mysql / jdbc driver are you running?  I am seeing a few errors in the logs but everything ends around 9/26/2009, nothing more after that

 

-Curtis

frankfang Novice
frankfang
59 posts since
Aug 18, 2008
Currently Being Moderated
Oct 8, 2009 6:17 PM in response to: Curtis Gross
Re: Problems with reading comprehension

Sorry it's hard to keep going back and forth on email. Other stuff keeps coming up.

 

In answer to your questions:

i) I can get an updated license for the install from the license page.

ii) I downloaded the latest jdbc driver from mysql.com.

 

Investigating further, it looks like the tables in the MySQL schema are duplicated - eg there's a jivedocuments and a jiveDocuments. I'm assuming that the db upgrade part did not take into consideration that the source db is from windows that is by default case insensitive.

 

How do we go abouts fixing this?

 

Can we schedule a time to do this over the phone with a remote session and get this put to rest?

 

Thanks.

Curtis Gross Jive Employee
Curtis Gross
4,164 posts since
Aug 2, 2007
Currently Being Moderated
Oct 9, 2009 8:32 AM in response to: frankfang
Re: Problems with reading comprehension

Thank you for the information Frank, this is actually a fairly easy fix that will probably just require a restart of the mysql server.

 

1) If you can, drop the database from MySQL and re-import it so that you have just one set of tables again.

2)

 

 

Just edit your MySQL configuration file in /etc/mysql/my.cnf (it may vary from system to system) and add this:
[mysqld]
lower-case-table-names=1

There! Now you just need to restart mysql

/etc/init.d/mysql restart

 

-Curtis

frankfang Novice
frankfang
59 posts since
Aug 18, 2008
Currently Being Moderated
Oct 15, 2009 10:38 AM in response to: Curtis Gross
Re: Problems with reading comprehension

Thanks for the response Curtis, we have eveything working now.

Curtis Gross Jive Employee
Curtis Gross
4,164 posts since
Aug 2, 2007
Currently Being Moderated
Oct 15, 2009 10:55 AM in response to: frankfang
Re: Problems with reading comprehension

Glad to hear it is working as expected!

 

-Curtis

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.