[GNC] systemd / sqlite 3 file not found error

[will at theprescotts.com]

Usually jobs that work for some types of logins and fail for others are either due to differences in file access permission or differences in environment variables. Maybe when it runs as root, the $PATH variable is different and it is not finding something. Or some other environment variable is different.

On 2020 Dec 13, at 12-13 12:28:36, Colin Arndt <colinfarndt at gmail.com> wrote:

Hi John,

Flatpak access makes sense as the culprit.
The .gnucash file is in my home folder.
The command completes when I run it as my user. Run as root, it fails.
Perhaps I'm trying to do something in a way it's not designed to be used?
Thanks again,
Colin

On Dec 13 2020, at 10:10 am, John Ralls <jralls at ceridwen.us> wrote:
> 
> 
>> 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
> 

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.