PHP+informix -922, -25582 errors

From: Makovský Vladimír (vladimir.makovsky_at_semd.cz)
Date: 10/27/03 

Date: Mon, 27 Oct 2003 11:51:25 +0100

Hi,

I have Apache 1.3.2 + PHP 4.3.2 + Informix (server 9.20, csdk 2.80) compiled
on HP-UX B.11.00 U 9000/800.

(./configure' '--prefix=/usr/apache1.3/php-4.3.2' '--without-mysql'
'--with-apache=/dlf1/src/apache_1.3.27/' '--with-informix=/usr/csdk2.80'
'--with-config-file-path=/usr/apache1.3/php-4.3.2')

apache runs with this identity:
User apache
Group or

I have simple script i.php with simple query to database:

1 <html>
2 <?php
3 if (!$connect_id = ifx_pconnect("db@hp-ux11","login","password")) {
4 echo "Unable to connect to Informix Database\n";
5 exit();
6 }
7
8 $result = ifx_query("select oscis,jm_prijm from idaido", $connect_id) or
die ("couldn't execute the query");
9 ifx_htmltbl_result($result, "border=\"1\"");
10 ifx_free_result($result);
11 ifx_close($connect_id);
12 ?>
13 </html>

Sometimes (that means I do not know how to force this error), but quite
often I get either this message (more often):

Warning: ifx_pconnect(): E [SQLSTATE=IX 000 SQLCODE=-922] in
/dlf1/home/apache/www/db/i.php on line 3
Unable to connect to Informix Database

or this message:

Warning: ifx_query(): Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-25582]) in
/dlf1/home/apache/www/db/i.php on line 8
couldn't execute the query

_Sometimes the script returns correct result_. Explanation of this error
through
the command finderr doesn't help me much:

-922 Cannot get name of current working directory.

A problem exists with the current working directory on this system or
on another computer system that your application is using. Possibly
your account does not have read access to the directory, or possibly
the file system that contains it is improperly mounted. Exit your
application, and retry. If the problem persists, see your system
administrator for assistance.

Sometimes it works so I think that the access rights should be ok.
Everything is on the same server. I am the administrator ;-).

-25582 Network connection is broken.

This error might indicate that the database server has terminated, or a
problem might exist on the network itself. Check that the network is
functioning and that the server is still running.

IDS 9.20 is up and network is functioning (when I run onstat -p after
the execution of i.php)

Any suggestions?

--v.m.

Relevant Pages

  • Re: i love php but php loves mysql and mysql hates me
    ... // This script adds a entry to the database. ... // Execute the query. ... // This script retrieves header and body text from the database. ...
    (php.general)
  • Re: [PHP] Newbie question, Which way is best?
    ... When the form calls the script it passes all the parameters that the script ... SELECT query, as is, back to the same script with a way to change just the ... As a relative newbie my self I think I understand what you are trying to do. ... If potental attackers have access to your field names they can much easier try and insert stuff into your database. ...
    (php.general)
  • Re: Query Help
    ... > objects in any database. ... that parcitular script is executed, I somehow tought that it shouln't put it ... Unless I misunderstand your tables and query, ... I have seen execution plans where the subquery gets ...
    (microsoft.public.sqlserver.programming)
  • Re: Automatic Scheduled Import
    ... query to import the data I'd write a script using the DAO library to ... create and execute the query without using Access itself; ... trouble of installing Access on the server). ... >I have a database on a shared server. ...
    (microsoft.public.access.externaldata)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)