New to GnuCash

[Robert Carroll]

Thank you both, I didn't realize that GC locks out users when another has it
open, but there will only be a few of us that use it, we'll just have to
make sure that when we are done we close it so the other can use it,
which shouldn't be too bad, my main line of work is not accounting :)  All
though some days it doesn't feel that way.

I appreciate the help and quick response.

Robert



On Wed, Aug 10, 2011 at 4:31 PM, Colin Law <clanlaw at googlemail.com> wrote:

> On 10 August 2011 20:43, Robert Carroll <rcarroll at seeklocate.com> wrote:
> > Hi,
> >
> > I am setting up GnuCash for the first time on my Ubuntu small business
> > network.  So each work station is based on the Ubuntu OS, there are 3 in
> > total.  I want to use MySQL which is on my Ubuntu server to manage the
> data
> > and each work station to access that data.  I am not finding a best
> practice
> > guide on how to set up something like this through my google searches,
> can
> > someone point me in the right direction.  What I would like to know is do
> I
> > need a .sql that will setup the tables and then connect to the sql server
> > from each WS?  Do i install GnuCash on each WS and then setup a
> connection
> > to the SQL db from there If so where do I setup that connection and is
> there
> > any suggestions for setting up that connection?  Each WS is on the same
> lan.
>
> Firstly, do you realise that GnuCash does not support mutli-user
> access to the data, even when using MySQL?
>
> Assuming that is understood, then install GC on each workstation, then
> on one of them create the initial set of accounts, and when saving it
> select mysql as the type, your server as the server, enter a database
> name then username and password as appropriate.  Then to use it on
> another workstation do File Open and select mysql and the rest and off
> you go.
>
> Colin
>