Playing with HTMLDB - wish me luck

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Jan 2006 12:46:07 -0500

I decided to start toying with HTMLDB and see what does it really do.
I want to see session variables, $_POST, $_GET, $_ENV, in a word, everything.
One way of doing it is to link PHP to HTMLDB. Well, Oracle uses perl 5.6.1,
the implementation was rather @#$%! but, eventually, I got it:

$ make install
Installing PHP SAPI module:       apache
cp libs/libphp5.so /home/htmldb/Apache/Apache/libexec/libphp5.so
chmod 755 /home/htmldb/Apache/Apache/libexec/libphp5.so
[activating module `php5' in /home/htmldb/Apache/Apache/conf/httpd.conf]
Installing PHP CLI binary:        /home/htmldb/local/bin/
Installing PHP CLI man page:      /home/htmldb/local/man/man1/
Installing build environment:     /home/htmldb/local/lib/php/build/
Installing header files:          /home/htmldb/local/include/php/
Installing helper programs:       /home/htmldb/local/bin/
  program: phpize
  program: php-config
Installing man pages:             /home/htmldb/local/man/man1/
  page: phpize.1
  page: php-config.1
Installing PEAR environment:      /home/htmldb/local/lib/php/
[PEAR] Archive_Tar    - installed: 1.3.1
[PEAR] Console_Getopt - installed: 1.2
pear/PEAR can optionally use package "pear/XML_RPC" (version >= 1.4.0)
[PEAR] PEAR           - installed: 1.4.6
Wrote PEAR system config file at: /home/htmldb/local/etc/pear.conf
You may want to add: /home/htmldb/local/lib/php to your php.ini include_path
Installing PDO headers:          /home/htmldb/local/include/php/ext/pdo/

In order to do that, I had to copy files from a real database $ORACLE_HOME/rdbms/public to the /home/htmldb/rdbms/public but, as both came from the 10.2
installation CD set, I'mreasonably certain of success. Besides that, I had to
tailor the linking procedure like this:


#!/bin/sh
set -a
ORACLE_HOME=/home/htmldb
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1
PATH=$ORACLE_HOME/perl/bin:$PATH
./configure --prefix=/home/htmldb/local --with-apxs=$ORACLE_HOME/Apache/Apache/bin/apxs --with-xmlrpc --with-zlib --with-bz2 --with-config-file-path=/home/htmldb/local/etc --enable-sigchild --without-sqlite --disable-mysql --without-pdo-sqlite --with-oci8 --with-pdo --with-pdo-oci
make


This is necessary because without that the "apxs" script (Apache config) supplied by oracle will not find any of the needed Perl modules. Now, I can
enter things like <?php ...?> into HTML text in HTMLDB. This should be interesting.
--
Mladen Gogala
http://www.mgogala.com
--
//www.freelists.org/webpage/oracle-l



Other related posts: