Using MySQL with GnuCash
Hossain
contacthossain at gmail.com
Mon Sep 14 15:41:59 EDT 2015
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.
On 15-Sep-2015 1:32 AM, Colin Law wrote:
> On 14 September 2015 at 20:27, Hossain <contacthossain at gmail.com> wrote:
>> I tried but failed. I use WAMP server for MySQL. Do I have to install (WAMP)
>> it in both PC to
>> connect to a remote Mysql server? In my MySQL main server PC , I made a user
>> for GNUCash
>> and grant it all privileges from ANYHOST. After I installed GNUCash in
>> remote PC, I tried to
>> connect to remote MySQL server by using the IP address of the MySQL server's
>> PC AS HOST
>> and "gnucash" as Datbase name, username that I created above and password.
>> But It shows an error
> You don't need WAMP, just the mysql server on the server machine, you
> don't need anything special on the client machine except possibly
> something like the mysql command line client (see below).
>
> Before trying to get gnucash going check using the mysql command line
> (or similar) on the client that you can connect to mysql on the
> server. Until you get that going this is not a gnucash issue but a
> mysql issue.
>
> Colin
>
>>
>> On 14-Sep-2015 9:14 PM, Colin Law wrote:
>>> On 14 September 2015 at 15:56, Hossain <contacthossain at gmail.com> wrote:
>>>> Hello, I want to save the GNUCash data to MySQL server , Hence, I
>>>> installed
>>>> WAMP.
>>>> GnuCash can connect to MySQL server very well but I dont see any related
>>>> database tables or data
>>>> in the database I made for Gnucash with PhpAdmin. Do I have to set the
>>>> saving preference at the beginningm when I make the file?
>>>> I did it later.
>>> You don't need to make the database in advance, GnuCash will make it
>>> if necessary when you save it. Just select mysql as the type to save
>>> as and provide the database name, user and password and it should do
>>> it. You should then be able to see the data in phpadmin.
>>>
>>> Does GC appear to save the data as mysql ok?
>>> Does mysql://.... then appear in the GC title bar?
>>> Can you close GC and and re-open it and the data are still there?
>>> If so then it is saving the data ok so if you can't see it in
>>> phpmyadmin then the problem lies there not in gc. You may have to
>>> refresh phpmyadmin after saving in GC.
>>>
>>> Colin
>>
More information about the gnucash-user
mailing list