RE: Playing with HTMLDB - wish me luck

  • From: "Stephen T Murphy" <SMurphy@xxxxxxxxxxxxxxxxx>
  • To: <gogala@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Jan 2006 13:11:18 -0500

If you want to use HTML-DB without the need to install Apache or HTML-DB
itself, just download and install Oracle-XE from OTN. Its Oracle's free
version of 10gR2 and comes pre-installed with HTML-DB already installed.
It doesn't use Apache. Instead, it has mod_plsql built into the DB
engine which is something new with 10.x. 


--
*-----------------------------------------------------------------------
----* 
  Stephen T. Murphy  
  Manager, Database and Technical Support 
  ITS - University Applications Development 
  MSC-100 
  The University at Albany, S.U.N.Y. 
  Albany,  New York    12222            
  Phone: (518) 437-4523     Fax: (518) 437-4540   
  MailTo: SMurphy@xxxxxxxxxxxxxxxxx     AIM: SMurphy199 
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Friday, January 20, 2006 12:46 PM
To: oracle-l
Subject: Playing with HTMLDB - wish me luck

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


--
//www.freelists.org/webpage/oracle-l


Other related posts: