Ubuntu

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

Reported by Christian Diefenbach on 2011-12-05
28
This bug affects 5 people
Affects Status Importance Assigned to Milestone
roundcube (Ubuntu)
Undecided
Unassigned

Bug Description

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) wrote :

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

Changed in roundcube (Ubuntu):
status: New → Confirmed
fluffy (fluffy) wrote :

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) wrote :

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) wrote :

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.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers