Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. - Mailing list pgsql-general

From David Johnston
Subject Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
Date
Msg-id 000301ccb14a$0f0824f0$2d186ed0$@yahoo.com
Whole thread Raw
In response to Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andre Lopes
Sent: Friday, December 02, 2011 6:14 PM
To: postgresql Forums
Subject: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.


With the method above I have no problems in enter "psql" but when I try to connect with the user created with these
methodto a webapp I got an error: 

[code]
Exception Value:
FATAL:  Ident authentication failed for user "mypoatgreuser"
[/code]

There is more permissions that I must to give to the user "mypoatgreuser"? What could be wrong here?

-----------------------------------------------------

Andre,

The information you have supplied is inadequate but I am concerned that you may just have a simple typo in your webapp
configuration:

"mypoatgreuser" => "mypostgreuser";  note the "a" should be an "s"

Also, it is considered proper for the shortened form of PostgreSQL to include the trailing "s" (Postgres) as opposed to
simply"Postgre"; might as well get used to that before you go naming everything you come across "postgre" :) 

David J.



pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
Next
From: Adrian Klaver
Date:
Subject: Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.