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 <p...@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 > p...@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 <jra...@ceridwen.us> wrote: >> >> >> >>> On Jun 13, 2021, at 4:09 AM, Peter West <p...@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 >> > _______________________________________________ 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.