<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>All:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>This email is to add
further information regarding the email sent by Mike Leahy.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>I have included a
copy of the .map file we are using. I haven't been able to find a useful
log file for MapServer, but I have attached the log file for the webserver
(IIS). Again, I am able to access the database fine, and the .map file works
well with a shapefile of the same point data, it is just getting it to
connect via postgis that is our problem.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>We are using
Microsoft IIS on Windows XP with a MapServer 3.6.6-dev build and MapScript 3.6
built by DMSolutions last Friday. The interface is built using MapLab,
again by DMSolutions. This also constructs all the php, etc... at the same
time. It is of course possible that the problem may lie in here as well. I am
relatively new at this so I am still floundering a bit with how the different
components interact.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>thanks,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>Paul</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>----------------------.map file</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>MAP<BR> EXTENT
273346 8670666 281455 8677412<BR> FONTSET
"./Independencia/etc/fonts.txt"<BR> IMAGECOLOR 255 255 255<BR>
IMAGEQUALITY 100<BR> IMAGETYPE PNG<BR> INTERLACE TRUE<BR>
SYMBOLSET "./Independencia/etc/symbols.sym"<BR> SHAPEPATH
"./Independencia"<BR> SIZE 600 500<BR> STATUS ON<BR>
TRANSPARENT FALSE<BR> UNITS METERS<BR> NAME
"Independencia"</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>
LEGEND<BR> IMAGECOLOR 204 204 255<BR>
INTERLACE TRUE<BR> KEYSIZE 18 12<BR>
KEYSPACING 5 5<BR> LABEL<BR>
SIZE MEDIUM<BR> TYPE
BITMAP<BR> BUFFER
0<BR> COLOR 0 0
89<BR> FORCE
FALSE<BR> MINDISTANCE
-1<BR> MINFEATURESIZE
-1<BR> OFFSET 0
0<BR> PARTIALS TRUE<BR>
END<BR> OUTLINECOLOR 0 0 0<BR> POSITION
LL<BR> STATUS ON<BR> TRANSPARENT
FALSE<BR> TEMPLATE
"c:/msapps/htdocs/mapedit/legend_template.html"<BR>
END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>
QUERYMAP<BR> COLOR 51 100 255<BR> SIZE -1
-1<BR> STATUS OFF<BR> STYLE HILITE<BR>
END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>
REFERENCE<BR> COLOR -1 -1 -1<BR> EXTENT
272051 8670801 282750 8677277<BR> IMAGE
"./vista.gif"<BR> OUTLINECOLOR 255 0 0<BR>
SIZE 100 60<BR> STATUS ON<BR>
MARKER 0<BR> MARKERSIZE
0<BR> MINBOXSIZE
3<BR> MAXBOXSIZE 0<BR>
END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>
SCALEBAR<BR> BACKGROUNDCOLOR 204 204 204<BR>
COLOR 0 0 0<BR> IMAGECOLOR 255 255 255<BR>
INTERLACE TRUE<BR> INTERVALS 5<BR>
LABEL<BR> SIZE
MEDIUM<BR> TYPE
BITMAP<BR> BUFFER
0<BR> COLOR 0 0
0<BR> FORCE
FALSE<BR> MINDISTANCE
-1<BR> MINFEATURESIZE
-1<BR> OFFSET 0
0<BR> PARTIALS TRUE<BR>
END<BR> OUTLINECOLOR 0 0 0<BR> POSITION
LL<BR> SIZE 300 8<BR> STATUS
ON<BR> STYLE 0<BR> TRANSPARENT
FALSE<BR> UNITS KILOMETERS<BR> END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>
WEB<BR> IMAGEPATH "c:/tmp/ms_tmp/"<BR>
IMAGEURL "/ms_tmp/"<BR> END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003> <BR>
LAYER<BR> CONNECTIONTYPE postgis<BR>
CONNECTION "dbname=edumap"<BR> DATA "shape FROM
gis_test"<BR> GROUP "Independencia"<BR> NAME
"Escuelas Primarias"<BR> SIZEUNITS
PIXELS<BR> STATUS ON<BR> TEMPLATE
"ttt.html"<BR> TOLERANCE 3<BR>
TOLERANCEUNITS PIXELS<BR> TYPE POINT<BR>
UNITS METERS<BR> CLASS<BR> NAME
"Escuelas"<BR> COLOR 150 0
0<BR> MAXSIZE
100<BR> MINSIZE
1<BR> SIZE 8<BR>
SYMBOL 2<BR> END<BR> END</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>END</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>-----------------------------------</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>Last section of
webserver log file:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>21:43:13 127.0.0.1
GET /msapps/htdocs/index.phtml 200<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/toolbar_maplab.phtml 200<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/toolbar.phtml 200<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/action.phtml 200<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_maplab_maplab.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_maplab_mapedit.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/appframeset.phtml 200<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_maplab_mapbrowser.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_maplab_gmapfactory.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_config_info.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_config_xml.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/icon_help.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/dmsglogo.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/maplab_mapedit.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/maplab_mapbrowser.gif 304<BR>21:43:13 127.0.0.1 GET
/msapps/htdocs/images/maplab_gmapfactory.gif 304<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/Independencia.phtml 200<BR>21:43:18
127.0.0.1 GET /msapps/projects/gmf_apps/Independencia/images/icon_eye.gif
304<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/images/a_pixel.gif 304<BR>21:43:18
127.0.0.1 GET /ms_tmp/1053985398_0_0_20_10.png 200<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/images/icon_redraw.gif 304<BR>21:43:18
127.0.0.1 GET /msapps/projects/gmf_apps/Independencia/images/icon_pan_north.gif
304<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/images/icon_pan_west.gif 304<BR>21:43:18
127.0.0.1 GET /msapps/projects/gmf_apps/Independencia/images/icon_pan_east.gif
304<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/images/icon_pan_south.gif
304<BR>21:43:18 127.0.0.1 GET /ms_tmp/105398539831121.gif 200<BR>21:43:18
127.0.0.1 GET /ms_tmp/105398539831122.gif 200<BR>21:43:18 127.0.0.1 GET
/msapps/projects/gmf_apps/Independencia/wrapper/drawmap.php
200</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003>--------------------------------------</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>The errors I am
getting are:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=935245621-26052003>ERROR: parser:
parse error at or near "WHERE"<BR>ERROR: parser: parse error at or near
"WHERE"<BR>DEBUG: pq_recvbuf: unexpected EOF on client
connection</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=935245621-26052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:SmartTagType name="PostalCode"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="country-region"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="State"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType>
<OBJECT id=ieooui classid=clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D></OBJECT>
<STYLE>st1\:* {
BEHAVIOR: url(#ieooui)
}
</STYLE>
<STYLE>@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
DIV.Section1 {
page: Section1
}
</STYLE>
<DIV class=Section1>
<P class=MsoNormal align=left><B style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Paul A Peters</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><BR></SPAN><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"><A
href="http://www.fes.uwaterloo.ca/u/papeters">http://www.fes.uwaterloo.ca/u/papeters</A></SPAN></P></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>