---------- 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? Kind regards, 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
