Save As MySQL is crashing gnucash

[Ian X Waddington]

Thank you for your input.

Ok I now have a user with privileges but it still crashes instantly.

I could be wrong but I'm inclined to think this problem is more fundamental to the application than MySQL.

Any additional thoughts would be ideal  - a step-by-step idiot proof guide to installing MySQL onto a Windows 7 PC and setting everything up to work with Gnucash would be even better :-)

Regards

-----Original Message-----
From: jh [mailto:jhoewener at googlemail.com] 
Sent: 26 November 2010 08:37
To: Ian X Waddington
Cc: gnucash-devel; gnucash-user
Subject: Save As MySQL is crashing gnucash

Hi,
I think you should file this as a bug!
No matter what mistake you make as a user, Gnucash should not crash, but rather give you a reasonable error message and handle the situation gracefully (what Gnucash usually does).

On my Ubuntu machine, after installing MySQL, I had to log into the MySQL-client on the commandline with:

mysql -u root -p

Then at the mysql prompt enter:

CREATE USER 'gncuser'@'localhost' IDENTIFIED BY 'gncpw'; GRANT ALL PRIVILEGES ON *.* TO 'gncuser'@'localhost';

Now I could use MySQL from within Gnucash.

Juergen


On Fri, 2010-11-26 at 07:18 +0000, Ian X Waddington wrote:
> Thank you, the entries in the archives suggest that a save as in 
> gnucash changing the type to mysql would create a database of name 
> gnucash with the user id and password I had entered.
> 
> Is this now not the case?
> 
> -----Original Message-----
> From: Robert Heller [mailto:heller at deepsoft.com]
> Sent: 26 November 2010 00:02
> To: Ian X Waddington
> Cc: gnucash-user at gnucash.org; Robert Heller
> Subject: Re: Save As MySQL is crashing gnucash
> 
> At Thu, 25 Nov 2010 22:59:47 -0000 "Ian X Waddington" 
> <iwaddox at gmail.com>
> wrote:
> 
> > 
> > Hi
> > 
> >  
> > 
> > On a Windows 7 machine I am running gnucash 2.3.17 and have just 
> > installed MySql 5.1.53
> > 
> >  
> > 
> > When I select file-save-as (with a new blank file of an existing 
> > test
> > file) I get the MySQL form to fill in and choose localhost, gnucash, 
> > (made up userid), (made up password) - gnucash immediately crashes 
> > and windows 7 tells me I've had an APPCRASH in 
> > libgncmod-backend-dbi.dll
> 
> made up userid, made up password ?
> 
> You can't just 'make up' a username and password.  You need to login 
> to mysql as the root user and create a username with a password.  You 
> probably also need to create a database (named gnucash I presume).
> Under Linux/UNIX one would fire up the mysql command from a shell with 
> the root user and password. I believe a *fresh* install leaves the 
> root user with no password (which really should get changed as the 
> first post install step).  Creating users and databases is covered in 
> the MySQL reference manual.
> 
> > 
> >  
> > 
> > I've search the list archives but could not find anything that 
> > seemed relevant so I would be grateful for any help or suggestions
> > 
> >  
> > 
> > Regards
> > 
> > _______________________________________________
> > 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.
> > 
> >                                            
>