Thanks for the info Jon. This was the info I needed. The tiles get generated correctly now. My install runs on a ubuntu gutsy server. The postgis.inputwas compiled as postgis.so.
John On Jan 29, 2008 11:54 PM, Jon Burgess <[EMAIL PROTECTED]> wrote: > > On Tue, 2008-01-29 at 23:08 +0100, John Wheeler wrote: > > Hi, > > > > I am trying to create my own tileserver to learn the tasks involved > > setting up a slippy map. So I managed to get osm2pgsl compiled and > > filled the postgresql gis database. Then I succeeded in getting mapnik > > generate some tiles for me! So far, so good. However, I used > > planet-latest.osm.bz2 and world_boundaries.tar.bz2, but the tiles > > generated and showing up in my browser show no roads and no cities at > > all. To generate the map I used the steps on the wiki. > > > > $ source ./set-mapnik-env > > $ ./customize-mapnik-map >$MAPNIK_MAP_FILE > > $ ./generate_tiles.py > > > > Can anyone point me the way how to fix this? > > > It sounds like you are failing to fetch any data from the database, this > could be for any number of reasons... > > - Verify you've got data in the Postgresql tables (if it took a few > hours to import then you probably do), e.g. > > gis=> select osm_id,astext(way) from planet_osm_point where amenity='pub' > limit 1; > osm_id | astext > ----------+------------------------------------------ > 26795285 | POINT(-13809852.0188925 5564541.1872538) > > > - Bad connection parameters, check the database name, table name, > username and password in the $MAPNIK_MAP_FILE (and the $MAPNIK_MAP_FILE > is the one actually being used by generate_tiles.py) > > - See also the Postgresql log files for things like... > FATAL: no pg_hba.conf entry for host "10.0.0.1", user "tile", database > "gis", SSL on > > - Check that Mapnik compiled the Postgis plugin, e.g. you should have > something like: > # ls -l /usr/local/lib/mapnik/input/postgis.input > -rwxr-xr-x 1 root root 163240 2008-01-25 21:28 > /usr/local/lib/mapnik/input/postgis.input > > - the user running the renderer must have permission to perform select() > on geometry_columns table in Postgres: > > gis=> select * from geometry_columns; > f_table_catalog | f_table_schema | f_table_name | f_geometry_column > | coord_dimension | srid | type > > -----------------+----------------+--------------------+-------------------+-----------------+--------+------------ > | public | planet_osm_point | way > | 2 | 900913 | POINT > | public | planet_osm_line | way > | 2 | 900913 | LINESTRING > | public | planet_osm_polygon | way > | 2 | 900913 | POLYGON > | public | planet_osm_roads | way > | 2 | 900913 | LINESTRING > (4 rows) > > > Jon > > >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
