pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] user authentication failed...
5+ messages / 4 participants
[nested] [flat]
* Re: [INTERFACES] user authentication failed...
@ 1999-06-09 17:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: StOo <stuart@comodo.net>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 1999-06-09 17:19 UTC (permalink / raw)
To: StOo <stuart@comodo.net>; +Cc: pgsql-interfaces
Did you remember to add the new machine to pg_hba.conf?
6.4 is pretty closemouthed about telling you exactly why it's refusing
your connection; "user authentication failed" actually covers a lot of
different reasons. 6.5 will give a bit more info ... hopefully not
enough to risk being a security problem ...
Also, the postmaster log may contain more info than is reported to
the client.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* user authentication failed...
@ 1999-06-09 17:48 StOo <stuart@comodo.net>
0 siblings, 1 reply; 5+ messages in thread
From: StOo @ 1999-06-09 17:48 UTC (permalink / raw)
To: pgsql-interfaces
This is really daft but i cant think what i have missed
I've got 1 postgres machine thats running the DB and 1 develkopment
machine that connects to the backend on the development machine and
plays ball nicley.
I've just come to add a new devlopment machine , same flavour of linux
same postgres release (6.4.2) i came to run a straight forward test
program and i keep getting
user authentication failed
the ports are the same, the user has been added in the psql even when i
use an exsisting name and password i get grief ... any ideas ...
Stuart
+-=-=-=-=-=-+
Too much coffee not enough sleep.
^ permalink raw reply [nested|flat] 5+ messages in thread
* user authentication failed.....
@ 1999-06-10 10:16 StOo <stuart@comodo.net>
0 siblings, 2 replies; 5+ messages in thread
From: StOo @ 1999-06-10 10:16 UTC (permalink / raw)
To: pgsql-interfaces
This is really daft but i cant think what i have missed
I've got 1 postgres machine thats running the DB and 1 development
machine that connects to the backend on the DB machine and
plays ball nicley.
I've just come to add a new devlopment machine , same flavour of linux
same postgres release (6.4.2) i came to run a straight forward test
program and i keep getting
user authentication failed
the ports are the same, the user has been added for psql even when i
use an exsisting name and password i get grief ... any ideas ...
Stuart
+-=-=-=-=-=-+
Too much coffee not enough sleep.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] user authentication failed.....
@ 1999-06-10 12:04 José Soares <jose@sferacarta.com>
parent: StOo <stuart@comodo.net>
1 sibling, 0 replies; 5+ messages in thread
From: José Soares @ 1999-06-10 12:04 UTC (permalink / raw)
To: StOo <stuart@comodo.net>; +Cc: pgsql-interfaces
run postmaster with -i parameter and give access to clients in the file
$PGDATA/pg_hba.conf
StOo ha scritto:
> This is really daft but i cant think what i have missed
>
> I've got 1 postgres machine thats running the DB and 1 development
> machine that connects to the backend on the DB machine and
> plays ball nicley.
>
> I've just come to add a new devlopment machine , same flavour of linux
> same postgres release (6.4.2) i came to run a straight forward test
> program and i keep getting
>
> user authentication failed
>
> the ports are the same, the user has been added for psql even when i
> use an exsisting name and password i get grief ... any ideas ...
>
> Stuart
>
> +-=-=-=-=-=-+
>
> Too much coffee not enough sleep.
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] user authentication failed.....
@ 1999-06-10 12:42 Olivier PRENANT <ohp@pyrenet.fr>
parent: StOo <stuart@comodo.net>
1 sibling, 0 replies; 5+ messages in thread
From: Olivier PRENANT @ 1999-06-10 12:42 UTC (permalink / raw)
To: StOo <stuart@comodo.net>; +Cc: pgsql-interfaces
Hi Stuart,
Did you check the pg_hba on the new machine?
Just my .02 $
On Thu, 10 Jun 1999, StOo wrote:
>
> This is really daft but i cant think what i have missed
>
> I've got 1 postgres machine thats running the DB and 1 development
> machine that connects to the backend on the DB machine and
> plays ball nicley.
>
> I've just come to add a new devlopment machine , same flavour of linux
> same postgres release (6.4.2) i came to run a straight forward test
> program and i keep getting
>
> user authentication failed
>
> the ports are the same, the user has been added for psql even when i
> use an exsisting name and password i get grief ... any ideas ...
>
> Stuart
>
> +-=-=-=-=-=-+
>
> Too much coffee not enough sleep.
>
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-06-10 12:42 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-09 17:48 user authentication failed... StOo <stuart@comodo.net>
1999-06-09 17:19 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-06-10 10:16 user authentication failed..... StOo <stuart@comodo.net>
1999-06-10 12:04 ` Re: [INTERFACES] user authentication failed..... José Soares <jose@sferacarta.com>
1999-06-10 12:42 ` Re: [INTERFACES] user authentication failed..... Olivier PRENANT <ohp@pyrenet.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox