<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Fixedsys;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi I’m trying to display Postgis data through Mapserver
but all I get back is a blank image. I have got mapserver demo/samples working with
shape files.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The map file I’m using is:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>NAME TEST<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>SIZE 400 300<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'># lat long extents<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>EXTENT 5 -48 24 -35<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>UNITS METERS<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>IMAGECOLOR 255 255 255<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>IMAGETYPE PNG<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>#NZGD2000 datum<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>PROJECTION<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> "init=esri:104108"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>END<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> CONNECTIONTYPE postgis<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> NAME "node"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> # Trusted connection to db ‘dblh’ on host ‘lh-deimos’<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> CONNECTION "user=postgres dbname=dblh host=lh-deimos"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> # Select column shape from table node<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> DATA "shape FROM node" <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> STATUS ON<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> TYPE POINT<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> CLASS<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> COLOR 0 0 0<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-NZ
style='font-size:10.0pt;font-family:Arial;color:black'>END # Map File<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-NZ
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-NZ
style='font-size:10.0pt;font-family:Arial;color:black'>The http request I’m
using is:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-NZ
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><a
href="http://lh-deimos/cgi-bin/mapserv?map=/var/www/htdocs/map/test.map&mode=map">http://lh-deimos/cgi-bin/mapserv?map=/var/www/htdocs/map/test.map&mode=map</a><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>I’m using:<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>Postgresql 7.42<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>Postgis 0.81<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>Geos 1.0<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>Proj 4.47<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>mapserver 4.02<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Arial><span lang=EN-NZ style='font-size:10.0pt;font-family:Arial;
color:black'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face=Fixedsys><span lang=EN-NZ style='font-size:10.0pt;font-family:Fixedsys;
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>