Python connect to mysql-gnucash doesn't work anymore with Rev 19209

[Phil Longstaff]

There was a change in the URL format.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Mike Evans <mikee at saxicola.idps.co.uk>
To: gnucash-devel at gnucash.org
Sent: Fri, May 28, 2010 9:56:16 AM
Subject: Re: Python connect to mysql-gnucash doesn't work anymore with Rev 19209

On Friday May 28 2010 09:31:29 Geert Janssens wrote:
> On Friday 28 May 2010, Christoph Holtermann wrote:
> >  Hello !
> > 
> > My python script ceased to run with a recent version
> > of gnucash (19209). It worked with 18542.
> > 
> > session=Session("mysql://localhost:gnucash:USER:PASSWORD")
> > 
> > now i get :
> > 
> > GnuCashBackendException: call to begin resulted in the following errors,
> > 
> >  (11,)
> > 
> > Can anyone help ? Did the syntax of the URI change ? I think i got it
> > from gnucashs window. Now there it is
> > mysql://christoph@localhost/gnucash. Using that in the Sessioncall
> > doesn's help either.
> 
> The window title won't display the password. So if you are using a password
> to connect to mysql (most likely), the URI syntax becomes:
> mysql://christoph:PASSWORD@localhost/gnucash
> 
> I don't know how python connects with gnucash, so I'm not sure how all of
> this propagates.
> 
> Assuming python leaves it to GnuCash internals to connect to the database
> and you didn't pass a password via URI, GnuCash will attempt to look up
> the password in the gnome keyring (on linux) or keychain (on OS X). Often
> accessing the key store will also pop up a dialog to unlock it first. If
> no proper password can be found in the key store, it will ask for a
> password in another popup dialog.
> 
> You don't give much information about your environment. If there's no X
> environment available, I suppose this keychain unlocking will fail and
> GnuCash' subsequent attempt to ask you for a password as well.
> 
> 
Just for info. this works for me,  

session = Session('mysql://USER:PASSWORD@localhost/gnucash')

System is Fedora 12.


-- 
GPG Key: 1024D/050895C2
Keyserver: http://pgp.mit.edu/          
Search String: 0x050895C2
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel