Using MySQL with GnuCash

[Derek Atkins]

Hi,

On Mon, September 14, 2015 3:47 pm, Hossain wrote:
> IS there any work around ? what if I use the option "create a new file"
> offered above.
> What does it do ? IS there any way I can do this ?

What exactly are you trying to do?

If you want two people to each be able to use GnuCash with their own,
unique data stored on MySQL then yes, that can do that.  Each user would
have their own database (and preferable their own unique mysql
username/password).

If, however, you want two users to access the SAME data, then no, gnucash
does not support that.  The only "workaround" is to make sure only one
user is using gnucash at a time.  You must exit gnucash on one machine
before you start it on the other machine.

-derek

> On 15-Sep-2015 1:45 AM, Colin Law wrote:
>> On 14 September 2015 at 20:41, Hossain <contacthossain at gmail.com> wrote:
>>> I did it  but GNUCash from remote PC can only use MySQL , when the
>>> Server PC
>>> is not using another GNUCash ( two application at  d same time). When
>>> Server
>>> PC
>>> is already running GNUCash, starting another GNUCash from client PC
>>> says
>>> "GUNCASH
>>> couldnt obtain the lock for mysql://gunuser@192.168.0.102/gnucash. That
>>> database
>>> maybe in use by another user, in which case you shoudnt open the
>>> database,
>>> What wud
>>> u like to do? " It has 4 options- Open Read Only, Create New File, Open
>>> Anyway, Quit .
>>> I dont know wat to do now. I want to use GNUCash at d same time from
>>> two
>>> PCs.
>> You can't.  Gnucash does not yet support multiple users at the same
>> time, even when using mysql.
>>
>> Colin
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant