Checking PHP support for database type

[wolfhard]

Hi guys,
I have the following message when trying to install the Database:
MySQL 4.0.25
PHP 5.0.4
Mantis 1.0.0rc1
Windows 2003 Server

Setting Database Hostname GOOD
Setting Database Type GOOD

Checking PHP support for database type BAD
database is not supported by PHP

Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin

Any ideas?
Thanks.
Wolfhard

[wolfhard]

Just to add to the previous problem description:

I used the information from the MySQL Monitor, i.e. Servername, Username, Password ..

Anything else I need to check? What am I forgetting.

Kind regards
Wolfhard

[HC]

I have the same error and I check to make sure that PHP is setup to use MySQL. Any ideas?

Kind Regards.

[wolfhard]

The my.ini file of my MySQL installation looks like this ....
It resides in the C:\WINDOWS directory ....
I am logged on to Windows as Administrator ....
Is it the version of MySQL that couses this problem??


#This File was made using the WinMySQLAdmin 1.4 Tool
#7/28/2005 10:46:06 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=10.0.0.8
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=wolfhard
password=hallihallo

[wolfhard]

STEP ONE ............................................................................................
Using Linux (or Windows), if you are getting this problem:

1. " Call to undefined function: mysql_connect() "
or
2. The test is failing for " Checking PHP support for database type " for mantis/admin/install.php

then do this to fix it:

(1) Find the file php.ini which is in your apache directory (suggestion: /etc/php4/apache2/php.ini)

(2) find the section:
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

(3) and uncomment or add:

extension=mysql.so

the same applies for the gd extension (if you would like to use it):
extension=gd.so

(4) restart apache (etc/init.d/apache2 restart) and thats it

Thanks to http://www.linuxsolved.com/forums/ftopic884.html

STEP TWO ...........................................................................................
to prevent this error:
"PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found"

Check the following:

PHP.ini contains:
extension_dir = "c:/php/ext/"
extension=php_mysql.dll

File Locations:
php_mysql.dll is in c:/php/ext/
libmySQL.dll is in c:/windows/system32/

Hope this helps and saves you some time. Don't forget to RTFM :-)

Kind regards
Wolfhard Aring