mkdir /tmp/app-fn_scheduler​

mkdir /tmp/app-fn_scheduler​

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

$ mkdir /tmp/scheduler.sqlite

I guess I raise a ticket with IBM then?

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

$ mkdir /tmp/scheduler.sqlite

I guess I raise a ticket with IBM then?

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

$ mkdir /tmp/scheduler.sqlite

I guess I raise a ticket with IBM then?

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

$ mkdir /tmp/scheduler.sqlite

I guess I raise a ticket with IBM then?

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

would you mind sharing with me the docker environment setup commands for postgres?

$ mkdir /tmp/scheduler.sqlite

I guess I raise a ticket with IBM then?

I followed similar steps:

$ mkdir /tmp/scheduler.sqlite

My app.config file:

[fn_scheduler]
timezone=America/New_York
thread_max=20
datastore_dir=/tmp/scheduler.sqlite

ls /tmp/scheduler.sqlite/scheduler.sqlite

mkdir /tmp/app-fn_scheduler​

Hi all ,

In my scenario , I don't care if the schedules got deleted once a restart is performed.

Still Im not able to get an app host version to work with sqlite , I have tried creating the file from the GUI and referencing it in the app with no luck.

If anyone have that working, I would appreciate the help, thanks.

Hi Mohamad,

Can yo share what your app.config file looks like? It should contain the setting `datastore_dir` to reference the directory which the sqlite file will reside, such as /tmp.

Hi all ,

In my scenario , I don't care if the schedules got deleted once a restart is performed.

Still Im not able to get an app host version to work with sqlite , I have tried creating the file from the GUI and referencing it in the app with no luck.

If anyone have that working, I would appreciate the help, thanks.

Hi Mark , 

I have tried both creating in /tmp (from apphost ssh) and /etc/rescircuits/ (from app config GUI)

I tried inputting both directories and files in  datastore_dir =   with no luck.

also I have done chmod 777 on both the files and directories

some examples I used : 

datastore_dir =/tmp/test.sqlite(where test.sqlite is a directory)

datastore_dir =/tmp/file.sqlite(where file.sqlite is a file)

datastore_dir = /etc/rescircuits/test.sqlite

datastore_dir = /etc/rescircuits/test

datastore_dir = /etc/rescircuits/test/test.sqlite

it always returns the same error : 

return self.loaded_dbapi.connect(*cargs, **cparams) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8)

also tried DEBUG log level its returning the same error

Hi Mohamad,

Can yo share what your app.config file looks like? It should contain the setting `datastore_dir` to reference the directory which the sqlite file will reside, such as /tmp.

Hi all ,

In my scenario , I don't care if the schedules got deleted once a restart is performed.

Still Im not able to get an app host version to work with sqlite , I have tried creating the file from the GUI and referencing it in the app with no luck.

If anyone have that working, I would appreciate the help, thanks.

hi @Mark Scherfling , please let me know  if you know of a fix for this issue , thanks.

Hi Mark , 

I have tried both creating in /tmp (from apphost ssh) and /etc/rescircuits/ (from app config GUI)

I tried inputting both directories and files in  datastore_dir =   with no luck.

also I have done chmod 777 on both the files and directories

some examples I used : 

datastore_dir =/tmp/test.sqlite(where test.sqlite is a directory)

datastore_dir =/tmp/file.sqlite(where file.sqlite is a file)

datastore_dir = /etc/rescircuits/test.sqlite

datastore_dir = /etc/rescircuits/test

datastore_dir = /etc/rescircuits/test/test.sqlite

it always returns the same error : 

return self.loaded_dbapi.connect(*cargs, **cparams) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8)

also tried DEBUG log level its returning the same error

Hi Mohamad,

Can yo share what your app.config file looks like? It should contain the setting `datastore_dir` to reference the directory which the sqlite file will reside, such as /tmp.

Hi all ,

In my scenario , I don't care if the schedules got deleted once a restart is performed.

Still Im not able to get an app host version to work with sqlite , I have tried creating the file from the GUI and referencing it in the app with no luck.

If anyone have that working, I would appreciate the help, thanks.