phpMyAdmin / Bugs / #4008 Unable to log back in after session expired

sfBob - 2013-07-30

Different config, same problem
phpmyadmin 4.0.4.1
Apache 2.2.3, PHP 5.2.17, MySQL 5.0.95

Last edit: sfBob 2013-07-30

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Brandon Amaro - 2013-07-30
  
  Upgrading to phpmyadmin 4.0.4.2 didn't solve the problem at all... :(
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DisgruntledGoat - 2013-09-13

I'm getting this as well in 4.0.6.

You can work around it for now by deleting all the crap out of the URL and logging in there. For example if your PMA installation is at example.com/phpmyadmin/, when you get the session expired message just go back to example.com/phpmyadmin/ and log in.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-11-30

On which page were you when the timeout occurred?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-01

status: open --> pending
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DisgruntledGoat - 2013-12-02

This just happened for me after importing a file. (Currently using 4.0.9.) So in other words:

Log into phpmyadmin as normal.

Go to a database, then a table.

Go to the Import page and import something (I was importing a CSV file into an empty table, in case that matters).

Leave phpmyadmin for a while until the session expires.

Click any menu item (e.g. Browse) for another page.

A dialog appears saying "Your session has expired. Please log in again." Click "Log in".

That takes you to the login page, so log in here. (If it helps, my URL here is http://localhost/phpmyadmin/index.php?db=&table=&server=1&target=import.php&token=5e5fefafae78856abf2eb78241fd1734).

This takes you to a page with a large red error box, saying "Incorrect format parameter". Actually, the page also lists all your databases down the side, which seems like a security flaw! The session is invalid (even if the password happens to be correct) so it shouldn't "leak" any information. (My URL here is now http://localhost/phpmyadmin/index.php?target=import.php&token=91baa23ff058e164ee10bd6e74d168ad#PMAURL-0:index.php?db=&table=&server=1&target=import.php&token=91baa23ff058e164ee10bd6e74d168ad)

Click any link again and the session expired dialog appears again.

Last edit: DisgruntledGoat 2013-12-02
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Brandon Amaro - 2013-12-09

This problem is in 4.1.0 as well. I'm getting this error on the SQL page when I run a query after my session expired. I did a little looking in the source code and it appears there's no form field named format in the pop-up edit query window... I think that is what is causing the problem in my case.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

status: pending --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

Brandon,
even if there is no "format" form field, import.php should be setting $format to something; however it does not and I think I know why. I just need more details to be able to reproduce the problem, to ensure my fix is correct. Are you opening a pop-up SQL window from the navigation panel? If not, please describe your scenario.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Brandon Amaro - 2013-12-10
  
  I'm using the pop-up SQL window.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

assigned_to: Marc Delisle
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

Yes, but there are two ways to open it. From where do you open it?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Brandon Amaro - 2013-12-10
  
  I opened it by clicking where it says edit.
  
  phpmyadmin.jpg
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Marc Delisle - 2013-12-10
    
    Ok, and you can still reproduce this with 4.1.0-rc3 ?
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

I can reproduce this problem in 4.0.10, but not in 4.1.0-rc3. Marking as resolved until further news.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-10

summary: Unable to log back in after session expired --> (ok 4.1.0-rc3) Unable to log back in after session expired

status: open --> resolved
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-12-12

Status: resolved --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

WIZNet - 2014-02-03

I'm still having this issue to PMA v4.1.6.

After leaving pma for a while and returning back with the session expired, I get a message
"No activity within 3600 seconds; please log in again."

Hiting log in, inserting username and correct password redirects inside pma but with message "Incorrect format parameter".

This is not the case for all login attempts, and there are times that after login it redirects to pma database view with no errors.

PHP Version: 5.4.24
phpMyAdmin Version information: 4.1.6
Web Server: nginx/1.4.4
MySQL Server version: 5.5.36
Database client version: libmysql - mysqlnd 5.0.10 - 20111026

PMA url when that happened:
/phpmyadmin/index.php?target=import.php&token=10c6cea8c0d8332c718df6f13b0fe1a7#PMAURL-0:index.php?db=&table=&server=1&target=import.php&token=10c6cea8c0d8332c718df6f13b0fe1a7

pma_4.1.6_IncorrectFormatParameter_error.jpg

pma_4.1.6_endSession_login.jpg

pma_4.1.6_versions.jpg

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2014-02-05

summary: (ok 4.1.0-rc3) Unable to log back in after session expired --> Unable to log back in after session expired

status: fixed --> open

assigned_to: Marc Delisle --> nobody

Group: 4.0.4 --> 4.1.6

Priority: 1 --> 5
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Leonard Lepadatu - 2014-03-10

I have same problem.
Quick Resolving: After logout click on phpMyAdmin sailing boat logo and it will open a new tab and a new session. Login with your credentials and will work.

Info:
Database server version: 5.5.35-0ubuntu0.13.10.2 - (Ubuntu)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
Apache/2.4.6 (Ubuntu)
Database client version: libmysql - 5.5.35
PHP extension: mysqli Documentation

phpMyAdmin: 4.0.6deb1

Last edit: Leonard Lepadatu 2014-03-10

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Martin Perez - 2014-04-11

I have the same problem.
Solution, go to phpmyadmin/index.php page (important clean url) and here login.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2014-11-21

assigned_to: Madhura Jayaratne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2014-11-21

status: open --> duplicate

Priority: 5 --> 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2014-11-21

Duplicate of bug #4276 and fixed in version 4.1.8
See https://sourceforge.net/p/phpmyadmin/bugs/4276/

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Unable to log back in after session expired

A software tool to bring MySQL to the Web

Group

Searches

Help

#4008 Unable to log back in after session expired

Discussion