Problems with dbi-connector and mysql

[Oliver Brandt]

Hi everybody,

I accidentaly sent the following reply directely to Phil instead of the
list. So here it goes again. I hope this helps others with
the same problem:

-------- Weitergeleitete Nachricht --------
> Von: Oliver Brandt <junk at oliverbrandt.de>
> An: Phil Longstaff <plongstaff at rogers.com>
> Betreff: Re: Problems with dbi-connector and mysql
> Datum: Sat, 27 Dec 2008 01:20:56 +0100
> 
> Hi Phil,
> 
> thank you very much for your reply! Sorry for posting on the wrong list.
> I just did not want to bug the developers with a problem I was sure
> there was a very simple solution to.
> 
> Well, thank you very much for your great hint! At a first glance
> everything seams to be working perfectly now. I can't put any excessive
> testing into it right now, as very ugent problems poped up today, I have
> to take care of first. I probably will not have the time to put
> execessive testing into Gnucash for a week or so. But I'll definately
> keep you posted if I run into any other problems.
> 
> For now, let me just describe my setup and what I did, as I hope this
> might help others that run into the same problem:
> 
> I'm using debian unstable (a linux distribution). Except for Gnucash,
> where I compiled the most current svn-version from source, I installed
> all the packages the gnucash "configure" required through apt. I also
> installed a mysql-server version 5.0. The problem was, that I did not
> have the libdbi-drivers for mysql installed. So after reading your
> message, I ran an "apt-get install libdbd-mysql" and now everything
> seams to work perfectly.
> 
> I just opened a local gnucash file. Afterwards I enterd the following
> information in "FILE" -> "Database Connection" and hit "SAVE":
> 
> host: localhost
> database: gnucash
> username: oliver
> password: xxx
> 
> To open the newly created database again, all I have to do is to take
> the same steps and enter the same location information but then hit
> "LOAD" instead of "SAVE".
> 
> Big thanks to the developers. You did a great job!
> 
> Phil, thank you very much again for your great help!
> 
> Cheers!
> 
> Oliver
> 
> Am Donnerstag, den 25.12.2008, 23:28 -0500 schrieb Phil Longstaff:
> > Hi Oliver,
> > 
> > a few things:
> > 1) Since this question involves software which has not been released yet, it 
> > should really be on gnucash-devel, not gnucash-user.
> > 2) What are you running on?  Linux?  Windows?  What distribution?
> > 3) Assuming you are on Linux, do you have a file /usr/lib/dbd/libdbdmysql.so 
> > (maybe /lib/dbd/ls ).
> > 
> > Phil
> > 
> > On December 25, 2008 03:11:59 pm Oliver Brandt wrote:
> > > Hi!
> > >
> > > thank you very much for gnucash. I've been using it for quite some time
> > > to do my personal finances and it works great. Now I'm trying to help a
> > > friend of mine, who needs to do accounting where multiple people can
> > > work on the same data. So I thought of a combination of gnucash and
> > > mysql. After researching for quite a while, I found out that the dbi
> > > connector seems to be the way to do it. I spent about 4 hours to get
> > > gnucash to build properly with the dbi-connector. But now I'm stuck
> > > getting it to connect to the mysql database. I've installed a clean
> > > version of mysql and executed the following mysql-command to have full
> > > access to the database:
> > >
> > > GRANT ALL ON *.* TO oliver at localhost IDENTIFIED BY 'xxxxx' WITH GRANT
> > > OPTION
> > >
> > > Now I've tryed both the save and the load button in the database
> > > connection outions. I staid wit the default options:
> > >
> > > server: localhost
> > > database: gnucash
> > > user: oliver
> > > password: xxx
> > >
> > > I always get the message "the following url could not be processed:
> > > mysql://localhost:gnucash:oliver:eis3Shia" original german message: "Die
> > > folgende URL konnte nicht verarbeitet werden".
> > >
> > > Same situation after I have created the database gnucash with "CREATE
> > > DATABASE gnucash".
> > >
> > > I'm really stuck and I could not find any more information neither
> > > through google nore by reading the archives. I would really appreciate
> > > it if you could point me into the right direction or towards some howto
> > > or something similar.
> > >
> > > Thank you very much!
> > >
> > > Merry Christmas!
> > >
> > > Oliver
> > >
> > >
> > >
> > > _______________________________________________
> > > 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.
> > 
> > _______________________________________________
> > gnucash-devel mailing list
> > gnucash-devel at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> >