Re: [GNC] storing password when using mysql backend

2020-01-15 Thread Geert Janssens
Op woensdag 15 januari 2020 05:15:07 CET schreef 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 reason why mysql backend should be any
> different. Besides, security (encryption) should not be handles on
> application level, but rather on System level (I have LUKS encrypted HDD)
> 
> Can I store the password locally? (in a config file, plaitext is fine).
> 
> Or, if this is not possible, where can I hard code it in the gnucash
> sourcecode ?
> 
> I already had to compile Gnucash from source (even though there exists a
> Debian package for my distribution), so recompiling again would not be
> difficult.
> 
> I think I read somewhere that password can be stored in Gnome Keyring,
> but I am not using Gnome Keyring.

If you don't want to type the password every time, using Gnome Keyring is the 
only option provided on linux to store the password. It shouldn't hurt 
installing gnome keyring even if you only use it for gnucash.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] storing password when using mysql backend

2020-01-15 Thread Colin Law
If you don't want password protection on the db then you can set it to empty.

Colin

On Wed, 15 Jan 2020 at 04:18, Fourhundred Thecat <400the...@gmx.ch> wrote:
>
> 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 reason why mysql backend should be any
> different. Besides, security (encryption) should not be handles on
> application level, but rather on System level (I have LUKS encrypted HDD)
>
> Can I store the password locally? (in a config file, plaitext is fine).
>
> Or, if this is not possible, where can I hard code it in the gnucash
> sourcecode ?
>
> I already had to compile Gnucash from source (even though there exists a
> Debian package for my distribution), so recompiling again would not be
> difficult.
>
> I think I read somewhere that password can be stored in Gnome Keyring,
> but I am not using Gnome Keyring.
>
> thank you,
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.