Thursday, January 10, 2008

Hiccups with PHP5 and xdebug on RHEL

Root cause of all this was that /usr/ filesystem is Read-only; so I had to compile binaries to install on writable area. So i did the following.

1. Executed the following from php source root folder; this installed the php binaries under --prefix location
./configure --prefix /scratch/asamuel/projects/opensource/php-5.2.5/install
make
make install


2. Executed the following from xdebug source root folder
/scratch/asamuel/projects/opensource/php-5.2.5/install/bin/phpize
./configure --enable-xdebug --with-php-config=../../php-5.2.5/install/bin/php-config
make


3. Copied /scratch/asamuel/projects/opensource/php-5.2.5/php.ini-recommended to /scratch/asamuel/projects/opensource/php-5.2.5/php.ini

4. Modified php.ini to load xdebug extension and enable remote debugging using
zend_extension="/scratch/asamuel/projects/opensource/xdebug/xdebug-2.0.2/modules/xdebug.so"
xdebug.remote_enable=On


3. Verified the build using (where alias php5=/scratch/asamuel/projects/opensource/php-5.2.5/sapi/cli/php -c /scratch/asamuel/projects/opensource/php-5.2.5/php.ini $*)
php5 -v
which resulted
PHP 5.2.5 (cli) (built: Jan 10 2008 12:52:19)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Xdebug v2.0.2, Copyright (c) 2002-2007, by Derick Rethans

Tuesday, January 08, 2008

Hiccups with Oracle Database

The Oracle Database installation and interfaces (sqlplus like) have improved heaps from what I can remember from the days of 8i version. With Oracle XE, installation is so simple that even a pre-teen can do it. But still you cud hit stumbles like following one(s) and takes bit of googling for find you way out.

1. Unable to access Apex (formerly HTMLDB) application remotely.

The apex service by default (as on 10g) will be running at port 8080 and is accessible locally using http://localhost:8080/apex; but due to security-by-default policy it is not accessible remotely using http://myhost.mydomain:8080/apex. To enable it login, using sqlplus or sqldeveloper as sysdba and execute the following.

exec dbms_xdb.setListenerLocalAccess(false);

More hiccups to follow as and when encountered.

I am well fed with these !!