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