Brett, apologies for sending the email direct to you! Hello Brett,
The ruby problems are solved, I mentioned them for future reference (if somebody searches the archives). Next time I will run it on an virtual appliance, thanks for the tip. Answers on your questions: > 1. Benelux = Belgium, Netherlands en Luxumbourg. It's a partial planet file, which is updated daily and I have downloaded it from: http://planet.openstreetmap.nl/benelux/ > 2. Yes, I am using MySQL 5.1.31 Community Edition. > 3. Using version 0.31.2: <osmosis_home>bin\osmosis --read-xml "path_to\planet-benelux-090817.osm" --write-apidb host="localhost" user="openstreetmap" password="openstreetmap" dbType="mysql" > 4. I don't have the compleet stacktrace anymore and I can't use my local pc right now to bulk read the entire database but basicly the mysql jdbc driver throws an exception with the message: Duplicate entry '37847304-2-court' for key 'PRIMARY' and this leads to Osmosis throwing an exception with the message: Unable to bulk insert way tags into the database. After restarting the tool it tries to populate the OSM database instead of the openstreetmap database. Additional: 1. I've simply copied the mysql-database-example.yml for connection parameters of db:migrate 2. I am a java programmer and have some understanding of exception concepts. My quess is that the database structure of mysql isn't very well tested against mysql after switching from mysql -> postgress? 3. I would like to use the street level lat/lon data from the database to compliment the database of 6pp (Dutch opensource alternative to freethepostcode, see:http://kvdb.net/projects/6pp). Thanks for the help! Dennie 2009/8/19 Brett Henderson <[email protected]> Dennie.nl wrote: > >> Hello, >> >> About osmosis (I can't get this working) using: partial planet.osm file >> from the benelux. >> * A lot of constraints errors: >> - unique user_name_index in table users >> - Duplicate entry '37847304-2-court' for key 'PRIMARY' / >> OsmosisRuntimeException: Unable to bulk insert way tags into the database >> >> I don't know if this is the right place to ask Osmosis questions, but some >> help would be appreciated. >> > For your ruby and rails issues I can't help much. However you'll probably > find life easier running this stuff on Linux. > > Either here or the osmosis-dev list are fine for Osmosis questions. I'm > offline at the moment so can't check out investigate your errors in much > detail. > > I have a few questions: > 1. What is benelux? Do you have a URL to the file you used? > 2. I asssume from your comments that you're using a MySQL database built > using the rake db:migrate command. Is this the case? > 3. What is the full osmosis command line you used? > 4. What is the full program output you received? > > Brett > > >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
