Re: [OSM-dev] Osmosis on Australia extract
Brett Henderson wrote: > Richard Chirgwin wrote: >> Hi, >> >> I'm trying to load the Australian OSM extract found here: >> http://www.osmaustralia.org/osmausextract.php >> >> Into a MySQL database using Osmosis. The failure (short version here, >> long below signature) is: >> >> Unable to parse xml file /home/richard/Desktop/australia.osm. >> publicId=(null), systemId=(null), lineNumber=8043380, columnNumber=1. >> at >> com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:114) >> at java.lang.Thread.run(Thread.java:619) >> Caused by: org.xml.sax.SAXParseException: XML document structures must >> start and end within the same entity. >> >> Any ideas? >> > > Perhaps the xml file has been truncated. Can you check the last lines > of the file to make sure the xml file has been closed correctly? The > program creating the file may have crashed half way through the file > creation. > > A command like tail should be able to do this for you. There are > other tools like xmlstarlet that might also help to validate xml files > but I haven't used them before. > > Brett > > Brett, Bingo, I think. The file ends on a tag rather than an tag. I'll let the generator of the file know about this, and see what happens if I add the tag manually. Thanks! Richard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Osmosis on Australia extract
Hi, I'm trying to load the Australian OSM extract found here: http://www.osmaustralia.org/osmausextract.php Into a MySQL database using Osmosis. The failure (short version here, long below signature) is: Unable to parse xml file /home/richard/Desktop/australia.osm. publicId=(null), systemId=(null), lineNumber=8043380, columnNumber=1. at com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:114) at java.lang.Thread.run(Thread.java:619) Caused by: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. Any ideas? Richard SEVERE: Thread for task 1-read-xml failed com.bretth.osmosis.core.OsmosisRuntimeException: Unable to parse xml file /home/richard/Desktop/australia.osm. publicId=(null), systemId=(null), lineNumber=8043380, columnNumber=1. at com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:114) at java.lang.Thread.run(Thread.java:619) Caused by: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195) at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:174) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:388) at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1411) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.endEntity(XMLDocumentFragmentScannerImpl.java:902) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.endEntity(XMLDocumentScannerImpl.java:605) at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.endEntity(XMLEntityManager.java:1393) at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(XMLEntityScanner.java:1763) at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.skipChar(XMLEntityScanner.java:1416) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784) 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) ... 1 more Nov 9, 2008 8:07:47 AM 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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Osmosis on OpenSuse with MySQL
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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql make failing
Greetings all, Tom Hughes wrote: > Martijn van Oosterhout wrote: >> What OS is this? libpq depends on krb5, that's true, but they should >> have both been installed already. (You don't need the develeopment >> header, just the runtime lib). > > At least on Fedora you will probably need the dev package, as it > contains the library you link against as well as the headers. The > runtime package only works for programs that are already linked. > > In this case the problem is more a lack of "-lkrb5" on the command > line anyway - he may well have the library but he isn't linking > against it and presumably his libpq.so isn't pulling it in for some > reason. > > Tom > Thanks for the responses so far... - The OS is OpenSUSE 10.3 - I'll try and get the libraries installed. At the moment apt can't locate them; I guess I need to find the right repository. Cheers, Richard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] osm2pgsql make failing
Hi from a new user. osm2pgsql is failing on make: /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' /usr/lib/libpq.so: undefined reference to [EMAIL PROTECTED]' What dependency am I missing? Thanks, Richard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev