[Pkg-roundcube-maintainers] Bug#887628: Bug#887628: roundcube: Unsupported database driver with sqlite3 after dist-upgrade or install on stretch

[Robert Lister]

Hello Guilhem,

Okay, I've just done this:

root at eeyore:/etc# dpkg-reconfigure roundcube-core
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
dbconfig-common: flushing administrative password
This instance of Roundcube is up-to-date.
Have fun!
apache2_invoke roundcube.conf: already enabled

root at eeyore:/etc# dpkg-reconfigure roundcube-core
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
Replacing config file /etc/dbconfig-common/roundcube.conf with new version
Replacing config file /etc/roundcube/debian-db.php with new version
dbconfig-common: dumping sqlite3 database roundcube to /var/tmp/roundcube.roundcube.2018-01-19-10.53.sqlite3.QwFQjY.
dbconfig-common: dropping old sqlite3 database roundcube.
dropping database roundcube: success.
verifying database roundcube was dropped: success.
creating database roundcube: success.
verifying database roundcube exists: success.
populating database via sql...  done.
This instance of Roundcube is up-to-date.
Have fun!
apache2_invoke roundcube.conf: already enabled

root at eeyore:/etc# apt-get install roundcube-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  roundcube-sqlite3
0 upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 70.9 kB of archives.
After this operation, 100 kB of additional disk space will be used.
Get:1 http://mirror.bytemark.co.uk/debian stretch/main amd64 roundcube-sqlite3 all 1.2.3+dfsg.1-4+deb9u1 [70.9 kB]
Fetched 70.9 kB in 0s (517 kB/s)
Selecting previously unselected package roundcube-sqlite3.
(Reading database ... 70705 files and directories currently installed.)
Preparing to unpack .../roundcube-sqlite3_1.2.3+dfsg.1-4+deb9u1_all.deb ...
Unpacking roundcube-sqlite3 (1.2.3+dfsg.1-4+deb9u1) ...
Setting up roundcube-sqlite3 (1.2.3+dfsg.1-4+deb9u1) ...


root at eeyore:/etc# apt-get install dbconfig-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  dbconfig-sqlite3
0 upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 956 B of archives.
After this operation, 9,216 B of additional disk space will be used.
Get:1 http://mirror.bytemark.co.uk/debian stretch/main amd64 dbconfig-sqlite3 all 2.0.8 [956 B]
Fetched 956 B in 0s (20.5 kB/s)
Selecting previously unselected package dbconfig-sqlite3.
(Reading database ... 70711 files and directories currently installed.)
Preparing to unpack .../dbconfig-sqlite3_2.0.8_all.deb ...
Unpacking dbconfig-sqlite3 (2.0.8) ...
Setting up dbconfig-sqlite3 (2.0.8) ...


Now I am back to the broken sqlite3 setup (Yesterday I installed it with
mysql instead, and this does indeed work.)

[19-Jan-2018 10:54:50 +0000]: <h4nhcfo9> DB Error: could not find driver in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 174 (GET /roundcube/?_page=1)
[19-Jan-2018 10:54:50 +0000]: <h4nhcfo9> DB Error: could not find driver (GET /roundcube/?_page=1)


Now that you mention it - it was definitely installed before the jessie
to stretch dist-upgrade. After upgrade, roundcube broke saying it was
unable to connect to the database, and I attempted to uninstall and
re-install roundcube-sqlite3, but this failed to fix.


I don't really understand why it broke following dist-upgrade, either.
Obviously something had gone wrong with its ability use the sqlite
driver, but no amount of installing on re-installing roundcube-sqlite3
or experimenting with the config could I identify the problem, though
the the roundcube config looks pretty much the same (doing a diff from
the old coonfig to the newly installed one revealed only minor changes
like the site name and mail server.)

After the last re-install attempt, I have to admit that I didn't
explicitly re-install roundcube-sqlite3. The roundcube installation
prompts the user if they want mysql or sqlite3, so I probably assumed
that it would install the right thing, or at least give me a warning
that I needed to install roundcube-sqlite3. :)

During the install (or dpkg-reconfigure) of roundcube-core, this pops up,
which says:

"If other database types are supported by roundcube but not shown here,
the reason for their omission is that the corresponding dbconfig-<database type>
packages are not installed."*

Which led me to believe everything needed was either installed, or would
be installed, but now I read more carefully:
*dbconfig*-<database type> (which I don't think I've ever explicitly had
to install or uninstall.)


 ┌────────────────────────────────┤ Configuring roundcube-core ├─────────────────────────────────┐
 │ The roundcube package can be configured to use one of several database types. Below, you      │
 │ will be presented with the available choices.                                                 │
 │                                                                                               │
 │ If other database types are supported by roundcube but not shown here, the reason for their   │
 │ omission is that the corresponding dbconfig-<database type> packages are not installed. If    │
 │ you know that you want the package to use another supported database type, your best option   │
 │ is to back out of the dbconfig-common questions and opt out of dbconfig-common assistance     │
 │ for this package for now. Install your preferred dbconfig-<database type> option from the     │
 │ list in the package dependencies, and then "dpkg-reconfigure roundcube" to select it.         │
 │                                                                                               │
 │ Database type to be used by roundcube:                                                        │
 │                                                                                               │
 │                                            mysql                                              │
 │                                            sqlite3                                            │
 │                                                                                               │
 │                                                                                               │
 │                          <Ok>                              <Cancel>                           │
 │                                                                                               │
 └───────────────────────────────────────────────────────────────────────────────────────────────┘


 Rob