[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Re: Blank PostGIS Layer in MapServer
From:       Ben Madin <ben () remoteinformation ! com ! au>
Date:       2008-12-18 5:49:11
Message-ID: 6A231555-434D-4C77-BBA5-62C191662471 () remoteinformation ! com ! au
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


G'day all,

A quick cross posting - I reply to myself - (thanks to Venkat for the  
suggestion, albeit not successful)

> I am having generally excellent results with MapServer 5.2, but I am  
> having a problem with a postgis line layer not displaying, and no  
> suggestion that it shouldn't from the logs.


This was resolved by upgrading from PostGIS 1.3.4 to 1.3.5.

Unfortunately having only upgraded to 1.3.4 on the 14th December, I  
missed : (from the refractions website)

News
PostGIS 1.3.5 Release
December 15, 2008
The 1.3.5 release of PostGIS is now available. This release is a small  
bug fix release, including a critical fix for using PostGIS with  
Mapserver and LINE layers.

Neither did I notice this information in the postgis-users list -  
would it have been posted? (I did notice the thread 'Changed behaviour  
of PostGIS confuses MapServer' but I was under the impression this  
caused a complete crash, not just an empty set to be returned.)

Either way, thanks to those who fixed it.

For FreeBSD, if it helps anyone I have attached an amended Makefile  
and distinfo for the port.

cheers

Ben


-- 

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben@remoteinformation.com.au



							Out here, it pays to know...


[Attachment #5 (multipart/mixed)]

[Attachment #7 (text/html)]

<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; " class=""><div class="" style="">G'day \
all,</div><div class="" style=""><br class="" style=""></div><div class="" style="">A \
quick cross posting -&nbsp;I reply to myself - (thanks to Venkat for the suggestion, \
albeit not successful)</div><div class="" style=""><br class="" style=""></div><div \
class="" style=""><blockquote type="cite"><span class="Apple-style-span" \
style="color: rgb(0, 0, 0); ">I am having generally excellent results with MapServer \
5.2, but I am having a problem with a postgis line layer not displaying, and no \
suggestion that it shouldn't from the logs.</span></blockquote></div><div class="" \
style=""><br class="" style=""></div><div class="" style="">This was resolved by \
upgrading from PostGIS 1.3.4 to 1.3.5.</div><div class="" style=""><br class="" \
style=""></div><div class="" style="">Unfortunately having only upgraded to 1.3.4 on \
the 14th December, I missed : (from the refractions website)</div><div class="" \
style=""><br class="" style=""></div><div class="" style=""><span \
class="Apple-style-span" style="color: rgb(85, 85, 85); font-family: Verdana; \
line-height: 18px; "><h1 style="font-family: Arial, Helvetica, sans-serif; \
font-weight: 100; line-height: 1.1em; color: rgb(0, 0, 0); margin-top: 0px; \
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 10px; \
padding-right: 0px; padding-left: 0px; font-size: 160%; padding-bottom: 9px; \
">News</h1><div class="listitem" style=""><div class="" style="margin-top: 0px; \
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; display: block; padding-top: \
5px; padding-right: 28px; padding-bottom: 5px; padding-left: 0px; background-image: \
url(http://postgis.refractions.net/images/arrow_orange_right.gif); background-repeat: \
no-repeat; font-size: 100%; line-height: 1em; font-weight: bold; background-position: \
100% 50%; "><a href="http://postgis.refractions.net/news/20081215/" style="color: \
rgb(0, 116, 188); text-decoration: none; ">PostGIS 1.3.5 Release</a></div><div \
class="" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: \
0px; padding-right: 0px; padding-left: 0px; font-size: 90%; padding-top: 0px; \
padding-bottom: 8px; ">December 15, 2008</div><div class="listitem-content" \
style=""><div class="" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; \
margin-left: 0px; padding-top: 5px; padding-right: 0px; padding-bottom: 5px; \
padding-left: 0px; ">The 1.3.5 release of PostGIS is&nbsp;<a \
href="http://postgis.refractions.net/download/" style="color: rgb(0, 116, 188); \
text-decoration: none; ">now available</a>. This release is a small bug fix release, \
including a critical fix for using PostGIS with Mapserver and LINE \
layers.</div></div></div></span></div><div class="" style=""><br class="" \
style=""></div><div class="" style="">Neither did I notice this information in the \
postgis-users list - would it have been posted? (I did notice the thread 'Changed \
behaviour of PostGIS confuses MapServer' but I was under the impression this caused a \
complete crash, not just an empty set to be returned.)</div><div class="" \
style=""><br></div><div class="" style="">Either way, thanks to those who fixed \
it.&nbsp;</div><div class="" style=""><br></div><div class="" style="">For FreeBSD, \
if it helps anyone I have attached an amended Makefile and distinfo for the \
port.</div><div class="" style=""><br class="" style=""></div><div class="" \
style="">cheers</div><div class="" style=""><br class="" style=""></div><div class="" \
style="">Ben</div><div class="" style=""><br class="" style=""></div><div class="" \
style=""><br class="" style=""></div><div apple-content-edited="true" class="" \
style=""> <span class="Apple-style-span" style="border-collapse: separate; \
border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: \
12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: \
none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: \
2; white-space: normal; widows: 2; word-spacing: 0px; "><div class="" \
style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: \
after-white-space; "><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; ">--&nbsp;</div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; \
font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br class="" \
style=""></div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; ">Ben Madin</div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; \
">REMOTE INFORMATION</div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal \
Helvetica; min-height: 14px; "><br class="" style=""></div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">t \
: +61 8 9192 5455</div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; ">f :&nbsp;+61 8 9192 5535</div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">m \
: 0448 887 220</div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; ">Broome&nbsp; &nbsp;WA&nbsp; \
&nbsp;6725</div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal \
Helvetica; min-height: 14px; "><br class="" style=""></div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; \
font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><a \
href="mailto:ben@remoteinformation.com.au">ben@remoteinformation.com.au</a></div><div \
class="" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: \
0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br \
class="" style=""></div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal \
Helvetica; min-height: 14px; "><br class="" style=""></div><div class="" \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; \
font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br class="" \
style=""></div><div class="" style="margin-top: 0px; margin-right: 0px; \
margin-bottom: 0px; margin-left: 0px; "><span class="Apple-tab-span" \
style="white-space:pre"><span class="Apple-style-span" style="white-space: pre; \
">							</span></span>Out here, it pays to know...</div></div><br \
class="Apple-interchange-newline" style=""></span> </div></body></html>


["PostGIS_distinfo" (PostGIS_distinfo)]

MD5 (postgis-1.3.5.tar.gz) = a36a68d169122ebfd07874af72a8c39b
SHA256 (postgis-1.3.5.tar.gz) = d873325adba709b43e627905479af6fb9081b650af252256e6613560972f4d80
SIZE (postgis-1.3.5.tar.gz) = 2197971
[Attachment #9 (text/html)]

<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; " class=""></body></html>


["PostGIS_Makefile" (PostGIS_Makefile)]

PORTNAME=       postgis
DISTVERSION=    1.3.5
CATEGORIES=     databases geography
MASTER_SITES=   http://postgis.refractions.net/download/

MAINTAINER=     anderson@cnpm.embrapa.br
COMMENT=        Adds support for geographic objects to PostgreSQL databases

LIB_DEPENDS=    proj.5:${PORTSDIR}/graphics/proj
RUN_DEPENDS=    postmaster:${PORTSDIR}/databases/postgresql${PGSQL_VER}-server

USE_BISON=      build
USE_PGSQL=      yes
USE_GMAKE=      yes
USE_LDCONFIG=   yes
USE_PERL5_BUILD=        yes

INSTALL_TARGET= install

OPTIONS=        GEOS "Include GEOS - the OpenGIS 'Simple Features for SQL'" off \
                UTF8 "UTF-8 support for shp2pgsql. (needs libiconv)" off

GNU_CONFIGURE=  yes
CONFIGURE_ARGS= --datadir=${PREFIX}/share/postgis \
                --bindir=${PREFIX}/bin \
                --libdir=${PREFIX}/lib \
                --with-proj

.include <bsd.port.pre.mk>

.if !defined(NOPORTDOCS)
BUILD_DEPENDS+= xsltproc:${PORTSDIR}/textproc/libxslt \
                ${LOCALBASE}/share/xsl/docbook/html/chunk.xsl:${PORTSDIR}/textproc/docbook-xsl
MAKE_ARGS+=     WITH-DOC=yes
MAN1=           pgsql2shp.1 shp2pgsql.1
PORTDOCS=       *
.else
MAKE_ARGS+=     NOPORTSDOC=yes
.endif

.if defined(WITH_UTF8)
USE_ICONV=      yes
MAKE_ENV+=      "LDFLAGS=-L${LOCALBASE}/lib"
.else
CONFIGURE_ARGS+=        --without-iconv
.endif

.if defined(WITH_GEOS)
LIB_DEPENDS+=   geos:${PORTSDIR}/graphics/geos
CONFIGURE_ARGS+=        --with-geos=${LOCALBASE}/bin/geos-config
.else
CONFIGURE_ARGS+=        --without-geos
.endif

pre-everything::
        @${SH} ${PKGINSTALL} ${PORTNAME} MESSAGE

post-install:
        @${MKDIR} ${PREFIX}/lib/postgresql
        @${LN} -s ${PREFIX}/lib/liblwgeom.so.1 ${PREFIX}/lib/postgresql
        @${SETENV} PKG_PREFIX=${PREFIX} \
                ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL

post-deinstall:
        @ ${SETENV} PKG_PREFIX=${PREFIX} \
                ${SH} ${PKGDEINSTALL} ${PORTNAME} POST-DEINSTALL

.include <bsd.port.post.mk>

[Attachment #11 (text/html)]

<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; " class=""></body></html>



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic