[GNC] systemd / sqlite 3 file not found error

[John Ralls]

> On Dec 13, 2020, at 9:57 AM, Colin Arndt <colinfarndt at gmail.com> wrote:
> 
> Hi all,
> 
> On Fedora Linux here, and I am trying to set up a systemd timer to pull price quotes once a week using gnucash-cli. Previously I was using cron to accomplish this, but would like to migrate to a systemd timer because this is on a laptop and I never know when it will be on or off. Systemd timers can handle missed execution times gracefully by simply running the command the next time the system is up.
> I've set it up to execute this command:
> /usr/bin/flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get /path/to/Books-sql.gnucash
> 
> Strangely, this produces a file not found error even though I've verified the path is correct.
> * 09:50:20 WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()] Sqlite3 file Books-sql.gnucash not found
> * 09:50:20 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()] Session Error: Sqlite3 file Books-sql.gnucash not found
> This isn't an issue with how I've set up the systemd timer or service, because when I run it as root from the command line, I get the same result.
> Thanks for any insight!

Is /path/to somewhere accessible by the flatpak's sandbox?

Regards,
John Ralls