[Pkg-roundcube-maintainers] Bug#961765: roundcube-core: package needs work for sqlite

[Russell Coker]

Package: roundcube
Version: 1.3.11+dfsg.1-1~deb10u1
Severity: normal

The package install asks questions about MySQL but there's no option for
specifying sqlite.  As sqlite is simpler it should be able to configure all
sqlite stuff if the user selects sqlite as database type.

For reference something like the following in /etc/roundcube/debian-db.php is
all that's needed for it:
$dbtype='sqlite';
$basepath='/var/cache/apache2/roundcube';

Next when you go to the web page for roundcube when using sqlite you get a
database connection error.  To fix that you need /var/lib/roundcube/SQL to be
a symlink to /usr/share/roundcube/SQL .

-- System Information:
Debian Release: 10.4
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.19.0-8-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8), LANGUAGE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: SELinux: enabled - Mode: Permissive - Policy name: default

Versions of packages roundcube-core depends on:
ii  dbconfig-common                             2.0.11+deb10u1
ii  debconf [debconf-2.0]                       1.5.71
ii  dpkg                                        1.19.7
ii  libapache2-mod-php                          2:7.3+69
ii  libapache2-mod-php7.0 [libapache2-mod-php]  7.0.33-0+deb9u3
ii  libapache2-mod-php7.3 [libapache2-mod-php]  7.3.14-1~deb10u1
ii  libmagic1                                   1:5.35-4+deb10u1
ii  php-auth-sasl                               1.0.6-3
ii  php-common                                  2:69
ii  php-intl                                    2:7.3+69
ii  php-mail-mime                               1.10.2-0.1
ii  php-net-sieve                               1.4.1-1
ii  php-net-smtp                                1.8.0-1
ii  php-net-socket                              1.0.14-2
ii  php-pear                                    1:1.10.6+submodules+notgz-1.1
ii  php7.0-cli [php-cli]                        7.0.33-0+deb9u3
ii  php7.0-json [php-json]                      7.0.33-0+deb9u3
ii  php7.3-cli [php-cli]                        7.3.14-1~deb10u1
ii  php7.3-intl [php-intl]                      7.3.14-1~deb10u1
ii  php7.3-json [php-json]                      7.3.14-1~deb10u1
ii  roundcube-sqlite3                           1.3.11+dfsg.1-1~deb10u1
ii  ucf                                         3.0038+nmu1

Versions of packages roundcube-core recommends:
ii  apache2 [httpd-cgi]  2.4.38-3+deb10u3
ii  php-gd               2:7.3+69
pn  php-pspell           <none>
ii  php7.3-gd [php-gd]   7.3.14-1~deb10u1

Versions of packages roundcube-core suggests:
pn  php-crypt-gpg      <none>
pn  php-net-ldap2      <none>
pn  php-net-ldap3      <none>
pn  roundcube-plugins  <none>

Versions of packages roundcube depends on:
ii  dpkg  1.19.7

-- debconf information excluded