Hello,
I've been fighting with this problem for a week.
I have installed oci8 in order to access an Oracle 11g database from
php 5.4.16
My php pages work fine. I can connect, select, update, insert.
Here is the code of a simple php page named connect.php that I put
under Apache default site
I access
http://localhost/connect.php and it displays the list of
the user's tables
<?php
putenv("ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe");
putenv("LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib:/lib:/usr/lib:/lib64:/usr/lib64");
$conn = oci_connect('havana', 'cdcdcdcdcdc', '//127.0.0.1/xe');
$stid = oci_parse($conn, 'select table_name from user_tables');
oci_execute($stid);
echo "<table>\n";
while (($row = oci_fetch_array($stid,
OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
echo "<tr>\n";
foreach ($row as $item) {
echo " <td>".($item !== null ?
htmlentities($item, ENT_QUOTES) : " ")."</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n";
?>
<diehjbac.png>
The problem is that once I configure Apache dbd authentication for
another site, my php code against the database stop working.
I try to access the same page
http://localhost/connect.php without
any modification to the page and I have this error screen:
<agiijajc.png>
I don't need to access the authenticated site. Just defining the
virtual host with the dbd authentication and restarting Apache,
makes my php database related code stop responding
I don't even need to configure all the directives for the
authentication.
I just put the DBDDriver oracle directive, restart Apache and
php-oracle doesn't work anymore
This is the virtual host definition:
<VirtualHost *:80>
ServerAdmin
webmaster@xxxxxxxxxx
DocumentRoot "/srv/auth"
ServerName auth.havana.tld
ErrorLog "/var/log/httpd/auth.havana.tld-error_log"
CustomLog
"/var/log/httpd/auth.havana.tld-access_log" common
DBDriver oracle
DBDParams "user=havana pass=crosemont
server=127.0.0.1:1521"
DBDPersist on
<Directory "/srv/auth">
AuthType Basic
AuthName "Havana"
AuthBasicProvider dbd
Require valid-user
AuthDBDUserPWQuery "SELECT p_client FROM client
WHERE n_client = %s"
</Directory>
</VirtualHost>
Configuration:
-Apache 2.4.6 Over CentOS 7
-An authenticated site configured to use dbd authenticacion
against an Oracle 11g database
I have compiled apr-1.5.2 libraries against Oracle
instanclient
I would appreciate any help.
Best regards,
José
