Backup User Sessions from a containerized Kolibri server v0.16.0

Hi there,
I am trying to backup user sessions from a containerized Kolibri Server v0.16.0 installed on a linux server. I was informed that the user data is stored in the db.sqlite3 and db.sqlite3.wal and db.sqlite3.shm files, but I cannot locate these files. The only database files are in the content folder
/kolibri/.kolibri/content/databases.
Where are the user session files located? Please assist urgently

Hi @Doris_Ratego,

To clarify, are you simply referring to your Kolibri instance as a “server”, or are you specifically using the kolibri-server package?

For background, Learning Equality provides a number of different installation methods for Kolibri, one of which is the high-performance kolibri-server package which customizes the installation to use PostgreSQL (docs). If that is indeed the case, you wouldn’t find any SQLite files besides those that you found, because it is using PostgreSQL instead to store data.

Regards,
Blaine

Hi Blain,

Thank you for your response. I am referring to kolibri-server package.

Where do I find the user sessions database? Does it exist in the kolibri-server package? I would like to backup the data.

Best regards,

Doris Ratego

Hi @Doris_Ratego,

My apologies, I was mistaken: kolibri-server does NOT configure PostgreSQL.

Could you please check the following path for the database files? /var/kolibri/.kolibri/

You can also find the Kolibri database location by navigating to Device > Info > Advanced > Database in the browser.

Again, my apologies for the confusion.

Regards,
Blaine