Write Access

Write Access

Article from Issue 99/2009

 

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)

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy Linux Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • Workspace: BambooInvoice

    If you want your business to run smoothly, deploying a dependable invoicing solution should be among your top priorities. BambooInvoice offers a user-friendly, web-based invoicing solution.

  • Workspace: Business Data

    Learn how to analyze your business data with the help of OpenOffice.org Base and the Sun Report Builder extension.

comments powered by Disqus
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters

Support Our Work

Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.

Learn More

News