# Oracle connection failure

**URL:** <https://community.dreamfactory.com/t/oracle-connection-failure/2487>\
**Category:** Connecting to SQL\
**Created:** [April 5, 2016, 6:16pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487 "2016-04-05T18:16:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![indy2005](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@indy2005](https://community.dreamfactory.com/u/indy2005)\
**Post date:** [April 5, 2016, 6:16pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487/1 "2016-04-05T18:16:31Z")

</div>

Hi,

I am using the Bitnami installer for dreamfactory-2.1.1-2 for redhat linux.

I have enabled oci8.iso in php.ini

> ; Local Variables:  
> ; tab-width: 4  
> ; End:  
> extension=oci8.so  
> ;extension=pdo\_ibm.so  
> ;extension=imagick.so  
> ;extension=oauth.so  
> ;extension=solr.so  
> ;extension=lzf.so  
> ;extension=memcache.so  
> ;extension=uploadprogress.so  
> ;extension=apcu.so

I have updated my setenv.sh file to have this at the end.

> LD\_LIBRARY\_PATH=/home/MYNAME/binaries/instantclient\_11\_2:$LD\_LIBRARY\_PATH  
> export LD\_LIBRARY\_PATH

And I have downloaded the 64 bit 11\_2 instant client from Oracle.

I can create the service, with this connection string, which I know is correct.

> oci:dbname=(DESCRIPTION = (ADDRESS\_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [se.emea.mycompany.net](http://se.emea.mycompany.net))(PORT = 1524))) (CONNECT\_DATA = (SID = DARIEL)))

But when I try and access any of the APIs through the service I get this in the logs.

> [2016-04-05 18:12:38] local.ERROR: \* System error building event map for service ‘ariel\_db’.  
> Failed to connect to database.

my php -m check returns oci8 OK.

> [PHP Modules]  
> bcmath  
> bz2  
> calendar  
> Core  
> ctype  
> curl  
> date  
> dom  
> ereg  
> exif  
> fileinfo  
> filter  
> ftp  
> gd  
> gettext  
> gmp  
> hash  
> iconv  
> imap  
> intl  
> json  
> ldap  
> libxml  
> mbstring  
> mcrypt  
> mongo  
> mssql  
> mysql  
> mysqli  
> mysqlnd  
> oci8  
> openssl  
> pcntl  
> pcre  
> PDO  
> pdo\_dblib  
> pdo\_mysql  
> pdo\_pgsql  
> pdo\_sqlite  
> pgsql  
> Phar  
> posix  
> readline  
> Reflection  
> session  
> SimpleXML  
> soap  
> sockets  
> SPL  
> sqlite3  
> standard  
> tidy  
> tokenizer  
> v8js  
> xml  
> xmlreader  
> xmlrpc  
> xmlwriter  
> xsl  
> Zend OPcache  
> zip  
> zlib

> [Zend Modules]  
> Zend OPcache

I tried to increase logging but it wont change for me, I set it ot DEBUG but the config panel always says WARNING.

What is going wrong?!

Password is correct, I am in and out of this database 50 times a day.

I can ping the server and telnet into the port 1524 from the dreamfactory instance.

Regards

Stephen

---

<div class="post-metadata">

**Author:** ![indy2005](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@indy2005](https://community.dreamfactory.com/u/indy2005)\
**Post date:** [April 7, 2016, 5:36pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487/2 "2016-04-07T17:36:32Z")

</div>

Can anyone advise? A rest service which cant connect to Oracle isnt much use to me 😉

---

<div class="post-metadata">

**Author:** ![indy2005](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@indy2005](https://community.dreamfactory.com/u/indy2005)\
**Post date:** [April 17, 2016, 8:07pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487/3 "2016-04-17T20:07:00Z")

</div>

oh well, I can’t use dreamfactory it seems. Shame, seemed promising on the face of it. I work for a very large corporate who are using Cisco Composite at the moment, and was hoping to evaluate this as an alternative.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [April 18, 2016, 2:36pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487/4 "2016-04-18T14:36:51Z")

</div>

I’m not certain what’s going on, but you can enable verbose logging by setting the DF\_LOG\_LEVEL to to DEBUG and then clearing the config cace:  
`php artisan config:clear` (from the htdocs folder) and restarting the instance

Before you clear the config cache you should check and make sure your cached app key matches the app key that’s in your .env file. If not, update the .env file to match. We had an issue with some of the Bitnami packages recently where the system was being set up and caching and different app key than what’s in the env. So if you clear the config cache and the env file has a different key, your system will get locked up.

---

<div class="post-metadata">

**Author:** ![indy2005](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@indy2005](https://community.dreamfactory.com/u/indy2005)\
**Post date:** [April 19, 2016, 2:07pm UTC](https://community.dreamfactory.com/t/oracle-connection-failure/2487/5 "2016-04-19T14:07:42Z")

</div>

Hi, I am brand new to dreamfactory - I don’t know how to do any of these things, apart from possibly run the php command.