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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users