getting mysql to work with php

dsgdevil · 02-09-2003, 07:33 PM

hi,i got mysql working but i cant get it working with php,when i try to install phpbb2,i get this error:
The PHP configuration on your server doesn't support the database type that you chose
anyone know what i have to do?thanks

wdingus · 02-09-2003, 07:50 PM

Install details? You show RH8 as your distro. Did you install both PHP and MySQL as part of Redhat 8 or did you go download and build them or something else? The copies included on the RH8 CDs work together as-is. Redhat does package the portion of PHP that includes the MySQL drivers as a separate package. Make sure this is installed: php-mysql-4.2.2-8.0.5

Other than that, create a simple PHP program that does

phpinfo();

and search the output HTML for mysql and see what you see...

dsgdevil · 02-09-2003, 08:54 PM

here's my phpinfo page
http://24.76.124.120/phpinfo.php
and i dont see a php-mysql-4.2.2-8.0.5 anywhere

wdingus · 02-09-2003, 09:12 PM

There is an entire section on MySQL not present in your phpinfo that I see on other servers. The php-msyql is an RPM installed package. Search for it in a shell:

# rpm -qa | grep -i php

That will show you all installed packages with php in the name. My guess is it won't be installed...

dsgdevil · 02-09-2003, 09:16 PM

here's what it says when i use that shell:
php-imap-4.2.2-8.0.5
php-4.2.2-8.0.5
php-ldap-4.2.2-8.0.5

dsgdevil · 02-09-2003, 09:20 PM

ok i downloaded that rpm off redhat.com,now the shell script looks like this:
php-imap-4.2.2-8.0.5
php-4.2.2-8.0.5
php-ldap-4.2.2-8.0.5
php-mysql-4.2.2-8.0.5
it should work now right?

wdingus · 02-09-2003, 09:23 PM

On my RH8 machine:

# rpm -qa | grep -i php
php-pgsql-4.2.2-8.0.5
php-imap-4.2.2-8.0.5
php-mysql-4.2.2-8.0.5
asp2php-gtk-0.76.2-3
php-ldap-4.2.2-8.0.5
php-manual-4.2.2-8.0.5
php-snmp-4.2.2-8.0.5
php-devel-4.2.2-8.0.5
php-4.2.2-8.0.5
asp2php-0.76.2-3
php-odbc-4.2.2-8.0.5

Install what's missing and you'll be good to go...

wdingus · 02-09-2003, 09:29 PM

Yes.. You may have to restart Apache first though...

# /etc/rc.d/init.d/httpd restart

dsgdevil · 02-09-2003, 09:35 PM

yes!it works now.thanks alot