[mapserver-users] mapserver6 (was 5) postgis connection problem

Fri May 27 02:18:13 PDT 2011

Sorry for wrong subject, I'm talking about mapserver6 here.

Ok, don't think it is a postgres/postgis problem...

Installed geoserver, and that is serving fine ....

Als0 tried mapserv from command line:
./mapserv -nh "QUERY_STRING=map=osmwm.map&mode=map" > /tmp/test11.png
also ok

mapfile snippet:

LAYER
    NAME test
    TYPE polygon
    STATUS default
    DEBUG 5
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=osm password=sssst user=geo"
    DATA "way28992 from (select * from landuse2) as foo using unique
osm_id using srid=28992"
    FILTER "landuse in ('industrial', 'residential')"
    METADATA
      "WMS_TITLE"                     "test"
      "WMS_SRS"                       "EPSG:28992"
      "OWS_EXTENT"                    "-26000 296000 293000 634000"
    END
    CLASS
    STYLE
      COLOR 255 0 0
    END
    STYLE
      OUTLINECOLOR 0 0 0
      WIDTH 3
      ANTIALIAS TRUE
    END
    END #CLASS
  END

On 05/26/2011 11:58 PM, Richard Duivenvoorde wrote:
> Like somebody else in the list I have a strange problem with MS6 on a
> fresh RHEL6 machine. Running the same data and mapfile in an older MS works.
> Below as much info I could get.
> Anybody a clue?
> I can recompile or add debug statements if nessecary (will be on irc
> tomorrow morning)
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> 
> I fail to get a postgres connection log somewhere on this machine...
> 
> a new installed RHEL6 machine:
> Red Hat Enterprise Linux Server release 6.0 (Santiago)
> 
> running
> "PostgreSQL 8.4.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
> 4.4.4 20100726 (Red Hat 4.4.4-13), 64-bit"
> and
> "1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
> 
> mapserver -v gives
> MapServer version 6.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
> SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
> SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> 
> I've done a gdal and mapserver compile myself
> 
> A database with OSM data and mapfile with connectionstring like:
> CONNECTION "host=localhost dbname=osm password=xxxx user=geo"
> keeps saying:
> Permission denied Is the server running on host "localhost" and
> accepting TCP/IP connections on port 5432? ) with connect string
> 'host=localhost dbname=osm password=******* user=geo'
> 
> while:
> - I can connect with that user/password via psql
> - can use shp2img and the same mapfile (generating a map)
> - can do
> ogrinfo -ro PG:'host=localhost user=geo password=xxxxxx dbname=osm' -sql
> "select count(*) from mytable"
> - even tried trust for all hosts in pg_hba.conf
> 
> setting debug in LAYER at 5
> 
> -- first part is from wms request (failing connection):
> [Thu May 26 23:45:30 2011].566614 msPostGISLayerOpen called: way28992
> from nl_osm_point using unique osm_id using srid=28992
> [Thu May 26 23:45:30 2011].566704 msPostGISLayerOpen: No connection in
> pool, creating a fresh one.
> [Thu May 26 23:45:30 2011].568103 msPostGISLayerOpen: Connection failure.
> [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error.
> Database connection failed (could not connect to server: Permission denied
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port 5432?
> could not connect to server: Permission denied
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port 5432?
> ) with connect string 'host=localhost dbname=osm password=******* user=geo'
> Is the database running? Is it allowing connections? Does the specified
> user exist? Is the password valid? Is the database on the standard port?
> [Thu May 26 23:45:30 2011].568138 msDrawMap(): Image handling error.
> Failed to draw layer named 'plaatsen'.
> [Thu May 26 23:45:30 2011].568224 msPostGISLayerClose called: way28992
> from nl_osm_point using unique osm_id using srid=28992
> [Thu May 26 23:45:30 2011].568238 freeLayer(): freeing layer at 0x1c67250.
> [Thu May 26 23:45:30 2011].568243 msPostGISLayerIsOpen called.
> [Thu May 26 23:45:30 2011].568251 freeLayer(): freeing layer at 0x1c6a7f0.
> [Thu May 26 23:45:30 2011].568255 msPostGISLayerIsOpen called.
> 
> -- This part is from shp2img (connection succesfull):
> [Thu May 26 23:47:55 2011].3388 msLayerIsVisible(): Skipping layer
> (plaatsen) because no CLASS in the layer is in-scale for this MAP scale
> [Thu May 26 23:47:55 2011].3450 msLayerIsVisible(): Skipping layer
> (plaatsen) because no CLASS in the layer is in-scale for this MAP scale
> [Thu May 26 23:47:55 2011].3457 msLayerIsVisible(): Skipping layer
> (plaatsen) because no CLASS in the layer is in-scale for this MAP scale
> [Thu May 26 23:47:55 2011].3470 msPostGISLayerOpen called: way28992 from
> (select way28992, z_order, landuse, osm_id, name from nl_osm_polygon
> order by z_order) as foo using unique osm_id using srid=28992
> [Thu May 26 23:47:55 2011].3478 msPostGISLayerOpen: No connection in
> pool, creating a fresh one.
> [Thu May 26 23:47:55 2011].16884
> msConnPoolRegister(residentialandindustry,host=localhost dbname=osm
> password=xxxx user=geo,0x18ff430)
> [Thu May 26 23:47:55 2011].27950 msPostGISLayerOpen: Got PostGIS version
> 10500.
> [Thu May 26 23:47:55 2011].27963 msPostGISLayerFreeItemInfo called.
> [Thu May 26 23:47:55 2011].27971 msPostGISLayerInitItemInfo called.
> [Thu May 26 23:47:55 2011].27986 msPostGISLayerWhichShapes called.
> [Thu May 26 23:47:55 2011].27992 msPostGISParseData called.
> [Thu May 26 23:47:55 2011].28008 msPostGISParseData:
> unique_column=osm_id, srid=28992, geom_column_name=way28992,
> table_name=(select way28992, z_order, landuse, osm_id, name from
> nl_osm_polygon order by z_order) as foo
> [Thu May 26 23:47:55 2011].28012 msPostGISBuildSQL called.
> [Thu May 26 23:47:55 2011].28016 msPostGISBuildSQLItems called.
> [Thu May 26 23:47:55 2011].28021 msPostGISBuildSQLItems: 2 items requested.
> [Thu May 26 23:47:55 2011].28025 msPostGISBuildSQLFrom called.
> [Thu May 26 23:47:55 2011].28031 msPostGISBuildSQLWhere called.
> [Thu May 26 23:47:55 2011].28034 msPostGISBuildSQLSRID called.
> [Thu May 26 23:47:55 2011].28038 msPostGISBuildSQLSRID: SRID provided
> (28992)
> [Thu May 26 23:47:55 2011].28041 msPostGISBuildSQLBox called.
> ...
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users