RE: [cobalt-users] Meta-Verify Errors - URGENT

[aljuhani <aljuhani@xxxxxxxxx>]

Here is how to fix PostgreSQL:

Occasionally the Postgres "cobalt" database on a RaQ will go totally south and 
the Virtual Site list in the control panel suddenly stops doing anything 
useful. Like existing.

First ensure that the problem is not simply caused by Postgres dying. Type:
ps -ef |grep postmaster and look for something other than the grep in your 
output. If there is nothing there then restart Postgres (see "Starting 
PostgreSQL" in the page list)If the site list is still missing then the 
database has smurfed and needs some TLC

Some problems of this nature can be sorted by downloading and running the 
siteManage-fix script (http://www.raqhelp.co.uk/downloads/siteManage-fix.tgz), 
but if this fails you have no choice but to drop the database completely and 
recreate it.
There are two ways to do this; the easy way, and the brutal way. This page 
describes the easy way.

The procedure is as follows...

su rootcd /usr/local/sbin/./setup-postgres./meta-verify -u -i ./meta-verify -u 
-a./meta-verify -s -i./meta-verify -s -a

The meta-verify script (http://www.raqhelp.co.uk/downloads/meta-verify.gz) is 
not present on some RaQ 3's (for some reason) so you can collect this copy 
with wget and gunzip it into the correct location.

The database is now fresh and blank and virgin, so you will now need to 
recreate the contents of the siteManage pages for each site using the sitefix 
script (http://www.raqhelp.co.uk/downloads/sitefix.gz).

wget it and gunzip it into /usr/local/sbin and run it thus:
./sitefix.pl

All being well, you should now have a functional Virtual Site list in your 
admin control panel, although some of the settings may be out of whack 
(incorrect disk quotas, SSI and/or CGI facilities switched off, and so on)
A thorough check of all sites will be required to ensure everything is as it 
should be.

THIS ARTICLE COPIED FROM The Cobalt RaQ Server Support Site 
(http://www.raqhelp.co.uk)

Regards,

Al-Juhani
aljuhani@xxxxxxxxx

>===== Original Message From cobalt-users@xxxxxxxxxxxxxxx =====
>At 09:24 AM 10/22/2002 -0600, you wrote:
>>On Tuesday, October 22, 2002, 6:16:49 AM, you wrote:
>>
>>JDG> On my raq4s, I have to run it from /usr/local/sbin, be sure that you 
are
>>JDG> in that directory.  It will run from other directories but for some
>>JDG> reason I do not get fixes without being in that directory.
>>
>>JDG> If you have not deleted anything or moved directories, then I would
>>JDG> reboot and then try it again.  You may try affing the -f
>>JDG> meta-verify -s -a -f
>>
>>
>>Tried that as well.....didn't work.  Something that happened
>>overnight, and I am not sure why, is that when you first go to the
>>Server Administration page, you get the following message rather than
>>the list of all the sites on the server:
>>
>>-----
>>No Virtual Sites were found with this search, try narrowing your
>>search criteria.
>>-----
>>
>>All the site are still functioning properly (HTTP, E-MAIL, FTP, Etc.)
>>but I am still not getting the sites to show up in the server admin
>>area, not getting any site administrators showing up in the user list
>>of a site admin page and still getting a list of every user when you
>>click List Management.
>>
>>:(
>Hi Ryan,
>
>I had that happen a few months ago and had to force a rebuild of the
>PostgreSQL database. I know that technique is documented in the archives.
>It is not a technique for the faint of heart! It worked like a charm in my
>situation.
>
>Please do not go and just do this! Get some more opinions on my suggestion!
>
>Could someone refer to the article that documents rebuilding the database
>for Ryan?
>
>Thanks,
>Glenn
>