Chapter 12. Problems with SQL (including MySQL, and postgreSQL).

Table of Contents
How do I get MySQL support working in the PHP3 module which comes with SWS?
I didn't choose to install postgreSQL when I did my initial SWS install. How do I install it now?
I want to install MySQL. How do I do it?
Can I use Access databases instead of a full blown RDBMS with SWS?

How do I get MySQL support working in the PHP3 module which comes with SWS?

Download the MySQL source (http://www.mysql.com/) and install the RPM, Then run rpm -bb (note that the -bb means "build binary" to RPM). Get the newest version, as the old binary MySQL RPMs don't work with 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
              

After this, you should be up and running.