php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #39119 Can't connect to several Online IDS servers
Submitted: 2006-10-10 18:41 UTC Modified: 2008-06-19 15:05 UTC
Votes:12
Avg. Score:3.0 ± 0.0
Reproduced:0 of 3 (0.0%)
From: dcalvo at hcuv dot sacyl dot es Assigned:
Status: Not a bug Package: Informix related
PHP Version: 5.1.6 OS: HP-UX 11i (11.11)
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: dcalvo at hcuv dot sacyl dot es
New email:
PHP Version: OS:

 

 [2006-10-10 18:41 UTC] dcalvo at hcuv dot sacyl dot es
Description:
------------
Hello.
First of all sorry about my english. I'm Spanish.
I have two HP-UX server with Apache 2.0.58 and PHP compiled as a shared object with informix CSDK 2.81TC1. Each server has an Informix Online Dynamic Server 7.31 running. The connectivity between IDS server works fine from informix dbaccess utility.
When i connect to the informix server located into the unix server  (HP-UX 1) where apache is configured and running i have no problem to connect and execute any query to access the IDS(1) . When I try to connect to the other unix server (HP-UX 2) with another IDS 7.31 (IDS 2) running, i can't connect to the remote database host , the error that the web page shows is SQLCODE=-908.
Doing the same from the other Unix server (HP-UX 2) the situation is the same, accessing to the local IDS 2 without problem, but can't connect to the remote database (IDS 1).
I don't know  if it's necessary to use the PDO_INFORMIX function to access Informix Database from PHP 5.1.6, or if this is an environment variable problem.

Thank's a lot.

Reproduce code:
---------------
if (!$id_con = ifx_connect("database@server","username","password"))
{echo "No te conectas.";}
else 
{Echo "Conectado con ".$id_con."<br>";
}

Expected result:
----------------
Conectado con Resource id #2

Actual result:
--------------
Warning: ifx_connect() [function.ifx-connect]: E [SQLSTATE=08 004 SQLCODE=-908] in /testpage.php on line 17
No te conectas.


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-10-10 18:50 UTC] inform at hcuv dot sacyl dot es
Accesing from another Unix server (HP-UX 3) with Apache Web Server 1.3.31 and  PHP 4.3.4 it's possible to connect to the IDS1 server without problems.
 [2006-10-10 19:02 UTC] tony2001@php.net
I'm afraid there were almost no changes since 4.3.4, so I'd look for some (mis)configuration issues on your machines.
 [2006-10-28 13:34 UTC] dcalvo at hcuv dot sacyl dot es
I have tried to used the versio 4.4.4 and all work's fine, without any changes on any of my IDS server configuration, so i supose therea are any differencies between version 4 and version 5 of PHP.
It is posible to copy the file ext/informix/(ifx.ec from version 4 to the veersion5 one?
i supose the answer is no, but i'm not sure.
Thank's a lot
 [2006-10-28 23:55 UTC] tony2001@php.net
So it was fixed in 5.x.
Fixed -> closed.
 [2006-10-29 06:09 UTC] dcalvo at hcuv dot sacyl dot es
Hello again.
With version 5.1.6 informix module cann't connect to several IDS database server from the same php page, but with version 4.4.4 it's posible, so there are differencies between version 4 and 5, abd i don't think that the problem was fixed in 5.x version.
 [2006-10-29 16:24 UTC] dcalvo at hcuv dot sacyl dot es
Hello again.
I'm new at the php developement, so i think is better to start with php 5 instead of using version 4.  I don't know what is the difference between 4 and 5 versions of ifx module, but with version 4 it's possible to connect to any informix databasae server configured out of the local database server, and with php version 5 it is not possible, using the same apache web server and the same informix database server. I think the connection method has change from version 4 to version 5, but i can't find the reason. It's very important to me start with version 5, it's the reason that i am looking for a solution.
Thank's again.
 [2008-06-19 15:05 UTC] pajoye@php.net
Please report it here:

http://pecl.php.net/bugs/report.php?package=informix

And please note that this extension is not maintained anymore and is looking for new maintainers.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 18 10:01:28 2024 UTC