Unable to connect to oracle with "bool(false)" message

696154

Hi,
my php unable to connect to database with message "bool(false)"

connect string :
$c = oci_connect("userid", "pwd", "db");
if (!$c)
{echo "unable to connect: ". var_dump(oci_error());
die();}

os : Linux Centos 5.2
php version : php 5.1.6
apache version : 2.2.3
Oracle version : 10g Rel.2
Oracle + apache + php on the same machine.

i hv followed instruction from php.net/manuel/en/oci8.installation.php and my oci8 environment was set as my oracle bash_profile environment but still can't get connected.

is there any post similiar with this ?
any help would be appreciated.
tks.

Edited by: HeLmi on Aug 3, 2011 2:40 PM

Christopher Jones-Oracle

The page you referenced says "On Red Hat Linux and variants, export variables at the end of /etc/sysconfig/httpd". Setting variables in your bash start scripts won't affect httpd.

696154

i meant i hv set my /etc/sysconfig/httpd variables as the same as my bash script, like ORACLE_HOME, ORACLE_SID, TNS_ADMIN and i can view that variables on the environment section with phpinfo().
and i hv set extension=oci8.so in /etc/php.ini

i hv followed instruction from "underground php and oracle manual" but i just can't found what did i missed in my configuration ?

Christopher Jones-Oracle

By now I expect you'll have found the oci_error() function and have got useful information about what exactly is failing. Perhaps you even solved the problem yourself?

696154

thanks fyi.

my connect string :
$c = oci_connect("userid", "pwd", "db");
if (!$c)
{echo "unable to connect: ". var_dump(oci_error());
die();}

my oci_error() not show any error message.
error in my browser : "bool(false). unable to connect: "
just that, with no other information.

maybe couse my php version is default php from centos 5.2, do i need to upgrade my php ?
or just missing configuration ?

Christopher Jones-Oracle

Did you ever sort this out? Is there environment information that would aid us in tracking down the issue?