[Mapserver-users] problem with mapserver4 and postgres

Tue Sep 30 22:09:29 PDT 2003

--0-619328017-1064984969=:21616
Content-Type: text/plain; charset=us-ascii

Has the db changed at all? Make sure the (column) f_geometry_column in the geometry_columns (table) points to the correct column name with the geometry column in the table you want to open "ejes_calles" . Pgadmin II make doing this easy.

collao_andres <collao_andres at hotmail.com> wrote:hello I have compiled to mapserver 4, and I can use LABEL and SHAPE 
without problems, but when trying to read from the data base in 
Postgres 7.3.2/PostGIS 0,7,5 does not show respective layer. I have 
tried of everything, but nothing seems to give result; only stranger 
who happens is that when making this consultation in postgres appears 
the following message

parse error at or near "geom" at character

in the past, this aplication run without problem over mapserver 3.6.6 
and when start with version 4 I modified the Mapfile 

You have any idea??

MAP
NAME "FIRSTMAP"
STATUS ON
#EXTENT -5696501 1923039 5696501 11022882
EXTENT 251537 6338840 258665 6344780 
SIZE 400 400 
SHAPEPATH "/usr/local/apache2/htdocs/alberto/"
IMAGETYPE png
IMAGECOLOR 255 255 255
UNITS METERS
WEB
IMAGEPATH "/usr/local/apache2/htdocs/tmp/"
IMAGEURL "/tmp/"
END
OUTPUTFORMAT
NAME "png"
MIMETYPE "image/png"
DRIVER "GD/PNG"
EXTENSION "png"
IMAGEMODE PC256
TRANSPARENT FALSE
END

PROJECTION
"proj=utm"
"zone=19"
"south"
"ellps=intl"
"towgs84=-288,175,-376,0,0,0,0"
"units=m"
"no_defs"
END
LAYER
NAME "SAMPLE GRID"
PROJECTION
"proj=utm"
"zone=19"
"south"
"ellps=intl"
"towgs84=-288,175,-376,0,0,0,0"
"units=m"
"no_defs"
END
TYPE LINE
STATUS ON
CLASS
COLOR 255 255 128
LABEL
TYPE BITMAP
SIZE MEDIUM
COLOR 255 100 50
END
END

GRID
MINSUBDIVIDE 64
MAXSUBDIVIDE 64
#ABELFORMAT "DDMM"
END
END
LAYER
NAME "ssd"
STATUS ON
DATA "comunas"
TYPE POLYGON
UNITS METERS
SIZEUNITS PIXELS
TOLERANCE 0
TOLERANCEUNITS PIXELS
CLASS
TEMPLATE "void"
STYLE
SYMBOL 0
COLOR 255 255 255
OUTLINECOLOR 200 200 200
SIZE 1
MINSIZE 1
MAXSIZE 100
END
END
END
LAYER
NAME "ejes_calles"
STATUS ON
DATA "the_geom from ejes_calles"
TYPE LINE
CONNECTIONTYPE POSTGIS
CONNECTION "user=admin password=admin dbname=valparaiso 
host=localhost port=5432"
UNITS METERS
SIZEUNITS METERS
TOLERANCE 0
TOLERANCEUNITS PIXELS
CLASS
NAME "calles_zoom_5"
STYLE
#SYMBOL 0
COLOR 0 0 0
SIZE 10
END
END
END
END

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--0-619328017-1064984969=:21616
Content-Type: text/html; charset=us-ascii

<DIV>Has the db changed at all? Make sure the (column) f_geometry_column in the geometry_columns (table) points to the correct column name with the geometry column in the table you want to open "ejes_calles" . Pgadmin II make doing this easy.<BR><BR><B><I>collao_andres <collao_andres at hotmail.com></I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">hello I have compiled to mapserver 4, and I can use LABEL and SHAPE <BR>without problems, but when trying to read from the data base in <BR>Postgres 7.3.2/PostGIS 0,7,5 does not show respective layer. I have <BR>tried of everything, but nothing seems to give result; only stranger <BR>who happens is that when making this consultation in postgres appears <BR>the following message<BR><BR>parse error at or near "geom" at character<BR><BR>in the past, this aplication run without problem over mapserver 3.6.6 <BR>and when start with version 4 I modified the Mapfile <BR><BR>You have any idea??<BR><BR>MAP<BR>NAME "FIRSTMAP"<BR>STATUS ON<BR>#EXTENT -5696501 1923039 5696501 11022882<BR>EXTENT 251537 6338840 258665 6344780 <BR>SIZE 400 400 <BR>SHAPEPATH "/usr/local/apache2/htdocs/alberto/"<BR>IMAGETYPE png<BR>IMAGECOLOR 255 255 255<BR>UNITS METERS<BR>WEB<BR>IMAGEPATH
 "/usr/local/apache2/htdocs/tmp/"<BR>IMAGEURL "/tmp/"<BR>END<BR>OUTPUTFORMAT<BR>NAME "png"<BR>MIMETYPE "image/png"<BR>DRIVER "GD/PNG"<BR>EXTENSION "png"<BR>IMAGEMODE PC256<BR>TRANSPARENT FALSE<BR>END<BR><BR>PROJECTION<BR>"proj=utm"<BR>"zone=19"<BR>"south"<BR>"ellps=intl"<BR>"towgs84=-288,175,-376,0,0,0,0"<BR>"units=m"<BR>"no_defs"<BR>END<BR>LAYER<BR>NAME "SAMPLE GRID"<BR>PROJECTION<BR>"proj=utm"<BR>"zone=19"<BR>"south"<BR>"ellps=intl"<BR>"towgs84=-288,175,-376,0,0,0,0"<BR>"units=m"<BR>"no_defs"<BR>END<BR>TYPE LINE<BR>STATUS ON<BR>CLASS<BR>COLOR 255 255 128<BR>LABEL<BR>TYPE BITMAP<BR>SIZE MEDIUM<BR>COLOR 255 100 50<BR>END<BR>END<BR><BR>GRID<BR>MINSUBDIVIDE 64<BR>MAXSUBDIVIDE 64<BR>#ABELFORMAT "DDMM"<BR>END<BR>END<BR>LAYER<BR>NAME "ssd"<BR>STATUS ON<BR>DATA "comunas"<BR>TYPE POLYGON<BR>UNITS METERS<BR>SIZEUNITS PIXELS<BR>TOLERANCE 0<BR>TOLERANCEUNITS PIXELS<BR>CLASS<BR>TEMPLATE "void"<BR>STYLE<BR>SYMBOL 0<BR>COLOR 255 255 255<BR>OUTLINECOLOR 200 200 200<BR>SIZE 1<BR>MINSIZE
 1<BR>MAXSIZE 100<BR>END<BR>END<BR>END<BR>LAYER<BR>NAME "ejes_calles"<BR>STATUS ON<BR>DATA "the_geom from ejes_calles"<BR>TYPE LINE<BR>CONNECTIONTYPE POSTGIS<BR>CONNECTION "user=admin password=admin dbname=valparaiso <BR>host=localhost port=5432"<BR>UNITS METERS<BR>SIZEUNITS METERS<BR>TOLERANCE 0<BR>TOLERANCEUNITS PIXELS<BR>CLASS<BR>NAME "calles_zoom_5"<BR>STYLE<BR>#SYMBOL 0<BR>COLOR 0 0 0<BR>SIZE 10<BR>END<BR>END<BR>END<BR>END<BR><BR><BR>_______________________________________________<BR>Mapserver-users mailing list<BR>Mapserver-users at lists.gis.umn.edu<BR>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users</BLOCKQUOTE></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search
--0-619328017-1064984969=:21616--