Your message dated Tue, 29 Aug 2006 08:27:36 +0200
with message-id <[EMAIL PROTECTED]>
and subject line [php-maint] Bug#385077: php5-pgsql: Will not connect to
PostgreSQL 8.1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: php5-pgsql
Version: 5.1.4-0.1
Severity: grave
Justification: renders package unusable
The package will not connect to PostgreSQL 8.1; the connection fails
with the following error:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: could not connect to server: No such file or
directory Is the server running locally and accepting connections on
Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
However, PostgreSQL is running and listening for connections; the
PostgreSQL utilities, such as psql, connect with out trouble. The
contents of /var/run/postgresql is:
[EMAIL PROTECTED]:/var/run/postgresql$ ls -a
.. .. 8.1-main.pid .s.PGSQL.5433 .s.PGSQL.5433.lock
[EMAIL PROTECTED]:/var/run/postgresql$
As you can see, the filenames differ by a single number (5432 vs 5433).
However, this bug makes the package useless for connecting to version
8.1 of PostgreSQL.
System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.4.27-2-386
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages php5-pgsql depends on:
ii debconf [debconf-2.0] 1.5.3 Debian configuration management sy
ii libapache2-mod-php5 [phpapi- 5.1.4-0.1 server-side, HTML-embedded scripti
ii libc6 2.3.6.ds1-4 GNU C Library: Shared libraries
ii libpq4 8.1.4-6 PostgreSQL C client library
ii php5-common 5.1.4-0.1 Common files for packages built fr
php5-pgsql recommends no packages.
-- debconf information:
php5/extension_pgsql_apache2: true
php5/remove_extension: true
php5/add_extension: true
--- End Message ---
--- Begin Message ---
On Mon, 2006-08-28 at 14:16 -0700, Tyler Riddle wrote:
> Package: php5-pgsql
> Version: 5.1.4-0.1
> Severity: grave
> Justification: renders package unusable
>
> The package will not connect to PostgreSQL 8.1; the connection fails
> with the following error:
The package will not connect to any version of PostgreSQL if you change
default port and not use port number when connecting.
> [EMAIL PROTECTED]:/var/run/postgresql$ ls -a
> .. .. 8.1-main.pid .s.PGSQL.5433 .s.PGSQL.5433.lock
> [EMAIL PROTECTED]:/var/run/postgresql$
Standard contents are:
total 4
drwxrwsr-x 2 postgres postgres 80 2006-08-24 18:57 .
drwxr-xr-x 10 root root 340 2006-08-25 16:30 ..
srwxrwxrwx 1 postgres postgres 0 2006-08-29 07:34 .s.PGSQL.5432
-rw------- 1 postgres postgres 34 2006-08-29 07:34 .s.PGSQL.5432.lock
Add port=5433 to your connection string and you'll be fine.
Closing this bug, since it's invalid.
Ondrej.
--
Ondrej Sury <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
--- End Message ---
