[support] Can't login into site

[Cary Gordon]

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 at 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 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> 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/ ]

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