[OSM-dev] problem with mapnik

[Jon Burgess]

On Sun, 2010-03-28 at 22:38 +0200, Ruggero wrote:
> 2010/3/28 Lennard <ldp at xs4all.nl>:
> > Ruggero wrote:
> >
> > Replying to reply which went direct to me instead of dev@
> >
> >>> Update your stylesheet. You haven't done that in at least 7 months[1].
> >>> Be aware that osm.xml has changed substantially since that time, so be
> >>> sure to read the documentation again.
> >>>
> >>> [1] http://trac.openstreetmap.org/changeset/17301
> >>
> >> thanks, now an other problem:
> >>
> >> MAPNIK_MAP_FILE="osm.xml" MAPNIK_TILE_DIR="tiles/" ./generate_tiles.py
> >> RuntimeError: PSQL error:
> >> FATAL:  Ident authentication failed for user "ruggero" (encountered
> >> during parsing of layer 'leisure')
> >
> > Did you run generate_xml.py or manually edit
> > inc/datasource-settings.xml.inc ? Is your username and password in that
> > file?
> 
> I ran:
> 
> ./generate_xml.py --host localhost --user ruggero --dbname gis
> --symbols ./symbols/ --world_boundaries ./world_boundaries/ --port
> 5432 --password xyz
> 
> I triyed to change ruggero to 'ruggero', and so on, I changed ruggero
> with root, postgres, but nothing change. In
> inc/datasource-settings.xml.inc there are all my data:
> 
> <Parameter name="type">postgis</Parameter>
> <Parameter name="password">xyz</Parameter>
> <Parameter name="host">localhost</Parameter>
> <Parameter name="port">5432</Parameter>
> <Parameter name="user">ruggero</Parameter>
> <Parameter name="dbname">gis</Parameter>
> <!-- this should be 'false' if you are manually providing the 'extent' -->
> <Parameter name="estimate_extent">false</Parameter>
> <!-- manually provided extent in epsg 900913 for whole globe -->
> <!-- providing this speeds up Mapnik database queries -->
> <Parameter name="extent">-20037508,-19929239,20037508,19929239</Parameter>
> 
> thank you very much for help

On most Unix installs postgres is setup in the default configuration to
work using the 'ident same user' authentication. To use this you should
remove the following params from the config: user, port, host, password.
Delete all the parameter lines for these.

Then mapnik will connect the same way as if you ran "psql gis" from the
command line (without specifying a host, username or password).

	Jon