MySQL Intergration and Android App

[Benjamin L. Naber]

I'm wondering if some of those bugs are from users that are not setting
up MySQL correctly, as I had some strange errors telling me I needed to
update a libdbd or libdbi on the Ubuntu Linux computer.

I looked around for days how to do this, but nothing came to me that
didn't involve smashing the computer with a hammer and redoing
everything.

So, the next thing I did was try accessing GNUCash using MySQL for data
storage on another computer. It gave me the same exact error. I was
pretty sure that WinXP did not use file libraries like that so I
suspected the Ubuntu Linux server to be defunct. However, I had made
tables with GNUCash before on the same WinXP computer, so something just
didn't seem to add up.

Long ago, my first attempt was done blindly not having a damn clue what
I was doing in MySQL. I just guessed at what I needed to do to create a
MySQL database and assign a user and some permissions. I gave the user
assigned to the gnucash database all privileges and let it go from
there. It worked fine.

Then, about a week ago when I really starting messing around again, and
that is when those pesky errors made their appearance. This time, I
created a different user with less permissions on MySQL, and GNUCash
didn't like it.

So I mimicked the permissions from the first user I created for database
gnucash, and it worked fine for both starting a new budget, and for
saving an existing one that was first started and stored on the local
computer as an XML file.

Now I just need to find exactly what permissions are needed so as not to
allow crazy stuff from happening.


~Benjamin

On Mon, 2012-11-26 at 17:32 +0900, John Ralls wrote:
> On Nov 26, 2012, at 11:41 AM, Benjamin L. Naber <benjamin at project23d.com> wrote:
> 
> > I hope I got the right listing for this...
> > 
> > Anyway, after seeing that GNUCash has been released on Google Play, I
> > got to playing around with GNUCash on my Ubuntu 10.04 laptop. It was
> > stated that Android doesn't yet support MySQL, but I'm not sure I
> > understood what he meant by that are there are RDBMS clients and
> > applications that can upload MySQL data such as QuickNote, available on
> > Google Play.
> > 
> > I had to get the 2.4 version from getdeb.net as the version that comes
> > with Ubuntu 10.04 is 2.2 or something like that. Either way, the older
> > version of GNUCash I had did not support MySQL for data reading/writing.
> > 
> > After a few rounds getting it work, and fussing with MySQL, I realized
> > that I was making the errors, and needed to fix myself. So I did.
> > 
> > I read some of the lists and from the wiki that folks want to have cross
> > platform access to GNUCash. There are a number of ways, none of which
> > seemed to me, as I know nothing compared to some of you, that there was
> > already something in place that will work for most, if not all.
> > 
> > I have GNUCash for both Windoz XP Pro, and Ubuntu. I'm able to build
> > MySQL database tables with each GNUCash program, if the tables did not
> > already exist. 
> > 
> > The caveat is that I'm able to access the same tables for both reading
> > and writing with either operating system platform. No errors have been
> > discovered....yet, and as long as I exit out of GNUCash on one machine
> > before going to another, GNUCash doesn't have any issues.
> > 
> > So, what I'd like to do is this. I have setup a small oscommerce and
> > MySQL database webserver that I would like some of the developers to
> > reply to me direct who is interested, and I will provide access details.
> > I'm looking for your feed back as to how well it performs for you over a
> > internet connection that goes out of my city, state, and possibly
> > country.
> > 
> > Should this be successful, I'm looking to market this on the gnucash.org
> > website to users of GNUCash and other database users who only need one
> > or a small amount of hosted databases for a small amount of cash each
> > year.
> > 
> > Of course, financial donations will be made to gnucash.org to show my
> > appreciation as I know nothing of coding.
> 
> Here's the fundamental issue with Android: Gnucash for Android (GFA) is a separate application from Gnucash. In order to directly access a Gnucash database, GFA would need the rather ungainly library code written in C with GLib contained in Gnucash, which it doesn't.
> 
> As for the web-backed service, well, that's kind of interesting. We were discussing that a couple of weeks ago. There are at present some known or suspected holes in our SQL implementation: Most things work, but there are some reported bugs that indicate not everything does. We're working on better test coverage to find the holes so that we can plug them. The next problem is that Gnucash isn't a database application, it just uses the database as a store. Most things it writes immediately and in reasonable transactions, but a few things aren't set up correctly and it needs to delete and re-write the whole database. That's going to kill performance over the net. We do intend to fix that, but lack of good and complete tests lies between here and there.
> 
> Regards,
> John Ralls
>