Connecting to a MySQL Database from Open Office Base – Errors

While trying to connect to a MySQL Database from Open Office base, you might get the ‘JDBC Driver could not be loaded error’

On Clicking the Test Class Button

It is actually pretty simple to solve.

Download the MySQL Connector jar file from mysql.com and save it to your desktop. You now get the file mysql-connector-java-5.0.8.tar.gz on the desktop

Open up a terminal and try unzipping the file after navigating to the Desktop
sudo tar -xvvzf mysql-connector-java-5.0.8.tar.gz

The tar command unzips the file and creates a directory named mysql-connector-java-5.0.8. Open the folder and you will find the file mysql-connector-java-5.0.8-bin.jar

That is actually the only file we are interested in. Move that file to the external libraries directory for your java runtime environment as below (you may have the modify for your actual runtime version.)
From the Desktop:
sudo mv mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /usr/lib/jvm/java-1.5.0-sun-1.5.0.14/jre/lib/ext/

The JDBC Connector now works properly


Note: If this doesn’t work, make sure that the correct JVM is selected for Open Office in Tools>Options in any of the Open-Office Applications.

Getting Skype to work on Debian Etch

I was having some trouble getting the new skype 2.0 to work on my system for testing. I downloaded the package from http://www.skype.com/go/getskype-linux-deb and downloaded file was skype-debian_2.0.0.63-1_i386.deb.

Double clicking on the file just opened up gdebi which closed again.

Running from the terminal, gdebi crashes with the following error.
Traceback (most recent call last):
File “/usr/bin/gdebi”, line 31, in ?
if not debi.open(sys.argv[1]):
File “/var/lib/python-support/python2.4/GDebi/GDebiCli.py”, line 31, in open
if not self._deb.checkDeb():
File “/var/lib/python-support/python2.4/GDebi/DebPackage.py”, line 185, in checkDeb
if arch != “all” and arch != apt_pkg.CPU:
AttributeError: ‘module’ object has no attribute ‘CPU’

A bit of research later, figured it was a problem with the python libraries and found this patch at debian.org.

It simply involves opening /var/lib/python-support/python2.4/GDebi/DebPackage.py

and replacing the line in the #check arch section

if arch != “all” and arch != apt_pkg.CPU:

with
if arch != “all” and arch != apt_pkg.Config["APT::Architecture"]:

Skype now installs without any trouble.