#4008 Unable to log back in after session expired

4.1.6
duplicate
None
1
2014-11-21
2013-07-06
No

After I upgraded to the latest version of phpMyAdmin (4.0.4.1), whenever I try to log back in after my session expired, I end up getting this message:

phpMyAdmin - Error

Incorrect format parameter

If it is helpful, my web server is running nginx 1.3.10, php 5.4.10 and mysql 5.5.29. Any help would be greatly appreciated.

Discussion

  • sfBob

    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
    • Brandon Amaro

      Brandon Amaro - 2013-07-30

      Upgrading to phpmyadmin 4.0.4.2 didn't solve the problem at all... :(

       
  • DisgruntledGoat

    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.

     
  • Marc Delisle

    Marc Delisle - 2013-11-30

    On which page were you when the timeout occurred?

     
  • Marc Delisle

    Marc Delisle - 2013-12-01
    • status: open --> pending
     
  • DisgruntledGoat

    DisgruntledGoat - 2013-12-02

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

    1. Log into phpmyadmin as normal.
    2. Go to a database, then a table.
    3. Go to the Import page and import something (I was importing a CSV file into an empty table, in case that matters).
    4. Leave phpmyadmin for a while until the session expires.
    5. Click any menu item (e.g. Browse) for another page.
    6. A dialog appears saying "Your session has expired. Please log in again." Click "Log in".
    7. 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).
    8. 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)
    9. Click any link again and the session expired dialog appears again.
     
    Last edit: DisgruntledGoat 2013-12-02
  • Brandon Amaro

    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.

     
  • Marc Delisle

    Marc Delisle - 2013-12-10
    • status: pending --> open
     
  • Marc Delisle

    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.

     
    • Brandon Amaro

      Brandon Amaro - 2013-12-10

      I'm using the pop-up SQL window.

       
  • Marc Delisle

    Marc Delisle - 2013-12-10
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-12-10

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

     
    • Brandon Amaro

      Brandon Amaro - 2013-12-10

      I opened it by clicking where it says edit.

       
      • Marc Delisle

        Marc Delisle - 2013-12-10

        Ok, and you can still reproduce this with 4.1.0-rc3 ?

         
  • Marc Delisle

    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.

     
  • Marc Delisle

    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
     
  • Marc Delisle

    Marc Delisle - 2013-12-12
    • Status: resolved --> fixed
     
  • WIZNet

    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

     
  • Marc Delisle

    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
     
  • Leonard Lepadatu

    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
  • Martin Perez

    Martin Perez - 2014-04-11

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

     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    • status: open --> duplicate
    • Priority: 5 --> 1
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks