Re: [GENERAL] Ident authentication failed for user

2012-03-01 Thread John R Pierce
On 03/01/12 10:03 AM, Ruben Blanco wrote: El día 1 de marzo de 2012 17:25, John R Pierce escribió: > On 03/01/12 9:02 AM, Ruben Blanco wrote: > specify host=localhost, otherwise its using the first 'local' line, which > specifies 'ident' authentication, as the error implies. Where should I

Re: [GENERAL] Ident authentication failed for user

2012-03-01 Thread Ruben Blanco
Hi John. Thanks a lot for your reply: El día 1 de marzo de 2012 17:25, John R Pierce escribió: > On 03/01/12 9:02 AM, Ruben Blanco wrote: > specify host=localhost, otherwise its using the first 'local' line, which > specifies 'ident' authentication, as the error implies. Where should I specify

Re: [GENERAL] Ident authentication failed for user

2012-03-01 Thread John R Pierce
On 03/01/12 9:02 AM, Ruben Blanco wrote: I cannot connect to my Postgres database from my PHP scripts. I get the error: PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in ... I have tried many combinations for "hos

[GENERAL] Ident authentication failed for user

2012-03-01 Thread Ruben Blanco
Hi: I cannot connect to my Postgres database from my PHP scripts. I get the error: PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in ... I have tried many combinations for "host" TYPE in "pg_hba.conf" (restarting po

Re: [GENERAL] Ident authentication failed for user - URGENT

2006-12-05 Thread brian
Marina Olhovsky wrote: Hello, I'm trying to assign a password for a postgres user. I've logged in as postgres, issued "alter user my_user with password 'my_passwd'". Doing "select * from pg_users" shows the new user with password assigned. However, when I try to start psql as the new user: "ps

Re: [GENERAL] Ident authentication failed for user - URGENT

2006-12-05 Thread Andreas Kretschmer
Marina Olhovsky <[EMAIL PROTECTED]> schrieb: > > Hello, > > I'm trying to assign a password for a postgres user. I've logged in as > postgres, issued "alter user my_user with password 'my_passwd'". Doing > "select > * from pg_users" shows the new user with password assigned. However, when I

[GENERAL] Ident authentication failed for user - URGENT

2006-12-05 Thread Marina Olhovsky
Hello, I'm trying to assign a password for a postgres user. I've logged in as postgres, issued "alter user my_user with password 'my_passwd'". Doing "select * from pg_users" shows the new user with password assigned. However, when I try to start psql as the new user: "psql -U my_user -W" and

Re: [GENERAL] Ident authentication failed for user "dsivam"

2006-11-30 Thread Martijn van Oosterhout
On Tue, Nov 28, 2006 at 03:40:09PM -0800, [EMAIL PROTECTED] wrote: > Hi- > > I've run into a problem using Postgres 8.1 that has me stumped: > > I'm logged on as user 'postgres' and I can connect using the following > command: > > bash$>psql > > However when I specify the host: > > bas

[GENERAL] Ident authentication failed for user "dsivam"

2006-11-30 Thread dsivam
Hi- I've run into a problem using Postgres 8.1 that has me stumped: I'm logged on as user 'postgres' and I can connect using the following command: bash$>psql However when I specify the host: bash$>psql -h localhost or bash$>psql -h hostname.domain.com I get the following error:

Re: [GENERAL] Ident authentication failed without su to user

2006-02-17 Thread jim_bowery
Yes. It turns out the problem was that my pg_hba.conf file was replaced by another file during a yum install of the new postgresql but in a different path. When I used "locate pg_hba.conf" it returned the path of the old file which didn't have the 'ident sameuser' rule.

Re: [GENERAL] Ident authentication failed without su to user

2006-02-16 Thread Chris
[EMAIL PROTECTED] wrote: I've created a database "bugs" and a user "bugs" (postgresql user as well as unix) and even made user "bugs" not require a password but I still get this: [EMAIL PROTECTED] bugzilla-2.20]# psql bugs bugs psql: FATAL: Ident authentication failed for user "bugs" ... but if

Re: [GENERAL] Ident authentication failed without su to user

2006-02-16 Thread Douglas McNaught
[EMAIL PROTECTED] writes: > I've created a database "bugs" and a user "bugs" (postgresql user as > well as unix) and even made user "bugs" not require a password but I > still get this: > [EMAIL PROTECTED] bugzilla-2.20]# psql bugs bugs > psql: FATAL: Ident authentication failed for user "bugs"

[GENERAL] Ident authentication failed without su to user

2006-02-16 Thread jim_bowery
I've created a database "bugs" and a user "bugs" (postgresql user as well as unix) and even made user "bugs" not require a password but I still get this: [EMAIL PROTECTED] bugzilla-2.20]# psql bugs bugs psql: FATAL: Ident authentication failed for user "bugs" ... but if I [EMAIL PROTECTED] bugzill

Re: [GENERAL] Ident authentication failed

2006-01-02 Thread Lucky Leavell
On Mon, 2 Jan 2006, Madison Kelly wrote: > Lucky Leavell wrote: > > v8.0.3 > > OS: SuSE 10.0 Pro > > > > I am new to PostgreSQL but fairly familiar with other RDBMS' such as Ingres, > > Informix and MySQL. > > > > I am attempting to switch from using MySQL to PostgreSQL with postfix. I > > hav

Re: [GENERAL] Ident authentication failed

2006-01-02 Thread Madison Kelly
Lucky Leavell wrote: v8.0.3 OS: SuSE 10.0 Pro I am new to PostgreSQL but fairly familiar with other RDBMS' such as Ingres, Informix and MySQL. I am attempting to switch from using MySQL to PostgreSQL with postfix. I have created the postfix user using createuser with a password but denying

[GENERAL] Ident authentication failed

2006-01-02 Thread Lucky Leavell
v8.0.3 OS: SuSE 10.0 Pro I am new to PostgreSQL but fairly familiar with other RDBMS' such as Ingres, Informix and MySQL. I am attempting to switch from using MySQL to PostgreSQL with postfix. I have created the postfix user using createuser with a password but denying the ability to create da