[mapserver-users] PostgreSQL on demo.mapserver.org down

[Jeff McKenna]

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
>>>
>>
>