Out of curiosity (and something common), have you verified that your settings.php file is correct? Best thing to do is to verify the settings in $databases by going into a shell and entering:
mysql -u {username from settings.php} -p{password from settings.php} -h {host from settings.php}
(note - there is no space between -p and the actual password, unlike all other attributes)
If that opens up then type in:
use {database name from settings.php};
(don't forget the ; at the end. If you do then just enter \g)
Another quick and easy check. Go to your webroot and enter:
php index.php
That will show the errors, along with the HTML. See if you get the same error. PHP uses different configurations for the command line and everything else, so if you don't get the error then the problem is in your php.ini file.
You can also try looking in your MySQL error logs for more information. On RedHat/CentOS they should be in /var/log/mysqld.log.
Jamie Holly http://hollyit.net
On 10/13/2013 4:06 AM, Alison wrote:
I am currently running PHP 5.3.3 with the MySQL Client API 5.1.69. The Client details are displayed in phpinfo(). MySQL is ver 14.14 Distribution 5.1.69 for Redfhat X86_64
Alison
At 05:15 PM 13-10-13, you wrote:
Thanks for all this help. Is there a best version of PHP and MySQL for Drupal 7? On Oct 12, 2013 11:04 PM, "Alison" <penguin@alisoncc.com mailto:penguin@alisoncc.com> wrote:
Hi Steve, I had something similar a year or so back. IIRC the PDOException message related to a PHP module not being loaded or an incorrect version of PHP. Alison At 02:59 PM 13-10-13, you wrote:Steve, You should try restarting the Mysql service. if that does not help, check on the host you are trying to connect, it shows localhost on the error, so is IP 127.0.0.1 bind to localhost ? On Sun, Oct 13, 2013 at 5:06 AM, Steve Kessler <skessler@denverdataman.com <mailto:skessler@denverdataman.com>> wrote: I hope someone can help me with this problem because I am not sure where to look and if its a server things or a Drupal thing. I cannot login into Drupal with any user. If I try and login the site does nothing but reload. It does not even give an error message. I got this error message once " "PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in lock_may_be_available() (line 167 of/opt/ee/hub.ee.com/includes/lock.inc <http://hub.ellerslie.com/includes/lock.inc>)." I have emptied the sessions table and everything looks good. Any help is appreciated. Thanks, Steve -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428 <tel:303-587-4428> -- [ Drupal support list | http://lists.drupal.org/ ] -- Regards, Vaibhav Jain -- [ Drupal support list | http://lists.drupal.org/ ]-- [ Drupal support list | http://lists.drupal.org/ ]-- [ Drupal support list | http://lists.drupal.org/ http://lists.drupal.org/ ]
This is a good troubleshooting technique, but it begs the questions of whether you have ever been able to log into the site.
Cary
On Oct 13, 2013, at 7:47 AM, Jamie Holly hovercrafter@earthlink.net wrote:
Out of curiosity (and something common), have you verified that your settings.php file is correct? Best thing to do is to verify the settings in $databases by going into a shell and entering:
mysql -u {username from settings.php} -p{password from settings.php} -h {host from settings.php}
(note - there is no space between -p and the actual password, unlike all other attributes)
If that opens up then type in:
use {database name from settings.php};
(don't forget the ; at the end. If you do then just enter \g)
Another quick and easy check. Go to your webroot and enter:
php index.php
That will show the errors, along with the HTML. See if you get the same error. PHP uses different configurations for the command line and everything else, so if you don't get the error then the problem is in your php.ini file.
You can also try looking in your MySQL error logs for more information. On RedHat/CentOS they should be in /var/log/mysqld.log.
Jamie Holly http://hollyit.net On 10/13/2013 4:06 AM, Alison wrote:
I am currently running PHP 5.3.3 with the MySQL Client API 5.1.69. The Client details are displayed in phpinfo(). MySQL is ver 14.14 Distribution 5.1.69 for Redfhat X86_64
Alison
At 05:15 PM 13-10-13, you wrote:
Thanks for all this help. Is there a best version of PHP and MySQL for Drupal 7? On Oct 12, 2013 11:04 PM, "Alison" penguin@alisoncc.com wrote: Hi Steve, I had something similar a year or so back. IIRC the PDOException message related to a PHP module not being loaded or an incorrect version of PHP. Alison
At 02:59 PM 13-10-13, you wrote:
Steve, You should try restarting the Mysql service. if that does not help, check on the host you are trying to connect, it shows localhost on the error, so is IP 127.0.0.1 bind to localhost ? On Sun, Oct 13, 2013 at 5:06 AM, Steve Kessler < skessler@denverdataman.com> wrote: I hope someone can help me with this problem because I am not sure where to look and if its a server things or a Drupal thing. I cannot login into Drupal with any user. If I try and login the site does nothing but reload. It does not even give an error message. I got this error message once " "PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in lock_may_be_available() (line 167 of/opt/ee/ hub.ee.com/includes/lock.inc)." I have emptied the sessions table and everything looks good. Any help is appreciated. Thanks, Steve -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428 -- [ Drupal support list | http://lists.drupal.org/ ]
-- Regards, Vaibhav Jain -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
We got it fixed. Our server admin forgot to turn on mod_rewrite.
Thanks for all the help! On Oct 15, 2013 7:13 PM, "Cary Gordon" listuser@chillco.com wrote:
This is a good troubleshooting technique, but it begs the questions of whether you have ever been able to log into the site.
Cary
On Oct 13, 2013, at 7:47 AM, Jamie Holly hovercrafter@earthlink.net wrote:
Out of curiosity (and something common), have you verified that your settings.php file is correct? Best thing to do is to verify the settings in $databases by going into a shell and entering:
mysql -u {username from settings.php} -p{password from settings.php} -h {host from settings.php}
(note - there is no space between -p and the actual password, unlike all other attributes)
If that opens up then type in:
use {database name from settings.php};
(don't forget the ; at the end. If you do then just enter \g)
Another quick and easy check. Go to your webroot and enter:
php index.php
That will show the errors, along with the HTML. See if you get the same error. PHP uses different configurations for the command line and everything else, so if you don't get the error then the problem is in your php.ini file.
You can also try looking in your MySQL error logs for more information. On RedHat/CentOS they should be in /var/log/mysqld.log.
Jamie Hollyhttp://hollyit.net
On 10/13/2013 4:06 AM, Alison wrote:
I am currently running PHP 5.3.3 with the MySQL Client API 5.1.69. The Client details are displayed in phpinfo(). MySQL is ver 14.14 Distribution 5.1.69 for Redfhat X86_64
Alison
At 05:15 PM 13-10-13, you wrote:
Thanks for all this help. Is there a best version of PHP and MySQL for Drupal 7? On Oct 12, 2013 11:04 PM, "Alison" penguin@alisoncc.com wrote: Hi Steve, I had something similar a year or so back. IIRC the PDOException message related to a PHP module not being loaded or an incorrect version of PHP. Alison
At 02:59 PM 13-10-13, you wrote:
Steve, You should try restarting the Mysql service. if that does not help, check on the host you are trying to connect, it shows localhost on the error, so is IP 127.0.0.1 bind to localhost ? On Sun, Oct 13, 2013 at 5:06 AM, Steve Kessler skessler@denverdataman.com wrote: I hope someone can help me with this problem because I am not sure where to look and if its a server things or a Drupal thing. I cannot login into Drupal with any user. If I try and login the site does nothing but reload. It does not even give an error message. I got this error message once " "PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in lock_may_be_available() (line 167 of/opt/ee/ hub.ee.com/includes/lock.inchttp://hub.ellerslie.com/includes/lock.inc)." I have emptied the sessions table and everything looks good. Any help is appreciated. Thanks, Steve -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428 -- [ Drupal support list | http://lists.drupal.org/ ]
-- Regards, Vaibhav Jain -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Alison -
Cary Gordon -
Jamie Holly -
Steve Kessler