[cobalt-users] RE: Virtual Sites GONE after messing with PostgreSQL

[Robert Fitzpatrick <webmaster@xxxxxxxxxxx>]

>I was messing around with PostgreSQL using Webmin. The only 
>thing I did was change the password for the 'admin' user. Now, 
>the Virtual Sites in the Cobalt GUI are gone and I keep 
>getting this message in the e-mail sent to admin@xxxxxxxxxx 
>saying 'The PostgreSQL server is down and cannot be restarted'.
>

Hate to be the first to respond to my own post, but I wanted to pass along
some other findings that I've found out since trying to get the list of
Virtual Sites going. If I go into the pg_hba.conf file and change to 'local
all trust', the sites all come back up. But when I return it to 'local all
crypt' I lose the list of virtual sites again. So, I believe I have a
permissions problem. Like I said above, I had changed the password for
'admin' using Webmin. Now, I also think the user 'postgres' settings may
have been changed also. So, how can I check the validity of these things
with Postgres or otherwise. Maybe the pg_shadow or other password file is
not in sync or something? Can anyone tell me the settings they show for the
user 'postgres'?

--
Robert Fitzpatrick