InitPostgres() fails through libpq - Mailing list pgsql-hackers
From | Egon Schmid |
---|---|
Subject | InitPostgres() fails through libpq |
Date | |
Msg-id | 35A4D0E6.7D7AD862@delos.lf.net Whole thread Raw |
List | pgsql-hackers |
I'm using the latest CVS and PHP can't get a connection. Starting the postmaster with or without the -i flag is not the problem. Also psql works fine. If I try to use PHP to access postgres I get the following: ------------------------------------------------------------------------------- postmaster: ServerLoop: handling reading 5 postmaster: ServerLoop: handling reading 5 postmaster: ServerLoop: handling writing 5 postmaster: BackendStartup: environ dump: ----------------------------------------- HOSTNAME=marliesle LOGNAME=postgres MACHTYPE=i586-debian-linux TERM=xterm HOSTTYPE=i586 PATH=/usr/local/pgsql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/bin/X11 HOME=/home/postgres SHELL=/bin/bash PS1=\h\$ PGLIB=/usr/local/pgsql/lib USER=postgres PGDATA=/usr/local/pgsql/data MANPATH=/usr/local/pgsql/man LANG=de_DE OSTYPE=linux SHLVL=1 _=/usr/local/pgsql/bin/postmaster _652_GNU_nonoption_argv_flags_=0000 POSTPORT=5432 POSTID=2147483646 PG_USER=nobody IPC_KEY=5432000 ----------------------------------------- postmaster: BackendStartup: pid 658 user nobody db verlag socket 5 postmaster child[658]: starting with (/usr/local/pgsql/bin/postgres, -p, -d3, -P5, -v131072, verlag, ) FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0] ---debug info--- Quiet = f Noversion = f timings = f dates = Normal bufsize = 64 sortmem = 512 query echo = f DatabaseName = [verlag] ---------------- InitPostgres().. An connection error occured. # <- A PHP message # postmaster: reaping dead processes... postmaster: CleanupProc: pid 658 exited with status 0 marliesle$ -------------------------------------------------------------------------------- Between InitPostgres()... and "An connection error occured" 'psql verlag' show's a "Welcome to the POSTGRESQL interactive sql monitor:" I append here the last lines from a strace (postmaster startet with -i): -------------------------------------------------------------------------------- munmap(0x40158000, 4096) = 0 socket(PF_UNIX, SOCK_STREAM, 0) = 5 connect(5, {sun_family=AF_UNIX, sun_path="/tmp/.s.PGSQL.5432"}, 20) = 0 fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK) = 0 getsockname(5, {sun_family=AF_UNIX, sun_path=""}, [3]) = 0 send(5, "\0\0\1(\0\2\0\0verlag\0\0\0\0\0\0"..., 296, 0) = 296 oldselect(6, [5], [], NULL, NULL) = 1 (in [5]) recv(5, "R\0\0\0\0", 8192, 0) = 5 oldselect(6, [5], [], NULL, NULL) = 1 (in [5]) recv(5, "K\0\0\2_\262\263\247\212Z", 8192, 0) = 10 close(5) = 0 write(1, "An connection error occured.\n", 29) = 29 munmap(0x40126000, 200704) = 0 close(4) = 0 munmap(0x40009000, 4096) = 0 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0 _exit(0) = ? -------------------------------------------------------------------------------- -Egon
pgsql-hackers by date: