<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="cid:filelist.xml@01C62E3A.835D52B0">
<link rel=Edit-Time-Data href="cid:editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"
downloadurl="http://www.5iamas-microsoft-com:office:smarttags"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place" downloadurl="http://www.5iantlavalamp.com/"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:UseWord2002TableStyleRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I’ll follow up my own post regarding
getting ODBC access to work in mapserver under Debian “sarge”,
since I now have this working (and so others who might later search for a
solution to this can be encouraged).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Straight recompilation proved to be an easy
ticket to getting mapserver working with Debian+Sarge+ODBC (and I upgraded to
mapserver 4.8.1 in the process, which may also have helped).<span
style='mso-spacerun:yes'> </span>I was a bit intimidated about
recompilation from having tried this once before when I was running on ‘woody’
(older Debian version), and then had to deal with backports and other such
ugliness.<span style='mso-spacerun:yes'> </span>The present process is
pretty painless since all the required support libraries are already built in suitable
development versions as Debian packages.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>So it really just boiled down to unpacking
the mapserver source distribution into a suitable directory, doing “<span
class=GramE>./</span>configure” <span
style='mso-spacerun:yes'> </span>a few times with suitable options turned
on (and getting the missing packages as they were identified) and finally doing
a “make”.<span style='mso-spacerun:yes'> </span>After
everything compiled, I just copied the revised mapserver into my cgi-bin folder
under a new name (so the old mapserv is still there just in case) and I’m
now happily displaying X/Y map points from a MySQL data table (even using a
rather more complicated query than shown originally).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I hope someone benefits from this someday…<o:p></o:p></span></font></p>
<div>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 color=navy
face="Times New Roman"><span style='font-size:10.0pt;color:navy;mso-no-proof:
yes'>---<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 color=navy
face="Times New Roman"><span style='font-size:10.0pt;color:navy;mso-no-proof:
yes'>Jeremy Raw<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 color=navy
face="Times New Roman"><span style='font-size:10.0pt;color:navy;mso-no-proof:
yes'>Transportation Systems Engineer / City of <st1:City w:st="on"><st1:place
w:st="on">Durham</st1:place></st1:City> / DCHC MPO</span></font><font
color=navy><span style='color:navy;mso-no-proof:yes'><o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 color=navy
face="Times New Roman"><span style='font-size:10.0pt;color:navy;mso-no-proof:
yes'>919-560-4366 ext. 308 / <a href="mailto:Jeremy.Raw@durhamnc.gov">Jeremy.Raw@durhamnc.gov</a></span></font><font
color=navy><span style='color:navy;mso-no-proof:yes'><o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy;mso-no-proof:
yes'> </span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> UMN MapServer
Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Raw, Jeremy<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, February 03, 2006
4:02 PM<br>
<b><span style='font-weight:bold'>To:</span></b> MAPSERVER-USERS@LISTS.UMN.EDU<br>
<b><span style='font-weight:bold'>Subject:</span></b> [UMN_MAPSERVER-USERS]
OGR+ODBC with Debian Sarge Mapserver</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Question:<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'>Does OGR ODBC access to a database table containing X/Y data
work in the standard Debian sarge Mapserver package (as opposed to having to
compile it from the ground up myself)?<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'>Details:<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'>I’ve been happily running the Debian sarge standard
package of Mapserver (version 4.4.1) for a number of months.<span
style='mso-spacerun:yes'> </span>The data sources for this project have
(until now) all been in shapefiles and inline features (passed in via
CGI).<span style='mso-spacerun:yes'> </span>I’m now trying to
enlarge the application to display point data from a MySQL database table
containing X/Y data.<span style='mso-spacerun:yes'> </span>Following the
terse but workable how-to on the Mapserver website, I’ve got ODBC up and
running and verified it all the way through using ogrinfo (from the standard
sarge gdal package) to access the data.<span style='mso-spacerun:yes'>
</span>Unfortunately, my mapserver (and also shp2img) perform a segmentation
fault every time they try to access the ODBC layer, with no indication of
what’s wrong.<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'>All I’d really like to know is if someone has gotten
this to work (or equally, if someone knows for sure that the standard sarge
package does not have suitable capabilities compiled in, or if it conflicts
with something else etc.) before I set about building the whole mapserver setup
from scratch.<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'>Here’s the test.ovf file (OGR Connection definition),
which as I noted works fine with ogrinfo (the file lives in my SHAPEPATH):<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'><OGRVRTDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span><OGRVRTLayer name='mypoints'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span><SrcDataSource>ODBC:user/password@MySQL</SrcDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span><SrcSQL>Select * from mypoints where (ptid&lt;100)
</SrcSQL><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span><GeometryField encoding='PointFromColumns' x='xcoord' y='ycoord'
/><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span><GeometryType>wkbPoint</GeometryType><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span></OGRVRTLayer><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'></OGRVRTDataSource><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'>Here’s the (very basic) layer definition from the
mapfile – the “circle” symbol is defined and works in other
layers.<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'>LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>NAME "mypoints"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>CONNECTIONTYPE OGR<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>CONNECTION "test.ovf"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>DATA "mypoints"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>STATUS DEFAULT<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span><span
style='mso-spacerun:yes'> </span>TYPE POINT<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'>
</span>CLASS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span
style='mso-spacerun:yes'>
</span>STYLE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span
style='mso-spacerun:yes'>
</span>COLOR 0 0 0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span
style='mso-spacerun:yes'>
</span>SIZE 2<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span
style='mso-spacerun:yes'>
</span>SYMBOL "circle"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span
style='mso-spacerun:yes'> </span>END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span>END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>END<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'>Any help or advice much appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Jeremy<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;mso-no-proof:yes'>---<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;mso-no-proof:yes'>Jeremy Raw<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;mso-no-proof:yes'>Transportation Systems Engineer /
City of <st1:place w:st="on"><st1:City w:st="on">Durham</st1:City></st1:place>
/ DCHC MPO</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;mso-no-proof:yes'>919-560-4366 ext. 308 / <a
href="mailto:Jeremy.Raw@durhamnc.gov">Jeremy.Raw@durhamnc.gov</a></span></font><span
style='mso-no-proof:yes'><o:p></o:p></span></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;mso-no-proof:yes'> </span><o:p></o:p></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>