Okay, that makes sense.
I configured the following folder for testing in dev.
mkdir /tmp/app-fn_scheduler-sqllite
Then tries the following two configurations and received the same error messages.
datastore_dir = /tmp/app-fn_scheduler-sqllite
datastore_dir = /tmp/app-fn_scheduler-sqllite/
Then I made the folder world writeable and get the same error messages.
chmod 777 /tmp/app-fn_scheduler-sqllite
datastore_dir = /tmp/app-fn_scheduler-sqllite
datastore_dir = /tmp/app-fn_scheduler-sqllite/
Error for all four attempts is as follows
fn-scheduler: selftest: failure selftest output: {'state': 'failure', 'reason': '(sqlite3.OperationalError) unable to open database file\n(Background on this error at: http://sqlalche.me/e/14/e3q8)'} Elapsed time: 0.025000 seconds
------------------------------
Tyler Bennett
------------------------------
Original Message:
Sent: Tue August 24, 2021 10:33 AM
From: Mark Scherfling
Subject: app-fn_scheduler database configuration
Hi Tyler,
I do agree that it's a bit of confusing. The app.config setting `datastore_dir` refers to a directory where the app will create the `scheduler.sqlite` file. So, make sure your entry is a `folder`:
mkdir /tmp/app-fn_scheduler
------------------------------
Mark Scherfling
Original Message:
Sent: Mon August 23, 2021 05:54 PM
From: Tyler Bennett
Subject: app-fn_scheduler database configuration
Can I get some guidance on deploying the app-fn_scheduler? I've read the documentation but it's not really straightforward on the setup of the sqllite/psql database connection.
We are using appHosts.
I tried the following option in the configuration and touched the file on disk(on the dev apphost)
datastore_dir = /tmp/app-fn_scheduler.sqllite
fn-scheduler: selftest: failure selftest output: {'state': 'failure', 'reason': '(sqlite3.OperationalError) unable to open database file\n(Background on this error at: http://sqlalche.me/e/14/e3q8)'} Elapsed time: 0.025000 seconds
touch /tmp/app-fn_scheduler.sqllite
chmod 777 /tmp/app-fn_scheduler.sqllite
-----------------------------
Tyler Bennett
------------------------------