<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt">Thanks for the replies,<br><br>Mapnik is working as generate_image works fine. It is definitely database access that is the problem. <br><br><br>gis=# select count(*) from planet_osm_point;<br> count<br>-------<br> 20753<br>(1 row)<br><br>gis=# select count(*) from planet_osm_roads;<br> count<br>-------<br> 31929<br>(1 row)<br><br><br><br>I have tried to run as root and as su- postgres and the same each time.<br><br>I changed the port and that had no effect<br><br>I ran postmaster with debug 5 and run never saw a connection. I ran psql and saw loads of connection info in the postmaster log. Is there a password field in osm.xml schema?<br><br>Is there a remote postgresql I could use to check if the maps work at least.<br><br>BTW, I just found the form. Should I use
that instead of this list?<br><br>Thanks<br><br>Diarmuid<br><br><br><br><div> </div>NOTICE: The information contained in this e-mail message and any attached files may be confidential information. If you are not the intended recipient, any use, disclosure or copying of this e-mail and any attached files is unauthorised. If you have received this e-mail in error, please notify me immediately by reply e-mail and delete the original.<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Jon Burgess <jburgess777@googlemail.com><br>To: Diarmuid Wrenne <dwrenne@yahoo.com><br>Cc: dev@openstreetmap.org<br>Sent: Monday, December 10, 2007 9:57:31 PM<br>Subject: Re: [OSM-dev] Populating the database<br><br>
<br>On Mon, 2007-12-10 at 12:38 -0800, Diarmuid Wrenne wrote:<br>> Hi,<br>> <br>> I am having problems populating the database. I have downloaded the<br>> data from <a href="http://download.geofabrik.de/osm/europe/" target="_blank">http://download.geofabrik.de/osm/europe/</a> and extracted<br>> it. I have created a postgresql database and created the schema as
per<br>> <a href="http://www.passback.org.uk/maps/fedora.shtml" target="_blank">http://www.passback.org.uk/maps/fedora.shtml</a><br>> <br>> I have modified the original big osm.xml to reflect the database<br>> setup.<br>> <br>> <Layer name="text" status="on" srs="+proj=merc +datum=WGS84 +k=1.0<br>> +units=m +over +no_defs"><br>> <StyleName>text</StyleName><br>> <Datasource><br>> <Parameter name="type">postgis</Parameter><br>> <Parameter name="host">localhost</Parameter><br>> <Parameter name="port">5433</Parameter> <br>> <Parameter name="user">apache</Parameter><br>> <Parameter name="dbname">gis</Parameter><br>> <Parameter
name="table">planet_osm_point</Parameter><br>> <Parameter name="estimate_extent">true</Parameter><br>> </Datasource><br>> </Layer><br>> <br>> I am<br>> running
/mnt/svn.openstreetmap.org/applications/utils/export/osm2pgsql/osm2pgsql -c -v /mnt/spatialdata/france.osm and getting<br>> <br>> <br>> Using projection SRS 3395 (WGS84 Mercator)<br>> Setting up table: planet_osm_point<br>> Setting up table: planet_osm_line<br>> Setting up table: planet_osm_polygon<br>> Setting up table: planet_osm_roads<br>> <br>> Reading in file: /mnt/spatialdata/france.osm<br>> Processing: Node(1012k) Way(97k) Relation(0k)<br>> Writing rel(0k)<br>> <br>> Writing way(8k)<br>> <br>> Node stats: total(1012818), max(157452867)<br>> Way stats: total(97612), max(15739751)<br>> Relation stats: total(97), max(3506)<br>> <br>> echo 'select count(*) from planet_osm_point;' | psql gis<br>> count<br>> -------<br>> 20753<br>> (1 row)<br>> <br>> However when I run <a target="_blank" href="http://Generate_tiles.py">Generate_tiles.py</a> I get no road data.
<br>> <br>> Any ideas<br><br>Unfortunately debugging why Mapnik fails to render data can be tricky
at<br>the best of times since it rarely produces useful error messages (it<br>just tends to carry on and ignore the data source).<br><br><br>> <Parameter name="type">postgis</Parameter><br>> <Parameter name="host">localhost</Parameter><br>> <Parameter name="port">5433</Parameter> <br>> <Parameter name="user">apache</Parameter><br>> <br><br>It is quite likely that your Postgres setup will not allow a connection<br>via localhost with no password. On Fedora you can typically avoid this<br>by setting:<br><br><Parameter name="host">/tmp</Parameter><br><br>This will force the client to connect via a Unix domain socket instead<br>of an IP socket and will typically avoid needing to specify any user<br>name, password or port number. <br><br>The equivalent data source in my local osm.xml file
has simply...<br><br> <Layer name="text" status="on" srs="+proj=merc +datum=WGS84 +k=1.0
+units=m +over +no_defs"><br> <StyleName>text</StyleName><br> <Datasource><br> <Parameter name="type">postgis</Parameter><br> <Parameter name="host">/tmp</Parameter><br> <Parameter name="dbname">gis</Parameter><br> <Parameter name="table">planet_osm_point</Parameter><br> <Parameter name="estimate_extent">true</Parameter><br> </Datasource><br> </Layer><br><br>Other distros setup the Postgres unix socket in other locations<br>(/var/run/postgresql is used by Debian/Ubuntu).<br><br>You might also find that changing the estimate_extent parameter to
false<br>is needed (this depends on you mapnik version and the data you have<br>loaded):<br><br> <Parameter name="estimate_extent">false</Parameter><br><br>If all that fails, try recompiling mapnik with DEBUG=1 set. Then when<br>you run the script you will get lots of debug information about what it<br>is doing on stdout/stderr.<br><br> Jon<br><br><br><br></div><br></div></div><br>
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a></body></html>