I recently installed Red Hat Enterprise Advanced Server 3. As part of the install, I asked it to install MySQL and Apache 2. I have discovered that PHP does not seemed to have been installed with MySQL support:

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/test.php on line 6

But when I look at <? phpinfo(); ?> is see:

I see that it has been configured with --with-mysql=shared,/usr.

Within php.conf (which gets included in the httpd.conf), is this line:

LoadModule php4_module modules/libphp4.so

Also when I run phpinfo() is see that --with-mysql=shared,/usr is there, so when php was installed it should have been compiled with MySQL support.

php.ini says this about MySQL:


[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limimt
mysql.connect_timeout = -1

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Erros will be displayed.
mysql.trace_mode = Off


Also, I see mysql.so at ./usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so

Do I need to declare this in php.ini? Such as:

extension=mysql.so

Any HELP would me appreciated!

was the mysqld [daemon] running when u ran the php script???

How would I check this?

I know that I have no problems accessing MySQL from the command line, but that's not what you are asking?

Since I let the RHEL3 GUI Installer do all of this (sellected the packages I wanted off the list...), maybe I should back out the RPMs (Apache, PHP, MySQL) and install them by hand? What worries me about that is I want to get all the ./configure flags right. This is your very basic web server box. Nothing fancy going on, dynamic web pages that draw content from mysql. Lot's of SELECT, very little INSERTS, non-critical data...

check this link out
-->http://www.blazonry.com/scripting/install_apache.php

#top

u should see a process which says mysqld