On 16/10/13, Tom Lane (t...@sss.pgh.pa.us) wrote:
> Rory Campbell-Lange writes:
> > 2013-10-16 16:21:16 BST template1 LOG: local user with ID does
> > not exist
> > 2013-10-16 16:21:16 BST template1 FATAL: Peer authentication failed
> > for user "postgres"
>
> > However /etc/passwd h
On 10/16/2013 8:34 AM, Rory Campbell-Lange wrote:
I've just turned the setting in pg_hba.conf from md5 back to peer and
reloaded the server so that it now reads as:
local all postgrespeer
Attempting to log in fails with the following error on t
Rory Campbell-Lange writes:
> Thanks for the suggestion for checking the logs. My apologies for not
> checking that. The logs show:
> 2013-10-16 16:21:16 BST template1 LOG: local user with ID does not
> exist
> 2013-10-16 16:21:16 BST template1 FATAL: Peer authentication failed for
>
On 16/10/13, Adrian Klaver (adrian.kla...@gmail.com) wrote:
> On 10/16/2013 06:56 AM, Rory Campbell-Lange wrote:
> >I have just done an update on my Debian servers running postgresql 9.2
> >(Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly
> >can't login to postgresql as post
On 10/16/2013 06:56 AM, Rory Campbell-Lange wrote:
I have just done an update on my Debian servers running postgresql 9.2
(Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly
can't login to postgresql as postgres with the normal peer/ident
authentication over a local Unix sock
I have just done an update on my Debian servers running postgresql 9.2
(Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly
can't login to postgresql as postgres with the normal peer/ident
authentication over a local Unix socket.
I've worked around it (I'm using md5 for the ti
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
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
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
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
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
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
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
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
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:
David Link <[EMAIL PROTECTED]> writes:
> Thanks for your suggestion. I'm new to the concept of packet sniffing
> and tracing. Can you suggest where I should go or what I should read to
> better understand this?
"man strace" ... strace is probably easier to use for this purpose than
a packet sn
Tom Lane wrote:
David Link <[EMAIL PROTECTED]> writes:
Does anyone know how I can test ident?
I'd try sniffing the IP traffic to and from it with a packet sniffer
and/or tracing the daemon's system calls with strace. Manually invoking
the daemon isn't going to prove a lot, you want to
David Link <[EMAIL PROTECTED]> writes:
> Does anyone know how I can test ident?
I'd try sniffing the IP traffic to and from it with a packet sniffer
and/or tracing the daemon's system calls with strace. Manually invoking
the daemon isn't going to prove a lot, you want to watch its reaction
to Pos
Hi,
I am having trouble with ident authentication. Everything is working
fine except when specifying host for connections on the local machine.
pg_hba.conf:
local all all ident wp
hostall all 10.97.8.0/24 ident wp
pg_ident.conf:
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.
[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
[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"
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
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
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
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
On Fri, 2005-03-04 at 19:59 -0500, David A. Cobb wrote:
> I've newly transitioned from Windoze to Debian Linux. And, of course,
> I'm installing things left and right.
>
> I had pgsql up and running, then I had to do a lot of tearing out and
> reinstalling other stuff. Now, when I try to conne
I've newly transitioned from Windoze to Debian Linux. And, of course,
I'm installing things left and right.
I had pgsql up and running, then I had to do a lot of tearing out and
reinstalling other stuff. Now, when I try to connect to psql I get:
psql: FATAL: IDENT authentication failed for u
On 24/01/2005 16:28 Jarkko Elfving wrote:
On Mon, 2005-01-24 at 09:21 -0700, Michael Fuhr wrote:
> Are you using a TCP connection or a Unix-domain socket connection?
> If the former, do you have an IDENT server running? If the latter,
> what platform are you using? Not all operating systems can p
On Mon, Jan 24, 2005 at 06:46:25PM +0200, Jarkko Elfving wrote:
> On Mon, 2005-01-24 at 09:39 -0700, Michael Fuhr wrote:
> >
> > What was the solution? It might be informative to people searching
> > the list archives because they're having the same problem.
>
> I just modify the pg_hba.conf fil
On Mon, 2005-01-24 at 09:39 -0700, Michael Fuhr wrote:
> On Mon, Jan 24, 2005 at 06:35:36PM +0200, Jarkko Elfving wrote:
>
> > I did get it work, thanks for help.
>
> What was the solution? It might be informative to people searching
> the list archives because they're having the same problem.
>
On Mon, Jan 24, 2005 at 06:35:36PM +0200, Jarkko Elfving wrote:
> I did get it work, thanks for help.
What was the solution? It might be informative to people searching
the list archives because they're having the same problem.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
-
Hi...
I did get it work, thanks for help.
--
Jarkko Elfving <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Mon, 2005-01-24 at 09:21 -0700, Michael Fuhr wrote:
> Are you using a TCP connection or a Unix-domain socket connection?
> If the former, do you have an IDENT server running? If the latter,
> what platform are you using? Not all operating systems can pass
> credentials over Unix-domain sockets
Jarkko Elfving <[EMAIL PROTECTED]> writes:
> I'm trying to connect to my test DB in localhost with pgAdmin3 but I got
> an error message
> Error connecting to the server: FATAL: Ident authentication failed for
> user "jarkko"
> What should I do?
Either run an identd daemon, or use a different aut
On Mon, Jan 24, 2005 at 05:55:29PM +0200, Jarkko Elfving wrote:
> I'm trying to connect to my test DB in localhost with pgAdmin3 but I got
> an error message
>
> Error connecting to the server: FATAL: Ident authentication failed for
> user "jarkko"
Are you using a TCP connection or a Unix-domai
Hi.
I'm trying to connect to my test DB in localhost with pgAdmin3 but I got
an error message
Error connecting to the server: FATAL: Ident authentication failed for
user "jarkko"
What should I do?
I'm reading documents about this and there was something about
pg_hba.conf and pg_ident.conf. I d
On Thu, Apr 22, 2004 at 01:58:14PM +0200, Karsten Hilbert wrote:
> a) it seems SQL ledger wants to store data in PostgreSQL
> b) I assume it wants to store *financial* data
> c) local/all/trust means *all* *local* users are *trusted*, eg
>don't require any authentication, hence system account
> > > Do yourself a favour and change authentication type in pg_hba.conf to
> > >
> > > local all trust
> > If you follow this sage advice you'll open up your financial
> > data to anyone happening to have an account on the machine in
> > question. Anyone. Not just people wh
>
> Jim Seymour wrote:
> > Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> >>If you follow this sage advice you'll open up your financial
> >>data to anyone happening to have an account on the machine in
> >>question. Anyone. Not just people who also happen to have
> >>*PostgreSQL* DB accounts.
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 21 April 2004 04:53 pm, Shanta McBain wrote:
> On April 21, 2004 13:26, Karsten Hilbert wrote:
> > If you follow this sage advice you'll open up your financial
> > data to anyone happening to have an account on the machine in
> > question.
41 matches
Mail list logo
