php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24419 ifx_connect broken when connecting to remote informix server
Submitted: 2003-06-30 13:25 UTC Modified: 2003-08-18 11:43 UTC
From: leightonbrown at excite dot com Assigned:
Status: Closed Package: Informix related
PHP Version: 4.3.2 OS: Windows 2000
Private report: No CVE-ID: None
 [2003-06-30 13:25 UTC] leightonbrown at excite dot com
Description:
------------
On a remote host running several informix server instances, ifx_connect will only connect to the INFORMIXSERVER that is the default for the user and password supplied. Even when sqlhosts and etc/services are setup correctly on the local host. 

Environment
PHP 4.3.2
Web server: Apache 2.0.46
Web server host: Windows 2000 SP 3
OS: Windows 2000 SP 3
Database: Informix OnLine Dynamic 7.3UD2R1
Database host OS: Solaris 5.8

local sqlhosts entry:
mars_tcp onsoctcp remote_1 mars_tcp
birch_tcp onsoctcp remote_1 birch_tcp

c:\winnt\system32\drivers\etc\services entry:
mars_tcp         1529/tcp
birch_tcp        1527/tcp


Reproduce code:
---------------
// program code [line 62 in index.php] fails :
$ifx_handle = ifx_connect("db1@mars_tcp", "userid", "passwd");

//program code [line 62 in index.php] succeeds :
$ifx_handle = ifx_connect("db2@birch_tcp", "userid", "passwd");

//birch_tcp is the default INFORMIXSERVER for userid/password or remote_1, mars_tcp is not.

Expected result:
----------------
$ifx_handle <> 0

Actual result:
--------------
$ifx_handle = 0 
with a logged error :
PHP Warning:  ifx_connect(): E [SQLSTATE=IX 000  SQLCODE=-761] in C:\Program Files\Apache Group\Apache2\htdocs\php\index.php on line 62

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-08-18 11:33 UTC] leightonbrown at excite dot com
Thanks, it works with this CVS snapshot.

Leighton
 [2003-08-18 11:43 UTC] sniper@php.net
works -> closed.

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 11:01:30 2024 UTC