Phpmyadmin fails to load and gives the below error.
====
Error
====
Warning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb’ - unable to open database: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
Fatal error: session_start() [function.session-start]: Failed to initialize storage module: sqlite (path: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
====
Fix
====
1)Login to shell of the server using root login
nano -w /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini
2) Search for [Session] and change the following
FROM:
—–
session.save_handler = sqlite
session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb
—–
TO
—–
session.save_handler = files
session.save_path = /tmp
—–
3) Save and exit
4) Restart Apache server using command
/etc/init.d/httpd restart
