Forum OpenACS Q&A: recovery package-install

Posted by Nitish Bezzala on 08/24/04 12:12 PM

Hi,

I have installed openACS 5.1.1 on Postgresql 7.3.2. Now I have also installed Postgresql 7.3.4 and want to move the old site to the new database.
I have followed the backup and recovery procedure given in the docs.

After restarting the server and pointing to the url, i get to the install page which says:

"Your PostgreSQL driver is correctly installed and configured.
The OpenACS data model is already installed. Click Next to scan the available packages."

On clicking next I get a page not found error :

"The requested URL could not be retrieved
While trying to retrieve the URL: http://192.168.12.74:8000/packages-install?"

This is from the log file :

[24/Aug/2004:14:10:00][8200.1075085952][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[24/Aug/2004:14:10:00][8200.1075085952][-main-] Notice: Sourcing files for postload...
[24/Aug/2004:14:10:00][8200.1075085952][-main-] Notice: Done.
[24/Aug/2004:14:10:00][8200.1075085952][-main-] Notice: Executing initialization code blocks...
[24/Aug/2004:14:10:02][8200.1075085952][-main-] Notice: nsmain: AOLserver/4.0.5 running
[24/Aug/2004:14:10:02][8200.1075085952][-main-] Notice: nsmain: security info: uid=503, euid=503, gid=503, egid=503
[24/Aug/2004:14:10:02][8200.1086671936][-sched-] Notice: sched: starting
[24/Aug/2004:14:10:02][8200.1075085952][-main-] Notice: nssock: listening on 192.168.12.74:8000
[24/Aug/2004:14:10:02][8200.1095461184][-driver-] Notice: starting
[24/Aug/2004:14:10:02][8200.1095461184][-driver-] Notice: driver: accepting connections
[24/Aug/2004:14:10:45][8200.1091267392][-conn:etg::1] Error: Unable to source /var/lib/aolserver/etg/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

Any suggestions ?

Thanks,
Nitish

2: Re: recovery package-install (response to 1)

Posted by Nitish Bezzala on 08/24/04 12:56 PM

Also, after running this command,

psql $OPENACS_SERVICE_NAME < /var/lib/aolserver/$OPENACS_SERVICE_NAME/database-backup/database-backup.dmp

there are no rows in users table or in apm_packages table.

3: Re: recovery package-install (response to 1)

Posted by Jade Rubick on 08/24/04 05:22 PM

Nitish, if you install both database versions on the same machine, you have to do a little trickery to make sure you're using the right database.

Usually, you have to make the new database listen on a second port, and then make sure the PGPORT or something like that is set correctly.

This is described a little in the documentation under the 4.6 - 5.0 upgrade, so that might be worth looking at.

However, I'm not sure you have to keep both versions on your system. I believe the upgrades from 7.3.2. to 7.3.4 won't require any dump and restore or anything, so you don't need a separate database.

4: Re: recovery package-install (response to 1)

Posted by Nitish Bezzala on 08/25/04 03:35 PM

I had installed openACS on a Red Hat Linux machine with the default postgres install and without the search module. I could not install openFTS on that postgres installation and so I installed postgres 7.3.4 using the openACS docs instructions. Only the new postgres is now running and I want to move the old data to this postgres installation.
The database is fine and working, but the data in the tables has not been moved.