[GNC] Gnucash Flatpak 3.2 Mysql issue

[Adrien Monteleone]

While --share=network should give you access to unix-sockets, I don’t think that includes access to ‘/etc/hosts’ which lies outside of the sandbox therefore, I’d suspect the reference to ‘localhost’ is not resolving, so only the actual IP address will work.

Regards,
Adrien

> On Sep 3, 2018, at 11:00 PM, 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.
>