[OSM-dev] Fwd: First experience

Dennie.nl dennie.nl at gmail.com
Wed Aug 19 14:51:55 BST 2009


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 <brett at bretth.com>

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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090819/08526375/attachment.html>


More information about the dev mailing list