Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
8 hours and 800 commands later ... Reformatted the computer, reinstalled Ubuntu 11.04, ran the FULL set of commands from the wiki, downloading the 500MB of coastline data, and adding my login name to the db permissions. Ran the database import, checked that the data was in the tables. Still nothing. The server works with the mapnik data, but can't get anything at all when I select local tiles. These script will be probably useful to make it working. $ sudo -u postgres psql -d dbname -c ALTER TABLE geometry_columns OWNER TO username $ sudo -u postgres psql -d dbname -c ALTER TABLE spatial_ref_sys OWNER TO username This is included in the setup scripts. Tables are owned correctly. The 900913 is not normally included with postgis. To add it you should run: $ sudo -u postgres psql -d dbname -f 900913.sql This too is already included. Data is already in the database as checked by gis=# SELECT * FROM spatial_ref_sys WHERE srid=900913; If you want to use hstore support then you will also need to enable the PostgreSQL hstore-new extension. That has also been done already by the setup script. Is there any way I can check what's going on? Apache logs show nothing. renderd is running OK. A bit stuck here ... Jim -- datalude: information security e: j...@datalude.com Philippines: +63 2 403 1311 / mob: +63 917 849 3939 Hong Kong: +852 6840 6693 w: http://www.datalude.com/ ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
But wait ... Although the web-page doesn't show any tiles http://localtileserver/osm/slippymap.html ... the individual tiles are being generated ... http://localtileserver/osm/11/1712/949.png Its a bit slow, but it is working ... don't know why the webpage won't load any tiles ... OK, I'll play with it for a bit. Jim Jim Morgan wrote, On Wednesday, 12 October, 2011 03:06 PM: 8 hours and 800 commands later ... Reformatted the computer, reinstalled Ubuntu 11.04, ran the FULL set of commands from the wiki, downloading the 500MB of coastline data, and adding my login name to the db permissions. Ran the database import, checked that the data was in the tables. Still nothing. The server works with the mapnik data, but can't get anything at all when I select local tiles. These script will be probably useful to make it working. $ sudo -u postgres psql -d dbname -c ALTER TABLE geometry_columns OWNER TO username $ sudo -u postgres psql -d dbname -c ALTER TABLE spatial_ref_sys OWNER TO username This is included in the setup scripts. Tables are owned correctly. The 900913 is not normally included with postgis. To add it you should run: $ sudo -u postgres psql -d dbname -f 900913.sql This too is already included. Data is already in the database as checked by gis=# SELECT * FROM spatial_ref_sys WHERE srid=900913; If you want to use hstore support then you will also need to enable the PostgreSQL hstore-new extension. That has also been done already by the setup script. Is there any way I can check what's going on? Apache logs show nothing. renderd is running OK. A bit stuck here ... Jim -- datalude: information security e: j...@datalude.com Philippines: +63 2 403 1311 / mob: +63 917 849 3939 Hong Kong: +852 6840 6693 w: http://www.datalude.com/ ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
So after 3 hours, did it work jim? I think that's the easy bit now. What's even more difficult is tweaking the default style to your own preference. OSM's mapnik xml is really ginormous. That would probably take me more than a week to understand. I do hope the carto css gets into the stable release soon. Just compare how much easier to style the map with css: http://mapnik.org/news/2011/sep/07/carto_parser_wrapup/ On Mon, Oct 10, 2011 at 8:03 PM, Jim Morgan j...@datalude.com wrote: his sounded so good, I thought I'd give it a go this afternoon. However the commands given as typed in the email don't work. I'd recommend reading the long version at the wiki page he references later on: http://wiki.openstreetmap.org/wiki/Ubuntu_tile_server Specifically I found these problems: - After adding the repository, you need to do an 'apt-get update' before the next step. - Very IMPORTANT. He doesn't mention the configuration step after installing libapache2-mod-tile. According to the wiki you need to add your own username after www-data in order to import data. As I didn't do this, the renderer did not work. I've also spent about two hours trying to re-configure this setting, and can't find out how to do it. So, yes, read the wiki first. - The osm2pgsql misses out the --slim command line element. I also found that I needed to reduce the memory usage, having only 1Gb in my laptop. The --verbose helped as well. so: osm2pgsql --slim --cache 300 --verbose philippines.osm.pbm So what could have been a five minute wonder install has now turned into a three hour marathon for me due to bad instructions. Read the wiki. -- cheers, maning -- Freedom is still the most radical idea of all -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ -- ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
maning sambale wrote, On Tuesday, 11 October, 2011 03:30 PM: So after 3 hours, did it work jim? I think that's the easy bit now. What's even more difficult is tweaking the default style to your own preference. OSM's mapnik xml is really ginormous. That would probably take me more than a week to understand. Nope. Not working after 5 hours and 500 commands even ... gave up about 8pm last night. Not sure if it was missing the step of putting my username in the setup script which meant it doesn't work, or something else. But as I can't get postgresql to remove and reinstall properly, there's no way I can tell. I'm thinking it will be quicker to reinstall the OS fresh and start from there. Sigh. Wish I'd done it in a VM now ... Jim -- datalude: information security e: j...@datalude.com Philippines: +63 2 403 1311 / mob: +63 917 849 3939 Hong Kong: +852 6840 6693 w: http://www.datalude.com/ ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
Not sure if it was missing the step of putting my username in the setup script which meant it doesn't work, or something else. But as I can't get postgresql to remove and reinstall properly, there's no way I can tell. I'm thinking it will be quicker to reinstall the OS fresh and start from there. Sigh. Wish I'd done it in a VM now ... I think osm2pgsql ReadMe would be helpful to make PostgreSQL / PostGIS working. https://github.com/openstreetmap/osm2pgsql These script will be probably useful to make it working. $ sudo -u postgres psql -d dbname -c ALTER TABLE geometry_columns OWNER TO username $ sudo -u postgres psql -d dbname -c ALTER TABLE spatial_ref_sys OWNER TO username The 900913 is not normally included with postgis. To add it you should run: $ sudo -u postgres psql -d dbname -f 900913.sql If you want to use hstore support then you will also need to enable the PostgreSQL hstore-new extension. $ sudo -u postgres psql dbname /usr/share/postgresql/8.4/contrib/hstore.sql Noli ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
This sounded so good, I thought I'd give it a go this afternoon. However the commands given as typed in the email don't work. I'd recommend reading the long version at the wiki page he references later on: http://wiki.openstreetmap.org/wiki/Ubuntu_tile_server Specifically I found these problems: - After adding the repository, you need to do an 'apt-get update' before the next step. - Very IMPORTANT. He doesn't mention the configuration step after installing libapache2-mod-tile. According to the wiki you need to add your own username after www-data in order to import data. As I didn't do this, the renderer did not work. I've also spent about two hours trying to re-configure this setting, and can't find out how to do it. So, yes, read the wiki first. - The osm2pgsql misses out the --slim command line element. I also found that I needed to reduce the memory usage, having only 1Gb in my laptop. The --verbose helped as well. so: osm2pgsql --slim --cache 300 --verbose philippines.osm.pbm So what could have been a five minute wonder install has now turned into a three hour marathon for me due to bad instructions. Read the wiki. Jim Eugene Alvin Villar wrote, On Monday, 10 October, 2011 07:07 AM: Hi guys, This sounds interesting. Rendering and making tiles just for the Philippines is viable on a desktop or even a laptop since the PBF file for the country is only 27 MB. Eugene -- Forwarded message -- From: *Kai Krueger* kakrue...@gmail.com mailto:kakrue...@gmail.com Date: Mon, Oct 10, 2011 at 6:13 AM Subject: [OSM-talk] Installing your own tileserver on Ubuntu To: t...@openstreetmap.org mailto:t...@openstreetmap.org Hello everyone, with the recent need to crack down on tile scrapers and apps to not over tax the main OSM tileservers and hosting, there has been a lot of talk trying to convince people to set up their own tileserver. Although that is of cause by far not the only hurdle to set up your own tileserver, one barrier is perhaps the perceived complicated procedure to set up all the elements necessary. Although there are a number of decent howtos already available on the wiki (perhaps even to many, each containing slightly different advice...), it is perhaps still more effort than people want to get into. In the hope to make this process even simpler, I have created a bunch of packages for Ubuntu containing all the necessary software, as well as glue packages to deal with the necessary setup and interaction between the different components. The packages aren't perfect yet, but hopefully sufficiently helpful already to be of use to others who are interested in playing around with their own tileserver. A simple standard tileserver can now be setup in 5 commands in a terminal: sudo add-apt-repository ppa:kakrueger/openstreetmap sudo apt-get install libapache2-mod-tile wget http://download.geofabrik.de/osm/north-america/us/colorado.osm.pbf osm2pgsql http://download.geofabrik.de/osm/north-america/us/colorado.osm.pbf%0Aosm2pgsql -C 1500 colorado.osm.pbf sudo /etc/init.d/renderd restart At the end you should have a working tileserver based on mod_tile and renderd with the standerd OSM-mapnik stylesheet. You can test it out by opening the installed slippymap at http://localhost/osm/slippymap.html You will of cause want to replace the above lines with the downloading and importing of an extract with the extract you care about. Although for smaller areas hardware requirements aren't too bad, they quickly go up beyond what can be handled by a standard desktop computer. My rough guestimate of what a typical desktop / laptop can handle is about an extract of 100 - 300 Mb (no more than an hours worth of import). This covers most of the US and German states, as well as many of the other less densely mapped countries. If you are more serious about your tileserver, you will need to tune the various configuration settings, but just to play around and for personal use, the default settings should work reasonable. More information can be found on yet another wiki-page... ( http://wiki.openstreetmap.org/wiki/Ubuntu_tile_server ) Any comments or feedback are welcome, Kai ___ talk mailing list t...@openstreetmap.org mailto:t...@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk -- http://vaes9.codedgraphic.com ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph -- datalude: information security e: j...@datalude.com Philippines: +63 2 403 1311 / mob: +63 917 849 3939 Hong Kong: +852 6840 6693 w: http://www.datalude.com/ ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph
Re: [talk-ph] Fwd: [OSM-talk] Installing your own tileserver on Ubuntu
Wow. 5 steps to setup tileserver in Ubuntu. I took me last Saturday and Sunday just to setup PostGIS and move OSM data (Australia.osm.pdf) using osm2pgsql and still have problem rendering it to TileMill in Mac OS X. Postgresql and PostGIS are not so good in Mac OS X at the moment, problem in finding the postgresql database data. If you want a different theme you can use this osm-hybrid-carto for TileMill. https://github.com/andrewharvey/osm-hybrid-carto OSM-Ph can probably sell services to local governments (towns and barangays) in creating custom maps (digital and hardcopy). It is good fund raising. Noli On 10/10/11, Eugene Alvin Villar sea...@gmail.com wrote: Hi guys, This sounds interesting. Rendering and making tiles just for the Philippines is viable on a desktop or even a laptop since the PBF file for the country is only 27 MB. Eugene -- Forwarded message -- From: Kai Krueger kakrue...@gmail.com Date: Mon, Oct 10, 2011 at 6:13 AM Subject: [OSM-talk] Installing your own tileserver on Ubuntu To: t...@openstreetmap.org Hello everyone, with the recent need to crack down on tile scrapers and apps to not over tax the main OSM tileservers and hosting, there has been a lot of talk trying to convince people to set up their own tileserver. Although that is of cause by far not the only hurdle to set up your own tileserver, one barrier is perhaps the perceived complicated procedure to set up all the elements necessary. Although there are a number of decent howtos already available on the wiki (perhaps even to many, each containing slightly different advice...), it is perhaps still more effort than people want to get into. In the hope to make this process even simpler, I have created a bunch of packages for Ubuntu containing all the necessary software, as well as glue packages to deal with the necessary setup and interaction between the different components. The packages aren't perfect yet, but hopefully sufficiently helpful already to be of use to others who are interested in playing around with their own tileserver. A simple standard tileserver can now be setup in 5 commands in a terminal: sudo add-apt-repository ppa:kakrueger/openstreetmap sudo apt-get install libapache2-mod-tile wget http://download.geofabrik.de/osm/north-america/us/colorado.osm.pbf osm2pgsql -C 1500 colorado.osm.pbf sudo /etc/init.d/renderd restart At the end you should have a working tileserver based on mod_tile and renderd with the standerd OSM-mapnik stylesheet. You can test it out by opening the installed slippymap at http://localhost/osm/slippymap.html You will of cause want to replace the above lines with the downloading and importing of an extract with the extract you care about. Although for smaller areas hardware requirements aren't too bad, they quickly go up beyond what can be handled by a standard desktop computer. My rough guestimate of what a typical desktop / laptop can handle is about an extract of 100 - 300 Mb (no more than an hours worth of import). This covers most of the US and German states, as well as many of the other less densely mapped countries. If you are more serious about your tileserver, you will need to tune the various configuration settings, but just to play around and for personal use, the default settings should work reasonable. More information can be found on yet another wiki-page... ( http://wiki.openstreetmap.org/wiki/Ubuntu_tile_server ) Any comments or feedback are welcome, Kai ___ talk mailing list t...@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk -- http://vaes9.codedgraphic.com ___ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph