[GNC] MySQL

[davidcousens49 at gmail.com]

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