Click here to register.
      
Sprechen Sie WebGUI? Parlez vous WebGUI? Se habla WebGUI? Spreekt u WebGUI?

Do you speak WebGUI? Please help us translate WebGUI into your language.



     Discuss > Etcetera

Upgrading from 5.4.3 to 5.5.8

User jjrowan
Date 3/16/2006 1:19 pm
Views 1101
Rating 9    Rate [
|
]
Previous · Next
User Message
jjrowan

I've been trying to upgrade 20 web sites from 5.4.3 to 5.5.8 but at the same time trying to go from Red Hat 9 to CentOS 4.2. After upgrading I thought there might be a problem with CentOS since that was new to the equasion but when I could not login to any of the sites I decided to create a site from the create.sql.  I was able to login to that and make changes so I started backtracking.  I found that when I ran the upgrade.pl in sbin although it had reported okay I had not scrolled back to see there were failures going from 5.4.3 to 5.5.8. 

 

Here's the contents from the webguiVersion table:

select * from webguiVersion;
+---------------+-----------------+-------------+
| webguiVersion | versionType     | dateApplied |
+---------------+-----------------+-------------+
| 4.6.6         | initial install |  1031248472 |
| 4.6.7         | upgrade         |  1033476095 |
| 4.6.8         | upgrade         |  1033476106 |
| 4.6.9         | upgrade         |  1033476122 |
| 4.7.0         | upgrade         |  1040621771 |
| 4.8.0         | upgrade         |  1040621792 |
| 4.9.0         | upgrade         |  1040621804 |
| 4.9.1         | upgrade         |  1040621816 |
| 4.9.2         | upgrade         |  1040621826 |
| 4.9.3         | upgrade         |  1040621836 |
| 4.9.4         | upgrade         |  1040621849 |
| 4.9.5         | upgrade         |  1040621856 |
| 5.0.0         | upgrade         |  1040621874 |
| 5.0.1         | upgrade         |  1045071233 |
| 5.0.2         | upgrade         |  1045071239 |
| 5.0.3         | upgrade         |  1045071246 |
| 5.1.0         | upgrade         |  1045764241 |
| 5.1.1         | upgrade         |  1045764253 |
| 5.1.2         | upgrade         |  1045764262 |
| 5.2.0         | upgrade         |  1052926327 |
| 5.2.1         | upgrade         |  1052926333 |
| 5.2.2         | upgrade         |  1052926333 |
| 5.2.3         | upgrade         |  1052926338 |
| 5.2.4         | upgrade         |  1052926338 |
| 5.2.5         | upgrade         |  1052926338 |
| 5.2.6         | upgrade         |  1052926340 |
| 5.3.0         | upgrade         |  1060057065 |
| 5.3.1         | upgrade         |  1060057088 |
| 5.3.2         | upgrade         |  1060057093 |
| 5.3.3         | upgrade         |  1060057099 |
| 5.4.0         | upgrade         |  1060057111 |
| 5.4.1         | upgrade         |  1060057130 |
| 5.4.2         | upgrade         |  1060057138 |
| 5.4.3         | upgrade         |  1060057147 |
+---------------+-----------------+-------------+
34 rows in set (0.00 sec)

 

When I run the sbin/upgrade.pl --doit here's what is displayed:

 READY TO BEGIN UPGRADES

Rownetco 5.4.3-5.4.4
        Backing up Rownetco (5.4.3)...OK
        Upgrading to 5.4.4...OK

Rownetco 5.4.4-5.5.0
        Backing up Rownetco (5.4.4)...OK
        Upgrading to 5.5.0...OK
Can't connect to data source , no database driver specified and DBI_DSN env var not set at ../../lib/WebGUI/Session.pm line 417
        Processing upgrade executable failed!

Rownetco 5.5.0-5.5.1
        Backing up Rownetco (5.5.0)...OK
        Upgrading to 5.5.1...OK

Rownetco 5.5.1-5.5.2
        Backing up Rownetco (5.5.1)...OK
        Upgrading to 5.5.2...OK

Rownetco 5.5.2-5.5.3
        Backing up Rownetco (5.5.2)...OK
        Upgrading to 5.5.3...OK

Rownetco 5.5.3-5.5.4
        Backing up Rownetco (5.5.3)...OK
        Upgrading to 5.5.4...OK

Rownetco 5.5.4-5.5.5
        Backing up Rownetco (5.5.4)...OK
        Upgrading to 5.5.5...OK

Rownetco 5.5.5-5.5.6
        Backing up Rownetco (5.5.5)...OK
        Upgrading to 5.5.6...OK

Rownetco 5.5.6-5.5.7
        Backing up Rownetco (5.5.6)...OK
        Upgrading to 5.5.7...OK

Rownetco 5.5.7-5.5.8
        Backing up Rownetco (5.5.7)...OK
        Upgrading to 5.5.8...OK

UPGRADES COMPLETE
Please restart your web server and test your sites.

NOTE: If you have not already done so, please consult
docs/gotcha.txt for possible upgrade complications.

 

The rownetco.com.conf was copied / modified from the 5.8.0 WebGUI.conf.original.  

 

Does anyone have a suggestion as to how I upgrade.  I don't want to rebuild 20 web sites after using the create.sql. 

--- (Edited on 3/16/2006 1:19 pm [GMT-0600] by jjrowan) ---



Back to Top
Rate [
|
]
 
 
jjrowan

Ok, here's where I stand now.  I have found that the virtual web configuration in Apache is apparently the cause of not being able to log into the site.  I thought using create.sql and having a fresh database, rather than one updated (with errors), resolved the login problem until I continued working the issue today.  When I tried to login to a new WebGUI site I was again locked out being thrown back to Visitor status.  I reworked the httpd.conf removing all virtual web sites and was able to login. 

 

I'll be studying the httpd.conf on my Red Hat 9 comparing it to the one on my CentOS machine to try to find out why the virtual web sites on CentOS are causing me these troubles.

 

--- (Edited on 3/21/2006 2:43 pm [GMT-0600] by jjrowan) ---



Back to Top
Rate [
|
]
 
 
     Discuss > Etcetera



Recent Discussions Color Key

Design:

Development:

Et Cetera:

Install/Upgrade:  

Smoketest:

Template Group:


Re: Shortcut of a thread by knowmad - Thu @ 07:33am

Re: Synopsis search results by knowmad - Thu @ 07:21am

Re: Templates workspace site by rogier - Thu @ 04:24am

Re: Templates workspace site by rogier - Thu @ 02:59am

Re: Shortcut of a thread by perlDreamer - Wed @ 11:46pm

Re: Ubuntu Load on Startup by SteveD - Wed @ 04:37pm

Shortcut of a thread by arjan - Wed @ 04:11pm

Re: preventing email spam mailto by lrobinson - Wed @ 03:51pm

preventing email spam mailto by sandraqu - Wed @ 03:39pm

Re: Data Form and Form Controls by martink - Tue @ 11:05am

Re: Synopsis search results by marieken - Tue @ 06:10am

Re: Übersetzungen vor dem nächsten Treffen by koen - Tue @ 04:24am

Re: Übersetzungen vor dem nächsten Treffen - Translations to be done before the next meeting will take place. by bernd - Tue @ 01:15am