Re[3]: [cobalt-users] Meta-Verify Errors - URGENT

[COMPUTICA <cobalt@xxxxxxxxxxxxxxxxxx>]

C> On Tuesday, October 22, 2002, 10:23:36 AM, you wrote:

a>> Here is how to fix PostgreSQL:

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

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

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

a>> The procedure is as follows...

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

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

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

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

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

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

a>> Regards,

a>> Al-Juhani
a>> aljuhani@xxxxxxxxx



Okay, I ran through every step above and I am no better off.  I didn't
get an error message while doing any of the steps, so I am going to
assume that there was no problems.

Yet, my same problems exist.

Should I be lead to believe that my database table in Postgres with
all the domain information is gone?

Users are still there.....sites still work.....but domains aren't in
list.

If that is the case...how do I go about rebuilding that table?  Is
there an easy way?  Or should I just start adding a site back into the
server through the GUI and then delete the old site files manually?

Any ideas?  I have already lost two fairly new customers due to these
problems and I don't want to lose anymore.....it's unfortunate
problems like that have to happen...  :(

Thanks,
Ryan