RStudio-Server-1.4.1717-foss-2021a-Java-11-R-4.1.0.eb

[JJImenezna]

Hello

Launching rerver I receive this error

ERROR database error 7 (Cannot establish connection to the database. unable to open database file); OCCURRED AT rstudio::core::Error rstudio::core::database::ConnectVisitor::operator()(const rstudio::core::database::SqliteConnectionOptions&) const src/cpp/core/Database.cpp:176; LOGGED FROM: int main(int, char* const*) src/cpp/server/ServerMain.cpp:694

All the installation and sanity chekcs have been performed witout issues. Any additional database must be created? Any help will be really apreciated Many thanks in advance Best Regards Jorge

[branfosj]

The sanity check command is:

    # This command requires a db conf (this may also be needed for live use)
    """MYTMP=`mktemp -d` && echo -e "provider=sqlite\ndirectory=$MYTMP/db" >> $MYTMP/db.conf && """
    "rserver --verify-installation=1 --database-config-file=$MYTMP/db.conf --server-data-dir=$MYTMP/sdd ",

You'll need something similar to create a per-use db. Obviously this means that the information that RStudio saves to this db will not be available between uses.

[JJImenezna]

Hello Update

Sanity cheack wass supossed to be fine however tha app was not being launched. I uncommented the lines for sqllite in .../../RStudio-Server/1.4.1717-foss-2021a-Java-11-R-4.1.0/extras/conf/database.conf and after changing permissions the database is created automaticallly ( at least for sqlite)

The issue I found is when two users are using the app at the same time

• Two users can not be sharing teh same port at the same time so they must launch the app with different port just in case

-Once the database is created another user can not launch the aplication due to write permissions in the db

sqlite3_statement_backend::loadOne: attempt to write a readonly database

I fixed this doing

rm /var/lib/rstudio-server/rstudio.sqlite chmod -R g=u /var/lib/rstudio-server

and finally chmod + r /../...RStudio-Server/1.4.1717-foss-2021a-Java-11-R-4.1.0/db/

I hope it helps Regards