Page 1 of 2

I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 4:34 pm
by Tim Rowley
This is a new install. Yesterday I got past a login problem by changing permissions and had entered phpMyAdmin last night and had tried to upload a database that was too big. I had already rewritten limits in php.ini but this morning remembered that I probably had to restart httpd and I also restarted mysqld. Now I can't get back in with my username and password. Do you have any ideas please.

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 5:50 pm
by skurudo
Try

Code: Select all

chmod 777 /var/lib/php/session

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 6:26 pm
by Tim Rowley
I did that yesterday and was into phpMyAdmin after that, but today I can't get in.
The login form page opens with a pink message box at the top saying "No activity within 1440 seconds; please log in again" which remains there after completing Username and Passwords and pressing Go. There is no error message.
I've just checked that these permissions were still there and they are.

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 6:29 pm
by skurudo
Clear cache and try again, and check error log.

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 7:43 pm
by Tim Rowley
I have cleared the cache and tried again. Nothing happened again, but this time there was no pink message box saying "inactive for more than 1440 seconds, sign in again". Nothing at all happened and no error message on screen.

I downloaded var/log/ mysqld.log but I don't know what I'm looking at.

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 7:54 pm
by skurudo
open up config.inc.php in the root phpMyAdmin directory and add this setting (anywhere):

Code: Select all

$cfg['LoginCookieValidity'] = <your_new_timeout>;
28800 for example
and restart apache

Re: I can't login to phpMyAdmin

Posted: Tue Apr 14, 2015 9:28 pm
by Tim Rowley
Thanks Skurudo
I've done that : I restarted httpd assuming that's what you meant by restart Apache, and then I cleared browser cookies, and still nothing happens.

Re: I can't login to phpMyAdmin

Posted: Wed Apr 15, 2015 8:08 am
by skurudo
Tim Rowley wrote:Thanks Skurudo
I've done that : I restarted httpd assuming that's what you meant by restart Apache, and then I cleared browser cookies, and still nothing happens.
Nothing - it's the same error "inactive for more than 1440 seconds" or...?
Try to clear sessions from /var/lib/php/session and log in.

Re: I can't login to phpMyAdmin

Posted: Wed Apr 15, 2015 2:46 pm
by Tim Rowley
There is no error message.
I'm wondering if I should reinstall everything adn perhaps choose Centos 7

Re: I can't login to phpMyAdmin

Posted: Wed Apr 15, 2015 2:48 pm
by skurudo
Tim Rowley wrote:There is no error message.
I'm wondering if I should reinstall everything adn perhaps choose Centos 7
Where do you look error messages? ;-)