from:"Sebastian E. Ovide"

From the Fedora mailing list:

For some (reasonable) reason, usually Fedora strongly discourages to ship
static archives in binary rpms:
https://fedoraproject.org/wiki/Packaging/Guidelines#Packaging_Static_Libraries
You can see this also happened on postgresql:
http://pkgs.fedoraproject.org/gitweb/?p=postgresql.git;a=commitdiff;h=a6a1e9bfab6192bbdaea41e88368ae7d242316d7

You should really check if libpgport.a is really needed, i.e.
check it the package you are trying to build supports dynamic
linkage (against libpgport.so).

On Thu, Nov 18, 2010 at 10:22 AM, Julien Cigar jci...@ulb.ac.be wrote:

 On 11/18/2010 10:35, Sebastian E. Ovide wrote:

 from
 http://forums.fedoraforum.org/showthread.php?p=1417824#post1417824 it
 looks like libpgport isn't supported by fedora...

 Is there any other way to build MapServer without that library ?


 disable Postgis support ?

 I don't use Fedora, but I reported a similar problem with the FreeBSD port,
 which looks like yours: http://www.freebsd.org/cgi/query-pr.cgi?pr=145002


 On Wed, Nov 17, 2010 at 3:49 PM, Sebastian E. Ovide
 sebastian.ov...@gmail.com mailto:sebastian.ov...@gmail.com wrote:

Hi Guys,

I'm building mapserver in Fedora 14 and getting

/usr/bin/ld: cannot find -lpgport
collect2: ld returned 1 exit status

doing

yum list | grep pgport
and
yum provides *pgport*

I cannot see any package with pgport...

any ideas ?


--
Sebastian E. Ovide







 --
 Sebastian E. Ovide






 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



 --
 No trees were killed in the creation of this message.
 However, many electrons were terribly inconvenienced.

 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver + OCI error while loading shared libraries from Apache ?

Hi All,

everything is working find from shell. I register the Oracle libraries with
ldconfig, I have even created a cgi that set the LD_LIBRARY_PATH

[...@mapserver-fc14 cgi-bin]$ cat test.sh
#!/bin/sh
export ORACLE_HOME=/home/gis/libs/instantclient_11_2/
export LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/
/var/www/cgi-bin/mapserv $*

and still getting

[Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50]
/var/www/cgi-bin/mapserv: error while loading shared libraries:
libclntsh.so.11.1: cannot open shared object file: No such file or directory
[Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50] Premature end of
script headers: test.sh

any ideas ?

note: this problem is on a Fedora 14
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver + OCI error while loading shared libraries from Apache ?

you are right...  the problem was that in Fedora the homes have access
restrictions by default ... thanks

On Thu, Nov 18, 2010 at 5:00 PM, Daniel Morissette dmorisse...@mapgears.com
 wrote:

 Does the file /home/gis/libs/instantclient_11_2/libclntsh.so.11.1 exist
 and is the full path to its location reachable by the user running the
 Apache server? i.e. check the permissions on all subdirs, especially
 /home/gis which is likely to have access restrictions by default.



 Sebastian E. Ovide wrote:
  Hi All,
 
  everything is working find from shell. I register the Oracle libraries
  with ldconfig, I have even created a cgi that set the LD_LIBRARY_PATH
 
  [...@mapserver-fc14 cgi-bin]$ cat test.sh
  #!/bin/sh
  export ORACLE_HOME=/home/gis/libs/instantclient_11_2/
  export LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/
  /var/www/cgi-bin/mapserv $*
 
  and still getting
 
  [Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50]
  /var/www/cgi-bin/mapserv: error while loading shared libraries:
  libclntsh.so.11.1: cannot open shared object file: No such file or
 directory
  [Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50] Premature end of
  script headers: test.sh
 
  any ideas ?
 
  note: this problem is on a Fedora 14
  --
  Sebastian E. Ovide
 
 
 
 
  
 
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users


 --
 Daniel Morissette
 http://www.mapgears.com/
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] msProcessProjection(): Projection library error. no system list, errno: 2

Hi All,

I'm using an map file that works fine on one server, but for some reason on
another server (just installed: Fedora) it is giving this error:

[Thu Nov 18 17:23:03 2010].578122 msProcessProjection(): Projection library
error. no system list, errno: 2

I've already set DEBUG 5 and CONFIG CPL_DEBUG ON bat I cannot find any
extra information that could help to understand what the problem is.. (I've
built mapserver with debug flag)

any ideas ?

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] msProcessProjection(): Projection library error. no system list, errno: 2

solved with

yum install proj-epsg


On Thu, Nov 18, 2010 at 5:31 PM, Michael Schulz msch...@webgis.de wrote:

 Hi,

 the projection-lib cannot find the epsg file, where all the
 projections are defined. Add

 CONFIG PROJ_LIB /usr/local/share/proj/nad

 your mapfile (you may have to adjust the path).

 Cheers, Michael


 2010/11/18 Sebastian E. Ovide sebastian.ov...@gmail.com:
  Hi All,
  I'm using an map file that works fine on one server, but for some reason
 on
  another server (just installed: Fedora) it is giving this error:
  [Thu Nov 18 17:23:03 2010].578122 msProcessProjection(): Projection
 library
  error. no system list, errno: 2
  I've already set DEBUG 5 and CONFIG CPL_DEBUG ON bat I cannot find
 any
  extra information that could help to understand what the problem is..
 (I've
  built mapserver with debug flag)
  any ideas ?
  --
  Sebastian E. Ovide
 
 
 
 
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 



 --
 ---
 Michael Schulz
 msch...@webgis.de

 in medias res
 Gesellschaft für Informationstechnologie mbH

 Schwimmbadstraße 2
 D-79100  Freiburg i. Br.

 Tel:  +49 (0)761 705798-102
 Tel:  +49 (0)761 705798-0
 Fax: +49 (0)761 705798-09

 http://www.webgis.de / http://www.zopecms.de
 --
 Geschäftsführer: Stefan Giese, Dr. Christof Lindenbeck
 Eingetragen im Handelsregister HRB 5930 beim Amtsgericht Freiburg
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] fedora 14 cannot find -lpgport

2010-11-17 Thread Sebastian E. Ovide

Hi Guys,

I'm building mapserver in Fedora 14 and getting

/usr/bin/ld: cannot find -lpgport
collect2: ld returned 1 exit status

doing

yum list | grep pgport
and
yum provides *pgport*

I cannot see any package with pgport...

any ideas ?


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] POINT layer from simple x, y table: Segmentation fault

2010-11-16 Thread Sebastian E. Ovide

On Tue, Nov 16, 2010 at 10:37 AM, Rahkonen Jukka
jukka.rahko...@mmmtike.fiwrote:

  Hi,

 No idea exactly about this, but if you manage to get further I fear you
 will be banging your head to the next wall because Mapserver won't get a
 spatial index from Oracle for such a query.  Adding USING NONE to the end
 of DATA should help then, see
 http://mapserver.org/input/vector/oracle.html

 I suppose you have some good reason for playing with x_coord and y_coord
 columns instead of massaging them into a real physical SDO_GEOMETRY column
 that could also be indexed with a spatial filter, for example going
 through a materialized view way.

 -Jukka Rahkonen-


Actually I have just convinced the DBA to add a column... ;)




  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 16. marraskuuta 2010 12:14
 *Vastaanottaja:* mapserver-users@lists.osgeo.org
 *Aihe:* [mapserver-users] POINT layer from simple x,y table: Segmentation
 fault

  Hi All,

 I've created a POINT layer:

   LAYER
 NAME POLICY
 TYPE POINT
 EXTENT 54225.00 5800.00 655625.00 1220325.00
 STATUS ON
 CONNECTIONTYPE OGR
 CONNECTION OCI:la001/la...@192.168.60.70/MFUATDB
 DATA Select match_level, x_coord, y_coord,
 SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL)
 as point From policy
 PROJECTION
   init=epsg:27700
 END
 CLASS
   STYLE
 SYMBOL star
 COLOR 255 0 0
 SIZE 10
   END
 END
   END

 and this is what I'm getting in apache logs:

 OGR: OGROpen(OCI:la001/la...@192.168.60.70/MFUATDB/0xa194160) succeeded as
 OCI.
 OCI: ExecuteSQL(Select match_level, x_coord, y_coord,
 SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL)
 as point From policy)
 OCI: Prepare(Select match_level, x_coord, y_coord,
 SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL)
 as point From policy)
 [Tue Nov 16 10:06:31 2010] [error] [client 10.0.1.50] FastCGI: incomplete
 headers (0 bytes) received from server /home/gis/bin/mapserv
 [Tue Nov 16 10:06:31 2010] [warn] FastCGI: (dynamic) server
 /home/gis/bin/mapserv (pid 1086) terminated due to uncaught signal '11'
 (Segmentation fault)


 any ideas ?
 --
 Sebastian E. Ovide





-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] draw polygons ordered by field ? (from File System)

2010-11-09 Thread Sebastian E. Ovide

Hi All,

Reading a shapefile (ESRI/MapInfo) from FS with polygons overlapping. Each
polygon is drawn with a different color based on a field called RISK.

Is it possible  define an order on how the polygons are drawn ? Say for
example to draw the polygons with field RISK 0 first, then with RISK =1
and so on...

I know that using PG we can use Select * from XXX order by RISK

Is there any way to do that using ESRI/MapInfo files ?

Thanks

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Ubuntu or Redhat 5 ?

2010-11-08 Thread Sebastian E. Ovide

Hi Guys,

I have been using MapServer + TileCache with Ubuntu 10.04 and now with 10.10
for the last few months and it works very well build it is a matter of a
couple of command lines and its administration is really stratigh forward.

My department is considering what OS should we use for production and the
alternatives are RedHat 5 or Ubuntu. What are your preferences and why ?

Thanks all !

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] layers sharing the same class ?

2010-11-04 Thread Sebastian E. Ovide

Hi All,

I have a lot of layers that are displayed using the same colors. If I need
to change a color for, I have to go trough all the layers, one by one, and
change all the colors..

Is there any way to define a CLASS (or a THEME ??) and just use it within
all the layers that share that class ?

This is what I have:

  LAYER
...
...
CLASSITEM CLASS
CLASS
  EXPRESSION A
  COLOR #FF
END
...
...
...
CLASS
  EXPRESSION Z
  COLOR #00
END
  END

Thanks
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] conf of MapServ+Apache.Lighttpd for better usability

2010-11-02 Thread Sebastian E. Ovide

Hi Guys,

I am using MapServer as a FastCgi (with lighttpd and Apache) connected to
Oracle, PG, ESRI shapes, ESRI binary grids and MapInfo TAB files.

There is a situation that makes the use of MapServer not very user friendly:

An user A opens a map, activates a slow layer and drags the map around. This
would add a lot of calls to the webserver that would launch many MapServer
processes reaching the maximum number of processes. At the same time, there
is another user B displaying another layer... this time a fast layer As
the maximum number of processes has been reached, the webserver cannot
create new processes until those alive finish their work, it cannot serve
the other user... that is very annoying as The other user would have to wait
a long time until the queue is processed and his map is displayed.

Another similar situation is when the user A get annoyed as the map is not
displaying and therefore decides to turn off the layer and turn on a
different layer... say a fast layer... he still need to wait that all the
MapServer processes finish the processing... That annoys the users that
doesn't understand what is going on... and thinks that the server has
crashed...

Is there anyway to configure Apache/Lighttpd to give higher priority to the
new calls ? (that means to conver the queue from FIFO to LIFO)

I have configured Apache FastCgi to kill the old processes once a minute...
but the process wont die... actually they would not die with a simple
kill... they would die with only kill -9 !!!

Any other solutions ?

Thanks
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: process survive after killing apache

2010-10-27 Thread Sebastian E. Ovide

Is there any way of telling to MapServer to kill himself after xx seconds ?

It keep running for ever using 100% of CPUs... (Kernel CPU)... it seams to
happen with huge polygons...


On Thu, Oct 21, 2010 at 4:26 PM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 Hi All,

 I'm having 2 problems:

 1) Mapserver uses 100% for infinite time... (hangs !) for some layers...
 2) Mapserver survives after killing Apache (same with lighttpd). It even
 wont die with a sudo killall mapserv at least that I pass the -9
 parameter.

 Any ideas ?

 (I'm running Mapserver on a VMware... , same problem with fastcgi or simple
 cgi)



 --
 Sebastian E. Ovide






-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Maximum number of points in a poligon

2010-10-27 Thread Sebastian E. Ovide

Hi All,

I have a shape with 2M polygons. The biggest one has 13k points. It works
very well, and fast enough.

I have another shape with 300k polygons and the biggest one has 800k
points... This shape hangs MapServer !... and I have to kill the process by
hand using kill -9. (see the other thread: process survive after killing
apache). The shape files can be opened with ogrinfo though

Is there a maximum number of points for single polygon supported by
MapServer ?

Thanks
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Maximum number of points in a poligon

2010-10-27 Thread Sebastian E. Ovide

Do you spliited the polygons manually or you have some script ? perhaps
using gdal ?

On Wed, Oct 27, 2010 at 1:36 PM, Rahkonen Jukka
jukka.rahko...@mmmtike.fiwrote:

  Hi,

 All I can say is that with our data the service went all to slow for the
 end users long before jamming.  We have been splitting the biggest lake
 polygons into pieces with no more than 45000 vertises because that was the
 limit of reasonable speed in our environment.  But in that case the limiting
 factor was the database and contains queries, not Mapserver.  Anyhow,
 splitting the lakes was good for Mapserver too.  For some other layers we
 have made simplified versions for the far-away zooms. Simplifying is better
 for WMS use if polygons are drawn with different outline colour but it gives
 a bit more work with building the scale dependent layers.

 -Jukka Rahkonen-

  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 27. lokakuuta 2010 14:57
 *Vastaanottaja:* mapserver-users@lists.osgeo.org
 *Aihe:* [mapserver-users] Maximum number of points in a poligon

 Hi All,

 I have a shape with 2M polygons. The biggest one has 13k points. It works
 very well, and fast enough.

 I have another shape with 300k polygons and the biggest one has 800k
 points... This shape hangs MapServer !... and I have to kill the process by
 hand using kill -9. (see the other thread: process survive after killing
 apache). The shape files can be opened with ogrinfo though

 Is there a maximum number of points for single polygon supported by
 MapServer ?

 Thanks
 --
 Sebastian E. Ovide





-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] query for ALL the layers

2010-10-26 Thread Sebastian E. Ovide

Hi All,

I'm using a query from a MapInfo like this:

DATA 'select * from sa_merged_01 where ogr_geometry = POLYGON or
ogr_geometry = MULTIPOLYGON'

Which select polygons and multipolygons from one single layer.

My datasource have tens of layers (doing ogrinfo ./mydata/ I can see tens of
layers)... How can I select all of them ? Any query that I can use ?

thanks


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Really New User Issue

2010-10-24 Thread Sebastian E. Ovide

what do you get if you go to *http://localhost/cgi-bin/mapserv *  ?

On Sun, Oct 24, 2010 at 5:19 AM, Tim Rood tro...@comcast.net wrote:

  Hello,



 For context, I assume I have the latest MapServer version, downloaded
 October 3.



 Also, I’m pretty familiar with desktop GIS, but unschooled with web and map
 server use.



 Installation and first tutorial section went well.

 Got to Example 2-1:  Example 2.1 - Pan and Zoom 
 Controlshttp://demo.mapserver.org/cgi-bin/mapserv?map=/osgeo/mapserver/tutorial/htdocs/example2.maplayer=stateszoom=0mode=browseroot=/tutorialprogram=/cgi-bin/mapservmap_web=template+example2-1.html(teaches
  click on map to pan, etc.) and
 pan/zoom page opens with map. OK.

 *But here’s the problem:*

 * *

 *the mapfile, (name: Example2.map. “type: map_auto_file” [new type to me])
 from demo.mapfile.org *

 * *

 *wants to be opened or saved every time I click on the map to pan.  *

 * *

 I expected the link above to run the local mapfile---and not open it
 either.



 I don’t understand the behavior I’m seeing.  What basic point am I missing?



 Thanks,



 Tim



 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Trouble with MapServer cgi

2010-10-23 Thread Sebastian E. Ovide

Hi Leigh,

I have not idea about Fedora... with Ubuntu it was a simple apt-get
install... with GIS repo...that's all... all working fine... In my case I
had to build gdal and mapserver as I needed Oracle drivers too and the
installation was very straight forward...

What OS do mapservers developers use ?

On Sat, Oct 23, 2010 at 10:16 AM, Leigh Holcombe
lholco...@triple-bypass.net wrote:

Hello,
I've been trying to learn the MapServer software for a few weeks now.
Mostly, I've been running some examples from Bill Kropla's book, but I've
also been trying out some things on my own. I'm running version 5.6.5 on
Fedora 13.

My first question is about SELinux context. After yum installation, the
mapserv executable found in /usr/sbin has a context of
system_u:object_r:bin_t:s0. However, this causes serious problems for
SELinux. After trying numerous modifications, I have found that
unconfined_u:object_r:httpd_unconfined_script_exec_t:s0 works - however,
according to documentation, this is just barely better than turning SELinux
off. Can you offer any advice about setting this properly? While SELinux
is not crucial to my practice development, I feel it's a good idea to learn
it.

Secondly, I am having trouble loading map images without forms. I have a
properly configured virtual host, whose docroot is /var/www/html/nwss.dev.
My cgi directory is /var/www/cgi-bin, and my mapfile is located in
/var/www/html/nwss.dev/mapserver_test. According to the documentation, the
path passed to the executable should be the path relative to the cgi
location. I take this to mean that either the absolute path above or the
relative path ../html/nwss.dev/mapserver_test should work. However, it does
not. Here is the HTML code I am trying to use (without ):

img src=
http://www.nwss.dev/cgi-bin/mapserv?map=../html/nwss.dev/mapserver_test/map_13.map?mode=map;
width=800 height=800 border=0

The web section (is it necessary in this example?) of my mapfile is:
WEB
TEMPLATE /var/www/html/nwss.dev/mapserver_test/map_13.html
IMAGEPATH /var/www/html/nwss.dev/mapserver_test/tmp/
IMAGEURL /mapserver_test/tmp/
END #end web

Clearly, I'm doing something wrong. But based on what I've read, it seems
right. Help! Thanks for your time.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

--
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] ESRI binary grids RRD files ?

2010-10-21 Thread Sebastian E. Ovide

solution:

make sure the .rrd and .aux files have exactly the same name as the folders
with the adf files. IE: in ext4 are case sensitive.


On Wed, Oct 20, 2010 at 9:13 AM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 Frank,

 I've left those RRD and I suspect that for some reason the pyramids are not
 read... In fact the performance is very good for zoomed in views (street
 level)... but it is very slow for zoom out views (city level)...  and I can
 see the IO working very hard...

 is there any way to see if MapServer/gdal is reading the pyramids correctly
 ?

 thanks


 On Tue, Oct 19, 2010 at 2:08 PM, Frank Warmerdam warmer...@pobox.comwrote:

 Sebastian E. Ovide wrote:

 Hi Guys,

 ESRI Binary grids contains a bunch of adf files and rrd files that I
 believe contains pyramids.
 Does MapServer needs those rrd files ? the question is because they are
 very big !


 Sebastian,

 Yes, MapServer will take advantage of .rrd overviews for ESRI binary
 grids.
 You can delete them but in some cases performance will suffer.

 Best regards,
 --

 ---+--
 I set the clouds in motion - turn up   | Frank Warmerdam,
 warmer...@pobox.com
 light and sound - activate the windows | http://pobox.com/~warmerdam
 and watch the world go round - Rush| Geospatial Programmer for Rent




 --
 Sebastian E. Ovide







-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] process survive after killing apache

2010-10-21 Thread Sebastian E. Ovide

Hi All,

I'm having 2 problems:

1) Mapserver uses 100% for infinite time... (hangs !) for some layers...
2) Mapserver survives after killing Apache (same with lighttpd). It even
wont die with a sudo killall mapserv at least that I pass the -9
parameter.

Any ideas ?

(I'm running Mapserver on a VMware... , same problem with fastcgi or simple
cgi)



-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] postgis to spatile-ogr

2010-10-21 Thread Sebastian E. Ovide

if you need only to display geometries with mapserver u can simply use
shapes files... anything that can be read by gdal can be read by mapserver

On Thu, Oct 21, 2010 at 2:38 PM, ni...@maich.gr wrote:

 Hello,

 Was wondering if an application that is currently set up with postgis data
 sources can work directly by changing only the data source, e.g change the
 DATA string to ogr in the mapfile.

 Have to setup a demo remotely and don't really want to drag pgsql along
 only for the demo.

 If, so, would ogr2ogr be the most direct way to dump the postgis tables
 into sqlite?

 regards,

 nicolas boretos

 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] ESRI binary grids RRD files ?

2010-10-20 Thread Sebastian E. Ovide

Frank,

I've left those RRD and I suspect that for some reason the pyramids are not
read... In fact the performance is very good for zoomed in views (street
level)... but it is very slow for zoom out views (city level)...  and I can
see the IO working very hard...

is there any way to see if MapServer/gdal is reading the pyramids correctly
?

thanks

On Tue, Oct 19, 2010 at 2:08 PM, Frank Warmerdam warmer...@pobox.comwrote:

 Sebastian E. Ovide wrote:

 Hi Guys,

 ESRI Binary grids contains a bunch of adf files and rrd files that I
 believe contains pyramids.
 Does MapServer needs those rrd files ? the question is because they are
 very big !


 Sebastian,

 Yes, MapServer will take advantage of .rrd overviews for ESRI binary grids.
 You can delete them but in some cases performance will suffer.

 Best regards,
 --

 ---+--
 I set the clouds in motion - turn up   | Frank Warmerdam,
 warmer...@pobox.com
 light and sound - activate the windows | http://pobox.com/~warmerdam
 and watch the world go round - Rush| Geospatial Programmer for Rent




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] ESRI binary grids RRD files ?

2010-10-20 Thread Sebastian E. Ovide

ok, using gdalinfo it looks like my rasters have some problems... I'll
follow up in gdal mailing list..

thanks

g...@mapserver:~$ gdalinfo data/ie/rasters/ie_t02_q200/
Driver: AIG/Arc/Info Binary Grid
Files: data/ie/rasters/ie_t02_q200/
   data/ie/rasters/ie_t02_q200/z001014x.adf
   data/ie/rasters/ie_t02_q200/prj.adf
   data/ie/rasters/ie_t02_q200/z001002.adf
   data/ie/rasters/ie_t02_q200/z001003.adf
   data/ie/rasters/ie_t02_q200/z001011x.adf
   data/ie/rasters/ie_t02_q200/z001008.adf
   data/ie/rasters/ie_t02_q200/z001004.adf
   data/ie/rasters/ie_t02_q200/dblbnd.adf
   data/ie/rasters/ie_t02_q200/w001001x.adf
   data/ie/rasters/ie_t02_q200/z001009x.adf
   data/ie/rasters/ie_t02_q200/z001012x.adf
   data/ie/rasters/ie_t02_q200/w001001.adf
   data/ie/rasters/ie_t02_q200/z001003x.adf
   data/ie/rasters/ie_t02_q200/sta.adf
   data/ie/rasters/ie_t02_q200/z001015.adf
   data/ie/rasters/ie_t02_q200/z001005.adf
   data/ie/rasters/ie_t02_q200/z001013x.adf
   data/ie/rasters/ie_t02_q200/z001010.adf
   data/ie/rasters/ie_t02_q200/w001000.adf
   data/ie/rasters/ie_t02_q200/z001006.adf
   data/ie/rasters/ie_t02_q200/z001014.adf
   data/ie/rasters/ie_t02_q200/hdr.adf
   data/ie/rasters/ie_t02_q200/z001001.adf
   data/ie/rasters/ie_t02_q200/z001005x.adf
   data/ie/rasters/ie_t02_q200/z001010x.adf
   data/ie/rasters/ie_t02_q200/z001004x.adf
   data/ie/rasters/ie_t02_q200/w001000x.adf
   data/ie/rasters/ie_t02_q200/z001013.adf
   data/ie/rasters/ie_t02_q200/z001015x.adf
   data/ie/rasters/ie_t02_q200/z001001x.adf
   data/ie/rasters/ie_t02_q200/z001007x.adf
   data/ie/rasters/ie_t02_q200/z001006x.adf
   data/ie/rasters/ie_t02_q200/z001011.adf
   data/ie/rasters/ie_t02_q200/z001007.adf
   data/ie/rasters/ie_t02_q200/z001008x.adf
   data/ie/rasters/ie_t02_q200/z001002x.adf
   data/ie/rasters/ie_t02_q200/z001009.adf
   data/ie/rasters/ie_t02_q200/z001012.adf
Size is 64402, 89106
Coordinate System is:
PROJCS[unnamed,
GEOGCS[WGS 84,
DATUM[WGS_1984,
SPHEROID[WGS 84,6378137,298.257223563,
AUTHORITY[EPSG,7030]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY[EPSG,6326]],
PRIMEM[Greenwich,0,
AUTHORITY[EPSG,8901]],
UNIT[degree,0.0174532925199433,
AUTHORITY[EPSG,9108]],
AUTHORITY[EPSG,4326]],
PROJECTION[Transverse_Mercator],
PARAMETER[latitude_of_origin,53.5],
PARAMETER[central_meridian,-8],
PARAMETER[scale_factor,1.35],
PARAMETER[false_easting,20],
PARAMETER[false_northing,25],
UNIT[METERS,1]]
Origin = (15390.000,461520.000)
Pixel Size = (5.000,-5.000)
Corner Coordinates:
Upper Left  (   15390.000,  461520.000) ( 10d54'41.98W, 55d21'55.72N)
Lower Left  (   15390.000,   15990.000) ( 10d39'3.41W, 51d22'1.58N)
Upper Right (  337400.000,  461520.000) (  5d49'56.05W, 55d22'51.38N)
Lower Right (  337400.000,   15990.000) (  6d 1'35.29W, 51d22'49.73N)
Center  (  176395.000,  238755.000) (  8d21'17.49W, 53d23'54.38N)
Band 1 Block=512x4 Type=Float32, ColorInterp=Undefined
  Min=1.000 Max=4.000
  NoData Value=-3.4028234663852886e+38
ERROR 3: Attempt to read past EOF in
data/ie/rasters/ie_t02_q200//../info/arc.dir.
ERROR 4: Failed to open table .VAT


On Wed, Oct 20, 2010 at 9:13 AM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 Frank,

 I've left those RRD and I suspect that for some reason the pyramids are not
 read... In fact the performance is very good for zoomed in views (street
 level)... but it is very slow for zoom out views (city level)...  and I can
 see the IO working very hard...

 is there any way to see if MapServer/gdal is reading the pyramids correctly
 ?

 thanks


 On Tue, Oct 19, 2010 at 2:08 PM, Frank Warmerdam warmer...@pobox.comwrote:

 Sebastian E. Ovide wrote:

 Hi Guys,

 ESRI Binary grids contains a bunch of adf files and rrd files that I
 believe contains pyramids.
 Does MapServer needs those rrd files ? the question is because they are
 very big !


 Sebastian,

 Yes, MapServer will take advantage of .rrd overviews for ESRI binary
 grids.
 You can delete them but in some cases performance will suffer.

 Best regards,
 --

 ---+--
 I set the clouds in motion - turn up   | Frank Warmerdam,
 warmer...@pobox.com
 light and sound - activate the windows | http://pobox.com/~warmerdam
 and watch the world go round - Rush| Geospatial Programmer for Rent




 --
 Sebastian E. Ovide







-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] ESRI binary grids RRD files ?

2010-10-19 Thread Sebastian E. Ovide

Hi Guys,

ESRI Binary grids contains a bunch of adf files and rrd files that I believe
contains pyramids.

Does MapServer needs those rrd files ? the question is because they are very
big !

thanks


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] doubt about mapserver URL: coordinate system

2010-10-07 Thread Sebastian E. Ovide

you are right. Thanks

On Wed, Oct 6, 2010 at 6:15 PM, Rahkonen Jukka jukka.rahko...@mmmtike.fiwrote:

 Hi,

 It looks like your application is calling Mapserver with native CGI
 requests and I believe you have defined some special Mapserver layer in your
 application. Try to change it to standard WMS layer.


 -Jukka Rahkonen-


 Sebastian E. Ovide wrote:

 Lähetetty: ke 6.10.2010 18:06
 Vastaanottaja: mapserver-users@lists.osgeo.org
 Aihe: [mapserver-users] doubt about mapserver URL: coordinate system

 Hi List

 I'm using OpenLayers + MapServer. With Firebug I see that OpenLayers calls
 MapServer with ULRs like this:

 http://mapserver/mapserver?layers=NAFRA_2008_final
 map=/home/gis/conf/mapserver/uk.map
 mode=map
 map_imagetype=png
 mapext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
 imgext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
 map_size=256+256
 imgx=128
 imgy=128
 imgxy=256+256

 Just trying to understand the coordinate system used by mapext and imgext.
 (
 it is different from than that used to call Google servers:

 http://mt0.google.com/vt/lyr...@133hl=ensrc=apix=257246y=166679z=19s=G
 )

 Is it possible to use a different coordinate system ? say for example the
 same coordinate system specified in the LAYER (in my case epsg:27700)

 thanks

 --
 Sebastian E. Ovide




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] doubt about mapserver URL: coordinate system

2010-10-06 Thread Sebastian E. Ovide

Hi List

I'm using OpenLayers + MapServer. With Firebug I see that OpenLayers calls
MapServer with ULRs like this:

http://mapserver/mapserver?layers=NAFRA_2008_final
map=/home/gis/conf/mapserver/uk.map
mode=map
map_imagetype=png
mapext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
imgext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
map_size=256+256
imgx=128
imgy=128
imgxy=256+256

Just trying to understand the coordinate system used by mapext and imgext. (
it is different from than that used to call Google servers:
http://mt0.google.com/vt/lyr...@133hl=ensrc=apix=257246y=166679z=19s=G
)

Is it possible to use a different coordinate system ? say for example the
same coordinate system specified in the LAYER (in my case epsg:27700)

thanks

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GetFeatureInfo over OGR OCI Layer

2010-10-06 Thread Sebastian E. Ovide

does

ogrinfo OCI:admcarto/admca...@ora10gex GV_SIGPAC_REC_ED50

work ?

On Fri, Oct 1, 2010 at 12:25 PM, David Alda Fernandez de Lezea da...@ikt.es
 wrote:

 Hi list,

 I'm trying to execute a GetFeatureInfo request over an Oracle layer via
 OGR. I can view the content of the layer, but when I make the request I
 don't get any result. I mean, I receive an empty GML. My layer config:

 LAYER
STATUS ON
CONNECTION OCI:admcarto/admca...@ora10gex
CONNECTIONTYPE OGR
DATA GV_SIGPAC_REC_ED50 #todo el sigpac
NAME RecintosSigpacOGR
PROJECTION
init=epsg:23030
END
DUMP TRUE
TYPE POLYGON
METADATA
wms_title   Recintos Sigpac
 2009
wms_srs EPSG:23030
wms_nameRecintosSigpacOGR
wms_server_version  1.1.1
wms_format  image/gif
wms_transparent true
wms_extent  46 469 61
 482
wms_include_items   all
gml_include_items all
END
MAXSCALE 1

TEMPLATE ms_template.html
PROCESSING LABEL_NO_CLIP=ON
PROCESSING CLOSE_CONNECTION=DEFER
SYMBOLSCALE 5000

#Simbologia
CLASSGROUP Simbologia_Recintos
CLASS
TEXT ([PARCELA]:[RECINTO])
STYLE
OUTLINECOLOR 0 234 0
END
LABEL
COLOR 254 254 255
OUTLINECOLOR 0 0 0
TYPE truetype
FONT sans
SIZE 6
POSITION cc
PARTIALS TRUE
END
NAME RecintosSigPac
GROUP Referencia_Sigpac
END

CLASS
STYLE
OUTLINECOLOR 0 234 0
WIDTH 1
END
NAME RecintosSigPac
GROUP Predeterminado
END

END

 Resultant file

 ?xml version=1.0 encoding=ISO-8859-1?

 msGMLOutput
 xmlns:gml=http://www.opengis.net/gml;
 xmlns:xlink=http://www.w3.org/1999/xlink;
 xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
 /msGMLOutput

 Any ideas? Something wrong configured?

 Thanks.


 Un saludo,


 ··

 David Alda Fernández de Lezea
 Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad

 IKT
 Granja Modelo s/n · 01192 · Arkaute (Araba)


 ··
 Tlfnos.: 945-00-32-95 Fax: 945-00.32.90

 ··
 email: da...@ikt.esweb: www.ikt.es

 ··
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] lighttpd, TNS:could not resolve...

2010-10-05 Thread Sebastian E. Ovide

Bingo ! yes, that worked...

resuming:

replaced TNS connection string

CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE

with EZConnect  syntax

CONNECTION OCI:GEO_US_DATA/geo_us_d...@192.168.60.70/MFUATDB:CA_WILDFIRE

where the tnsnames.ora is

MFUATDB =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = MFUATDB)
)
  )

Thanks

On Tue, Oct 5, 2010 at 12:48 PM, Michael Smith michael.sm...@usace.army.mil
 wrote:

  Sebastian,

 Instead of using TNS, you could try the EZConnect syntax of
 @host:port/service_name. That way you bypass even needing a TNS. Also if
 your port is 1521, you can just not include it and use

 CONNECTION “user/p...@hostname/service_name”

 Mike



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] lighttpd, TNS:could not resolve...

yes.


g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
-rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
g...@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
MFUATDB =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = mfuatdb)
)
  )


On Wed, Sep 29, 2010 at 7:58 PM, Dan Little danlit...@yahoo.com wrote:

 Is tnsnames.ora accessible by the web-server user? (Check the permissions.)

 Is t
 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, September 29, 2010 11:10:09 AM
 *Subject:* [mapserver-users] lighttpd, TNS:could not resolve...

 Hi All,

 I have installed MapServer on lighttpd + fastcgi.

 fastcgi.server = (
 /mapserver =
 ( localhost =
 (
 socket = /tmp/mapserver-fastcgi.socket,
 bin-path = /home/gis/bin/mapserv,
 bin-environment =
 (
 TNS_ADMIN = /home/gis/conf/
 ),
 max-procs = 2,
 check-local = disable
 )
 )
 )


 g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )

 and I'm getting:

 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
 `TESTII'. ORA-12154: TNS:could not resolve the connect identifier specified
 in unnamed

 from the logs:

 [Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
 [Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open failed
 for OGR connection in layer `TESTII'.
 ORA-12154: TNS:could not resolve the connect identifier specified
  in unnamed

 [Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error. Failed
 to draw layer named 'TESTII'.
 [Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.
 [Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at 0xa0237a0.
 [Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at 0xa024718.


 in mapserver:

   LAYER
 NAME TESTII
 TYPE POLYGON
 STATUS ON
 CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb
 CONNECTIONTYPE OGR
 DATA CA_WILDFIRE
 PROJECTION
   init=epsg:3857
 END
 CLASS
 #  NAME local_shape
   COLOR 0 0 255
   OUTLINECOLOR 0 0 255
 END
   END



 The connection string is right as I'm using it from gdal:

 g...@mapserver:~$ ogrinfo OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE
 INFO: Open of `OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE'
   using driver `OCI' successful.
 1: CA_WILDFIRE


 any ideas ?


 --
 Sebastian E. Ovide








-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] lighttpd, TNS:could not resolve...

no luck...

renamed servicename to capital.. so now connection name==service name...

same problem... ogrinfo works, mapserver doesn't

On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka
jukka.rahko...@mmmtike.fiwrote:

  Hi,

 For me, sometimes with some Oracle user name from some computers SQL*Plus
 does not understand if I am using the SERVICE_NAME.  It you happen to have
 the same situation you should be able to connect with the connection name,
 which seems to be MFUATDB for you.

 Actually, the error message TNS:could not resolve the connect identifier
 specified may mean that you should not use service name but the connect
 identifier.  Have a try and tell how it went.


 -Jukka Rahkonen-


  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 30. syyskuuta 2010 11:15
 *Vastaanottaja:* Dan Little
 *Kopio:* mapserver-users@lists.osgeo.org
 *Aihe:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 yes.


  g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
 -rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
 g...@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )


 On Wed, Sep 29, 2010 at 7:58 PM, Dan Little danlit...@yahoo.com wrote:

  Is tnsnames.ora accessible by the web-server user? (Check the
 permissions.)

  Is t
 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, September 29, 2010 11:10:09 AM
 *Subject:* [mapserver-users] lighttpd, TNS:could not resolve...

 Hi All,

 I have installed MapServer on lighttpd + fastcgi.

  fastcgi.server = (
 /mapserver =
 ( localhost =
 (
 socket = /tmp/mapserver-fastcgi.socket,
 bin-path = /home/gis/bin/mapserv,
 bin-environment =
 (
 TNS_ADMIN = /home/gis/conf/
 ),
 max-procs = 2,
 check-local = disable
 )
 )
 )


  g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )

 and I'm getting:

 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
 `TESTII'. ORA-12154: TNS:could not resolve the connect identifier specified
 in unnamed

 from the logs:

  [Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
 [Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open failed
 for OGR connection in layer `TESTII'.
 ORA-12154: TNS:could not resolve the connect identifier specified
  in unnamed

 [Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error.
 Failed to draw layer named 'TESTII'.
 [Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.
 [Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at 0xa0237a0.
 [Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at 0xa024718.


 in mapserver:

LAYER
 NAME TESTII
 TYPE POLYGON
 STATUS ON
 CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb
 CONNECTIONTYPE OGR
 DATA CA_WILDFIRE
 PROJECTION
   init=epsg:3857
 END
 CLASS
 #  NAME local_shape
   COLOR 0 0 255
   OUTLINECOLOR 0 0 255
 END
   END



 The connection string is right as I'm using it from gdal:

  g...@mapserver:~$ ogrinfo OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE
 INFO: Open of `OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE'
   using driver `OCI' successful.
 1: CA_WILDFIRE


 any ideas ?


 --
 Sebastian E. Ovide








 --
 Sebastian E. Ovide







-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] lighttpd, TNS:could not resolve...

on the same machine, with the same data and same tns file it works fine with
APACHE the problems is only with LIGHTTPD... it looks like TNS_ADMIN
= /home/gis/conf/ is ignored (in apache I've used SetEnv and PassEnv

???

On Thu, Sep 30, 2010 at 12:22 PM, Dan Little danlit...@yahoo.com wrote:

 Does shp2img work with your Mapfile?


 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* Rahkonen Jukka jukka.rahko...@mmmtike.fi
 *Cc:* mapserver-users@lists.osgeo.org
 *Sent:* Thu, September 30, 2010 4:47:30 AM
 *Subject:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 the message says:

 ORA-12154: TNS:could not resolve the connect identifier specified in
 unnamed

 so... does unnamed mean that gdal didn't get any name for the connection
 ?



 On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide 
 sebastian.ov...@gmail.com wrote:

 no luck...

 renamed servicename to capital.. so now connection name==service name...

 same problem... ogrinfo works, mapserver doesn't


 On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka 
 jukka.rahko...@mmmtike.fi wrote:

  Hi,

 For me, sometimes with some Oracle user name from some computers SQL*Plus
 does not understand if I am using the SERVICE_NAME.  It you happen to have
 the same situation you should be able to connect with the connection name,
 which seems to be MFUATDB for you.

 Actually, the error message TNS:could not resolve the connect
 identifier specified may mean that you should not use service name but the
 connect identifier.  Have a try and tell how it went.


 -Jukka Rahkonen-


  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 30. syyskuuta 2010 11:15
 *Vastaanottaja:* Dan Little
 *Kopio:* mapserver-users@lists.osgeo.org
 *Aihe:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 yes.


  g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
 -rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
 g...@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )


 On Wed, Sep 29, 2010 at 7:58 PM, Dan Little danlit...@yahoo.com wrote:

  Is tnsnames.ora accessible by the web-server user? (Check the
 permissions.)

  Is t
 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, September 29, 2010 11:10:09 AM
 *Subject:* [mapserver-users] lighttpd, TNS:could not resolve...

 Hi All,

 I have installed MapServer on lighttpd + fastcgi.

  fastcgi.server = (
 /mapserver =
 ( localhost =
 (
 socket = /tmp/mapserver-fastcgi.socket,
 bin-path = /home/gis/bin/mapserv,
 bin-environment =
 (
 TNS_ADMIN = /home/gis/conf/
 ),
 max-procs = 2,
 check-local = disable
 )
 )
 )


  g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )

 and I'm getting:

 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
 `TESTII'. ORA-12154: TNS:could not resolve the connect identifier specified
 in unnamed

 from the logs:

  [Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
 [Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open
 failed for OGR connection in layer `TESTII'.
 ORA-12154: TNS:could not resolve the connect identifier specified
  in unnamed

 [Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error.
 Failed to draw layer named 'TESTII'.
 [Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.
 [Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at
 0xa0237a0.
 [Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at
 0xa024718.


 in mapserver:

LAYER
 NAME TESTII
 TYPE POLYGON
 STATUS ON
 CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb
 CONNECTIONTYPE OGR
 DATA CA_WILDFIRE
 PROJECTION
   init=epsg:3857
 END
 CLASS
 #  NAME local_shape
   COLOR 0 0 255
   OUTLINECOLOR 0 0 255
 END
   END



 The connection string is right as I'm using it from gdal:

  g...@mapserver:~$ ogrinfo OCI:GEO_US_DATA/geo_us_d...@mfuatdb
 :CA_WILDFIRE
 INFO: Open of `OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE'
   using driver `OCI' successful.
 1: CA_WILDFIRE


 any ideas ?


 --
 Sebastian E. Ovide








 --
 Sebastian E

Re: [mapserver-users] lighttpd, TNS:could not resolve...

updates.

even if it works with APACHE + CGI, it does NOT work with APACHE+FASTCGI
(AppClass /home/gis/bin/mapserv -initial-env TNS_ADMIN=/home/gis/conf/)

On Thu, Sep 30, 2010 at 2:01 PM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 on the same machine, with the same data and same tns file it works fine
 with APACHE the problems is only with LIGHTTPD... it looks like 
 TNS_ADMIN
 = /home/gis/conf/ is ignored (in apache I've used SetEnv and PassEnv

 ???

 On Thu, Sep 30, 2010 at 12:22 PM, Dan Little danlit...@yahoo.com wrote:

 Does shp2img work with your Mapfile?


 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* Rahkonen Jukka jukka.rahko...@mmmtike.fi
 *Cc:* mapserver-users@lists.osgeo.org
 *Sent:* Thu, September 30, 2010 4:47:30 AM
 *Subject:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 the message says:

 ORA-12154: TNS:could not resolve the connect identifier specified in
 unnamed

 so... does unnamed mean that gdal didn't get any name for the connection
 ?



 On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide 
 sebastian.ov...@gmail.com wrote:

 no luck...

 renamed servicename to capital.. so now connection name==service name...

 same problem... ogrinfo works, mapserver doesn't


 On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka 
 jukka.rahko...@mmmtike.fi wrote:

  Hi,

 For me, sometimes with some Oracle user name from some computers
 SQL*Plus does not understand if I am using the SERVICE_NAME.  It you happen
 to have the same situation you should be able to connect with the 
 connection
 name, which seems to be MFUATDB for you.

 Actually, the error message TNS:could not resolve the connect
 identifier specified may mean that you should not use service name but the
 connect identifier.  Have a try and tell how it went.


 -Jukka Rahkonen-


  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 30. syyskuuta 2010 11:15
 *Vastaanottaja:* Dan Little
 *Kopio:* mapserver-users@lists.osgeo.org
 *Aihe:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 yes.


  g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
 -rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
 g...@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )


 On Wed, Sep 29, 2010 at 7:58 PM, Dan Little danlit...@yahoo.comwrote:

  Is tnsnames.ora accessible by the web-server user? (Check the
 permissions.)

  Is t
 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, September 29, 2010 11:10:09 AM
 *Subject:* [mapserver-users] lighttpd, TNS:could not resolve...

 Hi All,

 I have installed MapServer on lighttpd + fastcgi.

  fastcgi.server = (
 /mapserver =
 ( localhost =
 (
 socket = /tmp/mapserver-fastcgi.socket,
 bin-path = /home/gis/bin/mapserv,
 bin-environment =
 (
 TNS_ADMIN = /home/gis/conf/
 ),
 max-procs = 2,
 check-local = disable
 )
 )
 )


  g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )

 and I'm getting:

 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
 `TESTII'. ORA-12154: TNS:could not resolve the connect identifier 
 specified
 in unnamed

 from the logs:

  [Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
 [Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open
 failed for OGR connection in layer `TESTII'.
 ORA-12154: TNS:could not resolve the connect identifier specified
  in unnamed

 [Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error.
 Failed to draw layer named 'TESTII'.
 [Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at
 0xa00f298.
 [Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at
 0xa0237a0.
 [Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at
 0xa024718.


 in mapserver:

LAYER
 NAME TESTII
 TYPE POLYGON
 STATUS ON
 CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb
 CONNECTIONTYPE OGR
 DATA CA_WILDFIRE
 PROJECTION
   init=epsg:3857
 END
 CLASS
 #  NAME local_shape
   COLOR 0 0 255
   OUTLINECOLOR 0 0 255
 END
   END



 The connection string is right as I'm using it from gdal:

  g

Re: [mapserver-users] lighttpd, TNS:could not resolve...

done. (restarted server etc...)

exactly the same problem...





On Thu, Sep 30, 2010 at 2:51 PM, Dan Little danlit...@yahoo.com wrote:

 I was starting to suspect MapServer is just no seeing the environment
 variables...

 Try this... write a wrapper script mapserv.sh

 #!/bin/bash

 TNS_ADMIN=/home/gis/conf

 /home/gis/bin/mapserv

 Then update your script to point to mapserv.sh.




 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* Dan Little danlit...@yahoo.com
 *Cc:* Rahkonen Jukka jukka.rahko...@mmmtike.fi;
 mapserver-users@lists.osgeo.org
 *Sent:* Thu, September 30, 2010 8:01:22 AM

 *Subject:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 on the same machine, with the same data and same tns file it works fine
 with APACHE the problems is only with LIGHTTPD... it looks like 
 TNS_ADMIN
 = /home/gis/conf/ is ignored (in apache I've used SetEnv and PassEnv

 ???

 On Thu, Sep 30, 2010 at 12:22 PM, Dan Little danlit...@yahoo.com wrote:

 Does shp2img work with your Mapfile?


 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* Rahkonen Jukka jukka.rahko...@mmmtike.fi
 *Cc:* mapserver-users@lists.osgeo.org
 *Sent:* Thu, September 30, 2010 4:47:30 AM
 *Subject:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 the message says:

 ORA-12154: TNS:could not resolve the connect identifier specified in
 unnamed

 so... does unnamed mean that gdal didn't get any name for the connection
 ?



 On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide 
 sebastian.ov...@gmail.com wrote:

 no luck...

 renamed servicename to capital.. so now connection name==service name...

 same problem... ogrinfo works, mapserver doesn't


 On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka 
 jukka.rahko...@mmmtike.fi wrote:

  Hi,

 For me, sometimes with some Oracle user name from some computers
 SQL*Plus does not understand if I am using the SERVICE_NAME.  It you happen
 to have the same situation you should be able to connect with the 
 connection
 name, which seems to be MFUATDB for you.

 Actually, the error message TNS:could not resolve the connect
 identifier specified may mean that you should not use service name but the
 connect identifier.  Have a try and tell how it went.


 -Jukka Rahkonen-


  --
 *Lähettäjä:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide
 *Lähetetty:* 30. syyskuuta 2010 11:15
 *Vastaanottaja:* Dan Little
 *Kopio:* mapserver-users@lists.osgeo.org
 *Aihe:* Re: [mapserver-users] lighttpd, TNS:could not resolve...

 yes.


  g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
 -rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
 g...@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )


 On Wed, Sep 29, 2010 at 7:58 PM, Dan Little danlit...@yahoo.comwrote:

  Is tnsnames.ora accessible by the web-server user? (Check the
 permissions.)

  Is t
 *From:* Sebastian E. Ovide sebastian.ov...@gmail.com
 *To:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, September 29, 2010 11:10:09 AM
 *Subject:* [mapserver-users] lighttpd, TNS:could not resolve...

 Hi All,

 I have installed MapServer on lighttpd + fastcgi.

  fastcgi.server = (
 /mapserver =
 ( localhost =
 (
 socket = /tmp/mapserver-fastcgi.socket,
 bin-path = /home/gis/bin/mapserv,
 bin-environment =
 (
 TNS_ADMIN = /home/gis/conf/
 ),
 max-procs = 2,
 check-local = disable
 )
 )
 )


  g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
 MFUATDB =
   (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mfuatdb)
 )
   )

 and I'm getting:

 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
 `TESTII'. ORA-12154: TNS:could not resolve the connect identifier 
 specified
 in unnamed

 from the logs:

  [Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
 [Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open
 failed for OGR connection in layer `TESTII'.
 ORA-12154: TNS:could not resolve the connect identifier specified
  in unnamed

 [Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error.
 Failed to draw layer named 'TESTII'.
 [Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at
 0xa00f298.
 [Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at
 0xa0237a0.
 [Wed Sep 29 17:00:13 2010].717591

[mapserver-users] lighttpd, TNS:could not resolve...

2010-09-29 Thread Sebastian E. Ovide

Hi All,

I have installed MapServer on lighttpd + fastcgi.

fastcgi.server = (
/mapserver =
( localhost =
(
socket = /tmp/mapserver-fastcgi.socket,
bin-path = /home/gis/bin/mapserv,
bin-environment =
(
TNS_ADMIN = /home/gis/conf/
),
max-procs = 2,
check-local = disable
)
)
)


g...@mapserver:~$ cat /home/gis/conf/tnsnames.ora
MFUATDB =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = mfuatdb)
)
  )

and I'm getting:

msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
`TESTII'. ORA-12154: TNS:could not resolve the connect identifier specified
in unnamed

from the logs:

[Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
[Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open failed
for OGR connection in layer `TESTII'.
ORA-12154: TNS:could not resolve the connect identifier specified
 in unnamed

[Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error. Failed
to draw layer named 'TESTII'.
[Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.
[Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at 0xa0237a0.
[Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at 0xa024718.


in mapserver:

  LAYER
NAME TESTII
TYPE POLYGON
STATUS ON
CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb
CONNECTIONTYPE OGR
DATA CA_WILDFIRE
PROJECTION
  init=epsg:3857
END
CLASS
#  NAME local_shape
  COLOR 0 0 255
  OUTLINECOLOR 0 0 255
END
  END



The connection string is right as I'm using it from gdal:

g...@mapserver:~$ ogrinfo OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE
INFO: Open of `OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE'
  using driver `OCI' successful.
1: CA_WILDFIRE


any ideas ?


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] get polygons that contains a point

2010-09-20 Thread Sebastian E. Ovide

yes, this works wonderfully !

just wondering if this is a MapServer only feature of if it is part of some
OGC standard 



On Thu, Sep 16, 2010 at 4:00 PM, Lime, Steve D (DNR) steve.l...@state.mn.us
 wrote:

  In addition, the standard CGI mode=nquery will do this for you and you
 can craft WFS filters to do so as well.



 Steve



 *From:* mapserver-users-boun...@lists.osgeo.org [mailto:
 mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *Josh Hevenor
 *Sent:* Thursday, September 16, 2010 6:50 AM
 *To:* Sebastian E. Ovide
 *Cc:* mapserver-users@lists.osgeo.org
 *Subject:* Re: [mapserver-users] get polygons that contains a point



 Hi Sebastian
 Take a look at the queryByPoint function found here
 http://mapserver.org/mapscript/php/index.html#layerobj

 Hope this helps,
 Josh

 On 9/16/2010 7:35 AM, Sebastian E. Ovide wrote:

 Hi All

 I have a OGR Layer. Is there any service that I can use to retrieve all the
 polygons from that layer that contain a given point ? So in the request I
 add the coordinates and as response I get the polygons that own that point

 thanks


 --
 Sebastian E. Ovide








 ___

 mapserver-users mailing list

 mapserver-users@lists.osgeo.org

 http://lists.osgeo.org/mailman/listinfo/mapserver-users







 No virus found in this incoming message.

 Checked by AVG - www.avg.com

 Version: 8.5.441 / Virus Database: 271.1.1/3136 - Release Date: 09/15/10 
 06:34:00






-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] msQueryByPoint(): template for no matching record found

2010-09-20 Thread Sebastian E. Ovide

Hi All,

Is it possible to customize the msQueryByPoint(): Search returned no
results. No matching record(s) found.  message? maybe configuring a
template that specific error ???

thanks
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] get polygons that contains a point

2010-09-16 Thread Sebastian E. Ovide

Hi All

I have a OGR Layer. Is there any service that I can use to retrieve all the
polygons from that layer that contain a given point ? So in the request I
add the coordinates and as response I get the polygons that own that point

thanks


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Itasca Application: mapserv(): Web application error. Query mode needs a point, imgxy and mapxy are not set.

2010-09-16 Thread Sebastian E. Ovide

Hi Guys,

just playing around with the Itasca Application. Selecting Query features I
get mapserv(): Web application error. Query mode needs a point, imgxy and
mapxy are not set.

any ideas ?

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: Itasca Application: mapserv(): Web application error. Query mode needs a point, imgxy and mapxy are not set.

2010-09-16 Thread Sebastian E. Ovide

Ops, It works fine... just need to click inside a Polygon !

On Thu, Sep 16, 2010 at 4:08 PM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 Hi Guys,

 just playing around with the Itasca Application. Selecting Query features I
 get mapserv(): Web application error. Query mode needs a point, imgxy and
 mapxy are not set.

 any ideas ?

 --
 Sebastian E. Ovide







-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] FOSS4G benchmark

2010-09-10 Thread Sebastian E. Ovide

Hi Guys

http://svn.osgeo.org/osgeo/foss4g/benchmarking/scripts/results/2010/mapserver/
is empty. Is there anywhere where I can find the MapServer results ?

thanks

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Commercial support

2010-09-03 Thread Sebastian E. Ovide

Hi Guys,

Some companies choose commercial software such as Oracle MapViewer because
they offer the security of commercial support. So if the companies have any
problem configuring it (or any other problem) they will use the support that
they have paid for.

IT engineers in general can learn for them self and with the help of the
community support (mailing list) they are able to solve virtually any
problem. And MapServer mailing list is the perfect example of that.

Nevertheless, CEOs and boards of directors still need some kind of security
and they prefer to use software that provide commercial support.

Are you guys aware of companies that provide commercial support for
MapServer ?

thanks,



-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Commercial support

2010-09-03 Thread Sebastian E. Ovide

 http://www.osgeo.org/search_profile



Thanks for that guys. That is exactly what I was looking for.

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] California in Africa

2010-08-31 Thread Sebastian E. Ovide

Hi Guys,

I'm reading a MapInfo California Map with MapServer and google maps and I
can see California in Africa (in the Gulf of Guinea). I have tried
different  epsg in the projection section but I cannot find the correct one.

Any ideas ?

thanks


Geometry: Unknown (any)
Feature Count: 120871
Extent: (-373876.958741, -604494.167244) - (540030.000742, 450023.697768)
Layer SRS WKT:
PROJCS[unnamed,
GEOGCS[unnamed,
DATUM[North_American_Datum_1983,
SPHEROID[GRS 80,6378137,298.257222101],
TOWGS84[0,0,0,-0,-0,-0,0]],
PRIMEM[Greenwich,0],
UNIT[degree,0.0174532925199433]],
PROJECTION[Albers_Conic_Equal_Area],
PARAMETER[standard_parallel_1,40.5],
PARAMETER[standard_parallel_2,34],
PARAMETER[latitude_of_center,0],
PARAMETER[longitude_of_center,-120],
PARAMETER[false_easting,0],
PARAMETER[false_northing,-400],
UNIT[Meter,1.0]]
IncorporatedArea: String (1.0)
HazardCode: Real (4.0)
HazardClass: String (25.0)


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: California in Africa

2010-08-31 Thread Sebastian E. Ovide

3310 did it

On Tue, Aug 31, 2010 at 9:47 AM, Sebastian E. Ovide 
sebastian.ov...@gmail.com wrote:

 Hi Guys,

 I'm reading a MapInfo California Map with MapServer and google maps and I
 can see California in Africa (in the Gulf of Guinea). I have tried
 different  epsg in the projection section but I cannot find the correct one.

 Any ideas ?

 thanks


 Geometry: Unknown (any)
 Feature Count: 120871
 Extent: (-373876.958741, -604494.167244) - (540030.000742, 450023.697768)
 Layer SRS WKT:
 PROJCS[unnamed,
 GEOGCS[unnamed,
 DATUM[North_American_Datum_1983,
 SPHEROID[GRS 80,6378137,298.257222101],
 TOWGS84[0,0,0,-0,-0,-0,0]],
 PRIMEM[Greenwich,0],
 UNIT[degree,0.0174532925199433]],
 PROJECTION[Albers_Conic_Equal_Area],
 PARAMETER[standard_parallel_1,40.5],
 PARAMETER[standard_parallel_2,34],
 PARAMETER[latitude_of_center,0],
 PARAMETER[longitude_of_center,-120],
 PARAMETER[false_easting,0],
 PARAMETER[false_northing,-400],
 UNIT[Meter,1.0]]
 IncorporatedArea: String (1.0)
 HazardCode: Real (4.0)
 HazardClass: String (25.0)


 --
 Sebastian E. Ovide







-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver on Tomcat ??!

2010-08-30 Thread Sebastian E. Ovide

Hi, you can run MapServer on the same machine that runs Tomcat if you want

On Mon, Aug 30, 2010 at 8:04 AM, mani2604 mani2...@gmail.com wrote:


 Hi there,
 Well we've been using MS4W package on Windows Server 2003 till
 now.. So Is it possible to run mapserver on Tomcat?
 --
 View this message in context:
 http://osgeo-org.1803224.n2.nabble.com/Mapserver-on-Tomcat-tp5477064p5477064.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

2010-08-16 Thread Sebastian E. Ovide

Hi Ivan,


On Mon, Aug 16, 2010 at 6:02 AM, Lucena, Ivan ivan.luc...@pmldnet.comwrote:

 Sebastian,

 I have this little piece of code in Python that shows how 18 levels of
 pyramids would look like:

 ...
...

 10 185 265 1 1 1049401
 11 92 132 1 1 1049402
 ** What you don't have: **
 12 46 66 1 1 1049403
 13 23 33 1 1 1049404
 14 11 16 1 1 1049405
 15 5 8 1 1 1049406
 16 2 4 1 1 1049407
 17 1 2 1 1 1049408

 Where:


 ...

...



 You said that “it performs very well at zoom level under 12” and performs
 poorly with zoom level between 13 and 17.



are MapServer/GoogleMaps zoom level exactly the same as Oracle PyramidLevels
?

For example... in Oracle , Pyramid level 0 means maximum zoom... that in
MapServer/GoogleMaps it would something like 20 ???


 The problem is that you don't have those levels built into your GeoRaster
 object.

 So, before doing any change to the system settings, could you please try to
 increase the number of pyramids to 17?

 Building the pyramids is a internal process on the server. Even if you use
 gdaladdo, that will just call a function from the GeoRaster PL/SQL
 extension.

 It wouldn't take as long as before because it will add up to the existing
 levels.

 The PL/SQL call should looks like that:

 declare
  gr sdo_georaster;
 begin
  select georaster into gr from fluvd04q200pj where id = 1 for update;
  sdo_geor.generatePyramid(gr, 'rlevel=17 resampling=NN');
  update fluvd04q200pj set georaster = gr where id = 1;
  commit;
 end;
 /


from Oracle documentation

rLevel (for example, rLevel=2): Specifies the maximum reduction level: the
number of pyramid levels to create at a smaller (reduced) size than the
original
object. If you do not specify this keyword, pyramid levels are generated
until the
smaller of the number of rows or columns is between 64 and 128. The
dimension
sizes at each lower resolution level are equal to the truncated integer
values of the
dimension sizes at the next higher resolution level, divided by 2.

I've ignored the Oracle documentation and I've run it anyway... It toked 0.5
seconds to run !

In my case that code would not create any pyramids as I have already run
sdo_geor.generatePyramid(gr, 'resampling=NN'); which would build the maximun
levels of pyramids...


 And the gdaladdo command should look like that:

 gdaladdo
 georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1 2 4
 8 16 32 64 128 256 512 1024 2048 4096 8192 16384 32768 65536

 Best regards,

 Ivan



 Sebastian E. Ovide wrote:

 Ivan,



Yes!

and

No!

That query creates a *cursor* to go through the whole raster,
meaning, all the rows on the RasterDataTable that satisfy that query
in the order stipulated by it.

It does require a some memory but it looks like you got it.

 mmm... that makes me little bit nervous... I am testing it with a small
 map. Its is only UK with 5mx5m pixel Just wondering how this approach
 would scale to larger maps... US is 40 times bigger than UK... and they have
 more accurated maps and more than a single layer Just wondering how
 many manual configuration I'll be forced to do (Oracle created Spatial
 extention exactly for this reason... so the developer do not to think about
 handling blobs for him self anymore... reducing costs and risks)


By the way, how long does it take to produce a geotiff file? Have
loaded that image on QuantumGIS using the oracle_raster plugin? Hoes
does it perform?


 it is not possible to create a TIFF as it would be too big (max size is
 4GB)... and UK would be arounf 16GB (300MB in Oracle as I'm using deflate)

 I am testing Oracle MapViewer on the same table and it HAS the same
 problem The strange thing is that using MapBuilder (Oracle software to
 prepare the maps to use with MapViewer) the maps are displayed very fast at
 ANY zoom level !... therefore there is a way to do it fast (as MapBuilder
 does...)


I was expecting to find in the logs some query that reads a
subset of the whole image (just the tile/metatile that MapServer
is serving) for example using SDO_GEOR.getRasterSubset..


That would be very slow. The GDAL driver access the BLOB directly.

  not sure about that... well I guess that at least it releases some work
 from the Oracle server...  Anyway, as I have a spatial index, why don't just
 query only the right blobs?


I have more questions:

Are you using Mapserver FastCGI with a recent version?


 nop... I have not tried that yet... I'll try on Monday... I have tried as
 cgi and recently as mod_python.

If you do, them the process will remains in memory, the GDALDataset
associated with that GeoRaster will be keet, the *cursor* you remain
alive and all the zooms and pans are going to work faster. Like for
QGIS. Unless, of course, Mapserver is feeling the need to re-project
or produce a new overview tiles on the fly. Can you see that on the
 log?

Regards,

Ivan

Re: [mapserver-users] logging GDAL queries

2010-08-16 Thread Sebastian E. Ovide

Hi Ivan,

I did create those extra pyramid levels

 Overviews: 95162x135711, 47581x67855, 23790x33927, 11895x16963, 5947x8481,
2973x4240, 1486x2120, 743x1060, 371x530, 185x265, 92x132, 46x66, 23x33,
11x16, 5x8, 2x4, 1x2

 the performance has not improved. Why should it ? the extra pyramid levels
contains 46x66, 23x33, 11x16, 5x8, 2x4, 1x2 but the problems that I am
having are for 95162x135711, 47581x67855, 23790x33927, 11895x16963... that
are low pyramid levels... (ie: high zoom=low pyramid level)...

thanks

On Mon, Aug 16, 2010 at 1:30 PM, Ivan Lucena ivan.luc...@pmldnet.comwrote:

 Hi Sebastian,

 Did you fix the problem with the pyramid levels?

 Do you see any improved where the performance was poor before?

 Thanks for your valuable test. I appreciate.

 Regards,

 Ivan




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

2010-08-16 Thread Sebastian E. Ovide

Thank Ivan, I appreciate your help.

Regards

On Mon, Aug 16, 2010 at 7:23 PM, Ivan Lucena ivan.luc...@pmldnet.comwrote:

 Sebastian,

the performance has not improved. Why should it ? the extra pyramid
   levels contains 46x66, 23x33, 11x16, 5x8, 2x4, 1x2 but the problems
   that I am having are for 95162x135711, 47581x67855, 23790x33927,
   11895x16963... that are low pyramid levels... (ie: high zoom=low pyramid
   level)...

 If you are still having problem with MapViewer I suggest you to post your
 log at [http://forums.oracle.com/forums/forum.jspa?forumID=727]. Any
 improvement on MapServer+GeoRaster through GDAL would take a little bit of
 time to adapt the initial ETL design.

 Regards,

 Ivan



-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

2010-08-14 Thread Sebastian E. Ovide

Hi Ivan,

the pyramid levels in Oracle are not exactly the same as the zoom levels in
MapServer... Each level whould have 1/4 number of pixels as the previous
level...ie: X/2*Y/2

The size of the pyramid image at each level is determined by the original
image size and the pyramid level, according to the following formulas:


r(n) = (int)(r(0) / 2^n)
c(n) = (int)(c(0) / 2^n)


In my case I have generated all the possible levels of pyramids... The Idea
of generating the pyramids is to speeding up the zoomed out images.. ie: if
you want to display the whole UK, you do not need to get the 100kx160k
pixels... you can read an upper level in the pyramid reading only 1kx1k
pixels... in the same way, if you need to do a zoom in at street level, you
can read from the level 0, that means reading the maximum resolution and it
is fast as you read only a fraction of the whole image...

with MapViewer+GDAL it getting very slow when generating tiles at street
level  it should not be at that point you do not need pyramid any
more...

If I didn't have created pyramids, it still would be fast at street level
but it would be very slow at city level and it would be impossible to
display at country level...

does it make sense ?

On Fri, Aug 13, 2010 at 6:57 PM, Ivan Lucena ivan.luc...@pmldnet.comwrote:

 Sebastian,

 You said:

  yep I did... and the weir thing is that generating the images from far
  away zoom under 12... it performs very well... not sure why it doesn't
  in the levels 13-17  for that reason I was trying to find the SQL
  queries

 But your GeoRaster Pyramid level is maxLevel11/maxLevel

 By the size of you image you should have 20 level.

 Can you run sdo_geor.generatePyramid() again changing only the number of
 levels, keeping the same method. That should run faster, keeping the
 existing pyramid levels.

 Please let me know how it works now.

 Regards,

 Ivan

   ---Original Message---
   From: Ivan Lucena ivan.luc...@pmldnet.com
   To: Sebastian E. Ovide sebastian.ov...@gmail.com
   Cc: mapserver-users@lists.osgeo.org
   Subject: Re: [mapserver-users] logging GDAL queries
   Sent: Aug 13 '10 11:16
 
   Sebastian,
 
 ---Original Message---
 From: Sebastian E. Ovide sebastian.ov...@gmail.com
 To: Ivan Lucena ivan.luc...@pmldnet.com
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] logging GDAL queries
 Sent: Aug 13 '10 09:27
   
 On Fri, Aug 13, 2010 at 1:59 PM, Ivan Lucena [LINK:
 mailto:ivan.luc...@pmldnet.com] ivan.luc...@pmldnet.com wrote:
 Sebastian,
   
 You are using a very small block size, maybe because you are also
 using
 ArcGIS products and they only support Oracle GeoRaster with 256x256
 blocking. Is that right?
   
   
 nop... I guess that 256x256 if the default gdal_translate block size
 ?
 
   That is the default on GDAL/GeoRaster driver but you can change it using
 -co BLOCKXSIZE and -co BLOCKYSIZE.
 
   But that would require you to load the image again (and generate
 Pyramids again...)
 
   
 Because of that, to access your GeoRaster object, the GDAL driver is
 requesting a very large array of BLOB (100 approximately). That
 can
 make your sever such-up memory from the machine where it is running
 and it
 is probably using virtual memory (disk) what is really slow.
   
 do you mean where MapServer is running ?
   
 top - 14:41:31 up 7 days,  6:20, 10 users,  load average: 2.81, 1.92,
 1.20
 Tasks: 340 total,   2 running, 338 sleeping,   0 stopped,   0 zombie
 Cpu(s): 11.8%us, 10.4%sy,  7.7%ni, 62.1%id,  0.0%wa,  0.0%hi,
 8.0%si,  0.0%st
 Mem:  12331240k total,  5992136k used,  6339104k free,   189416k
 buffers
 Swap:  9084716k total,   703708k used,  8381008k free,  1481992k
 cached
   
   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+
 COMMAND
 24850 www-data  20   0  533m 330m  18m R   14  2.7   0:00.94
 mapserv
 24852 www-data  20   0  532m 329m  18m S   19  2.7   0:01.22
 mapserv
 24849 www-data  20   0  529m 326m  18m S   16  2.7   0:01.00
 mapserv
 24851 www-data  20   0  517m 314m  18m S   13  2.6   0:00.96
 mapserv
 24853 www-data  20   0  499m 296m  18m S8  2.5   0:00.75
 mapserv
 24854 www-data  20   0  470m 267m  18m S5  2.2   0:00.53
 mapserv
 
   Yeah. I am sorry. I called Mapserver a client :)
 
   It is a Oracle client in that case. You probably have another nice
 machine running Oracle.
 
   That is not the problem.
 
   
It also uses some memory on the client side just to hold the array
 too
 but if you are running everything (Mapserver,Oracle) on the same
 machine
 that will adds up.
   
   
 Oracle is running on another Machine... and is very likely that it is
 the
 bottle neck...
 
   Maybe not but I believe you have tools on Enterprise Manager to show the
 volume and speed of traffic.
 
   
   
 We

Re: [mapserver-users] logging GDAL queries

2010-08-14 Thread Sebastian E. Ovide

Hi Ivan,



 Because of that, to access your GeoRaster object, the GDAL driver is
 requesting a very large array of BLOB (100 approximately). T


I do not know how apServer/GDAL works, but I cannot understand this query:


[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM
RDT_FLUVD04Q200PJ
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
AND
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]PYRAMIDLEVEL =
:3
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]BANDBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]ROWBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
COLUMNBLOCKNUMBER ASC

It looks like  MapServer/GDAL is trying to read the whole pyramid level X of
the table RDT_FLUVD04Q200PJ ?

Am I right ?

at level 0 it would read the whole raster 

I was expecting to find in the logs some query that reads a subset of the
whole image (just the tile/metatile that MapServer is serving) for example
using SDO_GEOR.getRasterSubset..

any ideas ?

thanks
-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

2010-08-14 Thread Sebastian E. Ovide

Ivan,



 Yes!

 and

 No!

 That query creates a *cursor* to go through the whole raster, meaning, all
 the rows on the RasterDataTable that satisfy that query in the order
 stipulated by it.

 It does require a some memory but it looks like you got it.


mmm... that makes me little bit nervous... I am testing it with a small map.
Its is only UK with 5mx5m pixel Just wondering how this approach would
scale to larger maps... US is 40 times bigger than UK... and they have more
accurated maps and more than a single layer Just wondering how many
manual configuration I'll be forced to do (Oracle created Spatial
extention exactly for this reason... so the developer do not to think about
handling blobs for him self anymore... reducing costs and risks)



 By the way, how long does it take to produce a geotiff file? Have loaded
 that image on QuantumGIS using the oracle_raster plugin? Hoes does it
 perform?


it is not possible to create a TIFF as it would be too big (max size is
4GB)... and UK would be arounf 16GB (300MB in Oracle as I'm using deflate)

I am testing Oracle MapViewer on the same table and it HAS the same
problem The strange thing is that using MapBuilder (Oracle software to
prepare the maps to use with MapViewer) the maps are displayed very fast at
ANY zoom level !... therefore there is a way to do it fast (as MapBuilder
does...)



  I was expecting to find in the logs some query that reads a subset of the
 whole image (just the tile/metatile that MapServer is serving) for example
 using SDO_GEOR.getRasterSubset..


 That would be very slow. The GDAL driver access the BLOB directly.


not sure about that... well I guess that at least it releases some work from
the Oracle server...  Anyway, as I have a spatial index, why don't just
query only the right blobs?


 I have more questions:

 Are you using Mapserver FastCGI with a recent version?


nop... I have not tried that yet... I'll try on Monday... I have tried as
cgi and recently as mod_python.


 If you do, them the process will remains in memory, the GDALDataset
 associated with that GeoRaster will be keet, the *cursor* you remain alive
 and all the zooms and pans are going to work faster. Like for QGIS. Unless,
 of course, Mapserver is feeling the need to re-project or produce a new
 overview tiles on the fly. Can you see that on the log?

 Regards,

 Ivan


regards


-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] logging GDAL queries

Hi All

I am using MapServer + GDAL to render GeoRasters and I am having very poor
performance reading GeoRasters at a high zoom level... over 13... it would
take even 20 seconds per tile...

Is it possible to log the GDAL queries that MapServer is doing?  (and the
SQL queries that GDAL is doing ?)

thanks

-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

yep I did... and the weir thing is that generating the images from far
away zoom under 12... it performs very well... not sure why it doesn't in
the levels 13-17  for that reason I was trying to find the SQL
queries

On Fri, Aug 13, 2010 at 12:01 PM, Lucena, Ivan ivan.luc...@pmldnet.comwrote:

 Sebastian,


 Sebastian E. Ovide wrote:

 Hi All

 I am using MapServer + GDAL to render GeoRasters and I am having very poor
 performance reading GeoRasters at a high zoom level... over 13... it would
 take even 20 seconds per tile...


 Did you generate pyramids?


 Is it possible to log the GDAL queries that MapServer is doing?  (and the
 SQL queries that GDAL is doing ?)

 thanks

 --
 Sebastian E. Ovide




 


 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

 are the versions your are running (GDAL,Oracle)?
 Older version of the driver used to run a new query every time you change
 levels.
 Sebastian E. Ovide wrote:

 yep I did... and the weir thing is that generating the images from far
 away zoom under 12... it performs very well... not sure why it doesn't in
 the levels 13-17  for that reason I was trying to find the SQL
 queries

 On Fri, Aug 13, 2010 at 12:01 PM, Lucena, Ivan 
 ivan.luc...@pmldnet.commailto:
 ivan.luc...@pmldnet.com wrote:

Sebastian,


Sebastian E. Ovide wrote:

Hi All

I am using MapServer + GDAL to render GeoRasters and I am having
very poor performance reading GeoRasters at a high zoom level...
over 13... it would take even 20 seconds per tile...


Did you generate pyramids?


Is it possible to log the GDAL queries that MapServer is doing?
 (and the SQL queries that GDAL is doing ?)

thanks

-- Sebastian E. Ovide





  


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
mailto:mapserver-users@lists.osgeo.org

http://lists.osgeo.org/mailman/listinfo/mapserver-users





 --
 Sebastian E. Ovide








-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

Thanks Bart... I can see the debug info and the queries now

On Fri, Aug 13, 2010 at 9:36 AM, Bart van den Eijnden bart...@osgis.nlwrote:

 Add CONFIG CPL_DEBUG ON to your MAP object in the MAP file. Probably
 wise to add DEBUG 5 to your MAP and LAYER as well.

 Also add something like:

 CONFIG MS_ERRORFILE stderr and then check your Apache error log.

 Best regards,
 Bart

 --
 Looking for flexible support on OpenLayers or GeoExt? Please check out
 http://www.osgis.nl/support.html

 Bart van den Eijnden
 OSGIS
 bart...@osgis.nl

 On Aug 13, 2010, at 10:33 AM, Sebastian E. Ovide wrote:

  Hi All
 
  I am using MapServer + GDAL to render GeoRasters and I am having very
 poor performance reading GeoRasters at a high zoom level... over 13... it
 would take even 20 seconds per tile...
 
  Is it possible to log the GDAL queries that MapServer is doing?  (and the
 SQL queries that GDAL is doing ?)
 
  thanks
 
  --
  Sebastian E. Ovide
 
 
 
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Re: logging GDAL queries

Sumit,

The size of the pyramid image at each level is determined by the original
image size and the pyramid level, according to the following formulas:

r(n) = (int)(r(0) / 2^n)
c(n) = (int)(c(0) / 2^n)



there are strange queries been executed

for example, at ANY zoom level I can see this one: (see level 3 !)

[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
this=0x2986210) succeeds as GeoRaster.
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM
RDT_FLUVD04Q200PJ
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
AND
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]PYRAMIDLEVEL =
:3
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]BANDBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]ROWBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
COLUMNBLOCKNUMBER ASC
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
this=0x18be210) succeeds as GeoRaster.
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM
RDT_FLUVD04Q200PJ
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
AND
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]PYRAMIDLEVEL =
:3
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]BANDBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]ROWBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
COLUMNBLOCKNUMBER ASC
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]


