We’ve got an issue here (related to connecting to the MIS systems in our college so that we can have the data which they contain displayed in Moodle), and I wanted to see if anyone might have any tips on how we can resolve it.
We’re currently running Moodle 1.9.8+ (with a MySQL 5.051 server) in a Linux environment with PHP 5.2.6.
However, we don’t seem to be able to connect to the Oracle 9 database as our PHP build is missing the Oci8 extension and the ADOdb libraries ( - the PHP elements originally came in a ‘bundle’ which didn’t include these two).
I wanted to ask if anyone has any tips or suggestions on how we might manage to install the Oci8 extension and the ADOdb libraries without having to begin a new PHP build.
The only solution we can think of beyond that is to make a new build of PHP (perhaps on a Windows server) which includes these elements.
I’d really appreciate any comments: thanks!
From what I can tell you'll have to re-configure PHP using the --with-oci8 option, then re-compile (make, make install) it for the server you're on (http://www.php.net/manual/en/oci8.installation.php)
Re-building (the server) on Windows *may* be easier I guess since it's normally a case of just ensuring you have the extension dll files...
Alternatively find a binary distribution that has already been built with these extensions, trade off being that it may have stuff you don't want/need built in.
It's been a long while since I did this last, Im also not sure what Linux you're using (unfortunately I can only help with Ubuntu), I seem to remember that it was a combination of the following two tutorials that helped me on my way (for Ubuntu anyway).
Reading through the first one I think that's the one I followed, although you will probably need to change the instantclient filenames to reflect newer version numbers etc...
- How to install oci8 for PHP 5 on Ubuntu
-- Argh! what's up with the forum adding emoticons into the link above? Not sure how to avoid this, sorry.