Using Oracle Autonomous database with PHP

-
The Oracle Cloud free tier is pretty generous, one thing that stands out is the free tier for a managed database.  Normally I would use mysql , but this is oracle and I haven't used that in a long time.  I also haven't used it with PHP

These are my notes to make it work on ubuntu

overview:
1. download and install oracle client and sdk
2. setup your wallet
3. setup php
4. test

1. setup and install oracle stuff

mkdir /opt/oracle
mkdir /opt/oracle
cd /opt/oracle
wget https://download.oracle.com/otn_software/linux/instantclient/193000/instantclient-basic-linux.x64-19.3.0.0.0dbru.zip
wget https://download.oracle.com/otn_software/linux/instantclient/193000/instantclient-sdk-linux.x64-19.3.0.0.0dbru.zip
unzip instantclient-basic-linux.x64*.zip
unzip instantclient-sdk-linux.x64-*.zip
echo /opt/oracle/instantclient_19_3 > /etc/ld.so.conf.d/oracle-instantclient
ldconfig
echo "LD_LIBRARY_PATH=/opt/oracle/instantclient_19_3:$LD_LIBRARY_PATH" >> /etc/enviroment
LD_LIBRARY_PATH=/opt/oracle/instantclient_19_3:$LD_LIBRARY_PATH

2. setup wallet
Download your wallet from the OCI database page

cd /opt/oracle/instantclient_19_3/network/admin/ 
** get your wallet, put it here
unzip Wallet_DB*.zip   
** shouldn't need this
export TNS_ADMIN=/opt/oracle/instantclient_19_3/network/admin

3. setup php

apt-get install php-dev php-pear build-essential libaio1
pecl install oci8
**when asked use, instantclient,/opt/oracle/instantclient_19_3
echo "extension = oci8.so" >> /etc/php/7.2/cli/php.ini

4. test
use your ADMIN password or whatever creds.  see you connection names in /opt/oracle/instantclient_19_3/network/admin/tnsnames.ora  


$conn = oci_connect("ADMIN", "password", "connection name from tnsnames", null, 0);

if ($conn) {
   print "Success, connected!\n";
} else {
   $m = oci_error();
   echo $m['message'], "\n"; 
}

oci_close($conn);

Thanks to https://gist.github.com/hewerthomn/81eea2935051eb2500941a9309bca703

Comments

Post a Comment

Popular posts from this blog

using t1n1wall, opnsense or pfsense on Google Compute Engine GCE

-
I have been doing some work in GCP recently, both appengine , and GCE.  We wanted to make sure all our instances were on private ips and only the LBs had internet ips. This gave us the problem of how to allow our instances reach the internet for updates or for api calls outside. In AWS you had a NAT gateway, but in GCP this doesn't exist. So I set about looking at the easiest way to do NAT from a private IP subnet to a Public address.  I am very familiar with m0n0wall and t1n1wall and a tiny bit with pfsense and less with opnsense. The tl;dr is that all these distributions ship an image which within the distribution there is a disk image.  Taking this internal image, renaming it and re-compressing it is all you need to do to get it working in GCE. you can configure it via the serial port using these instructions  There are guides out there around doing things with Linux and stuff, but you can skip that step. I took the latest version ...
Read more

nginx decode base64 url for use with imgproxy

-
 i've been testing imgproxy, to handle our image serving needs, and it looks good. our existing servers are php based, and we sign and encode our urls for images.  To test out imgproxy , I wanted to simply drop it in as a replacement for our servers by sending a % of traffic.  There are many ways to do this, varnish was one, with custom code, but nginx is our go-to web server, so I had to find a way to have nginx sit in front of imgproxy and rewrite the decoded url. I settled on using njs, the cut down version of javascript that plugs into nginx as a loadable module.  Then use proxy_pass to pass the uri to javascript that will return the imgproxy compatable url, and proxy to it. a sample url would be http://foo.bar/images/c2lnbmF0dXJlZm9vaHR0cDovL3MzLWV1LXdlc3QtMS5hbWF6b25hd3MuY29tL215YnVja2V0b2ZwaG90b3MvcGhvdG9fb2ZfYV9jYXQ1fHx8MTIwMHgxMjAwfHx8fHx8fHw==.jpeg it has a sig, a bucket url, and parameters like image size. Getting nginx setup nginx.conf load_module modu...
Read more

Resol VBUS success

-
at last, the kind folks in Resol sent me the protocol specification for vbus with openwrt and rrdcollect and rrdcgi, I can now graph the pumps and temperature information of my solar water system. There is a bash script that collects from the serial port, decodes it , and then outputs the values to a file that rrdcollect parses. All good, some holes in the graphs, probably a bad awk in my script, to be investigated. Once it's working reliably with no holes, I will try to post graphs here, somehow EDIT: Now there is a google group http://groups.google.com/group/resol-vbus EDIT: I wrote a utility to parse the data, seems to have gotten lost in the group, it's here  https://code.google.com/p/vbusdecode/
Read more