How to fix Session Expired, please login again on adminer.php?
Sometimes when you work with adminer to manage your databases, especially on a freshly installed server you may encounter this problem.
Session expired, please login again.
What does the error indicate?
Typically this error means that the webserver you are using has no write permissions on the php sessions folder. Now the location of this folder varies from system to system and to determine where this folder is on your system please create a php file, lets call it info.php
<?php
phpinfo();
Now open this file on your web browser and look for session.save_path under Session menu.
In our case this value is: /var/lib/php/sesssion
When we check the owner and permissions of this folder we get
ls -ldh /var/lib/php/session/
As you can see this shows that the owner of the folder is root and apache. We must change it to group nginx group nginx by entering this command
sudo chown nginx:nginx /var/lib/php/session/
sudo chmod 700 /var/lib/php/session/
This should fix the error you are getting. Now if we refresh the page and try to log in adminer we should no longer see the error notice.
What’s adminer?
Adminer is a lightweight database management system which you can get from adminer.org in several flavours.
The full version which can manage MariaDB, MySQL,PostgreSQL, MongoDB, SQLite, MS SQL, Oracle
The Mysql Mariadb Only version
These two versions also have an english only version to make it more lightweight.
Unlike PhpMyAdmin, Adminer does not require any installation, it is a single page application you simply insert into the root of your domain and that’s it. It offers a basic interface but it does not lack any needed functionality. You can create databases, drop databases, run complex queries, examine table structures, export databases, tables to several formats and more.