Convincing MySQL and PHP to talk to each other

Ziggie · 12-14-2005, 04:04 PM

Here's hoping someone knows more than me (it's a sure thing at this point.

)

Running Linux RedHat Enterprise AS 3, with Apache web server, php, and mySQL. All three of these are working. PHP and mySQL are not talking to each other however. When I check php settings, they look ok. When I check mySQL it's running, and accessible from the commandline.

In talking it over with other php know-it-alls they think php might need to be reinstalled, with mySQL included. Here's where I need the help.

I'm still relatively new to Linux and havent figured out how to actually install anything (or when I do, how to find it afterwards). So is someone familiar with an Apache, php, mySQL setup on linux that can talk me through some things to check before I try to reinstall php/sql?

Failing that, can someone talk me through how to install software?

I know it's a tall order, so mucho thanks in advance for even taking a look at this post.

Ziggs -- who really needs to stop taking on tasks he's nowhere near qualified to handle.

quarry_06 · 12-14-2005, 04:08 PM

create a file info.php with following contents:

PHP Code:



<?php 
phpinfo(); 
?>

save it in your /var/www or wherever your files are stored and access it

localhost/info.php

post the results which appear under mysql. if nothing appears, then you have installed a php without mysql(i) support. That is rather unlikely, but it can happen (if you compile from source and don't add a --with-mysql-support line or something)

Ziggie · 12-14-2005, 04:14 PM

I've done that, and there is no mysql listed in the long list of everything.
I didn't actually install php on this system, just walked into it...mess and all.

So since it appears that php is installed with no sql support (even though php.ini references mysql and has all the correct settings) how do I get php to have sql support?
Running php 4.3...

GL1800 · 12-14-2005, 04:21 PM

There's really no point in wrestling all that, using a lamp stack is sooo much easier. It's a "just works" solution.

http://www.apachefriends.org/en/

Ziggie · 12-15-2005, 07:02 AM

So there's no way to simply find a flag, set it to on, restart apache et al, and have everything work happy together? Reinstalling Apache seems like overkill (if I understood that lamp stack approach).

Ziggie · 12-15-2005, 12:25 PM

OK, I found a redhat rpm for php-mysql, went to install it and got the error:

Quote:

error: Failed dependencies:
libmysqlclient.so.10 is needed by php-mysql-4.3.2-24.ent
Suggested resolutions:
/mysql-3.23.58-16.RHEL3.1.i386.rpm

Does this mean that it's not recognizing MySQL as installed? And if that's the case, how do I show it that MySQL is installed and working?

the file that it's looking for [libmysqlclient.so.10] is located in /usr/lib

GL1800 · 12-16-2005, 04:41 AM

Perhaps this has to do with the versions of things. If you solve this, how many more issues lie between today, and putting it on the air? These challenges are what led to the creation and popularity of LAMP stacks.

Ziggie · 12-16-2005, 07:07 AM

I see your point.

But I did force it to install, ignoring the dependencies, and it installed. Restarted apache and mysql and everything seems to be working.

Thanks for all the advice, and I will definitely keep LAMP stacks in mind for future upgrades.