[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [cobalt-users] Postgres Databse

#!/bin/sh
# 8/27/2001 Sun Microsystems, Inc.  #
# All RaQ 4 systems are subject to a pair of race conditions at
# build. One may leave /home/tmp with incorrect permissions. # The other may misconfigure PostgreSQL. Both will block 
# PostgreSQL from starting properly when the RaQ is powered on.
#
# The first symptom of this condition is an Internal Server
# Error when trying to view the Site List in the Server
# Administration interface.
#
# To correct either error condition, please run this
# script as root on the affected system.
# # #                  *** WARNING ***
# # ONLY RUN THIS SCRIPT ON A NEW OR FRESHLY REBUILT RAQ4
# THAT IS GIVING "INTERNAL SERVER ERROR" WHEN TRYING TO
# VIEW THE VIRTUAL SITE LIST IN THE RAQ ADMIN INTERFACE

echo "Forcing permission 01777 on /home/tmp"
chmod 01777 /home/tmp
echo
echo "Rebuilding PostgreSQL configuration"
mv /var/lib/pgsql /var/lib/headache.pgsql
echo
echo "(Re)Starting PostgreSQL"
/etc/rc.d/init.d/postgresql restart
echo
echo "Reconstructing the home site"
/usr/local/sbin/meta-verify -f -u -s -v -i
echo
echo "Done"


--
Bruce Timberlake
Technology Engineer
Sun Cobalt Server Appliances
Sun Microsystems, Inc.
Thanks Bruce! This helped get me to the solution. I did the above steps by hand rather than creating and running it as a script. When I got to restarting the postgresql database it pushed out an error that it couldn't write to /var/log/postgresql. When I went to /var/log to look for the file it did not exist, so I created it using 'touch' and then gave it the same permissions and owners as the compressed versions. I then had to start over and mv the database out and restart postgresql which took this time.
Problem was when I ran the '/usr/local/sbin/meta-verify -f -u -s -v -i' command it sucked in the users but not the sites so after some playing around with it I finally re-ran it removing the '-u' from the command and all the sites got sucked in and everything is good. 

This is just a recap in case anyone runs into this in the future.

Thanks again!


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com