[GNC] On a Mac, where are the database configuration details stored?

[John Ralls]

Generally speaking the passwords are stored in Keyring and the user is prompted if the password isn't found. I'm not sure what it does if the connection doesn't have a password. You can examine the keyring with /Applications/Utilities/Keyring Access. If it does have an entry for your database then you can either add the password there or delete the entry and GnuCash will prompt you for the password when you try to connect.

If there's no entry then I think you need to use File>Open to make a fresh connection and provide all of the information in the connection dialog.

On the off chance you want to look at the code start at https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/gnc-file.c#L748.

Regards,
John Ralls

> On Jun 13, 2021, at 5:32 PM, Peter West <pbw at pbw.id.au> wrote:
> 
> Thanks John.
> 
> I was looking for the way the connection is actually set up. At the moment, I have no password requirement for local connections (and no external connections.) If I want to add password validation to postgresql, what happens to my GnuCash connection?
> 
> 
> —
> Peter West
> pbw at ehealth.id.au
> “And if anyone forces you to go one mile, go with him two miles.”
> 
>> On 14 Jun 2021, at 3:11 am, John Ralls <jralls at ceridwen.us> wrote:
>> 
>> 
>> 
>>> On Jun 13, 2021, at 4:09 AM, Peter West <pbw at pbw.id.au> wrote:
>>> 
>>> As it says, where can I find the details of the database connection?
>> 
>> You mean for opening the most recently used book? In ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values with e.g.
>>  defaults read org.gnucash.Gnucash /org/gnucash/history/file0
>> or all of them
>>  defaults read org.gnucash.Gnucash | grep history
>> 
>> Regards,
>> John Ralls
>> 
>