Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?
pinaart at yahoo.com
Fri Aug 24 23:12:53 EDT 2012
I don't recall the exact steps I took, so I'm repeating it.
I clicked on the GnuCash menu entry which points to,
F:\usr\gnucash\bin\gnucash.exe (v2.4.11 built from svn r22268 on 2012-07-15)
GnuCash could not obtain the lock for mysql://email@example.com/gc120816f.
So, I clicked the "Open Anyway" button as I have done before and
it goes back to the splash screen, acting like it's going to open the database, but Windows 7 just displays the blue "busy" circle until the pop-up,
gnucash.exe has stopped working
comes up and I do "Close program".
I invoke it again, but this time, I say "Cancel" and open my 18 MB GnuCash_XML file from 2009.
Now, I do "Save as..." to mysql on localhost with Database "gc120825", Username "root" and it fails with,
The server at URL mysql://root@localhost/gc120825 experienced an error or encountered bad or corrupt data.
(The MySQL commandline interface shows,
F:\usr\MySQL\MySQL Server 5.5\bin\mysql.exe Ver 14.14 Distrib 5.5.24, for Win64 (x86)
So I hit the "Close" button and do it again, but this time I set Host to 127.0.0.1 and get the same error.
I give up on that one open 2009_converted_120816.gnucash.
I can't save that one either so I do a File -> Quit from GnuCash.
I created an empty file, Test1.gnucash. It has the default 5 accounts with zero balances on each.
I did a save as mysql://root@localhost/test1a, successfully.
I did File -> close.
I reinvoked GnuCash from the Start menu and got a pop-up, "Error",
Unspecified fatal error encountered, aborting.
I did Ok to close it. I then got another pop-up, "Microsoft Visual C++ Runtime Library",
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Ok - this one could be my fault! I recently discovered some Windows Updates were not being applied, so I did some gross clean-ups two days ago! This involved zapping all Microsoft Visual Studio applications and C++ (2005 - 2010, including runtime and Redistribute packages).
Since I wasn't getting this specific error before - I apologize for wasting your time - I will reimage my system and start from a pristine state before I test GnuCash again.
(Doh! I just hate going back 6 months... to my previous known good system.)
From: Derek Atkins <derek at ihtfp.com>
To: vArt <pinaart at yahoo.com>
Cc: Colin Law <clanlaw at googlemail.com>; "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org>
Sent: Friday, August 24, 2012 2:18 PM
Subject: Re: Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?
On Fri, August 24, 2012 4:08 pm, Art wrote:
> Correct. It hangs when I try to open the same db it saved.
> Any subsequent re-starts of GnuCash do the same for that database.
How did you exit GnuCash after your File -> Save As?
What happens if you click "open anyways"?
> - Art
> From: Colin Law <clanlaw at googlemail.com>
> To: Art <pinaart at yahoo.com>
> Cc: "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org>
> Sent: Friday, August 24, 2012 12:57 PM
> Subject: Re: Is there a step-by-step, "How to setup a MySQL database for
> use with GnuCash"?
> On 24 August 2012 20:53, Art <pinaart at yahoo.com> wrote:
>> I don't know if I should ask this in a different forum, but I've
>> experimented with GnuCash for several years, but recently wanted to just
>> use the MySQL database for my finances and GnuCash can never read them.
>> It can create a database which I can read from the MySQL commandline
>> interface, but GnuCash simply hangs when I try doing it from it.
> Do you mean that if you do Save As and select the mysql option that it
> creates the db ok, but then if you close and re-open gnucash that it
> does not re-open the mysql db?
> [deleted my text below for brevity - Art]
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
Derek Atkins 617-623-3745
derek at ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
More information about the gnucash-devel