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

["Alex Lee" <alex@xxxxxxxxxx>]

Your mistake was to mess with the admin password to the postgres
database.

Change it back to the original setting (it's some cryptic randomly
generated hash) and you'll be fine.

If you don't know what it is anymore, look at the file
/etc/cobalt/.meta.id

Now, don't go messing around with that again <g> It's what the GUI uses
to access the databases, create your own "admin" account for your own
databases.



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