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.

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,

Do you have solution for problem with create:

 datastore_dir

I have tried some solution but I have still problem:

The last test failed

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 Radomír,

Are you using a SOAR App Host? If you are, then the message is still the same, you must use db_url.

Remember that containers are ephemeral meaning that if the container or in this case the pods is restarted the SQLite database will be removed losing the data. Using db_url is the only solution for an App Host. If the pod is restarted it will simply reconnect to the remote Postgres server on startup with no data loss.

Hi,

Do you have solution for problem with create:

 datastore_dir

I have tried some solution but I have still problem:

The last test failed

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.

H Ben,

thanks for your answer.

Is  diferrent solution for call from my playbook to other system (Call REST API)? I cant use db, now

Hi Radomír,

Are you using a SOAR App Host? If you are, then the message is still the same, you must use db_url.

Remember that containers are ephemeral meaning that if the container or in this case the pods is restarted the SQLite database will be removed losing the data. Using db_url is the only solution for an App Host. If the pod is restarted it will simply reconnect to the remote Postgres server on startup with no data loss.

Hi,

Do you have solution for problem with create:

 datastore_dir

I have tried some solution but I have still problem:

The last test failed

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 Radomír,

I don't understand. The REST API application doesn't use a database. Can you explain the problem?

H Ben,

thanks for your answer.

Is  diferrent solution for call from my playbook to other system (Call REST API)? I cant use db, now

Hi Radomír,

Are you using a SOAR App Host? If you are, then the message is still the same, you must use db_url.

Remember that containers are ephemeral meaning that if the container or in this case the pods is restarted the SQLite database will be removed losing the data. Using db_url is the only solution for an App Host. If the pod is restarted it will simply reconnect to the remote Postgres server on startup with no data loss.

Hi,

Do you have solution for problem with create:

 datastore_dir

I have tried some solution but I have still problem:

The last test failed

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.

Srry my usecase

Playbook:

function REST API Call create Incident (SOAR) in HelpDesk system  -> Script postprocess write to Notes (SOAR) detail about created INC in Helpdesk.

My idea was Scheduler call run to playbook for get information from  Helpdesk and write to Notes (SOAR)

I need call to every hour: when changed detail (priority,desc and status)  in Inc (Helpdesk) then write information to Notes (SOAR)

Hi Radomír,

I don't understand. The REST API application doesn't use a database. Can you explain the problem?

H Ben,

thanks for your answer.

Is  diferrent solution for call from my playbook to other system (Call REST API)? I cant use db, now

Hi Radomír,

Are you using a SOAR App Host? If you are, then the message is still the same, you must use db_url.

Remember that containers are ephemeral meaning that if the container or in this case the pods is restarted the SQLite database will be removed losing the data. Using db_url is the only solution for an App Host. If the pod is restarted it will simply reconnect to the remote Postgres server on startup with no data loss.

Hi,

Do you have solution for problem with create:

 datastore_dir

I have tried some solution but I have still problem:

The last test failed

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.