Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread Andre Lopes
Hi John, Thanks for the replies. The problem was the ident in the host. Problem solved. Thanks a lot! Best Regards, On Fri, Dec 2, 2011 at 11:46 PM, John R Pierce wrote: > On 12/02/11 3:41 PM, Andre Lopes wrote: >> >> My pg_hba.conf have this: >> [code] >> # TYPE  DATABASE        USER      

Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread John R Pierce
On 12/02/11 3:41 PM, Andre Lopes wrote: My pg_hba.conf have this: [code] # TYPE DATABASEUSERCIDR-ADDRESSMETHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: hos

Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread Andre Lopes
Hi Adrian, Thanks for the reply. My pg_hba.conf have this: [code] # TYPE DATABASEUSERCIDR-ADDRESSMETHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: hostal

Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread John R Pierce
On 12/02/11 3:13 PM, Andre Lopes wrote: [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? 'ident' is the default authentication type for local

Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread Adrian Klaver
On Friday, December 02, 2011 3:13:41 pm Andre Lopes wrote: > Hi, > > I've installed PostgreSQL 9.0 in CentOS6 I don't have configured > anything in Postgre, I just created a user with this method: > > > With the method above I have no problems in enter "psql" but when I > try to connect with th

Re: [GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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

[GENERAL] Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.

2011-12-02 Thread Andre Lopes
Hi, I've installed PostgreSQL 9.0 in CentOS6 I don't have configured anything in Postgre, I just created a user with this method: [article] Here is how I do to create a Postgres user with the same username as my regular login in Linux Ubuntu. Go to your terminal with your regular user and do: {