GnuCash, Windows 7 and MySQL

[Geert Janssens]

I just managed to resolve the issue of using GnuCash with MySQL on Windows 7 
(both 32bit and 64bit). There were two bugs reported for this:
https://bugzilla.gnome.org/show_bug.cgi?id=624465
https://bugzilla.gnome.org/show_bug.cgi?id=635911

Apart from an unitialized pointer bug, the main reason the users weren't able 
to connect is because they got firewalled when using localhost as the 
hostname. Replacing localhost with 127.0.0.1 solves the problem. I remember 
there's a bug somewhere in bugzilla regarding GConf (which also affects 
GnuCash and is referenced from one of the older still open GnuCash bugs) that 
explained this: on Windows localhost refers to the ip address of your primary 
network card, not 127.0.0.1. The firewall filters incoming traffic on the 
former, but not on the latter.

My thanks go to Ian X Waddington and choiks here for patiently executing all 
tests I conjured up during this investigation.

But I'm not only writing this to inform, I would also like to propose to 
change the hostname that is set by default in the Save As and Open dialog 
boxes to 127.0.0.1. If we leave it as localhost, I guess we will be getting a 
lot of "It doesn't work" messages in the future.

What do you think ?

Geert