why ?


On Fri, Aug 13, 2010 at 12:56 PM, Sumit Sharma sumit...@hotmail.com wrote:


 I think there are 11 pyramid levels. could that be a problem? I am not an
 expert in GeoRaster, is it possible to create internal tiles in GeoRaster?
 if yes then, it may help you enhancing the performance
 --
 View this message in context:
 http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

On Fri, Aug 13, 2010 at 1:59 PM, Ivan Lucena ivan.luc...@pmldnet.comwrote:

 Sebastian,

 You are using a very small block size, maybe because you are also using
 ArcGIS products and they only support Oracle GeoRaster with 256x256
 blocking. Is that right?


nop... I guess that 256x256 if the default gdal_translate block size ?



 Because of that, to access your GeoRaster object, the GDAL driver is
 requesting a very large array of BLOB (100 approximately). That can make
 your sever such-up memory from the machine where it is running and it is
 probably using virtual memory (disk) what is really slow.


do you mean where MapServer is running ?

top - 14:41:31 up 7 days,  6:20, 10 users,  load average: 2.81, 1.92, 1.20
Tasks: 340 total,   2 running, 338 sleeping,   0 stopped,   0 zombie
Cpu(s): 11.8%us, 10.4%sy,  7.7%ni, 62.1%id,  0.0%wa,  0.0%hi,  8.0%si,
0.0%st
Mem:  12331240k total,  5992136k used,  6339104k free,   189416k buffers
Swap:  9084716k total,   703708k used,  8381008k free,  1481992k cached

  PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
24850 www-data  20   0  533m 330m  18m R   14  2.7   0:00.94 mapserv
24852 www-data  20   0  532m 329m  18m S   19  2.7   0:01.22 mapserv
24849 www-data  20   0  529m 326m  18m S   16  2.7   0:01.00 mapserv
24851 www-data  20   0  517m 314m  18m S   13  2.6   0:00.96 mapserv
24853 www-data  20   0  499m 296m  18m S8  2.5   0:00.75 mapserv
24854 www-data  20   0  470m 267m  18m S5  2.2   0:00.53 mapserv



 It also uses some memory on the client side just to hold the array too but
 if you are running everything (Mapserver,Oracle) on the same machine that
 will adds up.


Oracle is running on another Machine... and is very likely that it is the
bottle neck...


 We are aware of that problem but it would be very helpful if you could file
 a bug report on GDAL's trac [http://trac.osgeo.org/gdal/] Thanks.


I guess that the problem is that MapServer triys to read the whole map
instead of reading only tile  is that correct ?


 Just as curiosity. Did you loaded that image with gdal_translate? How long
 it took and long does it takes to generate pyramids? Ha, you forgot to say
 what version of Oracle you are using.


I loaded it with gdal in around 5 minutes... the pyramid (all levels) has
been created overnight


 Best regards,

 Ivan



   ---Original Message---
   From: Sebastian E. Ovide sebastian.ov...@gmail.com
   To: Lucena, Ivan ivan.luc...@pmldnet.com
   Cc: mapserver-users@lists.osgeo.org
   Subject: Re: [mapserver-users] logging GDAL queries
   Sent: Aug 13 '10 06:44
 
   sure...
 
 
   se...@seanspc:~/mapserver/mapserver-5.6.5$ gdalinfo --version
   GDAL 1.7.2, released 2010/04/23
 
   se...@seanspc:~/mapserver/mapserver-5.6.5$ gdalinfo
   georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1
   -mdd oracle
   Driver: GeoRaster/Oracle Spatial GeoRaster
   Files: none associated
   Size is 190325, 271423
   Coordinate System is:
   PROJCS[Popular Visualisation CRS / Mercator (deprecated),
   GEOGCS[Popular Visualisation CRS,
   DATUM[Popular_Visualisation_Datum,
   SPHEROID[Popular Visualisation Sphere,6378137,0,
   AUTHORITY[EPSG,7059]],
   TOWGS84[0,0,0,0,0,0,0],
   AUTHORITY[EPSG,6055]],
   PRIMEM[Greenwich,0,
   AUTHORITY[EPSG,8901]],
   UNIT[degree,0.01745329251994328,
   AUTHORITY[EPSG,9122]],
   AUTHORITY[EPSG,4055]],
   UNIT[metre,1,
   AUTHORITY[EPSG,9001]],
   PROJECTION[Mercator_1SP],
   PARAMETER[central_meridian,0],
   PARAMETER[scale_factor,1],
   PARAMETER[false_easting,0],
   PARAMETER[false_northing,0],
   EXTENSION[PROJ4,+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0
   +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +wktext
   +no_defs],
   AUTHORITY[EPSG,3785],
   AXIS[X,EAST],
   AXIS[Y,NORTH]]
   Origin = (-703633.464883987908252,7805920.616936270147562)
   Pixel Size = (4.999,-5.000)
   Metadata (oracle):
 TABLE_NAME=fluvd04q200pj
 COLUMN_NAME=georaster
 RDT_TABLE_NAME=RDT_FLUVD04Q200PJ
 RASTER_ID=62
 METADATA=georasterMetadata xmlns=[LINK:
   http://xmlns.oracle.com/spatial/georaster]
   http://xmlns.oracle.com/spatial/georaster;
 objectInfo
   rasterType20001/rasterType
   isBlankfalse/isBlank
   defaultRed1/defaultRed
   defaultGreen1/defaultGreen
   defaultBlue1/defaultBlue
 /objectInfo
 rasterInfo
   cellRepresentationUNDEFINED/cellRepresentation
   cellDepth8BIT_U/cellDepth
   NODATA255/NODATA
   totalDimensions2/totalDimensions
   dimensionSize type=ROW
 size271423/size
   /dimensionSize
   dimensionSize type=COLUMN
 size190325/size
   /dimensionSize
   ULTCoordinate
 row0/row
 column0/column
   /ULTCoordinate
   blocking
 typeREGULAR

Re: [mapserver-users] Re: GeoRaster via gdal on Ubuntu

2010-08-12 Thread Sebastian E. Ovide

Hi All,

problem solved rebuilding MapServer and using the new build

thanks

On Wed, Aug 11, 2010 at 4:09 PM, Sebastian E. Ovide
sebastian.ov...@gmail.com wrote:

yes, the mapserv is readin gthe wrong lib...

I have just added those PassEnv...

Location /cgi-bin/
SetEnv ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
SetEnv TNS_ADMIN /home/sebas/gdal/
SetEnv LD_LIBRARY_PATH
/u01/app/oracle/product/11.2.0/dbhome_1/lib:/home/sebas/gdal/lib
SetEnv PATH
/home/sebas/gdal/src/swig/python/scripts:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/home/sebas/gdal/bin:/home/sebas/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin
PassEnv LD_LIBRARY_PATH
PassEnv ORACLE_HOME
PassEnv TNS_ADMIN
PassEnv PATH
/Location

and renamed the wrong lib (the dirty trick)l... and still it is trying to
read from the wrong libgdal

any ideas ?

On Wed, Aug 11, 2010 at 3:56 PM, Daniel Morissette
dmorisse...@mapgears.com wrote:

Daniel Morissette wrote:
As I wrote in my previous email, try adding

PassEnv LD_LIBRARY_PATH

... to your httpd.conf so that the CGIs get the LD_LIBRARY_PATH value.

You'll probably also need a PassEnv directive for all the other env vars
that you are setting if you want the CGI to get them.

BTW, by httpd.conf I meant in your Apache config. Adding the PassEnv
in the Location /cgi-bin/ block in your
/etc/apache2/sites-enabled/000-default file after the corresponding
SetEnv directives should do as well.

--
Daniel Morissette
http://www.mapgears.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

--
Sebastian E. Ovide

--
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GeoRaster via gdal on Ubuntu

Thanks Ivan, actually that was one of my starting points. Still no luck.

as Gdal is working correctly (and all the variables has be re defined within
Location /cgi-bin/ as explained in that page)...the main question would
be how to make MapServ bind correctly to gdal ?

Is it possible that I am missing something in the map file ?

  LAYER
NAME sebas
TYPE RASTER
STATUS ON
DATA
georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
  END

is there any keyword to use gdal ?

On Wed, Aug 11, 2010 at 12:23 PM, Lucena, Ivan ivan.luc...@pmldnet.comwrote:

 Sebastian,

 Have you take a look on that page:

 http://mapserver.org/installation/oracle.html

 It is about GDAL/OGR/OCI but all the system settings experiments are
 applicable to GDAL/GeoRaster too.

 Regards,

 Ivan

 Sebastian E. Ovide wrote:

 Hi All,

 I've installed MapServer via ubuntugis repo and build gdal by hand in
 order to support oracle

 se...@seanspc:~/mapserver$ /usr/lib/cgi-bin/mapserv -v
 MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
 OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE
 SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
 SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
 SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS
 SUPPORTS=RGBA_PNG INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL
 INPUT=SHAPEFILE


 se...@seanspc:~/mapserver$ gdalinfo --version
 GDAL 1.7.2, released 2010/04/23
 se...@seanspc:~/mapserver$ gdalinfo --formats | grep GeoRaster
  GeoRaster (rw+): Oracle Spatial GeoRaster
 se...@seanspc:~/mapserver$ which gdalinfo
 /home/sebas/gdal/bin/gdalinfo


 now I'm trying to use MapServer with gdal to read GeoRasters but I'm
 getting this error:

 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1

 and from command line:

 se...@seanspc:~/mapserver$ gdalinfo
 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
 Driver: GeoRaster/Oracle Spatial GeoRaster
 Files: none associated
 Size is 24402, 49770
 Coordinate System is:
 PROJCS[British National Grid,
GEOGCS[Ordnance Survey Great Brit,
DATUM[Ordnance Survey Great Brit,
SPHEROID[Airy
 1830,6377563.396,299.3249646],375,-111,431,0,0,0,1],
PRIMEM[Greenwich,0.00],
UNIT[Decimal Degree,0.01745329251994330]],
PROJECTION[Transverse_Mercator],
PARAMETER[Scale_Factor,0.9996012717],
PARAMETER[Central_Meridian,-2.00],
PARAMETER[Latitude_Of_Origin,49.00],
PARAMETER[False_Easting,40.00],
PARAMETER[False_Northing,-10.00],
UNIT[Meter,1.]]
 Origin = (49950.000,1250050.000)
 Pixel Size = (25.000,-25.000)
 Image Structure Metadata:
  INTERLEAVE=PIXEL
  COMPRESSION=DEFLATE
 Corner Coordinates:
 Upper Left  (   49950.000, 1250050.000) (  8d28'31.89W, 60d58'39.59N)
 Lower Left  (   49950.000,5800.000) (  6d52'14.32W, 49d50'57.59N)
 Upper Right (  66.000, 1250050.000) (  2d49'4.15E, 61d 2'50.13N)
 Lower Right (  66.000,5800.000) (  1d37'14.80E, 49d53'42.66N)
 Center  (  354975.000,  627925.000) (  2d42'48.98W, 55d32'34.62N)
 Band 1 Block=256x256 Type=Byte, ColorInterp=Gray
  NoData Value=255
  Overviews: 12201x24885, 6100x12442, 3050x6221, 1525x3110, 762x1555,
 381x777, 190x388, 95x194


 So I suspects that MapServer is using the wrong gdal...

 is gdal binding hardcoded into MapServer ? or MapServer would use gdal
 from the path ?

 Thanks
 --
 Sebastian E. Ovide




 

 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
Sebastian E. Ovide
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Re: GeoRaster via gdal on Ubuntu

Hi Daniel,

gdal is in my home dir...

se...@seanspc:~/public_html/workshop-5.4$ echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11.2.0/dbhome_1/lib:/home/sebas/gdal/lib

se...@seanspc:~/public_html/workshop-5.4$ ldd
/usr/lib/cgi-bin/mapserv-custom | grep gdal
libgdal.so.1 = /home/sebas/gdal/lib/libgdal.so.1
(0x7fc005571000)

se...@seanspc:~/public_html/workshop-5.4$ cat
/etc/apache2/sites-enabled/000-default
...
Location /cgi-bin/
SetEnv ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1
SetEnv TNS_ADMIN /home/sebas/gdal/
SetEnv LD_LIBRARY_PATH
/u01/app/oracle/product/11.2.0/dbhome_1/lib:/home/sebas/gdal/lib
SetEnv PATH
/home/sebas/gdal/src/swig/python/scripts:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/home/sebas/gdal/bin:/home/sebas/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin
/Location
...


??


On Wed, Aug 11, 2010 at 2:26 PM, Daniel Morissette dmorisse...@mapgears.com
 wrote:

 Where is the new GDAL lib installed? Did you update your runtime libpath
 to point to the new GDAL lib location? And if so how ? (LD_LIBRARY_PATH
 or ld.so.conf?)

 If you used LD_LIBRARY_PATH, then you need to make sure the value is
 passed to your CGIs by Apache by adding a PassEnv LD_LIBRARY_PATH
 directive to your httpd.conf.

 Also, you can use the command ldd mapserv-custom to determine which
 copy of libgdal.so is being used.

 Daniel

 Sebastian E. Ovide wrote:
  I have just built MapServer... just in case..
 
  ./configure --with-gdal=/home/sebas/gdal/bin/gdal-config
  make
 
  se...@seanspc:~/mapserver/mapserver-5.6.5$ ./mapserv -v
  MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
  OUTPUT=SVG SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV INPUT=EPPL7
  INPUT=GDAL INPUT=SHAPEFILE
 
 
  cd /usr/lib/cgi-bin/
  ln -s /home/sebas/mapserver/mapserver-5.6.5/mapserv mapserv-custom
 
  and changed index.html to point to mapserv-custom
 
  the problem is still there...
 
  any other ideas ?
 
 
  On Wed, Aug 11, 2010 at 11:33 AM, Sebastian E. Ovide
  sebastian.ov...@gmail.com mailto:sebastian.ov...@gmail.com wrote:
 
  Hi All,
 
  I've installed MapServer via ubuntugis repo and build gdal by hand
  in order to support oracle
 
  se...@seanspc:~/mapserver$ /usr/lib/cgi-bin/mapserv -v
  MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
  OUTPUT=WBMP OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG
  SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI
  SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
  SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
  SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS SUPPORTS=RGBA_PNG
  INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
 
 
  se...@seanspc:~/mapserver$ gdalinfo --version
  GDAL 1.7.2, released 2010/04/23
  se...@seanspc:~/mapserver$ gdalinfo --formats | grep GeoRaster
GeoRaster (rw+): Oracle Spatial GeoRaster
  se...@seanspc:~/mapserver$ which gdalinfo
  /home/sebas/gdal/bin/gdalinfo
 
 
  now I'm trying to use MapServer with gdal to read GeoRasters but I'm
  getting this error:
 
 
 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
 
  and from command line:
 
  se...@seanspc:~/mapserver$ gdalinfo
 
 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
  Driver: GeoRaster/Oracle Spatial GeoRaster
  Files: none associated
  Size is 24402, 49770
  Coordinate System is:
  PROJCS[British National Grid,
  GEOGCS[Ordnance Survey Great Brit,
  DATUM[Ordnance Survey Great Brit,
  SPHEROID[Airy
  1830,6377563.396,299.3249646],375,-111,431,0,0,0,1],
  PRIMEM[Greenwich,0.00],
  UNIT[Decimal Degree,0.01745329251994330]],
  PROJECTION[Transverse_Mercator],
  PARAMETER[Scale_Factor,0.9996012717],
  PARAMETER[Central_Meridian,-2.00],
  PARAMETER[Latitude_Of_Origin,49.00],
  PARAMETER[False_Easting,40.00],
  PARAMETER[False_Northing,-10.00],
  UNIT[Meter,1.]]
  Origin = (49950.000,1250050.000)
  Pixel Size = (25.000,-25.000)
  Image Structure Metadata:
INTERLEAVE=PIXEL
COMPRESSION=DEFLATE
  Corner Coordinates:
  Upper Left  (   49950.000, 1250050.000) (  8d28'31.89W,
 60d58'39.59N)
  Lower Left  (   49950.000,5800.000) (  6d52'14.32W,
 49d50'57.59N)
  Upper Right (  66.000, 1250050.000) (  2d49'4.15E, 61d
 2'50.13N)
  Lower Right (  66.000,5800.000) (  1d37'14.80E,
 49d53'42.66N)
  Center  (  354975.000,  627925.000) (  2d42'48.98W,
 55d32'34.62N)
  Band 1 Block=256x256 Type=Byte, ColorInterp=Gray
NoData Value=255
Overviews: 12201x24885, 6100x12442, 3050x6221, 1525x3110

Re: [mapserver-users] GeoRaster via gdal on Ubuntu

Hi Cristiano,


I've tried the dirty trick..

se...@seanspc:/usr/lib$ ls -la libgdal1*
-rw-r--r-- 1 root root  7476096 2010-03-13 08:59 libgdal1.6.0.so.1.13.3
lrwxrwxrwx 1 root root   22 2010-04-30 14:19 libgdal1.6.0.so.1.seb -
libgdal1.6.0.so.1.13.3
-rw-r--r-- 1 root root 17994558 2010-05-19 14:05 libgdal1.7.0.a
-rw-r--r-- 1 root root  8302832 2010-05-19 14:05 libgdal1.7.0.so.1.14.2
lrwxrwxrwx 1 root root   22 2010-05-20 07:57 libgdal1.7.0.so.1.seb -
libgdal1.7.0.so.1.14.2
lrwxrwxrwx 1 root root   22 2010-05-20 07:57 libgdal1.7.0.so.seb -
libgdal1.7.0.so.1.14.2


and yes... I'm getting an error in the log file:


[Wed Aug 11 15:56:10 2010] [error] [client 10.0.1.50]
/usr/lib/cgi-bin/mapserv: error while loading shared libraries:
libgdal1.7.0.so.1: cannot open shared object file: No such file or directory

so obviously MapServer is reading the wrong libgdal




On Wed, Aug 11, 2010 at 2:01 PM, Cristiano Sumariva sumar...@gmail.comwrote:

 Well one dirty test you can do is rename the shared library gdal from .so
 to another name or remove it from your shared lib path.
 Then exec mapserver again.
 I think that if it is using shared lib then an error will be launched.
 I remember that one mapserver installation mine failed in a server update
 due to wrong symlink on shared libs.

 Try also ldconfig -l to see where your library loader is looking for
 libraries.

 2010/8/11 Sebastian E. Ovide sebastian.ov...@gmail.com

 Thanks Ivan, actually that was one of my starting points. Still no luck.

 as Gdal is working correctly (and all the variables has be re defined
 within Location /cgi-bin/ as explained in that page)...the main question
 would be how to make MapServ bind correctly to gdal ?

 Is it possible that I am missing something in the map file ?

   LAYER
 NAME sebas
 TYPE RASTER
 STATUS ON
 DATA
 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
   END

 is there any keyword to use gdal ?


 On Wed, Aug 11, 2010 at 12:23 PM, Lucena, Ivan 
 ivan.luc...@pmldnet.comwrote:

 Sebastian,

 Have you take a look on that page:

 http://mapserver.org/installation/oracle.html

 It is about GDAL/OGR/OCI but all the system settings experiments are
 applicable to GDAL/GeoRaster too.

 Regards,

 Ivan

 Sebastian E. Ovide wrote:

 Hi All,

 I've installed MapServer via ubuntugis repo and build gdal by hand in
 order to support oracle

 se...@seanspc:~/mapserver$ /usr/lib/cgi-bin/mapserv -v
 MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
 OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE
 SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
 SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
 SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS
 SUPPORTS=RGBA_PNG INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL
 INPUT=SHAPEFILE


 se...@seanspc:~/mapserver$ gdalinfo --version
 GDAL 1.7.2, released 2010/04/23
 se...@seanspc:~/mapserver$ gdalinfo --formats | grep GeoRaster
  GeoRaster (rw+): Oracle Spatial GeoRaster
 se...@seanspc:~/mapserver$ which gdalinfo
 /home/sebas/gdal/bin/gdalinfo


 now I'm trying to use MapServer with gdal to read GeoRasters but I'm
 getting this error:


 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1

 and from command line:

 se...@seanspc:~/mapserver$ gdalinfo
 georaster:geoserver,geoserver,MFPRODUK_11G,LSLIDE_V5_RASTER,georaster,id=1
 Driver: GeoRaster/Oracle Spatial GeoRaster
 Files: none associated
 Size is 24402, 49770
 Coordinate System is:
 PROJCS[British National Grid,
GEOGCS[Ordnance Survey Great Brit,
DATUM[Ordnance Survey Great Brit,
SPHEROID[Airy
 1830,6377563.396,299.3249646],375,-111,431,0,0,0,1],
PRIMEM[Greenwich,0.00],
UNIT[Decimal Degree,0.01745329251994330]],
PROJECTION[Transverse_Mercator],
PARAMETER[Scale_Factor,0.9996012717],
PARAMETER[Central_Meridian,-2.00],
PARAMETER[Latitude_Of_Origin,49.00],
PARAMETER[False_Easting,40.00],
PARAMETER[False_Northing,-10.00],
UNIT[Meter,1.]]
 Origin = (49950.000,1250050.000)
 Pixel Size = (25.000,-25.000)
 Image Structure Metadata:
  INTERLEAVE=PIXEL
  COMPRESSION=DEFLATE
 Corner Coordinates:
 Upper Left  (   49950.000, 1250050.000) (  8d28'31.89W, 60d58'39.59N)
 Lower Left  (   49950.000,5800.000) (  6d52'14.32W, 49d50'57.59N)
 Upper Right (  66.000, 1250050.000) (  2d49'4.15E, 61d 2'50.13N)
 Lower Right (  66.000,5800.000) (  1d37'14.80E, 49d53'42.66N)
 Center  (  354975.000,  627925.000) (  2d42'48.98W, 55d32'34.62N)
 Band 1 Block=256x256 Type=Byte, ColorInterp=Gray
  NoData Value=255
  Overviews: 12201x24885, 6100x12442, 3050x6221, 1525x3110, 762x1555,
 381x777, 190x388, 95x194


 So I suspects that MapServer is using the wrong gdal...

 is gdal binding hardcoded into MapServer ? or MapServer

Re: [mapserver-users] Re: GeoRaster via gdal on Ubuntu