[PHP] MySQL-PHP-RAQ4 dilemma!

[Greg Conway]

Hi all,
 
I'm trying to add MySQL to my RaQ4. It came 
by default with PHP4 but no MySQL.  

I've installed all 4 RPMs (including the developer part and 
everything) of the latest version, and MySQL is working fine. 
I've got DbTools (fantastic!) to interact with it, no probs.

However, I have reason to believe that PHP has been compiled 
without MySQL support. Namely 'cause phpMyAdmin doesn't work and 
I'm clutching at the only thing on the install list that I didn't 
do myself (ie php4 was pre-installed and is built into the GUI, 
unlike my RaQ3 where I added it in).

When I first started tinkering around with adding PHP4 to my 
other RaQ3, I remember using tarballs with switches to ensure 
MySQL support was installed.

So, my question is, how can I tell if PHP has been compiled with 
MySQL support or not, and if not, how can I add it in without 
breaking whatever's already there!! I presume PHP will be an RPM 
(or even a .PKG?), so can I specify these options within RPM installation?

Many thanks for any help.

Regards,

Greg Conway.

 --
+---+
|  Greg Conway, Technical Director  | 
|GML Networking Technologies|
+---+
 Email/MSN:mailto:[EMAIL PROTECTED]
 ICQ#: 100219981
 mobile tel.:   +44 (0) 7974 666 967
 mobile fax:+44 (0) 7970 087 935
 Internet:  http://www.gmlnt.com
 office tel.:   +44 (0) 1255 672 103
 office fax:+44 (0) 1255 679 909
+---+
| GMLNT ** Sensible Smart Solutions |
+---+
***
This is a confidential communication between sender and addressee. If you are not the 
intended recipient of this message, please notify the sender and do not read, copy, 
use or disclose this communication to others. Any opinions or views expressed are 
those of the individual, and unless otherwise stated, are not those of the company. 
All attachments and intellectual rights remain the property of GML (NT) Limited.
***

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP] MySQL-PHP-RAQ4 dilemma!

[Greg Conway]

Hi Steve,

Thanks. I have tried this (the line was not there), but still I have my
original problem. I am now suspecting it is more than a PHP problem, as I
have the same problem with Zope (where I have PHP installed :) but I don't
think the MySQL connector is reliant on it!), namely:

Error
MySQL said:

MySQL Connection Failed: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)

So I think it's something wrong with the MySQL somewhere... despite the fact
that MySQL is running okay! I have Db Tools querying the Db okay from
outside the machine!!

Anyway, thanks for the tip.

Regards,

Greg.

> -Original Message-
> From: Steve Werby [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2002 22:41
> To: Greg Conway; Php-General
> Subject: Re: [PHP] MySQL-PHP-RAQ4 dilemma!
>
>
> "Greg Conway" <[EMAIL PROTECTED]> wrote:
> > I'm trying to add MySQL to my RaQ4. It came
> > by default with PHP4 but no MySQL.
>
> I'd have to check a clean RaQ4 to be sure, but I thought MySQL
> was installed
> by default, but it was setup as a loadable module in PHP and was commented
> out by default.  Please check for the file mysql.so on your
> server.  If it's
> there, you're PHP has MySQL support compiled, it just needs to be
> turned on.
> Try checking for /usr/lib/apache/php/mysql.so or in case it's in
> a different
> location try "locate mysql.so".  If you find it, try this.
>
> 1. Edit /etc/httpd/php.ini and add the following at the bottom:
>
> extension=mysql.so
>
> If it's there, but has a ";" in front, remove the ";" as that's a comment
> character.
>
> 2. Restart Apache.
>
> /etc/rc.d/init.d/httpd restart
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.com/
>

***
This is a confidential communication between sender and addressee. If you are not the 
intended recipient of this message, please notify the sender and do not read, copy, 
use or disclose this communication to others. Any opinions or views expressed are 
those of the individual, and unless otherwise stated, are not those of the company. 
All attachments and intellectual rights remain the property of GML (NT) Limited.
***

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]