php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #69968 Connectivity Issue
Submitted: 2015-06-30 13:14 UTC Modified: 2015-07-01 05:49 UTC
From: vijaybabu dot r at hp dot com Assigned:
Status: Wont fix Package: PostgreSQL related
PHP Version: 5.4.42 OS: HP UX
Private report: No CVE-ID: None
View Developer Edit
 [2015-06-30 13:14 UTC] vijaybabu dot r at hp dot com 
Description:
------------
I have installed php 5.2 & 5.4 and postgres 9.4 in same server HP UX 11.31 ia64.

Whenever i tried to connect postgres database, am getting below message in browser 

Unable to connect to PostgreSQL server: could not get socket error status: Error 0 in /opt/hpws22/apache/htdocs/one.php on line 3

And in postgres log file, am getting below message

Incomplete startup packet

I have tried to connect the same postgres with Perl and psql. Its all working fine with same parameters. But from PHP i couldnt connect.

Test script:
---------------
<?php
$options = " host='localhost' port='5432' user='vijay' password='abcd123' dbname='test456' ";
pg_connect($options);

//i tried with ip address, host name, 127.0.0.1 & socket(/tmp/)

?>



Actual result:
--------------
Unable to connect to PostgreSQL server: could not get socket error status: Error 0 in /opt/hpws22/apache/htdocs/one.php on line 3

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2015-07-01 05:47 UTC] yohgaki@php.net
-Status: Open +Status: Wont fix
 [2015-07-01 05:47 UTC] yohgaki@php.net 
Sorry, but I cannot reproduce the issue on 5.6... Support for 5.2/5.4 is already finished.
I have to close this. If you find issue on 5.6, please re-open.

php > var_dump(pg_connect("host=localhost port=5432 user=yohgaki"));
resource(1) of type (pgsql link)
php > var_dump(pg_connect("host='localhost' port=5432 user=yohgaki"));
resource(2) of type (pgsql link)
php > var_dump(pg_connect("host='localhost' port='5432' user=yohgaki"));
resource(3) of type (pgsql link)
php > var_dump(pg_connect("host='localhost' port='5432' user='yohgaki'"));
resource(4) of type (pgsql link)
php > var_dump(pg_connect(" host='localhost' port='5432' user='yohgaki'"));
resource(5) of type (pgsql link)
php > var_dump(pg_connect(" host='127.0.0.1' port='5432' user='yohgaki'"));
resource(6) of type (pgsql link)
php > var_dump(pg_connect(" host='127.0.0.1' user='yohgaki'"));
resource(7) of type (pgsql link)
php > var_dump(pg_connect(" host='127.0.0.1' port='5432' user='yohgaki' "));
resource(8) of type (pgsql link)
php > echo phpversion();
5.6.10
 [2015-07-01 05:49 UTC] yohgaki@php.net 
BTW, PostgreSQL module is simple libpq wrapper. Make sure you build PHP with the correct (i.e. PostgreSQL 9.4's) libpq.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Jul 01 16:01:38 2025 UTC