PHP/MySQL CentOS(RedHat) Installation Woes

Hi:
I am trying to set up a server with php and mysql (also apache).

The server is newly installed with centos (one of the 4. flavor, installed
by server provider).

A buddy and me configured the box and managed to get MySQL running (we had
to install MySQL server via yum, as only client had been installed) So far
have only been able to access MySQL via native UNIX fia ssh. We got ftp up
and running and have managed to get a phpinfo page out of the server via
remote http.

However when I began to run my code it seems as if php doesn't know about
MySQL. I found the following in the error log:

PHP Fatal error: Call to undefined function: mysql_connect() in
/home/websiteA/httpdocs/classes/class_DataFunctions.php on line 32

Here is the code generating the failure condition:

$this->dbhandle = mysql_connect($this->hostname, $this->user,
$this->password);

The variables are set and defined, the code has been tested on my local
windows machine. I have confirmed the variables have value on the RedHat
machine as well.

It just seems as if php does not know about MySQL

I am using PHP Version 4.3.9 and a 4. Something version of MySQL

PHPInfo reports in the configuration section '--with-mysql=shared,/usr' and
all of the settings in my httpd.conf and php.ini files seem to be OK, as far
as I can tell. In fact they seem to be almost identical to those running a
similar code set on a different server.

I really need to get this up and running so any help would be enormously
appreciated.

Thanx in advance!

Dan

Re: PHP/MySQL CentOS(RedHat) Installation Woes

On Jun 24, 10:38 am, "news.prolog.net" wrote:
> Hi:
> I am trying to set up a server with php and mysql (also apache).
>
> The server is newly installed with centos (one of the 4. flavor, installed
> by server provider).
>
> A buddy and me configured the box and managed to get MySQL running (we had
> to install MySQL server via yum, as only client had been installed) So far
> have only been able to access MySQL via native UNIX fia ssh. We got ftp up
> and running and have managed to get a phpinfo page out of the server via
> remote http.
>
> However when I began to run my code it seems as if php doesn't know about
> MySQL. I found the following in the error log:
>
> PHP Fatal error: Call to undefined function: mysql_connect() in
> /home/websiteA/httpdocs/classes/class_DataFunctions.php on line 32
>
> Here is the code generating the failure condition:
>
> $this->dbhandle = mysql_connect($this->hostname, $this->user,
> $this->password);
>
> The variables are set and defined, the code has been tested on my local
> windows machine. I have confirmed the variables have value on the RedHat
> machine as well.
>
> It just seems as if php does not know about MySQL
>
> I am using PHP Version 4.3.9 and a 4. Something version of MySQL
>
> PHPInfo reports in the configuration section '--with-mysql=shared,/usr' and
> all of the settings in my httpd.conf and php.ini files seem to be OK, as far
> as I can tell. In fact they seem to be almost identical to those running a
> similar code set on a different server.
>
> I really need to get this up and running so any help would be enormously
> appreciated.
>
> Thanx in advance!
>
> Dan

I am pretty new at this so I might be wrong. I looks like you are
trying to use MySQL Improved (mysqli) and it is not recognized by the
versions of php/mysql you are using.

Re: PHP/MySQL CentOS(RedHat) Installation Woes

news.prolog.net wrote:
> Hi:
> I am trying to set up a server with php and mysql (also apache).
>
> The server is newly installed with centos (one of the 4. flavor,
> installed by server provider).
>
> A buddy and me configured the box and managed to get MySQL running (we
> had to install MySQL server via yum, as only client had been installed)
> So far have only been able to access MySQL via native UNIX fia ssh. We
> got ftp up and running and have managed to get a phpinfo page out of the
> server via remote http.
>
> However when I began to run my code it seems as if php doesn't know
> about MySQL. I found the following in the error log:

yum install php-mysql


--

//Aho