Support for Oracle on PHP

[defferrari]

Hello,

My company is testing the cPanel, to a future migration, but we need the support Oracle on PHP.

The cPanel I can configure this? How?

[cPanelDavidG]

Hello,

My company is testing the cPanel, to a future migration, but we need the support Oracle on PHP.

The cPanel I can configure this? How?

Use EasyApache (WHM -> Software -> Apache Update) to install PHP 5 and PDO support. To enable PDO, at step 5 click the button to get you to the advanced configuration screen and under the PHP 5 section, check the box for PDO.

Then in WHM -> Software -> Module Installers, click "Manage" next to PHP Pecl and install PDO_OCI

Refer to Oracle's documentation on PDO do understand how to access Oracle databases via PHP.

[orware]

@cPanelDavidG

In relation to this question, do the appropriate Oracle Instant Client Libraries get installed when PDO gets installed?

If everything gets installed automatically that would be great.

Thanks!

[cPanelDavidG]

@cPanelDavidG

In relation to this question, do the appropriate Oracle Instant Client Libraries get installed when PDO gets installed?

If everything gets installed automatically that would be great.

Thanks!

Looking at Oracle's documentation on the subject, it does not seem likely:

http://www.oracle.com/technology/pub...o_oracle5.html

[orware]

This would be my impression as well from what I've read which is why I was asking if the Oracle Instant Client Libraries would be installed automatically with PDO as part of cPanel/WHM's features (since WHM does do a lot of things for users automatically).

This would mean then that even if PDO_OCI (or just the OCI module) were enabled it wouldn't mean that they would work, and users would still be required to install the Instant Client (either before or after the PHP modules were enabled)?

Would there be any problems in downloading and installing the Instant Client libraries manually (in regards to disturbing any cPanel/WHM functions), since it looks like that would be the approach that would need to be taken?

[cPanelDavidG]

This would be my impression as well from what I've read which is why I was asking if the Oracle Instant Client Libraries would be installed automatically with PDO as part of cPanel/WHM's features (since WHM does do a lot of things for users automatically).

This would mean then that even if PDO_OCI (or just the OCI module) were enabled it wouldn't mean that they would work, and users would still be required to install the Instant Client (either before or after the PHP modules were enabled)?

Would there be any problems in downloading and installing the Instant Client libraries manually (in regards to disturbing any cPanel/WHM functions), since it looks like that would be the approach that would need to be taken?

I don't foresee that causing issues with cPanel/WHM. However, I will note that PDO is not very well maintained by the PHP team so you may encounter issues as a result.

[orware]

Thanks for the update David, I'd more than likely be using the vanilla OCI extension because of the lack of documentation on PDO, but either way I'd need to get it going...is there an option for OCI in addition to the PDO_OCI option? It's really a small change in the php.ini, but I don't know if the way WHM takes care of things if this would require a recompile or not?

[cPanelDavidG]

Thanks for the update David, I'd more than likely be using the vanilla OCI extension because of the lack of documentation on PDO, but either way I'd need to get it going...is there an option for OCI in addition to the PDO_OCI option? It's really a small change in the php.ini, but I don't know if the way WHM takes care of things if this would require a recompile or not?

Rule of thumb is if it wouldn't involve a recompile in a regular Linux/FreeBSD PHP environment, then it wont require a recompile in a cPanel/WHM environment, and vice-versa.