Skip site navigation (1) Skip section navigation (2)

bug with identd autentication

From: BLON Sébastien <sebastien(dot)blon(at)nfrance(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug with identd autentication
Date: 2001-03-22 18:00:12
Message-ID: 20010322190012.A16800@albertine.nfrance.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi

The postmaster backend seems to be blocked when the identd server of the peer
accepts the connection but does not respond. (ie if the load is too high
on the identd server for example)

In fact, identd is dying without closing the socket. I know that it
is an identd problem ( pident 3.012 )

The identification seems to be performed by the parent process,
not by a child. Postgres stops forking and does not accept
connections anymore. (See strace below)

The timeout seems to be not configurable.

If posgtres is not restarted or if we do not wait for 5 minutes or
more, Postgres keeps blocking.

I hope i am clear enough.

select(6, [3 4 5], [], NULL, NULL)      = 1 (in [5])
SYS_175(0x2, 0x8197260, 0, 0x8, 0x2)    = 0
read(5, "\0\0\1(", 4)                   = 4
SYS_175(0x2, 0x81971e0, 0, 0x8, 0x2)    = 0
select(6, [3 4 5], [], NULL, NULL)      = 1 (in [5])
SYS_175(0x2, 0x8197260, 0, 0x8, 0x2)    = 0
read(5, "\0\2\0\0sintes\0\0\0\0\0\0\0\0\0"..., 292) = 292
open("/home/postgres/pg_hba", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/home/postgres/pg_hba.conf", O_RDONLY) = 6
fstat(6, {st_mode=S_ISVTX|0263, st_size=0, ...}) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x400150
00
read(6, "#\n# Example PostgreSQL host acc"..., 4096) = 4096
read(6, "USERAUTH are not allowed.\n\n# F"..., 4096) = 2597
close(6)                                = 0
munmap(0x40015000, 4096)                = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 6
bind(6, {sin_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("216.167.107.
199")}, 16) = 0
connect(6, {sin_family=AF_INET, sin_port=htons(113), sin_addr=inet_addr("216.167
.107.198")}, 16) = 0
send(6, "1920,5432\n", 10, 0)           = 10
recv(6,




-- 
        Sébastien BLON - Technicien Réseaux - blon(at)nfrance(dot)com
        Nfrance Conseil - 4 Rue J.F Kennedy - 31000 - Toulouse
Phone : +33 5 34 455 502 http://www.nfrance.com   Fax : +33 5 34 455 507

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-03-22 18:10:38
Subject: bug with identd autentication
Previous:From: Darren KingDate: 2001-03-22 17:18:31
Subject: RE: need solution for cachelookupfailed error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group