-----BEGIN PGP SIGNED MESSAGE-----
Hi,
Well, I've solved my problem with Thies's help It turned out to be a
permissions problem:
It was a (@#$%^) permissions problem on the root oracle directory.
I have oracle installed in /home/oracle/OraHome1, and the permissions
on /home/oracle was 700. Once I changed it to 755, everything worked.
Original message is below for your reference:
I'm trying to get PHP with the OCI interface to oracle working on a
system. I have it working on one system, but when I set it up exactly
the same on a different system, it fails.
The oracle client is installed, and I have the perl DBI module working
properly on both systems.
This is on a RedHat 6.2 system with Oracle 8.1.6.1 and Apache 1.3.12
installed
The php module I'm executing is:
<?php
$conn = OCILogon("dldb", "dldb123","devdb1");
$s="select count(*) from survey";
$stmt=OCIParse($conn,$s);
OCIExecute($stmt);
OCIFetchInto($stmt,&$line);
OCIFreeStatement($stmt);
print "count of survey is $line[0]";
?>
Amd I'm getting the following errors via the web browser:
Warning: _oci_open_server: Error while trying to retrieve text for
error ORA-12154
in /home/httpd/html/test_db.php on line 2
Warning: Supplied argument is not a valid OCI8-Connection resource in
/home/httpd/html/test_db.php on line 4
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/httpd/html/test_db.php on line 5
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/httpd/html/test_db.php on line 6
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/httpd/html/test_db.php on line 7
co
there is nothing in the log files to indicate what is wrong. Any idea
what is going on?
The only difference between these two systems is their location, one is
external to the network, the other is internal.
Thanks in advance.
JBB
- --
ICQ # 44910403
Power Listviewer URL: http://www.bigfoot.com/~PowerListviewer
PMMail Archiver URL: http://www.bigfoot.com/~Jonathan_Bayer/archiver
For PGP Public key block/Fingerprint send the following message to me
as the Subject:
Send PGP Signature
- --
ICQ # 44910403
Power Listviewer URL: http://www.bigfoot.com/~PowerListviewer
PMMail Archiver URL: http://www.bigfoot.com/~Jonathan_Bayer/archiver
For PGP Public key block/Fingerprint send the following message to me as the Subject:
Send PGP Signature
-----BEGIN PGP SIGNATURE-----
Version: PGPsdk version 1.7.1 (C) 1997-1999 Network Associates, Inc. and its
affiliated companies.
iQCVAwUBOjY3ko1F3x2FJJilAQE2/AP/SczLDPqw8tnNa+z1FVF5FP6q3XfulPiT
M/fxlofZylE971bd/IVK9kx0x5opxwZK2uj6wfIkyqnfWBEJXYur+Bbpf9j7DpI3
CRryaBAqt0j3kBk7sz69IF134wFZLdSVJch/4NuI8rcsDBAwwL3NjJ2K52vnHXul
WYFJHaWAntY=
=i/UK
-----END PGP SIGNATURE-----
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
