PHP MySql Problem
 

I haven't used mysql at all until yesterday when I tried to install SMF. I was getting some database connection issues, tried to work them out, and ended up giving up. Today I bought the domain pcgamertalk.com so I have got to work this out so I tried phpBB hoping it would miraculously work. Not suprisingly, that didn't work. When installing phpBB it gave me an option to change the type of database the forum should be installed in. I tried both MySql versions it allowed me and neither worked.

Obviously something is wrong with configuration of php and mysql, but I can't figure it out. When I login into webmin, I can add databases and tables to mysql, but I can't connect from a php script. Has anyone else had this problem? Thanks

chiefsmurph I have to apologize for getting back to you late on this one. I have a side project going that eating all my free time. It sounds like your missing the php-devel for either MySQL or http. I had the same problem on my server. It turned out that I needed http php-devel and after I installed it everything worked.

The php-devel for http or mysql is not just for http or mysql, right? I looked on google and couldn't find anything for "php-devel for http," but when I searched just for php-devel there were plenty of rpms.

I downloaded one and tried to install it, but I got an error:

file /usr/bin/pear from install of php-devel-4.0.6-12 conflicts with file from package php-pear-4.3.9-3.8

Do I have to uninstall php's old extensions before I try to install php-devel or does that mean I already had them?

Your going to have to update the php-devel with yum. Try "yum install MySQL-devel" and try "yum install php-devel" Let me know if one of those two fixes your problem. :)

Ran them both and no luck. Still getting error here.

MySQL-devel gave me:

No Match for argument: MySQL-devel
Nothing to do

Php-devel did a lot. Looked like this:

Transaction Summary
======================
Install 1 Package(s)
Update 3 Package(s)
Remove 0 Package(s)

Try "yum install php4-mysql" and let me know if that works? Dont worry we will get you up and running. Also check and make sure php_mysql.dll is enabled in the php.ini.

yum install php4-mysql said nothing to do, but I looked in my php.ini file and theres no php_mysql.dll.

I searched for mysql and found: extension_dir = /var/lib/mysql/ is that right?

Also, extension wasn't set. I thought it had something to do with extensions but I may be way off.

The only other thing I can think of is you need to rebuild PHP for MySQL. What OS are you running and what version of PHP do you have?

If your running PHP 4 you can follow this guide to rebuild your PHP for MySQL.
http://www.eth0.us/sourcephp

Centos Php 4. Thanks for the help. I'll try to recompile php later today.

I read the page on recompiling php and I got to the part where I was running "up2date libpng-devel libjpeg-devel freetype-devel freetype libjpeg libpng." I ran it and it gave me

Downloading headers to solve dependencies...
There was an error downloading: http://mirror.centos.org/centos/4/os...L4_U2.i386.hdr
There was an error downloading: http://mirror.centos.org/centos/4/os...2.1-1.i386.hdr

...continually