[OSM-dev] Osmosis on OpenSuse with MySQL

[Shaun McDonald]

Do you have tables in the database as per the main site. osmosis  
doesn't automatically create the tables by default.

For setting up please see:
http://wiki.openstreetmap.org/index.php/Rails

Shaun

On 7 Nov 2008, at 07:43, Richard Chirgwin wrote:

> Hi,
>
> Osmosis has installed okay, and I can read-write from and to XML. But
> running to a database, things fall over. The full error is below my
> signature.
>
> Environment:
> - OpenSUSE 10.3 with MySQL Server 5.0.45
> - Osmosis 0.29
>
> There is a database called osm, and a user account "osmosis" with
> password "osmosis" on localhost.
>
> So the command line is:
> osmosis --read-xml file="/home/richard/planet.osm" --write-mysql
> host="localhost" database="osm" user="osmosis" password="osmosis"
>
> The failure seems to occur on schema_info:
> SEVERE: Thread for task 1-read-xml failed
> com.bretth.osmosis.core.OsmosisRuntimeException: Unable to create
> streaming resultset.
> [snip]
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> 'osm.schema_info' doesn't exist
>
> Is there something I need to do to create the schema_info table, so as
> to allow Osmosis to run?
>
> Richard
>
> Richard
> SEVERE: Thread for task 1-read-xml failed
> com.bretth.osmosis.core.OsmosisRuntimeException: Unable to create
> streaming resultset.
>        at
> com 
> .bretth 
> .osmosis 
> .core 
> .mysql 
> .common.DatabaseContext.executeStreamingQuery(DatabaseContext.java: 
> 209)
>        at
> com 
> .bretth 
> .osmosis 
> .core 
> .mysql 
> .common 
> .SchemaVersionValidator 
> .validateDBVersion(SchemaVersionValidator.java:63)
>        at
> com 
> .bretth 
> .osmosis 
> .core 
> .mysql 
> .common 
> .SchemaVersionValidator.validateVersion(SchemaVersionValidator.java: 
> 45)
>        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:109)
>        at
> com 
> .sun 
> .org 
> .apache 
> .xerces 
> .internal 
> .parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
>        at
> com 
> .sun 
> .org 
> .apache 
> .xerces 
> .internal 
> .parsers 
> .AbstractXMLDocumentParser 
> .emptyElement(AbstractXMLDocumentParser.java:180)
>        at
> com 
> .sun 
> .org 
> .apache 
> .xerces 
> .internal 
> .impl 
> .XMLDocumentFragmentScannerImpl 
> .scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
>        at
> com 
> .sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl 
> $FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
>        at
> com 
> .sun 
> .org 
> .apache 
> .xerces 
> .internal 
> .impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
>        at
> com 
> .sun 
> .org 
> .apache 
> .xerces 
> .internal 
> .impl 
> .XMLDocumentFragmentScannerImpl 
> .scanDocument(XMLDocumentFragmentScannerImpl.java:510)
>        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:109)
>        at java.lang.Thread.run(Thread.java:619)
> Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> 'osm.schema_info' doesn't exist
>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 
> 936)
>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
>        at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
>        at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
>        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1207)
>        at
> com 
> .bretth 
> .osmosis 
> .core 
> .mysql 
> .common.DatabaseContext.executeStreamingQuery(DatabaseContext.java: 
> 204)
>        ... 21 more
> Nov 7, 2008 6:29:10 PM com.bretth.osmosis.core.Osmosis main
> SEVERE: Execution aborted.
> com.bretth.osmosis.core.OsmosisRuntimeException: One or more tasks  
> failed.
>        at
> com 
> .bretth 
> .osmosis 
> .core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:141)
>        at com.bretth.osmosis.core.Osmosis.main(Osmosis.java:55)
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2433 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081107/4f1b077a/attachment.bin>