RE: [PHP] MySQL-PHP-RAQ4 dilemma!
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]
Re: [PHP] MySQL-PHP-RAQ4 dilemma!
Have you ever connected to MySQL from the local machine? Sounds like a permissions problem, because it appears to be successfully creating the socket. Your user may not be set up to access it from localhost, perhaps just the remote machine. Log in to MySQL as admin/root and execute the following query: GRANT ALL PRIVILEGES ON 'database' TO 'username@localhost' IDENTIFIED BY 'password'; Obviously, substitute database, username and password with your specific values. That query will allow the particular user/pass combo to access MySQL from the local machine. Mike Frazer Greg Conway [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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]
RE: [PHP] MySQL-PHP-RAQ4 dilemma!
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... 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. Perhaps your mysql installation uses a socket elsewhere? Have a look at the output of 'mysqladmin variables' which should have an environment variable which shows the socket location. Also have a look in your php.ini, where there are some settings for mysql connections. -- David Robley Temporary Kiwi! -- 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]
[PHP] MySQL-PHP-RAQ4 dilemma!
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]