GnuCash on Windows with MySQL backend

[Yitzchok Lavi]

Thanks for your reply
I made a mistake - it does remember the server name when prompting for a password on start. I recall now that in my hunt for a "save password" option I tried opening again from a database and it's there that the server name resets to localhost.
I'm on Windows 8.1.

From: geert.gnucash at kobaltwit.be
To: gnucash-user at gnucash.org
CC: yl-gnucash- at outlook.com
Subject: Re: GnuCash on Windows with MySQL backend
Date: Sun, 23 Nov 2014 10:35:25 +0100



On Saturday 22 November 2014 17:43:44 Yitzchok Lavi wrote:
> I am using Gnucash 2.6.3 on both Windows (specifically git rev
> 166cbb7+) and Linux (maybe it's 2.6.4 on Linux) against the same
> MySQL database.On Linux I have never had a problem - once I connected
> to the database I reconnect automatically every time I start the
> program.On Windows I find that every time I connect I am prompted for
> the password and also the server name is incorrect (it defaults to
> localhost). I probably didn't notice this at the beginning because I
> was having so much trouble with another issue which was an actual bug
> in GnuCash.Is there a setting which affects this behaviour? I looked
> on the preferences page and didn't see anything there.ThanksYitzchok
 
Hi,
 
GnuCash relies on the system to provide a safe store for the database password. On linux it uses gnome's keychain on OS X there's the system wide keyring. Windows doesn't provide such a safe store system wide so on Windows the password is never kept. Indeed that means you have to retype it each time.
 
When it prompts for the password it should do so with the correct hostname and database. And it does so correctly on my test system.
 
What is the name of your mysql server ? And the name of the database ? Which version of Windows ?
 
Geert