On 18 Mar 2008, at 14:02, ivom wrote: > > > ---------- Forwarded message ---------- > Date: Tue, 18 Mar 2008 13:22:47 +0100 (CET) > From: ivom <[EMAIL PROTECTED]> > To: Steve Hill <[EMAIL PROTECTED]> > Subject: Re: [Mapnik-users] Rendering osmdata > > Thanks for your reply Steve, > > I have enabled the following logging option for postgresql > log_connections = on in /etc/postgresql/8.2/main/postgresql.conf > and restarted > postgres > > when I do > $ echo "select count(*) from planet_osm_roads;" | psql gis > i see the following in /var/log/postgresql/postgresql-8.2-main.log: > 2008-03-18 13:14:05 CET [unknown]LOG: connection received: host= > [local] > 2008-03-18 13:14:05 CET ivomLOG: connection authorized: user=ivom > database=gis > > gues thats ok since on the client-side i see my query result. > > I have the following after sourcing set-mapnik-env: > MAPNIK_TILE_DIR=/home/ivom/mapnik/tiles/ > MAPNIK_DBPORT=5432 > MAPNIK_SYMBOLS_DIR=/usr/local/src/osmapps/rendering/mapnik/symbols > MAPNIK_DBPASS= > MAPNIK_MAP_FILE=/home/ivom/osm.xml > MAPNIK_WORLD_BOUNDARIES_DIR=/usr/local/src/osmapps/rendering/mapnik/ > world_boundaries > MAPNIK_DBNAME=gis > MAPNIK_DBHOST=localhost > MAPNIK_DBUSER=ivom > > i have genarated my osm.xml after that so the same settings have > landed in > there for Datasource type is postgres > > during the run of the standard generate_image.py i see no database > activity in > respect with logging. Is it correct to understand this as: mapnik > decides it is > not appropriate to contact the database? Or is it impossible to > contact the > database with the settings passed for the Datasource? The output > during the run > of generate_image.py remains amazingly silent (nothing). > > Is there a debug switch to get something from the mapnik libraries > to see what > it is doing in the direction of the postgres database?
How did you install Mapnik? Could you verify you have postgis.input (plug-in) ? You need postgresql-dev packages to build it. > > Kind regards, > Cheers Artem > On Tue, 18 Mar 2008, Steve Hill wrote: > >> On Mon, 17 Mar 2008, ivom wrote: >> >>> It is clear to me the >>> data does not get read from the database by mapnik when I run the >>> standard >>> generate_image.py. How can I best troubleshoot this problem? >> >> Did you put the right database name in set-mapnik-env (and source >> that >> script)? >> >> You might try turning postgres's logging on to see if mapnik is >> actually >> making queries (and see if they are sane). >> >> - Steve >> xmpp:[EMAIL PROTECTED] sip:[EMAIL PROTECTED] http:// >> www.nexusuk.org/ >> >> Servatis a periculum, servatis a maleficum - Whisper, Evanescence >> >> > _______________________________________________ > Mapnik-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/mapnik-users > _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
