Control: tag -1 moreinfo On Fri, 29 May 2020 at 11:38:31 +1000, Russell Coker via Pkg-roundcube-maintainers wrote: > The package install asks questions about MySQL but there's no option for > specifying sqlite.
Making sure Roundcube works out of the box with SQLite3 is part of the manual
tests I do before each upload. The below works for me FWIW (this uses the
default
basepath from dbconfig, namely /var/lib/dbconfig-common/sqlite3/roundcube):
~$ CHROOT="$(schroot -c buster-amd64-sbuild -b)"
~$ sudo schroot -d/ -c "$CHROOT" -r -- apt install -y dialog debconf
~$ sudo schroot -d/ -c "$CHROOT" -r -- apt install -y openssl nginx-light
php-fpm php
~$ PHP_VERSION=7.3
~$ sudo schroot -d/ -c "$CHROOT" -r -- tee /etc/nginx/sites-available/default
<<-EOF
server {
listen 127.0.0.1:8080 default_server;
root /var/lib/roundcube;
server_name _;
client_max_body_size 64m;
location = / { index index.php; }
location = /index.php {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php${PHP_VERSION}-fpm.sock;
}
location /plugins/ {}
location /program/js/ {}
location /program/resources/ {}
location /skins/ {}
location / { internal; }
location ~ /\. { internal; }
}
EOF
~$ sudo schroot -d/ -c "$CHROOT" -r -- apt install -y roundcube roundcube-core
roundcube-plugins roundcube-sqlite3
~$ sudo schroot -d/ -c "$CHROOT" -r -- install -oroot -groot -m0755 -d /run/php
~$ sudo schroot -d/ -c "$CHROOT" -r -- /usr/sbin/"php-fpm$PHP_VERSION"
--fpm-config "/etc/php/$PHP_VERSION/fpm/php-fpm.conf"
~$ sudo schroot -d/ -c "$CHROOT" -r -- nginx
> 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';
We set $config['db_dsnw'] to "sqlite:///$basepath/$dbname?mode=0640" so
I'm surprised this works without $dbname. Do you set $config['db_dsnw']
in /etc/roundcube/config.inc.php?
Anyway the “safe” way to reconfigure the database is to run `dpkg-reconfigure
roundcube-core`
and to answer questions from dbconfig. (It appears to be able to create
and populate SQLite3 databases under different $basepath too.)
Same thing goes for other backends; I didn't try to manually point
Roundcube to an empty database on a MySQL server but I doubt it takes
care of installing/upgrading schemas on its own (it doesn't necessarily
have the permissions for it). We rely on dbconfig for DB creation,
re-configuration, schema upgrades, etc.
--
Guilhem.
signature.asc
Description: PGP signature
