php-mysql in Fedora Core 6

mvelasco2 · 11-24-2006, 04:26 PM

Hello,

Running Ferdora Core 6 with PHP 5.1.6 and MySQL 4.1.21. I originally had MySQL 5 but had to remove this and install version 4.1.21 because the application I needed would not run on version 5 properly. I managed to install MySQL 4.1.21 but now need to install php-mysql and whenver I try to install it from apt or yum it needs to upgrade MySQL to version 5 again.

How can I install php-mysql in this scenario?

Any ideas or suggestions would be greatly apprecited.

Thanks,
Marlon

reeseslover531 · 11-24-2006, 06:51 PM

well it looks like you will need to compile php.

mvelasco2 · 11-24-2006, 08:24 PM

Can you please send me a link or doc where this procedure is explained? I am fairly new to linux and have always depended on apt or yum to install programs so compiling a program is new to me.

Thanks,
Marlon

Quote:

Originally Posted by reeseslover531

well it looks like you will need to compile php.

GeekBoy · 12-18-2006, 11:42 PM

I am also having problems with PHP 5 not runing some web sites using PHP w/MySQL.

It seems with PHP 5, they are no longer including what is called "client libraries." I do not know what this is.

Here is some information I found:

Quote:

The only change in PHP 5 is that we are no longer bundling the client library itself. Some reasons in no particular order:

Most systems these days already have the client library installed.

Given the above, having multiple versions of the library can get messy. For example, if you link mod_auth_mysql against one version and PHP against another, and then enable both in Apache, you get a nice fat crash. Also, the bundled library didn't always play well with the installed server version. The most obvious symptom of this being disagreement over where to find the mysql.socket Unix domain socket file.

Maintenance was somewhat lax and it was falling further and further behind the released version.

Future versions of the library are under the GPL and thus we don't have an upgrade path since we cannot bundle a GPL'ed library in a BSD/Apache-style licensed project. A clean break in PHP 5 seemed like the best option.

This won't actually affect that many people. Unix users, at least the ones who know what they are doing, tend to always build PHP against their system's libmyqlclient library simply by adding the --with-mysql=/usr option when building PHP. Windows users may enable the extension php_mysql.dll inside php.ini. For more details, see the MySQL Reference for installation instructions. Also, be sure libmysql.dll is available to the systems PATH. For more details on how, read the FAQ on setting up the Windows systems PATH. Because libmysql.dll (and many other PHP related files) exist in the PHP folder, you'll want to add the PHP folder to your systems PATH.

Seems we will have to compile PHP for Fedora 6, even though I would think the devlopers would know about this problem and already had compiles PHP with the client libraries it needs.
I will look and find at www.php.net on how to compile properly..so should you.

GeekBoy · 12-19-2006, 12:13 AM

The solution is simple!

Find the php.ini file and add the following line:

extension=mysql.so

Now all the php problems with MySQL not working are solved.