Parveen,<div>It sounds as though either the osm2pgsql import did not work, or you imported the data into a different database to the one mapnik is using (I did that once and got very confused...).</div><div><br></div><div>
I would check what is in your database with a few simple queries from the command line.</div><div>Try:</div><div>psql -d gis <assuming gis is the database you used for the osm2pgsql import></div><div>\d</div><div>
<br></div><div>\d should list all the tables in the database - on my computer I get:</div><div><div> List of relations</div><div> Schema | Name | Type | Owner </div><div>--------+--------------------+----------+--------</div>
<div> public | contours | table | graham</div><div> public | contours_gid_seq | sequence | graham</div><div> public | geometry_columns | table | graham</div><div> public | planet_osm_line | table | graham</div>
<div> public | planet_osm_nodes | table | graham</div><div> public | planet_osm_point | table | graham</div><div> public | planet_osm_polygon | table | graham</div><div> public | planet_osm_rels | table | graham</div>
<div> public | planet_osm_roads | table | graham</div><div> public | planet_osm_ways | table | graham</div><div> public | spatial_ref_sys | table | graham</div><div>(11 rows)</div></div><div><br></div><div>
(but you will not have the contours ones).</div><div><br></div><div>If you do not have something like this, then osm2pgsql has failed - I would try the import again with a very small area - just download a bit of a local town and import that so it is quicker than a whole country - and look out for any errors.</div>
<div><br></div><div>If the tables do exist you can do some simple queries like:</div><div>select osm_id,name from planet_osm_polygon where leisure='playground';</div><div><br></div><div>to see if the data looks reasonable.</div>
<div><br></div><div>Regards</div><div><br></div><div><br></div><div>Graham.</div><div><br><br><div class="gmail_quote">On 30 January 2011 08:58, Parveen Arora <span dir="ltr"><<a href="mailto:parveenaroraosm@gmail.com">parveenaroraosm@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Sun, Jan 30, 2011 at 2:01 PM, H.S.Rai <<a href="mailto:hardeep.rai@gmail.com">hardeep.rai@gmail.com</a>> wrote:<br>
> On Sun, Jan 30, 2011 at 12:50 PM, Parveen Arora<br>
> <<a href="mailto:parveenaroraosm@gmail.com">parveenaroraosm@gmail.com</a>> wrote:<br>
>> On Sun, Jan 30, 2011 at 12:46 PM, yvecai <<a href="mailto:yvecai@gmail.com">yvecai@gmail.com</a>> wrote:<br>
>>> Try:<br>
>>><br>
>>> $./generate_xml.py osm.xml --dbname gis --user parveen --accept-none<br>
>><br>
>> $./generate_xml.py --dbname gis --user username --accept-none<br>
>> ran successfully<br>
>> but<br>
>> $./generate_image.py is giving error:<br>
>><br>
>> Traceback (most recent call last):<br>
>> File "./generate_image.py", line 37, in <module><br>
>> mapnik.load_map(m,mapfile)<br>
>> RuntimeError: PSQL error:<br>
>> FATAL: Ident authentication failed for user "parveen" (encountered<br>
>> during parsing of layer 'leisure')<br>
><br>
> Authentication issue.<br>
</div>Sir I am using Super user<br>
<div class="im"><br>
> Visit: <a href="http://wiki.openstreetmap.org/wiki/Mapnik" target="_blank">http://wiki.openstreetmap.org/wiki/Mapnik</a> and search for<br>
> "authentication failed for user".<br>
</div>I have followed it still following problem in<br>
./genrate_image<br>
<div class="im"><br>
Traceback (most recent call last):<br>
File "./generate_image.py", line 37, in <module><br>
mapnik.load_map(m,mapfile)<br>
RuntimeError: PSQL error:<br>
</div>ERROR: relation "planet_osm_polygon" does not exist<br>
LINE 4: from planet_osm_polygon<br>
^<br>
Full sql was: 'select * from<br>
(select way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name,highway,<br>
case when religion in ('christian','jewish') then religion else<br>
'INT-generic'::text end as religion<br>
from planet_osm_polygon<br>
where landuse is not null<br>
or leisure is not null<br>
or aeroway in ('apron','aerodrome')<br>
or amenity in<br>
('parking','university','college','school','hospital','kindergarten','grave_yard')<br>
or military in ('barracks','danger_area')<br>
or "natural" in ('field','beach','desert','heath','mud','wood','sand')<br>
or power in ('station','sub_station','generator')<br>
or tourism in<br>
('attraction','camp_site','caravan_site','picnic_site','zoo')<br>
or highway in ('services','rest_area')<br>
order by z_order,way_area desc<br>
) as leisure<br>
limit 0'<br>
<div class="im"> (encountered during parsing of layer 'leisure')<br>
<br>
</div>Is there any problem in data file which I have for India<br>
Last time there was some problem in that file so that was not working<br>
--<br>
With Kind Regards<br>
<font color="#888888">Parveen Arora<br>
</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
dev mailing list<br>
<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/dev" target="_blank">http://lists.openstreetmap.org/listinfo/dev</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Graham Jones<div>Hartlepool, UK.</div><br>
</div>