Announcement Announcement Module
Collapse
No announcement yet.
SQLite failed to open/create session database in PhpMyAdmin Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite failed to open/create session database in PhpMyAdmin


    You may receive the following error when accessing PhpMyAdmin either from WHM or cPanel, It is a bug in the PhpMyAdmin configuration.

    ----------------------------
    Warning: session_write_close() [function.session-write-close]: open(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/sess_uRSQBGTEZx2uuePd8SpsgTHJ6Z7, O_RDVW) failed: No such file or directory (2) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/navigation.php on line 45
    ----------------------------

    Here is the fix for that;

    1. Login to the server using root login details.
    2. Open the file “/usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini”
    3. Search for the [Session] variable & underneath it, change the following

    Replace:
    ==========
    session.save_handler = sqlite
    session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb
    ==========

    To:
    ==========
    session.save_handler = files
    session.save_path = /tmp
    ==========

    PhpMyAdmin uses sqlite as the file handler, but it needs to be changed to files & the location of the session files to be stored needs to be changed to /tmp or any other path to store temporary files.
    Last edited by afsal; 9th July 2014, 12:26 PM.
Tag Cloud Tag Cloud Module
Collapse
Working...
X