[mapserver-users] No Postgresql mapserver images

[Rahkonen Jukka]

Hi,

Feels odd, I have "listen_addresses = '*'  " in my PostgreSQL 9.2 postgresql.conf and Mapserver works as supposed. The wildcard * should include everything, including localhost.

It comes into my mind that sometimes I have had same kind of issues when creating configuration files by using copy-paste from PDF, Word, or OpenOffice documents. Some letters may not actually be the same as they look when they go via clipboard. I guess this has also something to do with the fonts. If you are curious you may try to change the configuration back with some plain text editor and by writing the asterisk * from the keyboard for making sure that it really is an asterisk.

-Jukka Rahkonen-


________________________________
Michael McInnis wrote:

> Dang, how embarrassing. Following some bad online examples I had the wrong setting in the postgresql.conf file
which when corrected enabled my mapserver to properly display postgresql geometry.

/etc/postgresql/9.1/main/postgresql.conf
I had :                                                              listen_addresses = '*'
which needed to be :                                      listen_addresses = 'localhost'

Thank you for all the helpful responses in debugging this.

Michael McInnis 6033 44th Ave. N.E. Seattle, WA 98115 206 517-4701

> Date: Sun, 28 Jul 2013 11:14:10 -0300
> From: jmckenna at gatewaygeomatics.com
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] No Postgresql mapserver images
>
> On 2013-07-26 8:01 PM, Michael McInnis wrote:
> > Problem: Although I can use my mapserver install to draw shapefile maps
> > I can’t draw maps from my postgres source. I can also display the
> > postgres points in QGIS so I’m not sure what the problem is in mapserver.
> >
> >
> >
> > Ideas? Thanks in Advance !
>
> When I'm in this position, the first thing I try is the exact function
> call (from your error message) through a psql commandline call to
> Postgres/PostGIS. Another thing to try is to duplicate this call
> through an ogrinfo commandline call to Postgres.
>
> -jeff
>
>
>
>
> --
> Jeff McKenna
> MapServer Consulting and Training Services
> http://www.gatewaygeomatics.com/
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users