phpmyadmin error

Portal Home > Knowledgebase > Articles Database > phpmyadmin error

Posted by DediPath, 05-12-2008, 08:44 PM
Warning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb' - malformed database schema - unable to open a temporary database file for storing temporary tables 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 I get that error in cPanel when I click to go to phpmyadmin.
Posted by cloud911, 05-13-2008, 02:35 AM
WHM -> PHP Configuration Editor -> Switch to Advanced Change 'session.save_handler' value to 'files' (without quotes) Restart apache
Posted by DediPath, 05-13-2008, 07:25 AM
Already set to that.
Posted by zacharooni, 05-14-2008, 01:51 AM
Do that and paste output here.
Posted by pixeldawn, 05-14-2008, 01:52 AM
I'm getting the same error as well, anyone know a fix ?
Posted by zacharooni, 05-14-2008, 09:26 PM
I instructed him to change CPANEL=stable in /etc/cpupdate.conf and run this: /scripts/upcp --force cd /var/lib/mysql service mysql stop find -type f -name "*.MYI" | xargs myisamchk -r service mysql start Seems to have fixed the issue, would be good if someone can replicate that fix.
Posted by NelsonT, 05-14-2008, 11:11 PM
I did force/downgrade cpanel from auto-curr to auto-stable and yes fix the problem. I tried this on one of my toy vps not for production environment.
Posted by NelsonT, 05-14-2008, 11:37 PM
Release also works flawless.
Posted by GLucas, 05-15-2008, 04:53 PM
Had to change to Release from Current and all is fine now.
Posted by lowbwtom, 07-07-2008, 06:19 PM
fix worked great, until reboot. cpanel says license key does not match. had to reset to release version. back to same original problem now.
Posted by zacharooni, 07-09-2008, 08:38 PM
hostname your.servers.host.name /usr/local/cpanel/cpkeyclt /scripts/upcp -f