Subject: Re: [OSM-dev] set up test server - msg#00174

List: gis.openstreetmap.devel

Date: Prev Next Index Thread: Prev Next Index

On 26 Aug 2006 at 17:21, Jonas Svensson wrote:

> Btw, I have begun importing the planet-dump. Had to change a few '
> to " in the perl script. If the import works I will try to check in
> that change. Seems like it will be a few hours...

It seemed to work but after 15 hours it was spending 99% of the
time swapping and only got a third of the nodes so I killed it. It
should probably be checked in to svn anyway so I attach it for
someone to do that.

Can I use planet2mysql.rb instead for this task? Would it use less
memory?

/Jonas

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

---- File information -----------
File: planetosm-to-db.pl
Date: 27 Aug 2006, 10:09
Size: 14141 bytes.
Type: Unknown

planetosm-to-db.pl
Description: Binary data

_______________________________________________
dev mailing list
dev@xxxxxxxxxxxxxxxxx
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev

Was this page helpful?

Thread at a glance:

Previous Message by Date: click to view message preview

Re: [OSM-dev] openlayers alpha

Oops, meant to send this to dev, not talk. > if you run the rails app then you now get openlayers a la > london.freemap.in > > imagery provided by tile.openstreetmap.org (will check in that stuff > tomorrow or monday) based on chris' stuff and stabbing mapserver > repeatedly. > > fixes needed: > > * mercator projection > * move openlayers stuff somewhere sensible > * upgrade to OL 2.0 > * use landsat.openstreetmap.org > > It's running off an old planet.. > > Can someone look at converting the planet.osm thats running now (or > last weeks) using this > http://wiki.openstreetmap.org/index.php/HOWTO_creating_an_OpenLayers_powere >d_OSM > > to shapefiles via GML? Just doing it with the python script quickly runs > out of memory. Could we short-circuit the GML? If I have the time (there's freemap stuff I need to do for the SoC conference; however it's more likely I can do somethig with it after that) I can have a go at doing something which goes straight from planet to shapefiles. However I would need to research shapefiles first so it wouldn't be a one-day job. Nick _______________________________________________ talk mailing list talk@xxxxxxxxxxxxxxxxx http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk

Next Message by Date: click to view message preview

[OSM-dev] utils/osm-data is ruby code?

Just for curiosity: why is ruby code Data? in the directory utils: osm-data/ osm-data/test osm-data/test/tc_rexml.rb osm-data/test/tc_data.rb osm-data/test/all.rb osm-data/lib osm-data/lib/osm osm-data/lib/osm/rexml.rb osm-data/lib/osm/data.rb -- Jörg (Germany, Munich) http://www.ostertag.name/ TeamSpeak2: ts2.ostertag.name, user: tweety, Channel: "GPS Drive" irc://irc.oftc.net/#osm

Previous Message by Thread: click to view message preview

Re: [OSM-dev] set up test server

On 26 Aug 2006 at 15:53, Immanuel Scholz wrote: > Hi, > > > 1. I can't create new account: "Internal Server Error". This is > > some problem with the mysql settings which I have not really > > understood so far. Minor problem I think. > > "Internal Server Error" is spit out on almost any error. :-( > > Look at the following places for help: > > /var/log/apache2/access.log > /var/log/apache2/error.log > /var/log/apache2/osm.access.log > /var/log/apache2/osm.error.log > /tmp/localhost.log > > Best, do one tail over all these files and put it to your desktop > background or on the second monitor. osm.error.log says: [Sat Aug 26 15:07:49 2006] [error] mod_ruby: error in ruby [Sat Aug 26 15:07:49 2006] [error] mod_ruby: /home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm /dao.rb:239:in `close': MySQL server has gone away (Mysql::Error) [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm /dao.rb:239:in `call_sql' [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm /dao.rb:327:in `does_user_exist?' [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /home/jonas/svn.openstreetmap.org/www.openstreetmap.org/ruby/api/osm /dao.rb:284:in `create_account' [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /home/jonas/svn.openstreetmap.org/www.openstreetmap.org/eruby/create -account.rhtml:61 [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from (eval):117 [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /usr/lib/ruby/1.8/apache/eruby-run.rb:116:in `run' [Sat Aug 26 15:07:49 2006] [error] mod_ruby: from /usr/lib/ruby/1.8/apache/eruby-run.rb:72:in `handler' Seem like there is some problem with the connection to mysql. The users table in the database is empty. My servinfo.rb looks like this: $DBSERVER = 'localhost' $DATABASE= 'osm' $USERNAME = 'root' $PASSWORD = 'password' $SERVER_NAME = '192.168.0.199' and there is a database osm in mysql. And no, I did not use password for password. :-) Btw, I have begun importing the planet-dump. Had to change a few ' to " in the perl script. If the import works I will try to check in that change. Seems like it will be a few hours... /Jonas

Next Message by Thread: click to view message preview

Re: [OSM-dev] set up test server

Hi, > Can I use planet2mysql.rb instead for this task? Would it use less > memory? planet2mysql.rb does use constant memory (about 4-5MB) regardless of the amount of data parsed. The disadvantage is, that it takes much longer. ;) Ciao, Imi

Loading Comments...