Hi Jose. It looks like you need to create a separate virtual host for each of the sites you want to connect to.
Try putting the original virtualhost configuration back to the way when it was working, then copy and paste that VH section and edit it for the new site. For each virtual host you will need the corresponding <VirtualHost> … </VirtualHost> section in your apache2 configuration file. HTH, Keith On 24 Nov 2015, at 03:43, Jose Tremols <tremols1...@gmail.com> wrote: > 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 webmas...@havana.tld > 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é >
