Re: Problem connecting to localhost in 7.4.2

>The command I am running is:
>psql -h 127.0.0.1 nagios
>Username is shawn
>This works if I leave off the -h 127.0.0.1.
>Attached is the strace for postmaster. The strace for psql is too big
>for the email list, so it is posted at
>
>
Perhaps your default firewall set up in FC2 is blocking 5432 to localhost?
What does your /sbin/iptables -L say?

Sincerely,

Joshua D. Drake

>http://pookie.dyndns.org/strace-psql.txt
>Thank you in advance for your help.
>
>
>------------------------------------------------------------------------
>
>[root(at)conops2 log]# strace -frp 3526
>Process 3526 attached - interrupt to quit
> 0.000000 select(6, [3 4 5], NULL, NULL, {1, 445000}) = 0 (Timeout)
> 1.446027 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000217 time(NULL) = 1099092340
> 0.000147 clone(Process 3683 attached
>child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3683
>[pid 3526] 0.000920 utime("/tmp/.s.PGSQL.5432", NULL <unfinished ...>
>[pid 3683] 0.000124 close(3 <unfinished ...>
>[pid 3526] 0.000189 <... utime resumed> ) = 0
>[pid 3683] 0.000068 <... close resumed> ) = 0
>[pid 3526] 0.000070 utime("/tmp/.s.PGSQL.5432.lock", NULL <unfinished ...>
>[pid 3683] 0.000142 close(4) = 0
>[pid 3683] 0.000097 close(5) = 0
>[pid 3683] 0.000095 close(7) = 0
>[pid 3683] 0.000113 close(8) = 0
>[pid 3526] 0.000318 <... utime resumed> ) = 0
>[pid 3526] 0.000209 rt_sigprocmask(SIG_SETMASK, [], <unfinished ...>
>[pid 3683] 0.000090 open("/var/lib/pgsql/data/PG_VERSION", O_RDONLY|O_LARGEFILE) = 3
>[pid 3526] 0.000226 <... rt_sigprocmask resumed> NULL, 8) = 0
>[pid 3683] 0.000084 fstat64(3, <unfinished ...>
>[pid 3526] 0.000080 select(6, [3 4 5], NULL, NULL, {60, 0} <unfinished ...>
>[pid 3683] 0.000228 <... fstat64 resumed> {st_mode=S_IFREG|0600, st_size=4, ...}) = 0
>[pid 3683] 0.000213 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xf64c7000
>[pid 3683] 0.000145 read(3, "7.4\n", 4096) = 4
>[pid 3683] 0.000216 close(3) = 0
>[pid 3683] 0.000106 munmap(0xf64c7000, 4096) = 0
>[pid 3683] 0.000127 rt_sigaction(SIGHUP, {SIG_IGN}, {0x8157600, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000166 rt_sigaction(SIGINT, {SIG_IGN}, {0x81576d0, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000162 rt_sigaction(SIGTERM, {0x817dd50, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000166 rt_sigaction(SIGQUIT, {0x817dca0, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000180 rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_IGN}, 8) = 0
>[pid 3683] 0.000153 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0
>[pid 3683] 0.000151 rt_sigaction(SIGUSR1, {SIG_IGN}, {0x8158cb0, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000158 rt_sigaction(SIGUSR2, {SIG_IGN}, {0x8158e40, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000165 rt_sigaction(SIGCHLD, {SIG_DFL}, {0x8157a60, [], SA_RESTART}, 8) = 0
>[pid 3683] 0.000158 rt_sigaction(SIGTTIN, {SIG_DFL}, {SIG_IGN}, 8) = 0
>[pid 3683] 0.000188 rt_sigaction(SIGTTOU, {SIG_DFL}, {SIG_IGN}, 8) = 0
>[pid 3683] 0.000152 rt_sigaction(SIGCONT, {SIG_DFL}, {SIG_DFL}, 8) = 0
>[pid 3683] 0.000152 rt_sigaction(SIGWINCH, {SIG_DFL}, {SIG_DFL}, 8) = 0
>[pid 3683] 0.000152 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
>[pid 3683] 0.000315 semctl(3473447, 4, IPC_64|SETVAL, 0xfeea7a34) = 0
>[pid 3683] 0.000358 time(NULL) = 1099092340
>[pid 3683] 0.000770 exit_group(0) = ?
>Process 3683 detached
> 0.000709 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted)
> 0.000133 --- SIGCHLD (Child exited) @ 0 (0) ---
> 0.000187 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000308 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 3683
> 0.000286 time(NULL) = 1099092340
> 0.000269 waitpid(-1, 0xfeea789c, WNOHANG) = 0
> 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 0.000121 sigreturn() = ? (mask now [])
> 0.000204 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000141 time(NULL) = 1099092340
> 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 0.000128 select(6, [3 4 5], NULL, NULL, {300, 0}) = 1 (in [4], left {297, 849000})
> 2.150629 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000177 accept(4, {sa_family=AF_INET, sin_port=htons(32825), sin_addr=inet_addr("127.0.0.1")}, [16]) = 9
> 0.000431 getsockname(9, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
> 0.000454 setsockopt(9, SOL_TCP, TCP_NODELAY, [1], 4) = 0
> 0.000285 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
> 0.000147 clone(Process 3686 attached
>child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3686
>[pid 3526] 0.001056 close(9 <unfinished ...>
>[pid 3686] 0.000162 close(3 <unfinished ...>
>[pid 3526] 0.000062 <... close resumed> ) = 0
>[pid 3686] 0.000072 <... close resumed> ) = 0
>[pid 3686] 0.000062 close(4) = 0
>[pid 3686] 0.000106 close(5) = 0
>[pid 3526] 0.000114 time( <unfinished ...>
>[pid 3686] 0.000062 close(7) = 0
>[pid 3686] 0.000113 close(8) = 0
>[pid 3686] 0.000179 rt_sigaction(SIGTERM, {0x817dde0, [], SA_RESTART}, <unfinished ...>
>[pid 3526] 0.000105 <... time resumed> NULL) = 1099092342
>[pid 3686] 0.000064 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0
>[pid 3686] 0.000105 rt_sigaction(SIGQUIT, {0x817dde0, [], SA_RESTART}, <unfinished ...>
>[pid 3526] 0.000110 rt_sigprocmask(SIG_SETMASK, [], <unfinished ...>
>[pid 3686] 0.000083 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0
>[pid 3686] 0.000104 rt_sigaction(SIGALRM, {0x817dde0, [], 0}, <unfinished ...>
>[pid 3526] 0.000090 <... rt_sigprocmask resumed> NULL, 8) = 0
>[pid 3686] 0.000060 <... rt_sigaction resumed> {SIG_IGN}, 8) = 0
>[pid 3526] 0.000098 select(6, [3 4 5], NULL, NULL, {298, 0} <unfinished ...>
>[pid 3686] 0.000224 rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE SEGV ALRM TERM CONT SYS RTMIN], NULL, 8) = 0
>[pid 3686] 0.000372 socket(PF_FILE, SOCK_DGRAM, 0) = 3
>[pid 3686] 0.000301 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0
>[pid 3686] 0.000315 connect(3, {sa_family=AF_FILE, path="/dev/log"}, 16) = 0
>[pid 3686] 0.000381 time([1099092342]) = 1099092342
>[pid 3686] 0.000343 rt_sigaction(SIGPIPE, {0x36e450, [], 0}, {SIG_IGN}, 8) = 0
>[pid 3686] 0.000339 send(3, "<134>Oct 29 19:25:42 postgres[36"..., 95, 0) = 95
>[pid 3686] 0.000304 rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
>[pid 3686] 0.000168 write(2, "LOG: connection received: host="..., 53) = 53
>[pid 3686] 0.000189 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={60, 0}}, NULL) = 0
>[pid 3686] 0.000196 recv(9, "\0\0\0\10\4\322\26/", 8192, 0) = 8
>[pid 3686] 0.000212 send(9, "N", 1, 0) = 1
>[pid 3686] 0.000685 recv(9, "\0\0\0$\0\3\0\0user\0shawn\0database\0nagi"..., 8192, 0) = 36
>[pid 3686] 0.000854 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
>[pid 3686] 0.000152 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
>[pid 3686] 0.000214 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
>[pid 3686] 0.000252 close(4) = 0
>[pid 3686] 0.000135 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
>[pid 3686] 0.000127 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
>[pid 3686] 0.000148 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
>[pid 3686] 0.000256 close(4) = 0
>[pid 3686] 0.000120 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
>[pid 3686] 0.000126 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
>[pid 3686] 0.000153 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
>[pid 3686] 0.000241 close(4) = 0
>[pid 3686] 59.996233 --- SIGALRM (Alarm clock) @ 0 (0) ---
>[pid 3686] 0.000800 exit_group(0) = ?
>Process 3686 detached
> 0.000761 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted)
> 0.000524 --- SIGCHLD (Child exited) @ 0 (0) ---
> 0.000117 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000169 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 3686
> 0.000287 send(6, "\2\0\0\0\30\0\0\0\0\0\0\0f\16\0\0\0\0\0\0\0\0\0\0", 24, 0) = 24
> 0.000650 waitpid(-1, 0xfeea789c, WNOHANG) = 0
> 0.000121 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 0.000117 sigreturn() = ? (mask now [])
> 0.000406 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
> 0.000224 time(NULL) = 1099092402
> 0.000125 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 0.000126 select(6, [3 4 5], NULL, NULL, {238, 0} <unfinished ...>
>Process 3526 detached
>
>
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL