Apache2, perl, DBI, Informix - connect problems

From: Rob Saunders (Rob_at_Saunders.yourideal.co.uk)
Date: 01/20/04 

Date: 20 Jan 2004 07:01:04 -0800

I have a perl script which accesses an Informix database via a
DBI->connect statement which returns a database handle, etc...

When performing this op as a regular user (user A) at the command
line, this works fine, and I can see a list of the data retrieved from
the database.

When performing the op via my browser, the connect fails with the
following:

Software error:

DBI connect('database@socket','userB',...) failed: SQL: -1829:
<<Failed to locate SQL error message> at
/usr/local/apache2/perl/application.pl line 58

(The parameters passed to the DBI connect, userB, password, are
identical between command line and web operations, so, userA runs the
command at command line or via a browser and the connect is done using
userB and userB's attributes - which work at command line, but don't
from the browser).

The 1829 error referenced refers to:

-1829 Cannot open file citoxmsg.pam.

The file citoxmsg.pam is missing from the directory $INFORMIXDIR/msg.

I've checked, and this file does exist. However, is it available to
the web db connect user, userB? Do I need to install informix where it
is visible to the web server? i.e. underneath the /usr/local/apache2
directory - I would hope not for security!

Within my perl.conf file I set up some environment variables that are
significant to Informix, INFORMIXDIR, INFORMIXSERVER, ONCONFIG, etc...
and I've compared these between my command line and web processes, but
to no avail. INFORMIXDIR is set to /home/informix which is a symbolic
link to the installation location under /opt ...

Help!!

Thanks in advance

Rob

Relevant Pages

  • Re: Apache2, perl, DBI, Informix - connect problems
    ... > When performing this op as a regular user at the command ... > identical between command line and web operations, so, userA runs the ... Do I need to install informix where it ...
    (perl.dbi.users)
  • Re: bde to ado
    ... // MessageId: DB_E_ERRORSINCOMMAND ... The command text contained one or more errors. ... Providers should use OLE DB ... > oleprovide = informix ole provide ...
    (borland.public.delphi.database.ado)
  • Re: View contents of backup file
    ... a backup of an informix database. ... I am told the "onunload" command was ... and I am no expert informix backup/restore. ...
    (comp.databases.informix)
  • Re: export to
    ... but the analogous facility in Informix is UNLOAD ... and that is emulated in the client (command line) program. ...
    (perl.dbi.users)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)