[cobalt-users] newbie postgresql

["Jason Humphrey" <Jasonh@xxxxxxxxxxxx>]

Hi,
	I'm trying to run a php web content manager called "mambo". When I'm
installing it tells me that my server (a raq4) supports sql and there is no
problems. The next step asks for a mysql username and password and the
database name.

So.. I need to create a database with a username and password. I ssh in as
admin then su -. im using the command line "createdb mambodbbws -u
jhumphrey"
I believe this Should create a database called mambodbbws with a user
jhumphrey.

I get this error message
"psql: No pg_hba.conf entry for host localhost, user admin, database
template1"

I have tried su postgresql but it asks for a password and I don't know what
it is because I guess cobalt sets a standard one.

Is this the right way to create a database? and then how do I set a password
for the username?

Thanks Jason