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

[COMPUTICA <cobalt@xxxxxxxxxxxxxxxxxx>]

On Tuesday, October 22, 2002, 2:27:14 PM, you wrote:

GP> At 02:11 PM 10/22/2002 -0600, you wrote:

>>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

GP> Sorry Ryan,

GP> That was the very last thing I could try when I was down in that hell.

GP> The guys (and gals) on this list will help you, probably better than Sun 
GP> will, but they also have to work to satisfy their bosses or customers as 
GP> well. Sorry to hear you lost customers over this!

GP> Glenn


Thanks Glenn!  Appreciate the response.

Now, I have successfully added a new domain to the list, added a
user (site admin) and logged in and don't see any mailing lists that
show all my users!  ;)

When I run meta-verify on the server now, it shows a single virtual
host (site66).

Is there any way I can get into the Postgres database table for
virtual domains and just copy-n-paste the info in there for my new
domain and edit it for all the other domains?

Would that work?  If so....how do I access that table of Postgres?

Thanks,
Ryan