[GNC] Gnucash Flatpak 3.2 Mysql issue

[Colin Law]

Excellent, thanks for working that out.  Specifying 127.0.0.1 works
for me too.  I have updated the issue [1].
That means that for me the flatpak is a working solution.  However,
given the fact there has been absolutely no feedback from the
maintainer on any of this I am not particularly hopeful that the
flatpak will be kept up to date, any more than the snap package has
been.

Colin

[1] https://github.com/flathub/org.gnucash.GnuCash/issues/17
On Tue, 4 Sep 2018 at 05:03, Plutocrat <plutocrat at gmail.com> wrote:
>
> Well I was bored at work (which isn't to say I didn't have any to do ...), so I thought I'd fiddle around with the gnucash flatpak I had installed on my laptop to see if I could figure out what was going on.
>
> I personally use the XML file, so I installed mysql-server, struggled to reset the root password and then created a gnucash user and database. Tried to save to host=localhost, db=gnucash, user=gnucash, password=xxxxxx and experienced the same problem as previously detailed on this list.
>
> Cue an hour of digging through documentation on flatpak,
> http://docs.flatpak.org/en/latest/sandbox-permissions-reference.html
>
> This looked promising, but didn't work, throwing an error.
> flatpak permission-show org.gnucash.GnuCash
>
> This flag looked like it might work, but made no difference.
> --share=network  (Giving network access also grants access to all host services listening on abstract Unix sockets (due to how network namespaces work)
>
> Eventually I found the manifest.json file in /usr/lib/flatpak/blah/blah and determined that it did actually have network access anyway. And /home/user/ directory access, for the record.
>
> I was poring through mysql logs, and I saw 'Listening on 127.0.0.1', so I thought I'd give that a try on the off-chance ... and it worked! Database saved OK, and I could work off that one.
>
> So, apparently changing hostname from localhost to 127.0.0.1 was the magic charm. Anyone else want to give it a try and report back?
>
> P.
> _______________________________________________
> 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.