MySQL Database Not Available

[luisamato]

» Operating system type and version Debian Sarge Stable
» Sugar Suite version 4.2.0
» Webserver type and version Apache 2.0.54-5
» PHP version 4.3.10-16
» MySQL server version 4.1.11a

MySQL Database Not Available

Whe i try to install Sugar all items are OK but database is not available

PHP version Unsupported (ver 4.3.10-16)
MySQL Database Not Available
XML Parsing OK
cURL Library Not found: scheduler will not be functional
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path (/var/lib/php4) OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 32M OK (32M)

dabsugar:/etc/apache2# apt-cache search php | grep mysql
acidlab-mysql - Analysis Console for Intrusion Databases for MySQL
php3-cgi-mysql - Mysql module for PHP3 (use with php3-cgi)
php3-mysql - Mysql module for PHP3 (use with php3)
php4-mysql - MySQL module for php4
phpbb2-conf-mysql - Automatic configurator for phpbb2 on MySQL database
dabsugar:/etc/apache2# dpkg -l | grep php
ii php4 4.3.10-16 server-side, HTML-embedded scripting languag
ii php4-common 4.3.10-16 Common files for packages built from the php
ii php4-mysql 4.3.10-16 MySQL module for php4
ii phpmyadmin 2.6.2-3sarge1 set of PHP-scripts to administrate MySQL ove
dabsugar:/etc/apache2# dpkg -l | grep aapache
dabsugar:/etc/apache2# dpkg -l | grep apache
ii apache-common 1.3.33-6sarge1 support files for all Apache webservers
ii apache2 2.0.54-5 next generation, scalable, extendable web se
ii apache2-common 2.0.54-5 next generation, scalable, extendable web se
ii apache2-doc 2.0.54-5 documentation for apache2
ii apache2-mpm-pr 2.0.54-5 traditional model for Apache2
ii apache2-utils 2.0.54-5 utility programs for webservers
ii libapache-mod- 4.3.10-16 server-side, HTML-embedded scripting languag
ii libapache2-mod 4.3.10-16 server-side, HTML-embedded scripting languag
dabsugar:/etc/apache2# dpkg -l | grep mysql
ii libdbd-mysql-p 2.9006-1 A Perl5 database interface to the MySQL data
ii libmysqlclient 4.0.24-10sarge mysql database client library
ii libmysqlclient 4.1.11a-4sarge mysql database client library
ii mysql-client-4 4.1.11a-4sarge mysql database client binaries
ii mysql-common-4 4.1.11a-4sarge mysql database common files (e.g. /etc/mysql
ii mysql-server-4 4.1.11a-4sarge mysql database server binaries
ii php4-mysql 4.3.10-16 MySQL module for php4

[luisamato]

Edit /etc/php4/apache2/php.ini and add the following two lines

extension=mysql.so
extension=gd2.so

Thats all

[normk]

I am getting the same error on a Win2k server during initial setup. I can't get past the first config screen on a new install as I get a red notation - Mysql Database - not found
Do I need to edit the php.ini file?

[wauters]

I found the answer to this, you need to turn on the extension in php.ini, remove the ; in front of php_mysql.dll and everything will work fine.

[paikmoses]

It's obvious to enable the php-mysql extension to make php communicate to mysql.

Regards,