Problems with SQL (including MySQL, and postgreSQL)

1. How do I get MySQL support working in the php3 module which comes with SWS?

Download the MySQL source (http://www.mysql.com/) install the rpm, run rpm -bb (Note that the -bb means "build binary" to rpm) or run and install it, get the newest version as the old binary MySQL rpm's totally crap out in glibc 2.1. Download the PHP 3.0.7 (works for me, haven't tried 3.0.8 yet) source rpm, add "--with-mysql=/usr" to the spec file and rpm -bb and install it. Note you will need freetype-devel, and a few other odds and ends for it to behave.

Install PHP, and then edit /etc/httpd/conf/httpd.conf:

LoadModule php3_module modules/libphp3.so
AddModule mod_php3.c

You will also need to create the symlinks in /etc/httpd (if they do not exist):

libexec -> ../../usr/libexec/
logs -> ../../var/log/httpd
modules -> ../../usr/lib/apache

And you should be up and running.

2. I didn't choose to install postgreSQL when I did my initial SWS install how do I install it now?

We have recorded an install as it actually happened with errors so you can see some of the things which can happen and see how they were fixed. The record is here.

3. I want to install MySQL. How do I do it?

We have recorded an install as it actually happened with errors so you can see some of the things which can happen and see how they were fixed. The record is here.

4. Can I use Access databases instead of a full blown RDBMS with SWS?

There has been a lot of discussion about this on the PHP mailing list. Perhaps you should look at the following link:
Access with PHP.