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 <benja...@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 > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
