Moving Roundcubes sqlite database breaks it.

English Applications
#1

I am having a problem with moving my sqlite database on my Rouncube server running on a Leap15.2 system (I have a manual install and want to move it to the Offical openSUSE package so it updates properly and automatically). To track down the issue more clearly I have done another fresh install on a Tumbleweed system. Changed the permissions and set up the database which I unimaginativly called ‘database’. I then did the following tests. Either moving or copying the database and then appropriately editing “config.inc.php” to point to reflect the new path.

From a completely working stytem.

ProgressTM:/srv/www/roundcubemail # mv database database2
ProgressTM:/srv/www/roundcubemail # pico config/config.inc.php
ProgressTM:/srv/www/roundcubemail #

It was still working. :good:

ProgressTM:/srv/www/roundcubemail # cp database2 database3
ProgressTM:/srv/www/roundcubemail # pico config/config.inc.php
ProgressTM:/srv/www/roundcubemail #

This broke it. :bad: Returns “Invalid Request. No data was saved” when attempting to logon via a webpage.

ProgressTM:/srv/www/roundcubemail # mkdir db
ProgressTM:/srv/www/roundcubemail # mv database2 db
ProgressTM:/srv/www/roundcubemail # pico config/config.inc.php
ProgressTM:/srv/www/roundcubemail #

This also broke it. :bad: Returns “Invalid Request. No data was saved” when attempting to logon via a webpage.

But moving it back makes it work again.

I can browse all database versions with sqlitebrowser, no problem.

Any explanation, ideas or suggestions would be greatfully recieved.

#2

Although I haven’t actually tried to do what you’re doing,
The following are obvious observations.

Your first operation simply changed the name of the database file. So, same location and the original data file.

Your second operation actually created a new database file. AFAIK SQLite supports only one running database file at a time although you should be able to open multiple files to merge. You can also run multiple databases within a single file. Maybe someone who knows better will enlighten me on this if I’m wrong.

Your third operation changed the location. IIRC the SQLite application is configured for only a single location. IIRC you have to modify the SQLite configuration to access a new location.

SQLite is a very simple database application with limited configuration and functionality.
If you want to do more, you’re expected to use MySQL?MariaDB.

TSU

#3

Thanks …

A full reboot worked.