Re: [ADMIN] Problem connecting to localhost in 7.4.2

Joshua D. Drake Sun, 31 Oct 2004 08:48:28 -0800

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.

------------------------------------------------------------------------

[EMAIL PROTECTED] 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 [EMAIL PROTECTED])

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

begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Re: [ADMIN] Problem connecting to localhost in 7.4.2

Reply via email to