[Live-demo] [OSGeo] #1059: gpsdrive's Mapnik doesn't start since stuff changed

[OSGeo]

#1059: gpsdrive's Mapnik doesn't start since stuff changed
---------------------+------------------------------------------------------
 Reporter:  hamish   |       Owner:  live-demo@…              
     Type:  defect   |      Status:  new                      
 Priority:  normal   |   Milestone:  OSGeoLive6.5             
Component:  LiveDVD  |    Keywords:  gpsdrive, postgis2, 6.5  
---------------------+------------------------------------------------------
 Hi,

 gpsdrive runs Mapnik to generate map tiles on-the-fly using the OSM data
 loaded into PostGIS and shapefiles from Natural Earth for the coastline,
 world city names, etc.

 This failed in beta1.iso (cleanly, it just reverts to static satellite
 image backdrop) since the shapefiles moved, specifically 10m_land.shp
 isn't where it used to be and had a name change. I've fixed those in SVN
 now, but the transition to PostGIS 2 now causes a crash:

 {{{
 terminate called after throwing an instance of
 'mapnik::datasource_exception'
   what():  :
 ERROR:  function asbinary(geometry) does not exist
 LINE 1: SELECT AsBinary("way") AS geom,"aeroway","amenity","building...
                ^
 HINT:  No function matches the given name and argument types. You might
 need to add explicit type casts.
 Full sql was: 'SELECT AsBinary("way") AS
 geom,"aeroway","amenity","building","highway",\
 "landuse","leisure","man_made","military","natural","power","railway","tourism"
 from \
  (select * from planet_osm_polygon order by z_order,way_area desc)\
  as leisure WHERE "way" && SetSRID('BOX3D(-134041.6 6972313.6,-130457.6
 6975180.799999999)'::box3d, 900913)'

 Aborted (core dumped)
 }}}

 hopefully a PostGIS expert can provide some tips, I'm not seeing any
 asbinary() or AsBinary() in the gpsdrive source code.

 http://gpsdrive.svn.sourceforge.net/viewvc/gpsdrive/trunk/src/database_postgis.c?revision=HEAD&view=markup

 http://gpsdrive.svn.sourceforge.net/viewvc/gpsdrive/trunk/src/database_postgis.h?revision=HEAD&view=markup


 in the mean time I've just set mapnik=0 in the ~/.gpsdrive rc file (see
 gisvm/bin/install_gpsdrive.sh) to disable mapnik mode.



 thanks for any pointers,
 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1059>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.