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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: leightonbrown at excite dot com
New email:
PHP Version: OS:

 

 [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: Fri Dec 27 00:01:30 2024 UTC