[GNC] systemd / sqlite 3 file not found error

[Colin Arndt]

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!
Colin