Re: [GNC] password when using mysql backend

2021-08-13 Thread Fourhundred Thecat
thank you, but I am not using gnome keyring, or any other key manager. I would like to simply store the password somewhere in a file in my gnucash profile. how can I do this? > On 2021-08-13 17:59, John Ralls wrote: On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch>

[GNC] password when using mysql backend

2021-08-13 Thread Fourhundred Thecat
Hello, I am using gnucash 3.4-1 on Debian 10. And I am using mysql backend. Every time I start gnucash, I have to type my password manually. This is very annoying, and as far as I can tell adds no real security. Is it possible to store the mysql password somewhere locally? If this is not possi

[GNC] sql query to show all changed transactions during given time interval

2021-06-16 Thread Fourhundred Thecat
Hello, I am using gnucash with mysql backend. I know how to query mysql database, to list for example all transactions for the last week: SELECT t.post_date,a.name,t.description,s.value_num FROM splits as s,transactions as t,accounts as a WHERE s.account_guid = a.guid AND s.tx_guid = t.guid AND

[GNC] storing password when using mysql backend

2020-01-14 Thread Fourhundred Thecat
Hello, I am using Gnucash 3.4 with Mysql (MariaDB) backend. Every time I start Gnucash, I have to type in the mysql password. The way I see it, this seems more like a security theater than a real security. Normally when Gnucash is using xml backend, files are stored locally unencrypted. I see no