roundcube can not connect to sqlite database after upgrade from natty to oneiric

[Christian Diefenbach]

Version is:
Package: roundcube
State: installed
Automatically installed: no
Version: 0.5.4+dfsg-1
Priority: extra
Section: universe/web
Maintainer: Ubuntu Developers <email address hidden>
Uncompressed Size: 131 k
Depends: roundcube-core (= 0.5.4+dfsg-1)

 dpkg -l |grep roundcube
ii roundcube 0.5.4+dfsg-1 skinnable AJAX based webmail solution for IMAP servers - metapackage
ii roundcube-core 0.5.4+dfsg-1 skinnable AJAX based webmail solution for IMAP servers
ii roundcube-plugins 0.5.4+dfsg-1 skinnable AJAX based webmail solution for IMAP servers - plugins
ii roundcube-sqlite 0.5.4+dfsg-1 metapackage providing sqlite dependencies for RoundCube

Error Message is:
DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

I believe that roundcube is trying to use sqlite.so which got removed from php5-sqlite.

After the upgrade to oneiric I get repeated mails from cron:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626+lfs/sqlite.so' - /usr/lib/php5/20090626+lfs/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

excerpt from /var/log/roundcube/errors:
[05-Dec-2011 09:36:49 +0100]: DB Error: [Error message: extension sqlite is not compiled into PHP]
 ** sqlite(sqlite)://:xxx@//var/lib/dbconfig-common/sqlite/roundcube/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 101 (GET /roundcube/)
[05-Dec-2011 09:43:06] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[05-Dec-2011 09:43:06] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[05-Dec-2011 09:43:06] MDB2 Error: not found (-4): [Error message: extension sqlite is not compiled into PHP]

[05-Dec-2011 09:43:06 +0100]: DB Error: [Error message: extension sqlite is not compiled into PHP]
 ** sqlite(sqlite)://:xxx@//var/lib/dbconfig-common/sqlite/roundcube/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 101 (GET /roundcube/)
[05-Dec-2011 09:43:06] MDB2 Error: not found (-4): [Error message: extension sqlite is not compiled into PHP]

[05-Dec-2011 09:43:06 +0100]: DB Error: [Error message: extension sqlite is not compiled into PHP]
 ** sqlite(sqlite)://:xxx@//var/lib/dbconfig-common/sqlite/roundcube/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 101 (GET /roundcube/)
[05-Dec-2011 09:43:06] MDB2 Error: not found (-4): [Error message: extension sqlite is not compiled into PHP]

[05-Dec-2011 09:43:06 +0100]: DB Error: [Error message: extension sqlite is not compiled into PHP]
 ** sqlite(sqlite)://:xxx@//var/lib/dbconfig-common/sqlite/roundcube/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 101 (GET /roundcube/)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[fluffy (fluffy)]

Is this problem in roundcube, or actually in mdb2? It looks like mdb2 is what's generating the error, and it may simply not be attempting to load the extension or something.

I do really wish I could get my roundcube back, though. squirrelmail is no substitute!

[Daniel Swarbrick (pressureman)]

It appears that the last few versions of php5-sqlite have not included sqlite.so, which is required by the php-mdb2-driver-sqlite package. There is an unofficial mdb2 driver that uses the PDO sqlite extension, which may work, however roundcube also needs to be patched in order to use that unofficial mdb2 driver.

This bug has just affected me on a Debian Wheezy system. It appears that Debian shipped sqlite.so in php5-sqlite up until 5.3.8, but as my system just pulled a 5.3.9 package of php5-sqlite, roundcube now can't connect to the sqlite DB.

Ubuntu seems to have omitted sqlite.so from their php5-sqlite packages for a while longer than Debian has.

[Daniel Swarbrick (pressureman)]

Debian has also now dropped support for SQLite in Roundcube, largely due to the fact that PHP no longer supports SQLite 2.x. I was forced to migrate my DB to MySQL. Don't expect SQLite support to make a comeback. It's up to Roundcube to step into the 21st century and support SQLite 3.x.

[Sebastien F4GRX (f4grx)]

Hello

I got the same problem by upgrading from squeeze to wheezy.

As I understand from the previous comments, there is no solution.

So are we all left with a DEAD webmail?

[Eric Forgeot (eforgeot)]

hello,

you're not stuck. Roundcube upgraded to sqlite3 at least from version 0.9.

Just download latest roundcube, and migrate your current installation (see http://trac.roundcube.net/wiki/Howto_Upgrade)

Then if you got an error like the one I got when using the migration tool ("file is encrypted or is not a database"), migrate your sqlite2 db to sqlite3 by hand :

mv db.sqlite db.sqlite2-old
sqlite db.sqlite2-old .dump | sqlite3 db.sqlite

It worked for me.