[OGo-Users] ogo Debian Sarge First install apach2 404

Adam Tauno Williams users@opengroupware.org
Thu, 01 Mar 2007 08:07:08 -0500


> > psql -h localhost -U OGo OGo
> > If you don't specify a "-h" it assumes a domain socket connection with
> > uses different default authentication;  since OGo is using a TCP/IP
> > connection, to test you should use a TCP/IP connection.
> Maybe I am too stupid for postgresql :/
> su - postgres
> psql -h localhost -U ogo ogo (lowercases are correct because both user
> and database are written in lowercases)
> returns: FATAL: IDENT-Authentification for user ogo failed

"IDENT-Authentication" means you must be who are claiming to be,  su to
"ogo" and try it.

> Why??
> Even after consulting postgresql's docs I don't see any mistype or
> something :(

You aren't mistyping anything,  what you are trying to do just doesn't
match your configuration;  look in pg_hba.conf.

> > Nope, I don't think that matters.  If you are getting a Skyrix error
> > though the browser then you have the Apache connection working.
> Let me resume: The only problem I got now is to let OGo connect to the
> postgresql-DB, right?

Yes, seems that way.

Did you look at the WMOGAG section on database connection configuration?
Also see the PostgreSQL documentation for the differences between
trust/ident/password mechanisms.