[support] Can't login into site

[Jamie Holly]

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 at alisoncc.com 
>> <mailto:penguin at 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 at denverdataman.com
>>>         <mailto:skessler at 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/> ]
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20131013/de767ded/attachment.html