MySQL not working: undefined function

[labrat]

I have recently set up a box with RH Linux 8.0 and installed Apache (v2.0), PHP (v4.2.2) and mySQL (v3.23.52) from the RPM. I can access mySQL fine from the terminal but as soon as I hit any MySQL functions in PHP it chokes.

Since I'm a total newbie with Linux I am hoping I don't have to rebuild and reinstall anything because I don't really know my way around yet. Is this possibly due to something set incorrectly in the php.ini file?

One thing might be that the path to one of the necessary files is not right. It seems that the guy who did the install for me put it all on one partition and I am not finding things in the usual paths. Maybe you could tell me what to look for.

Here is my simple test:

<?php   

$dbcnx = mysql_connect("localhost", "root");
if (!$dbcnx)
{
  echo "Error: Could not connect to database.  Please try again later.";
  exit;
} //end if
?>

I get the error:
"Fatal error: Call to undefined function: mysql_connect() in /home/xxxx/public_html/test_mysql.php on line 13"

I tried this with "$dbcnx = mysql_connect("localhost", "root", "password");"

and "$dbcnx = @mysql_pconnect("localhost", "root", "password");"

but I also get errors with these statements.

So it really looks like a problem with my set up.

How can I troubleshoot this?

TIA
-Labrat

[sijis]

i honestly wouldn't know how to trouble shoot that, but what i can do
is tell you that php has a settings file, it should be named:
php.ini

you should look into that file and see if there is anything that 'looks' odd. I belive there is an example php.ini file too that should help
for reference.
hth.

[jerdo]

You need to install the php-mysql rpm. Redhat 8.0 uses that to allow php to interact with mysql. https://rhn.redhat.com/errata/RHSA-2003-017.html#Red%20Hat%20Linux%208.0

[labrat]

Sorry if I sound lost, but I pretty much am when it comes to Linux...

I checked the package viewer utility and it seems like this is already installed. Are you saying I need to upgrade my installation of it? I am running Gnome desktop... can you tell me what to look for to verify whether this was installed properly or whether it is installed at all. Or give me the command to enter in the terminal. I am still getting used to finding my way around Linux. I know how to locate a file and view it if you tell me what to look for.

Perhaps it is a problem with permissions. I tried to use tar but it wouldn't work until I logged in as su.

Maybe you know a good help group or tutorial for Linux admin. (other than the Red Hat page). It seems I really need to do that before I am proficient enough to deal with upgrading or installing any software.

Lastly, I should mention that the setup of Linux on my machine is not standard, I think. The IT guy from my office installed it for me and put everything on one partition due to a small disk drive (6 G😎. He knew it was for a web server with PHP and MySQL so I am sure he included those in the packages that were installed.

Thanks for the help.
-Labrat

[jerdo]

Open a terminal and type rpm -q php-mysql
That will tell you if it's installed.

[labrat]

Thanks... I checked and it is not installed... :-(

I guess it's only mysql and php--not php-mysql that is installed

Now I have to figure out how to do an install. If anyone can point me to some sort of tutorial on how to do this type if install I would be forever grateful. I will plan on downloading the .rpm file you mentioned earlier in the thread, but I just don't know how to get it installed.

I'm off to look for info now...

-Labrat

[jerdo]

Try this "rpm -Uvh packagename" or "rpm -ivh packagename"

[labrat]

Well I appreciate all this help but I guess this was not meant to be simple for me... Here's what happened:

rpm --install php-mysql-4.2.2-8.0.7.i386.rpm

warning: php-mysql-4.2.2-8.0.7.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
error: Failed dependencies:
php = 4.2.2-8.0.7 is needed by php-mysql-4.2.2-8.0.7

DOH!!!

I got this same message when I tried your -ivh as well.

I managed to check the version of php and it is 4.2.2-8.0.5. I guess I need to do some more reading.

Either that or bag the whole thing 🙁 I actually downloaded v4.3.1 so maybe I'll just have to figure out how to upgrade php. One day I might actually get conversant in this stuff... back to the LDP...

-labrat

[keith73]

I got the same failed dependencies error. Anyone else find a solution to this yet?

I'm trying to grab the package off of redhat's ftp server, it downloads it, opens it, but then fails on dependencies.

php = 4.2.2-8.0.5 is needed by php-mysql-4.2.2-8.0.5

yet I have php 4.2.2-8.0.7.
Is it not backwards compatible??

• keith

UPDATE!!!!

I fixed the problem.
I found the RIGHT rpm by doing a search on redhat's site. even that had bad links in a few places, but finally I downloaded from here:
[url]ftp://updates.redhat.com/8.0/en/os/i386/php-mysql-4.2.2-8.0.7.i386.rpm[/url]

• keith