[mapserver-users] overviews from Postgis-Raster
hello Can you give me a hint about using overviews from Postgis-raster data store ? kind regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Bilgi İşlem Dairesi Başkanlığı-CBS Grubu Ahmet Temiz Geological Eng. Information Systems - GIS Group Disaster and Emergency Management of Presidency ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008
Hi, Definitely looks like a permissions issue. Try granting read-access on the c:\MapData folder to IIS AppPool\DefaultAppPool user - assuming this is the application pool that MapServer and/or PHP is running under using CGI. If that fails try granting Everyone read-only access to see if it is permissions. Regards, Seth On 07/05/2015 20:41, EVANS, JAMES R GS-13 USAF ACC 84 RADES/SCZE wrote: I am making no progress on getting this working. I did add the error_reporting(E_All) to the script, but I don't get any errors. From the IIS log, it looks like the server is getting the request, php must be reading the script and calling the mini driver. It looks like the gdal mini driver is trying to read the base imagery and is failing. Here is a piece of the IIS log: 2015-05-07 17:06:33 10.89.89.44 GET /mapserver/mapserv.exe map=content/servemap.mapservice=WMSrequest=GetMapversion=1.3crs=CRS:84layers=Land_Seastyles=defaulttransparent=TRUEformat=image/pngwidth=512height=512bbox=-72.0,18.0,-36.0,54.0 80 - 10.89.89.191 Java/1.7.0_51 200 0 0 1875 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=7Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=6Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 3221225595 718 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=8Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=6Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=7Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=8Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 15 If I try to send the URL from a browser, I get back an error that says this: ?xml version='1.0' encoding=ISO-8859-1 standalone=no ? !DOCTYPE ServiceExceptionReport SYSTEM http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd; ServiceExceptionReport version=1.1.1 ServiceException msDrawMap(): Image handling error. Failed to draw layer named #39;Land_Sea#39;. drawGDAL(): Unable to access file. GDALDatasetRasterIO() failed: c:\MapData\Land-Sea.xml, band 1: IReadBlock failed at X offset 9, Y offset 4 /ServiceException /ServiceExceptionReport I really don't know how to troubleshoot this. The pieces I have to work with are the map file, the layer XML files, for example Land-Sea.xml, the Tile.php script, (which seems to be working), and the tiled image set. These same pieces work great with the same version of Mapserver, from GISInternals, on Windows 7 running IIS 7. I'm thinking that this must be a permissions problem on Windows Server 2008. Any ideas on where to go from here would be appreciated. Thanks, James -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jeff McKenna Sent: Thursday, May 07, 2015 5:48 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008 I would definitely head to the command prompt on the Windows machine, and then call php.exe through the commandline, passing it your .php file that is supposed to generate your map image, such as: php myscript.php You might also make sure that your test php script shows all errors (I think it can be set directly inside your script with: error_reporting(E_ALL) but I might be wrong on syntax... -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008
I am making no progress on getting this working. I did add the error_reporting(E_All) to the script, but I don't get any errors. From the IIS log, it looks like the server is getting the request, php must be reading the script and calling the mini driver. It looks like the gdal mini driver is trying to read the base imagery and is failing. Here is a piece of the IIS log: 2015-05-07 17:06:33 10.89.89.44 GET /mapserver/mapserv.exe map=content/servemap.mapservice=WMSrequest=GetMapversion=1.3crs=CRS:84layers=Land_Seastyles=defaulttransparent=TRUEformat=image/pngwidth=512height=512bbox=-72.0,18.0,-36.0,54.0 80 - 10.89.89.191 Java/1.7.0_51 200 0 0 1875 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=7Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=6Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 3221225595 718 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=8Y=6 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=6Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=7Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 0 2015-05-07 17:06:33 127.0.0.1 GET /mapserver/content/tile.php T=Land-SeaL=1X=8Y=5 80 - 127.0.0.1 GDAL+WMS+driver+(http://www.gdal.org/frmt_wms.html) 500 0 2147500037 15 If I try to send the URL from a browser, I get back an error that says this: ?xml version='1.0' encoding=ISO-8859-1 standalone=no ? !DOCTYPE ServiceExceptionReport SYSTEM http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd; ServiceExceptionReport version=1.1.1 ServiceException msDrawMap(): Image handling error. Failed to draw layer named #39;Land_Sea#39;. drawGDAL(): Unable to access file. GDALDatasetRasterIO() failed: c:\MapData\Land-Sea.xml, band 1: IReadBlock failed at X offset 9, Y offset 4 /ServiceException /ServiceExceptionReport I really don't know how to troubleshoot this. The pieces I have to work with are the map file, the layer XML files, for example Land-Sea.xml, the Tile.php script, (which seems to be working), and the tiled image set. These same pieces work great with the same version of Mapserver, from GISInternals, on Windows 7 running IIS 7. I'm thinking that this must be a permissions problem on Windows Server 2008. Any ideas on where to go from here would be appreciated. Thanks, James -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jeff McKenna Sent: Thursday, May 07, 2015 5:48 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008 I would definitely head to the command prompt on the Windows machine, and then call php.exe through the commandline, passing it your .php file that is supposed to generate your map image, such as: php myscript.php You might also make sure that your test php script shows all errors (I think it can be set directly inside your script with: error_reporting(E_ALL) but I might be wrong on syntax... -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008
On 2015-05-06 8:26 PM, EVANS, JAMES R GS-13 USAF ACC 84 RADES/SCZE wrote: Hi, I was previously using IIS 7 on Windows 7, and was running a php script that called the gdal mini drivers to serve up a tiled image set. Now I'm trying to get it to work on Server 2008. For some reason, it does not seem to work. On the IIS log file, I can see the valid request come in, and I can see php calling the mini drivers. I just don't get an image back on the client side. The logs from the working IIS on windows 7 looks just like the logs on the non working Windows Server 2008. It could be some sort of security setting, or a permissions problem. Also, is there something I need to do to enable the gdal mini drivers? It's been about 2 years since I set this up previously and I just don't remember having this problem before. Any hints on how to verify the PHP is working, and how the gdal mini drivers are running would be appreciated. Thanks, James I would definitely head to the command prompt on the Windows machine, and then call php.exe through the commandline, passing it your .php file that is supposed to generate your map image, such as: php myscript.php You might also make sure that your test php script shows all errors (I think it can be set directly inside your script with: error_reporting(E_ALL) but I might be wrong on syntax... -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] overviews from Postgis-Raster
On 2015-05-07 5:20 AM, Ahmet Temiz wrote: hello Can you give me a hint about using overviews from Postgis-raster data store ? kind regards I use PG 9.4.1 with Postgis 2.1.7 on MS4W and Ubuntu, and when I load raster data, to create overviews through the raster2pgsql utility I specify the -l switch and a factor, such as -l 2. That will produce an extra table containing the overviews (if the regular table is lidar, the overview table will be named o_2_lidar). Then I can choose to show either table in MapServer. If I want to show the overview table, I would specify table=0_2_lidar inside my DATA statement in the mapfile. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] URL redirection under IIS
Hi James, If you want some Open Source karma you could write all of your IIS notes as you travel down this path onto the MapServer wiki, for the whole community: https://github.com/mapserver/mapserver/wiki -jeff On 2015-05-07 8:35 AM, James_in_Utah wrote: Thanks for the replies. I got it working for the most part by downloading and installing the URL Rewrite module for IIS from Microsoft. Using that you create a web.config file with rewrite rules in it. The file goes in the inetpub\wwwroot directory. Funny thin is, the same rules that worked under IIS 7 on Windows 7 don't work under Server 2008. It seems to be much more picky. I remember it being much easier under Apache. Thanks, James -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] URL redirection under IIS
I will do that. It might come in handy for myself when I go through this in another year or two... -- View this message in context: http://osgeo-org.1560.x6.nabble.com/URL-redirection-under-IIS-tp5203788p5204607.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
Re: [mapserver-users] URL redirection under IIS
Thanks for the replies. I got it working for the most part by downloading and installing the URL Rewrite module for IIS from Microsoft. Using that you create a web.config file with rewrite rules in it. The file goes in the inetpub\wwwroot directory. Funny thin is, the same rules that worked under IIS 7 on Windows 7 don't work under Server 2008. It seems to be much more picky. I remember it being much easier under Apache. Thanks, James -- View this message in context: http://osgeo-org.1560.x6.nabble.com/URL-redirection-under-IIS-tp5203788p5204594.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
Re: [mapserver-users] URL redirection under IIS
Bingo, I am constantly referring to my own docs written years ago, everyday :) Thanks James. -jeff On 2015-05-07 9:10 AM, James_in_Utah wrote: I will do that. It might come in handy for myself when I go through this in another year or two... -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GDal Mini drivers and php script under IIS 7 on Windows Server 2008
I saw that suggestion at the end of the day, and I quickly set C:\MapData permission to allow everyone to have read, and that had no effect. I got the same error. I do think it's a permission issue, maybe just not reading the tiles. I didn't see any IUSR_MachineName type user, or any other IIS type user, so I'm thinking the app pool calling gdal doesn't exist. I have no idea what I'm doing here. This was pretty automatic when I tried it under Windows 7. I guess I'll spend the weekend trying to come up to speed on IIS default users. I won't be back in the office to try anything until Monday, but any suggestions would be welcomed. Thanks, James -- View this message in context: http://osgeo-org.1560.x6.nabble.com/GDal-Mini-drivers-and-php-script-under-IIS-7-on-Windows-Server-2008-tp5204513p5204752.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
Re: [mapserver-users] URL redirection under IIS
Several times, I have done a search for how to do something in MapServer or PostGIS, and ended up finding one of my old posts to the list... -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jeff McKenna Sent: Thursday, May 07, 2015 7:20 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] URL redirection under IIS Bingo, I am constantly referring to my own docs written years ago, everyday :) Thanks James. -jeff On 2015-05-07 9:10 AM, James_in_Utah wrote: I will do that. It might come in handy for myself when I go through this in another year or two... -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users