That was sure tricky. Eventually the magical error I needed was deep in the postgres logs:
*** LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. WARNING: could not create listen socket for "localhost" FATAL: could not create any TCP/IP sockets *** Once I saw that I knew that it was not a role or missing db issue, it was the port (something else started to use port 5432 on this VM). I changed the postgres config for this instance to use 5433, then updated the mapfile, and all is fine again. I've recorded this change at http://wiki.osgeo.org/wiki/MapServer_at_AdhocVM To test this, click this link and go for a coffee (you can see why we seeded the cache! ha) http://demo.mapserver.org/cgi-bin/foss4g?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=OSM_Denver&STYLES=&SRS=EPSG:4326&BBOX=-105.208290,39.542378,-104.769779,39.980889&WIDTH=800&HEIGHT=800&FORMAT=image/png Night all, -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ On 2014-05-28, 5:26 PM, Rahkonen Jukka (Tike) wrote: > Hi Jeff, > > Sure it is advertised on the main page http://demo.mapserver.org. Try the > GetMap link on the row > > "WMS OpenStreetMap service (GetCapabilities) (GetMap) -used in OpenLayers map > on main site." > > -Jukka- > > Jeff McKenna wrote: > >> I think at one point that service was used to seed the cache for the >> OpenLayers/Mapcache demo on the main site (Denver OSM). But that WMS >> service is actually not advertized/published anywhere (the full list of >> active >> services is available at http://demo.mapserver.org/). >> >> -jeff >> >> >> -- >> Jeff McKenna >> MapServer Consulting and Training Services >> http://www.gatewaygeomatics.com/ >> >> >> >> On 2014-05-28, 2:45 PM, Rahkonen Jukka (Tike) wrote: >>> Hi Alex, >>> >>> PostgreSQL service on localhost, port 5432 does not accept connection from >> user "www-data" for database "osm". You can catch the error with this >>> >>> http://demo.mapserver.org/cgi- >> bin/foss4g?&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&LAYERS=OS >> M_Denver&STYLES=&CRS=EPSG:4326&BBOX=-105.208290,39.542378,- >> 104.769779,39.980889&WIDTH=800&HEIGHT=800&FORMAT=image/png >>> >>> -Jukka- >>> ________________________________________ >>> Alex Mandel wrote: >>> >>> On 05/28/2014 07:58 AM, Rahkonen Jukka (Tike) wrote: >>>> Hi, >>>> >>>> Mapserver demos at demo.mapserver.org do not work because the >> PostgreSQL on the same machine has been down for some days. Could someone >> try to restart the database service? >>>> >>>> -Jukka Rahkonen- >>> >>> Which demo/url are you specifically getting an error on? I'm not seeing >>> anything particularly wrong on the server. >>> >>> Thanks, >>> Alex >>> >> > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
