Bug #55105 [NEW]: ActiveRecord\DatabaseException
| From: | carl dot mcmullen at bsci dot com | Date: | Fri, 01 Jul 2011 15:44:32 +0000 |
| Subject: | Bug #55105 [NEW]: ActiveRecord\DatabaseException | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-161467@lists.php.net to get a copy of this message | ||
From:
Operating system: RedHat Enterprise 5.5
PHP version: 5.3.6
Package: PDO related
Bug Type: Bug
Bug description:ActiveRecord\DatabaseException
Description:
------------
---
From manual page: http://www.php.net/ref.pdo-oci
---
I built PHP 5.3.6 from Source using the following commands in a bash
script. The
compile, install process ran without errors.
#!/bin/bash
export ORACLE_HOME=/oracle/product/10.2.0
export MYSQL_DIR=/usr/local/mysql-5.1.52
export PHP_HOME=/usr/local/php-5.3.6
./configure \
--prefix=$PHP_HOME \
--with-apxs2=/usr/sbin/apxs \
--with-mysql-sock=/tmp/mysql.sock \
--with-oci8=$ORACLE_HOME \
--with-mysql=$MYSQL_DIR \
--with-mysqli=$MYSQL_DIR/bin/mysql_config \
--with-pear=$PHP_HOME/lib/php \
--with-libdir=lib64 \
--with-ldap \
--with-curl \
--enable-mbstring \
--with-pdo-mysql=$MYSQL_DIR \
--with-pdo-oci=$ORACLE_HOME
make
make install
Test script:
---------------
require_once "php-activerecord/ActiveRecord.php";
date_default_timezone_set ( "America/Chicago" );
ActiveRecord\Config::initialize(function($cfg) {
$cfg->set_model_directory("models");
$cfg->set_connections(array( "oracle" =>
"oci://envsviewer:guidant3@stpsn155/latenvs" ));
$cfg->set_default_connection("oracle");
});
Expected result:
----------------
A successful connection to the Oracle DB.
Actual result:
--------------
Fatal error: Uncaught exception 'ActiveRecord\DatabaseException' with
message
'exception 'PDOException' with message 'SQLSTATE[]: pdo_oci_handle_factory:
OCI_INVALID_HANDLE (/usr/local/src/php-5.3.6/ext/pdo_oci/oci_driver.c:579)'
in
/var/www/html/latenvsdev/classes/php-activerecord/lib/adapters/OciAdapter.php:25
Stack trace: #0 /var/www/html/latenvsdev/classes/php-
activerecord/lib/adapters/OciAdapter.php(25): PDO-
>__construct('oci:dbname=//st...', 'envsviewer', 'guidant3', Array)
>#1
/var/www/html/latenvsdev/classes/php-activerecord/lib/Connection.php(101):
ActiveRecord\OciAdapter->__construct(Object(stdClass)) #2
/var/www/html/latenvsdev/classes/php-activerecord/lib/ConnectionManager.php(33):
ActiveRecord\Connection::instance('oci://envsviewe...') #3
/var/www/html/latenvsdev/classes/php-activerecord/lib/Table.php(103):
ActiveRecord\ConnectionManager::get_connection(NULL) #4
/var/www/html/latenvsdev/classes/php-activerecord/lib/Table.php(80):
ActiveRecord\Table->reestablish_connection(false) #5
/var/www/html/latenvsdev/cla in /var/www/html/latenvsdev/classes/php-
activerecord/lib/Connection.php on line 109
--
Edit bug report at https://bugs.php.net/bug.php?id=55105&edit=1
--
Try a snapshot (PHP 5.2): https://bugs.php.net/fix.php?id=55105&r=trysnapshot52
Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=55105&r=trysnapshot53
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=55105&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=55105&r=fixed
Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=55105&r=needdocs
Fixed in release: https://bugs.php.net/fix.php?id=55105&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=55105&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=55105&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=55105&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=55105&r=support
Expected behavior: https://bugs.php.net/fix.php?id=55105&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=55105&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=55105&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=55105&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=55105&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=55105&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=55105&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=55105&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=55105&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=55105&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=55105&r=mysqlcfg
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=55105&r=trysnapshot54