Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin token mismatch for long time idle

I installed phpMyAdmin 4.0.4.1 on my local develop enviroment, I set auth_type to config. Also I provide authentication requirements by this settings:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['password'] = 'somepassword';

But after a while that it is idle, if I click on any link of it , it shows me an error token mismatch, Is there any way that I increase its TTL? or make it alive permanently?

enter image description here

Above picture shows error.

like image 488
Arash Mousavi Avatar asked Aug 06 '13 09:08

Arash Mousavi


4 Answers

I solve this annoying problem by following instructions below:

  1. open /etc/php5/apache2/php.ini
  2. find ;session.save_path = "/tmp", this line may look also like this ;session.save_path = "/var/lib/php5"
  3. remove first semicolon from this line
  4. restart apache by executing sudo service apache2 restart

FYI: I work under Ubuntu 12.04 with apache2, php5, phpMyAdmin 4.0.5 so for different systems and servers file path may be a little different.

In case of any troubles check if directory from step 2. is writable for server.

Good luck.

like image 185
jmarceli Avatar answered Nov 03 '22 07:11

jmarceli


in file libraries/common.inc.php

line 1076
delete this part

 /*
 * There is no point in even attempting to process
 * an ajax request if there is a token mismatch
 */
 if (isset($response) && $response->isAjax() && $token_mismatch) {
    $response->isSuccess(false);
    $response->addJSON(
        'message',
        PMA_Message::error(__('Error: Token mismatch'))
    );
    exit;
}
like image 40
adolfjap Avatar answered Nov 03 '22 09:11

adolfjap


For me this seemed to be caused by my root partition being full up, and I guess this error was triggered by php being unable to write to the session directory.

like image 3
leeb Avatar answered Nov 03 '22 09:11

leeb


I had to turn my cookies on in my browser and it worked for me. (Using MAMP on OSX)

like image 2
thespacecadette Avatar answered Nov 03 '22 09:11

thespacecadette