CDbConnection failed to open Oracle with no further info

Yii 1.1 Installation and Setup
1

YII_DEBUG
YII_DEBUG1024×768 61.1 KB

|PHP version|Passed
|$_SERVER variable|Passed
|Reflection extension|Passed
|PCRE extension|Passed
|SPL extension|Passed
|DOM extension|Passed
|PDO extension|Passed
|PDO SQLite extension|Passed
|PDO MySQL extension|Passed|
|PDO PostgreSQL extension|Warning
|PDO Oracle extension|Passed
|PDO MSSQL extension (pdo_mssql)|Warning
|PDO MSSQL extension (pdo_dblib)|Warning
|PDO MSSQL extension (pdo_sqlsrv)|Warning
|Memcache extension|Passed
|APC extension|Warning
|SOAP extension|Passed
|GD extension with FreeType support or ImageMagick extension with PNG support|Passed
|Ctype extension|Passed
|Fileinfo extension|Passed

<?php return array( 'connectionString'=>'oci:dbname=127.0.0.1:1521/SOH;charset=utf8;', 'username' => 'USERAD', 'password' => 'xxx', 'class'=>'ext.oci8Pdo.OciDbConnection', ); My server CentOS 7, PHP 5.6, Apache 2.4. I can connect to DB via remote Navicat so I think DB started well.
2

Can you post relevant information from log file?

3

Here the information from /runtime/application.log

2022/06/17 09:39:02 [error] [exception.CDbException.getCode] 0
in /var/www/html/web.admin/protected/controllers/UserController.php (138)
in /var/www/html/web.admin/public_html/index.php (23)
2022/06/17 09:39:02 [error] [exception.CDbException.errorInfo]
in /var/www/html/web.admin/protected/controllers/UserController.php (138)
in /var/www/html/web.admin/public_html/index.php (23)
2022/06/17 09:39:02 [error] [exception.CDbException] exception ‘CDbException’ with message 'CDbConnection failed to open the DB connection: ’ in /var/www/html/web.admin/protected/framework/db/CDbConnection.php:384
Stack trace:
#0 /var/www/html/web.admin/protected/framework/db/CDbConnection.php(330): CDbConnection->open()
#1 /var/www/html/web.admin/protected/framework/db/CDbConnection.php(308): CDbConnection->setActive(true)
#2 /var/www/html/web.admin/protected/framework/base/CModule.php(387): CDbConnection->init()
#3 /var/www/html/web.admin/protected/framework/base/CApplication.php(450): CModule->getComponent(‘db’)
#4 /var/www/html/web.admin/protected/framework/db/ar/CActiveRecord.php(634): CApplication->getDb()
#5 /var/www/html/web.admin/protected/framework/db/ar/CActiveRecord.php(2361): CActiveRecord->getDbConnection()
#6 /var/www/html/web.admin/protected/framework/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(Object(ExUser))
#7 /var/www/html/web.admin/protected/framework/db/ar/CActiveRecord.php(79): CActiveRecord->getMetaData()
#8 /var/www/html/web.admin/protected/controllers/UserController.php(138): CActiveRecord->__construct(‘search’)
#9 /var/www/html/web.admin/protected/framework/web/actions/CInlineAction.php(49): UserController->actionAdmin()
#10 /var/www/html/web.admin/protected/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#11 /var/www/html/web.admin/protected/framework/web/filters/CFilterChain.php(133): CController->runAction(Object(CInlineAction))
#12 /var/www/html/web.admin/protected/framework/web/filters/CFilter.php(40): CFilterChain->run()
#13 /var/www/html/web.admin/protected/framework/web/CController.php(1145): CFilter->filter(Object(CFilterChain))
#14 /var/www/html/web.admin/protected/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(Object(CFilterChain))
#15 /var/www/html/web.admin/protected/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#16 /var/www/html/web.admin/protected/framework/web/CController.php(291): CFilterChain->run()
#17 /var/www/html/web.admin/protected/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#18 /var/www/html/web.admin/protected/framework/web/CWebApplication.php(282): CController->run(‘admin’)
#19 /var/www/html/web.admin/protected/framework/web/CWebApplication.php(141): CWebApplication->runController(‘user/admin’)
#20 /var/www/html/web.admin/protected/framework/base/CApplication.php(180): CWebApplication->processRequest()
#21 /var/www/html/web.admin/public_html/index.php(23): CApplication->run()
#22 {main}
REQUEST_URI=/index.php/user/admin

4

What is the content of that line?
What is your setup in config/db.php?

I suspect something is not right in your connection setup!

5

Here is the setup in config/db.php:

<?php return array( 'connectionString'=>'oci:dbname=127.0.0.1:1521/SOH;charset=utf8;', 'username' => 'USERAD', 'password' => 'xxx', 'class'=>'ext.oci8Pdo.OciDbConnection', ); Content of /var/www/html/web.admin/protected/framework/db/CDbConnection.php:384 is in the picture I uploaded. I think I got problem with php modules pdo.so, pdo_oci.so or oci8.so, or maybe Oracle Client.
6

I see your connection must be the issue.
try this one: Using Yii with Oracle through PDO | Wiki | Yii PHP Framework