[GNC] MySQL

D. sunfish62 at yahoo.com
Sun Mar 13 20:16:47 EDT 2022


Henrik, 

As the third David on this thread, I fully echo what the other two have said, but will further add that if you are hoping to access the data serially and singly from a common location, the default XML file format can work equally effectively. And you don't have to maintain a MySQL server. 

David T.


-------- Original Message --------
From: davidcousens49 at gmail.com
Sent: Sun Mar 13 18:28:45 EDT 2022
To: gnucash-user at gnucash.org
Subject: Re: [GNC] MySQL

Henrik,

I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
  
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data file without significant risk of
error. The libraries and routines for SQL access currently do not have the
record locking capability to support multiple simultaneous use. You will need to
establish administrative protocols, if using several computers to access
GNuCash, to ensure such access is not simultaneous.

I would initially trial testing on a single computer which is also running the
MySQL server supplying the data, to ensure there are no server installation
problems before trying to access the server remotely.  Once this is functioning
you can then be reasonably sure that any remote access problems are
communication/permissions issues and not intrinsic issues within GnuCash.
David Cousens

On Sun, 2022-03-13 at 18:37 +0000, Henrik Morsing wrote:
> Hi,
> 
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though, is
> this expected? Half the time is just hangs and says "The server experienced
> and error..." even though I can connect and log in manually with no issues.
> 
> Thanks for any tips

_______________________________________________
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.


More information about the gnucash-user mailing list