[postgis-users] postgis connection problem

[Chris Hodgson]

Does your postgres use have a password? (you have to include it in the
connection string)
Does mapserver give you an error message? (you can use shp2img to test it on
the console)
Also, the mappostgis.c file in the mapserver CVS has very verbose error
reporting, which would certainly help determine the cause of your problem -
I know that you can just replace the mapserver 3.6 mappostgis.c file with
the one in CVS (which is for 3.7) and then re-make it without any problems.

Chris

----- Original Message -----
From: "benedetto.porfidia" <porfidia at anpa.it>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, August 08, 2002 11:55 AM
Subject: [postgis-users] postgis connection problem


> Hi All
> I installed postgis 0.71 on postgrasql 7.2.1 and all works fine
> then installed mapserver 3.6.1 with the following config options:
> ./configure -prefix=/usr/local/mapserver-3.6.1/
> --with-proj=/home/porfidia/proj-4.4.5 --with-ogr
> --with-gdal=/usr/local/gdal-1.1.7/apps/gdal-config --with-wmsclient
> --with-postgis=/usr/local/pgsql/bin/pg_config
> and all seems good couse if tipe ./mapserv I get : This
> script...........
> but when I try to connect MS to Postgis with the following mapfile i
> can't get anything
> mapfile
> #
> #begin object map
> #
> NAME Postgis&postgreSQL
> UNITS meters
> EXTENT 0 4037663 1500000 5264500
> SIZE 640 480
> LAYER
> CONNECTIONTYPE postgis
> NAME "faults_it"
> # connect to a remote spatial db
> CONNECTION "user=postgres dbname=dbtest host=10.158.1.126 port=5432"
> # Get the lines from the 'geom' column of the 'faults_it' table
> DATA "the_geom from faults_it"
> STATUS ON
> TYPE LINE
> #Of the lines in the extents, only render all
> COLOR 255 22 22
> SYMBOL "solid"
> SIZE 4
> END
>
> postmaster runs with -i option
> and no error appears in terminal window
> where am I wrong
> Anyone can help me?
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>