Hi all, i have a modules question regarding apache and mysql.

There is this system at work which is running a mysql server and apache with php.

But the mysql doesnt work together with with apache and php. I later noticed that mysql was installed and set to active work in the system before the completion of apache and php so there isnt a module compiled for mysql to work with apache.

I was now wondering if anybody has a tip or a clue on how to get mysql to work with php and if there is a way to do this without recompiling mysql. Is there a way to just get a mod_mysql.so someway?

I'm sorry for my bad english but i hope you'll understand my anyway.

Its a RedHat * machine.


-----------------------
Few clips from PHPINFO:

Configure Command './configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--with-apxs2=/usr/sbin/apxs'
----------------------------------

dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT

MySQL support is built in to php. It even says in the phpinfo you posted:
"--with-mysql"

If you explain why it didn't work or any error messages you got we might be able to help....

yeah i do understand that php support mySQL thats why im asking maybe someone know how can i re compile the PHP to support the MYSQL coz upon installing it form package as RPM there is no specificatoins of mySQL such us --with-mysql='path' is just directlky point to '--with-mysql=shared,/usr' so i guess there is no way for you to find out that mysql is not defined properly