[mapserver-users] Mapserver / PostGIS Connection troubles

[Tyler Mitchell]

Be sure also to check out the mailing list archives at
postgis.refractions.net.
If all your CONNECTION information is correct, then the message "Error
parsing POSTGIS connection information" may actually be misleading.  I
think that the newer postgis releases give much more verbose error messages
now.

Here's what I suspect - does your web server "user" have select/read access
from the postgis database?
You may try the following in your postgis database and see if it helps:
>grant select on county to public;
>grant select on geometry_columns to public;

That was a big step for me :)


|---------+--------------------------------------->
|         |           "Lowther, David W"          |
|         |           <dlowther at ou.edu>           |
|         |           Sent by:                    |
|         |           owner-mapserver-users at lists.|
|         |           gis.umn.edu                 |
|         |                                       |
|         |                                       |
|         |           09/18/2002 07:05 AM         |
|         |                                       |
|---------+--------------------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |       To:       mapserver-users at lists.gis.umn.edu                                                                                                |
  |       cc:                                                                                                                                        |
  |       Fax to:                                                                                                                                    |
  |       Subject:  [mapserver-users] Mapserver / PostGIS Connection troubles                                                                        |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|




I am trying to set up postgres/Postgis and set up mapserver and enable web
mapping here...
We have Mapserver with postGIS support on a IIS/NT machine webserver, and,
Postgresql and postgis configured on a windows 2000 workstation. When
trying
to get mapserver work with this setup as per instructions on this page,
http://postgis.refractions.net/docs/x444.html...
We are getting a, "msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS
connection information."
Dont find answers for this behavior..Has anyone come across this problem
before? and can help?

The Layer is defined in the mapfile as follows:


LAYER
    CONNECTIONTYPE postgis
    NAME "cnty_poly"
    CONNECTION "user=****** password=****** dbname=DW hostname=**IPADD***
port=5432"
    DATA "the_geom from county"
    STATUS DEFAULT
    TYPE POLYGON
     CLASS
                 OUTLINECOLOR 128 128 128
                 COLOR 255 255 255
                 SIZE 2
    END
END



David Lowther
Software Engineer
GEO Information Systems
dlowther at ou.edu
(405) 325-3131
http://www.geo.ou.edu