[GNC] Gnucash 3.8 Flatpak Not Connecting to MySQL

[Geert Janssens]

Hi Alan,

That is probably the issue described here:
https://github.com/flathub/org.gnucash.GnuCash/issues/17

In short: the flatpak sandbox has very limited access to your host system by default. It can 
access your home directory and the network via tcp/ip connections. However if you use 
"localhost" as network location, this will try to connect via a unix socket instead.

There are two possible workarounds:
1. use 127.0.0.1 instead of localhost, which usually makes myqsl use a real tcp/ip connection.
2. allow access to the unix socket used by mysql for your gnucash flatpak. The command would 
be something like:
flatpak override --filesystem=/var/run/mysqld/mysqld.sock org.gnucash.GnuCash
Though you should doublecheck the path to the mysqld.sock socket as it varies from platform to 
platform.

Regards,

Geert

Op dinsdag 4 februari 2020 00:39:34 CET schreef Alan Whiteman:
> Hello,
> 
> Recently I moved to KDE Neon as my preferred distro, I had manually
> installed Gnucash 2.6 which connected to MySQL perfectly fine. A recent
> system update forced the removal of Gnucash in order to update some
> libraries. When I tried to re-install from the Discover Software Center,
> the only version available was 3.8 via Flatpak.
> 
> The installation of this version went fine, with some minor changes:
> 
> "Your gnucash metadata has been migrated.
> 
> Old location: /home/user/.gnucash
> New location: /home/user/.var/app.org.gnucash.GnuCash/data/gnucash
> 
> If you no longer intend to run GnuCash 2.6.x or older on this system you
> can safely remove the old directory.
> 
> In addition:
> 
> The following file has been copied to
> /home/alan/.var/app/org.gnucash.GnuCash/config/gnucash instead:
> -config.user (Renamed to: config-user.csm)"
> 
> 
> But when I try to retrieve my old accounts, it refuses to connect to the
> database, with the following message:
> 
> "The server at URL mysql://user@localhost/gnucash experienced an error
> or encountered bad or corrupt data."
> 
> In the end, I uninstalled Gnucash 3.8 Flatpak version and installed
> 2.6.19 through apt, which works.
> 
> Any insights into making the newer version work will be greatly appreciated.
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.