Hi

Over the past couple of weeks I've been trying to get Mapnik up and
running on Windows, initially Vista, now Windows 7. After much trial and
error I've got OSM data into the database
- install Postgres (8.3)/PostGIS (1.4.0)
- install Python (2.5) & Perl
- install osm2pgsql & Mapnik (0.6.1)
- load OSM data to database gis (user brennant, no password) using osm2pgsql
- download and extract world boundaries, shoreline etc shapefiles
- create/run set-mapnik-env.bat, run customize-mapnik-map to make
osm.xml, and edit to fix up Windows related issues

For the past several days I have been trying to run generate_image.py. I 
am getting a plain blue image output. It is not throwing any errors, but 
if I check the Postgres log there are failures connecting to the database.

2009-12-01 22:47:49 ESTLOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.
2009-12-01 22:47:49 ESTLOG:  unexpected EOF on client connection

This is odd as I have no problem connecting to the database using
osm2pgsql. How does the Mapnik connection to the database differ from
the osm2pgsql connection, and are there any bits of config I should be
looking out for?


FWIW, relevant bits of the path are
PATH=C:\Program Files
(x86)\PostgreSQL\8.3\bin;c:\osm2pgsql;C:\dev\python25;c:\mapnik_0_6_1\li
b;C:\strawberry\c\bin;C:\strawberry\perl\bin;

pg_hba.conf
-----------
local    all     all     trust
host     all     all     127.0.0.1/32    trust
host     all     all     ::1/128         trust

Sample extract from osm.xml below

<Layer name="land features" status="on" srs="+proj=merc +a=6378137
+b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m
+nadgri...@null +no_defs +over">
      <StyleName>piers</StyleName>
      <Datasource>
       <Parameter name="type">postgis</Parameter>
       <Parameter name="host">localhost</Parameter>
       <Parameter name="port">5432</Parameter>
       <Parameter name="user">brennant</Parameter>
       <Parameter name="password"></Parameter>
       <Parameter name="dbname">gis</Parameter>
       <Parameter name="table">
       (select way from planet_osm_line where man_made='pier') as piers
       </Parameter>
       <Parameter name="estimate_extent">false</Parameter>
       <Parameter
name="extent">-20037508,-19929239,20037508,19929239</Parameter>
     </Datasource>
</Layer>

While I know Windows is not the OS of choice around here, hopefully
someone can offer some suggestions, as the primary problem seems to be
the Python scripts talking to Postgres/PostGIS.

Secondary question is - why would I get a plain blue file? I would have
thought that the coastline would generate as it's stored in the
world_boundaries directory, not in the database.

thanks
-- 
----
[email protected]
Canyoning? try http://ozultimate.com/canyoning
Bushwalking? try http://ozultimate.com/bushwalking

_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users

Reply via email to