DSP Does Not Connect To Oracle


#1

Hi

Please help

Cannot connect to Oracle - error message

Failed to launch service “oracle”: ORA-24315: illegal attribute type

Bitnami Ubuntu Image
Database Version: 1.9.0
DreamFactory Services Platform Version: 1.9.1
Admin Application Version: 1.0.10

php -m shows oci8
phpinfo() shows

OCI8 Support : Enabled
OCI8 DTrace Support : Disabled
OCI8 Version: 2.0.8
Revision: $Id: f04114d4d67cffea4cdc2ed3b7f0229c2caa5016 $
Oracle Run-time Client Library Version : 11.1.0.7.0
Oracle Compile-time Instant Client Version : 11.2

setenv.sh

LD_LIBRARY_PATH=/opt/bitnami/oracleclient/instantclient_11_1:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

The latest 12.x library does not work as oci8.so is looking for 11.x

Oracle Connection String

oci:dbname=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DELORA)))

sudo /opt/bitnami/ctlscript.sh restart

monit: action failed -- There is no service by that name
Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd stopped
/opt/bitnami/php/scripts/ctl.sh : php-fpm stopped
/opt/bitnami/mysql/scripts/ctl.sh : mysql stopped
150708 13:32:09 mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
150708 13:32:09 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
/opt/bitnami/mysql/scripts/ctl.sh : mysql  started at port 3306
[08-Jul-2015 13:32:23] NOTICE: configuration file /opt/bitnami/php/etc/php-fpm.conf test is successful

/opt/bitnami/php/scripts/ctl.sh : php-fpm started
Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd started at port 80
monit: action failed -- There is no service by that name

web.del-dreamfactory.archana.ndtv.com.log

[2015-07-08 05:41:02][app][ERROR    ] REST Exception #500 > Failed to launch service "oracle": ORA-24315: illegal attribute type {"host":"del-dsp","request_uri":"/rest/oracle/_schema?fields=name&refresh=true","source_ip":"xxx.xxx.xxx.xxx","sapi_name":"fpm-fcgi"}

Can someone, please, help me figure out what I may be doing wrong?

Thanks a lot

Iyer


#2

I will try to reproduce this, but since this is not DreamFactory’s driver and you’re enabling a feature in a Bitnami stack, Bitnami support would be a better resource for you.

Can you post the surrounding log entries from web.del-dreamfactory.archana.ndtv.com.log?