Write Access

Bamboo Intelligence

Many thanks to Dmitri Popov for the interesting and informative articles over the years. I sure have learned a lot with your help. However, I seem to have come stuck following your guide for setting up business intelligence with OpenOffice Base linked to BambooInvoice. I have a working installation of BambooInvoice, and when I get to testing the connection with the database from the setup wizard in OpenOffice, it won't connect. I have attached a screen dump of the error. I am using bambooinvoice as the database name; the server URL is http://localhost/myname/newco/bambooinvoice, and the port is 3306.

My software versions are OpenOffice 2.4.1 with JRE 1.6.0_07 and MySQL connector 5.1.7.

Kenn Heeley

LM

Dmitri Popov writes:

Hi, Kenn:

It's difficult to say what could cause the problem – there are too many unknowns. What version of OpenOffice.org do you use? On what Linux distro? Is BambooInvoice installed on a local server? Assuming you specified the port, you have to check whether your MySQL installation actually accepts connections from external hosts on this port. In many cases, MySQL is set to refuse any connection coming from external hosts. Can you connect to your MySQL server from an external machine?

Linux Installation

I recently bought Linux Pro Magazine specifically for the Fedora 9 DVD that was in it (as I've been using Slackware Linux since version 9). However, the udev/hal article and the green PC article were both interesting.

Anyway, the DVD was broken – it was physically fine, without scratches, but I had numerous problems with it. The DVD detected my IDE hard drive as SATA, locked hard when trying to bring up my Ethernet card (Toshiba Satellite A55-S306), and the installer broke at various random packages. I know that there are many reasons why, so I do not directly blame you or Fedora, but I would like to tell you a story that illustrates why this is bad.

I bought Corel Linux in 2000. I was totally brand new to Linux. Corel did not like my laptop's LCD screen at all, and could not use my modem. I lost all my information on Win98SE as well. In any case, I forgot about it until I heard about FreeBSD from a friend. To make a long story short, I installed RH9, then Slackware 9. It wasn't until about a year ago that I found my old Corel Linux install media.

What I hope is that other people who are new to Linux don't just try one bad DVD, then use it as their reason why "Linux sucks," etc. I care about the Linux community a whole lot and would hate to hear that.

Robert Delahunt (aka TwinReverb)