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.

Hi Mohamad,

You cannot use SQLite with App Host because containers are ephemeral and the database will not persist after a container restart.

https://ibmresilient.github.io/resilient-community-apps/fn_scheduler/README.html#migrating-to-v1-0-2

******

# db url if using a postgreSQL DB. Use this with AppHost# db_url=postgresql://username:password***@host:port/database (or) db_url=postgresql+pypostgresql://username:password***@host:port/database

Use this setting rather than the SQLite datastore_dir setting to persist the scheduler DB in PostgreSQL. This is necessary in an App Host environment to retain your schedules outside the app container.

********

In short, stand up Postgres elsewhere and point the scheduler application to it so the data persists regardless of whether the container is restarted. You cannot use Postgres that comes with SOAR.

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.

Hi Ben,

little late to the party, I am trying to achieve the same in my lab without making the app pointing at another server that has the Postgres with no luck sadly.

Any workaround using the dir rather than the url would be much appreciated :)

Hi Mohamad,

You cannot use SQLite with App Host because containers are ephemeral and the database will not persist after a container restart.

https://ibmresilient.github.io/resilient-community-apps/fn_scheduler/README.html#migrating-to-v1-0-2

******

# db url if using a postgreSQL DB. Use this with AppHost# db_url=postgresql://username:password***@host:port/database (or) db_url=postgresql+pypostgresql://username:password***@host:port/database

Use this setting rather than the SQLite datastore_dir setting to persist the scheduler DB in PostgreSQL. This is necessary in an App Host environment to retain your schedules outside the app container.

********

In short, stand up Postgres elsewhere and point the scheduler application to it so the data persists regardless of whether the container is restarted. You cannot use Postgres that comes with SOAR.

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.