Promised to post the steps of installing 2 different open source databases into Debian...
As you know, Debian is one of the oldest linux distro with a good package management with more than 15 thousands packages (till date - 14 Sept 2005 - Deb 3.1) under its distributed repository.
I tried installing Apache 1.3x, this time with SSL support. Meaning that i can browse my page with
https://xxx.xxx.xxx/ and
http://xxx.xxx.xxx/. If i want the web page to point to my own home directory (presume that i wanted to have a personal page which under my own home directory (/home/skywalker/public_html/index.html), then create a directory directly in home directory, named public_html and put an index.html or index.php for testing.
While installing using apt-get, php4-mysql, php4-pgsql, mysql-client, mysql-server, postgresql-8.0, postgresql-8.0-client... (i might be wrong now with packages name. i'll suggest to open up to terminal(mostly like you're in X-windows), one doing a search of apt-cache search postgresql to make sure you put the right package name.
After installing everything accordingly, i'll do a test with php on apache to make sure php successfully points to both databases. Of course it's to add into a something.php and browse it through your favourite browser - I'm using Firefox!
A hint of checking if your browser doesn't browse php format successfully. Once i successfully installed apache, php, mysql and postgresql even though every daemons were restarted automatically, checking http.conf doesn't see anything wrong though. I almost give up the test and switching back to my windows to do my reporting stuff. Then i switch back to debian box, the php test page works!!
I guess eventually reboot does help... who knows... ;)
Right, back to our theme here - after the test page, scroll down... Bingo... php points to both mysql and postgresql... I guess the key point that i shouldn't missed is php4-mysql and php4-pgsql.
Alright... more or less there, time to move on...
regards,
Skywalker