[OSM-talk] Osmosis error while trying to import planet file into Mysql

[Lambertus]

As the title says, I'm trying to import a planet file into a mysql database 
on my debian machine. I've done the following steps to accomplish this:
- Install mysql-server-5.0 (using no password for root)
- Create a database
- Create the tables according to the Osmosis mysql schema as said in the 
wiki
- Iinstall sun-java6-bin
- Install libmysql-java
- Download Osmosis (version 0.24)

This seems all ok to me, so I run the command to fill the database:

bzcat planet/planet-latest.osm.bz2 | java -Xmx1048m -jar 
utils/osmosis/osmosis.jar --rx /dev/stdin enableDateParsing=no 
outPipe.0="planet" --wm inPipe.0="planet" host="localhost" database="osm" 
user="root"

Now Osmosis returns with the error "Unable to find database driver" (see 
below for the full error message). Can someone give me a pointer to where 
I've gone wrong?

Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main
INFO: Osmosis Version 0.24
Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main
INFO: Preparing pipeline.
Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main
INFO: Launching pipeline execution.
Mar 6, 2008 8:16:55 PM com.bretth.osmosis.core.Osmosis main
INFO: Pipeline executing, waiting for completion.
Exception in thread "Thread-1-rx" 
com.bretth.osmosis.core.OsmosisRuntimeException: Unable to find database 
driver.
        at 
com.bretth.osmosis.core.mysql.common.DatabaseContext.loadDatabaseDriver(DatabaseContext.java:58)
        at 
com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:77)
        at 
com.bretth.osmosis.core.mysql.common.DatabaseContext.executeStreamingQuery(DatabaseContext.java:197)
        at 
com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:62)
        at 
com.bretth.osmosis.core.mysql.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:44)
        at 
com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:316)
        at 
com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java:1004)
        at 
com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
        at 
com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:108)
        at 
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
        at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1772)
        at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2923)
        at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:647)
        at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:508)
        at 
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
        at 
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
        at 
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
        at 
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
        at 
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:198)
        at 
com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:101)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at 
com.bretth.osmosis.core.mysql.common.DatabaseContext.loadDatabaseDriver(DatabaseContext.java:55)
        ... 22 more
Mar 6, 2008 8:16:56 PM com.bretth.osmosis.core.Osmosis main
INFO: Pipeline complete.