Re: [Geoserver-users] Change the output of OpenLayer in Geoserver
What you can do with the preview is right-click and so a "show source" - this will show the openlayers code that Geoserver has generated. This is a perfectly viable template to start creating your own web application from. Typically web apps are built in a development environment (eg Eclipse, netbeans, etc) which generated a deployable war. Replace the default index.html that the environments typically generate with the code from the geoserver template and you can start working. However, you will likely want to point to a local server version of OL. However, OL has moved to version 3 which is quite a different beast from version that is in at least my instance of geoserver. For starting a new project you would probably be better off starting with OL3 and one of their examples. The geoserver preview template can still give you some good pointers however. Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver and ecw raster formats
Dear Daniele, many thanks for getting back to me so quickly – much appreciated. The only reason I’m using 32bit JRE/JDK is to able enable JAI since (I am told) this is necessary for fast rendering of images. How necessary is JAI these days? (it’s very old and only 32 bit on Window). It certainly would be easier to go 64 bit for everything and maybe that might solve my problem. Perhaps it’s not possible to have JAI enabled AND be able to server ecw rasters. You can’t have everything in life! Thanks for tip about GDAL version - that maybe a problem since OSGeo4w only gives you the ‘latest and greatest’ they use gdal 1.11. I could uninstall gdal and install the version maintained on gisinternals (which is gdal 1.9) – there are different MSVC compile versions (2012, 2010, 2008 etc) which I’m not sure how critical the choice is. Also no JNI files at all. I’ve downloaded GeoTools 13-1 which has this one file : gt-ogr-jni-13.1.jar but that’s not a dll So where are these JNI dll’s to be found and where would I put them? – I’ve unpacked gdal-1.9.2-MSVC2008-x64.zip but nothing with the text string jni appears. So to sum up, I’ll try these: 1. Forget about JAI on Windows and go 64 bit for everything. 2. Install the Windows friendly gdal 1.9 from gisinternal and re-link PATH and environmental variables 3. Find the mysterious JNI dll’s and put them in the right place. If I actually succeed I’ll write a detailed account for anyone else with a similar set up. All the best David @boscinet From: Daniele Romagnoli-3 [via OSGeo.org] [mailto:ml-node+s1560n5213640...@n6.nabble.com] Sent: 30 June 2015 16:30 To: tilia Subject: Re: Geoserver and ecw raster formats Dear David, I would take a look to my previous reply to similar topic from the discussion you have already checked: http://osgeo-org.1560.x6.nabble.com/MrSID-and-ECW-files-in-GeoServer-Issues-installing-GDAL-in-Windows-td5207798.html Please, take a look to my reply of Jun 03, 2015; 5:55pm It contains some useful clarifications. That being said, I would add some feedbacks in relation to your report, which may help in investigating your issues: 1) You shouldn't mix 32 and 64 version when dealing with native libs (DLLs), otherwise you may get errors like this: "Can't load IA 32-bit .dll on a AMD 64-bit platform" Therefore I would proceed with a fully 64 arch/libs/JVM installation . 2) You said that you have installed GDAL via OSGeo4w. I'm not sure about which GDAL version is provided with OSGeo4w. Which version does it install? GeoTools/GeoServer GDAL plugins are currently tied to GDAL 1.9.2 although some users did successfully installation with GDAL 1.10. A different version may raise issues. Moreover, does it also contains the JNI libs? (a set of DLLs needed to bridge java code to C libraries). Please, let us know. Best Regards, Daniele On Tue, Jun 30, 2015 at 4:25 PM, tilia <[hidden email]> wrote: Fresh install of Geoserver + Tomcat but only default raster formats available. OS Windows server 2008R2 64bit, Tomcat 7.0.62, JVM 32bit jre/jdk1.7 (for JAI), Geoserver 2.7.1.1 deployed as .war. Fast server with lots of RAM and HD space. All the .jars from Geoserver-2.7.1.1-gdal-plugin and imageio-ext-1.1.10-jars placed in the \webapps\geoserver\WEB-INF\lib. GDAL installed via OSGeo4w. Environmental variables and paths are fine since gdal works from the command line (both cmd.exe and OSGeo shell) and gdalinfo lists all the raster formats including ecw. I’ve read and re-read the threads on the this subject from this forum (thanks to Daniel Romagnoli, Mark Volz for insights covering this issue) as well as the instructions on Geoserver.org regarding installing extra raster formats + I have read available books on Geoserver. I’ve tried various combinations of 32bit and 64bit versions of gdal-x-ecw.msi. (I notice that there are very many versions of gdal_ECW_JP2ECW.dll – how significant are these differences?). I’ve been trying these various combinations of them, installing, uninstalling, stopping and starting many times over two days but absolutely no way can I get Geoserver to recognise anything other than the default raster formats and certainly not ecw. There are clearly some crucial step/s I’ve missed and/or missing .jar/.dll in some folder or perhaps as missing tag in a config file somewhere. Any hints to allow me to preserver (and maintain sanity) would be appreciated! -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-and-ecw-raster-formats-tp5213620.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Clou
Re: [Geoserver-users] Geoserver and ecw raster formats
Dear David, I would take a look to my previous reply to similar topic from the discussion you have already checked: http://osgeo-org.1560.x6.nabble.com/MrSID-and-ECW-files-in-GeoServer-Issues-installing-GDAL-in-Windows-td5207798.html Please, take a look to my reply of Jun 03, 2015; 5:55pm It contains some useful clarifications. That being said, I would add some feedbacks in relation to your report, which may help in investigating your issues: 1) You shouldn't mix 32 and 64 version when dealing with native libs (DLLs), otherwise you may get errors like this: *"Can't load IA 32-bit .dll on a AMD 64-bit platform"* Therefore I would proceed with a fully 64 arch/libs/JVM installation . 2) You said that you have installed GDAL via OSGeo4w. I'm not sure about which GDAL version is provided with OSGeo4w. Which version does it install? GeoTools/GeoServer GDAL plugins are currently tied to GDAL 1.9.2 although some users did successfully installation with GDAL 1.10. A different version may raise issues. Moreover, does it also contains the JNI libs? (a set of DLLs needed to bridge java code to C libraries). Please, let us know. Best Regards, Daniele On Tue, Jun 30, 2015 at 4:25 PM, tilia wrote: > Fresh install of Geoserver + Tomcat but only default raster formats > available. > OS Windows server 2008R2 64bit, Tomcat 7.0.62, JVM 32bit jre/jdk1.7 (for > JAI), Geoserver 2.7.1.1 deployed as .war. Fast server with lots of RAM and > HD space. > All the .jars from Geoserver-2.7.1.1-gdal-plugin and > imageio-ext-1.1.10-jars > placed in the \webapps\geoserver\WEB-INF\lib. GDAL installed via OSGeo4w. > Environmental variables and paths are fine since gdal works from the > command > line (both cmd.exe and OSGeo shell) and gdalinfo lists all the raster > formats including ecw. > I’ve read and re-read the threads on the this subject from this forum > (thanks to Daniel Romagnoli, Mark Volz for insights covering this issue) as > well as the instructions on Geoserver.org regarding installing extra raster > formats + I have read available books on Geoserver. I’ve tried various > combinations of 32bit and 64bit versions of gdal-x-ecw.msi. (I notice > that there are very many versions of gdal_ECW_JP2ECW.dll – how significant > are these differences?). I’ve been trying these various combinations of > them, installing, uninstalling, stopping and starting many times over two > days but absolutely no way can I get Geoserver to recognise anything other > than the default raster formats and certainly not ecw. > There are clearly some crucial step/s I’ve missed and/or missing .jar/.dll > in some folder or perhaps as missing tag in a config file somewhere. Any > hints to allow me to preserver (and maintain sanity) would be appreciated! > > > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/Geoserver-and-ecw-raster-formats-tp5213620.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any d
Re: [Geoserver-users] Change the output of OpenLayer in Geoserver
Ciao Carla, GeoServer ships with a minified openlayers that only does what we need, and it's driven by an internal template that it's not meant to be modified, but if you're curious, here is the java code that runs when doing the request with format equals to application/openlayers: https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/map/OpenLayersMapOutputFormat.java and the templates used to generate the preview (which one is going to be used, depends on the GeoServer version you have): https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/resources/org/geoserver/wms/map/OpenLayers2MapTemplate.ftl https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/resources/org/geoserver/wms/map/OpenLayers3MapTemplate.ftl Cheers Andrea On Tue, Jun 30, 2015 at 4:25 PM, carla.nardinocchi < carla.nardinoc...@uniroma1.it> wrote: > Thanks for your answer. > At the moment I'm working in localhost with geoserver. I'm showing > geographical layers (shapefiles). Now, I would like to use a personalized > layout. > I'll look at OpenLayers examples as you suggested. > > But, I wonder where and how geoserver (say OpenLayers) builds the default > layout I'm using and how I can modify it. > > When I execute 'OpenLayer' command in Layer Preview, which action I'm > doing... > > Do you know any material, where I can see some examples ...I started > looking > up in geoserver/tutorial but I'm still a 'little bit' confused :) > > thanks carla > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/Change-the-output-of-OpenLayer-in-Geoserver-tp5213456p5213621.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. --- -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] OS Mastermap in Production 1000's of users
Do you have meta tiling turned on? I can't see that the DB access is the bottle neck (though with Oracle anything is possible) - I would have the lower levels cache on request so that at least popular areas become faster - unless you are very short fo disk space Ian On Tue, Jun 30, 2015 at 3:33 PM gavin.montgomery wrote: > Thank you both, yes ultimately we would like to move to postGIS too, > however > slightly constrained by client requirements. > > We have been advised to increase the tile size of the requests to improve > DB > query performance. I am happy to implement this change but do not believe > it > is going to have a substantial impact on the performance when we scale up > the numbers - maybe allow for another 100 users or so... > > FYI we currently have approx 50-60 users concurrent, this will be going up > significantly in coming weeks and we know the oracle DB will start to run > hot with that many requests. > > Gavin > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560p5213619.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Geoserver and ecw raster formats
Fresh install of Geoserver + Tomcat but only default raster formats available. OS Windows server 2008R2 64bit, Tomcat 7.0.62, JVM 32bit jre/jdk1.7 (for JAI), Geoserver 2.7.1.1 deployed as .war. Fast server with lots of RAM and HD space. All the .jars from Geoserver-2.7.1.1-gdal-plugin and imageio-ext-1.1.10-jars placed in the \webapps\geoserver\WEB-INF\lib. GDAL installed via OSGeo4w. Environmental variables and paths are fine since gdal works from the command line (both cmd.exe and OSGeo shell) and gdalinfo lists all the raster formats including ecw. I’ve read and re-read the threads on the this subject from this forum (thanks to Daniel Romagnoli, Mark Volz for insights covering this issue) as well as the instructions on Geoserver.org regarding installing extra raster formats + I have read available books on Geoserver. I’ve tried various combinations of 32bit and 64bit versions of gdal-x-ecw.msi. (I notice that there are very many versions of gdal_ECW_JP2ECW.dll – how significant are these differences?). I’ve been trying these various combinations of them, installing, uninstalling, stopping and starting many times over two days but absolutely no way can I get Geoserver to recognise anything other than the default raster formats and certainly not ecw. There are clearly some crucial step/s I’ve missed and/or missing .jar/.dll in some folder or perhaps as missing tag in a config file somewhere. Any hints to allow me to preserver (and maintain sanity) would be appreciated! -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-and-ecw-raster-formats-tp5213620.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Change the output of OpenLayer in Geoserver
Thanks for your answer. At the moment I'm working in localhost with geoserver. I'm showing geographical layers (shapefiles). Now, I would like to use a personalized layout. I'll look at OpenLayers examples as you suggested. But, I wonder where and how geoserver (say OpenLayers) builds the default layout I'm using and how I can modify it. When I execute 'OpenLayer' command in Layer Preview, which action I'm doing... Do you know any material, where I can see some examples ...I started looking up in geoserver/tutorial but I'm still a 'little bit' confused :) thanks carla -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Change-the-output-of-OpenLayer-in-Geoserver-tp5213456p5213621.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] OS Mastermap in Production 1000's of users
Thank you both, yes ultimately we would like to move to postGIS too, however slightly constrained by client requirements. We have been advised to increase the tile size of the requests to improve DB query performance. I am happy to implement this change but do not believe it is going to have a substantial impact on the performance when we scale up the numbers - maybe allow for another 100 users or so... FYI we currently have approx 50-60 users concurrent, this will be going up significantly in coming weeks and we know the oracle DB will start to run hot with that many requests. Gavin -- View this message in context: http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560p5213619.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Could not list layers for this store (JDBC Image Mosaic)
Hi David Do you see a stack trace in the GeoServer log file. Cheers Christian On Tue, Jun 30, 2015 at 3:24 PM, David Haynes II wrote: > Hello, > > I am trying to build an app that utilizes raster files that I have > ingested into my PostgreSQL/PostGIS database. The error occurs when trying > to make the PostGIS raster data store. The error on the web interface says > "Could not list layers for this store, an error occurred retrieving them: > Failed to create reader from file:glc.postgis.xml and hints null". > > However the geoserver log reports a connection error. > 2015-06-29 09:02:30,681 WARN [data.jdbc] - Could not acquire A BDCP > connection pool.:org.geotools.data.DataSourceException: Connection pool > improperly set up: Cannot create PoolableConnectionFactory (Connection > refused. Check that the hostname and port are correct and that the > postmaster is accepting TCP/IP connections.) > > What is wrong? > > I know that I have the connection xml defined properly. I am following the > following documentation. > > http://docs.geoserver.org/2.5.x/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html > > > > > > > > > > > > > -- > David Haynes, Ph.D. > Research Associate Terra Populus > Minnesota Population Center > www.terrapop.org > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] OS Mastermap in Production 1000's of users
You might also want to only rebuild the tiles where there is an actual change - I assume you are using the change only updates? The math to decide which tiles to invalidate is quite easy - I used to have a script but the client kept them internal so I can't share I'm afraid. And I second Mark's comment - dump oracle for PostGIS as soon as you can. Ian On Tue, Jun 30, 2015 at 12:08 PM Ismail, Mark wrote: > Hi Gavin > > Only comment I can add is regarding the use of oracle to store your > spatial data. > > I serve up mastermap data for the Merseyside area . I had a lot of > complaints from my users about the speed of the maps loading > > I had all the mastermap data in an oracle 11 database. I switched to > Postgis and the map tile loading time decreased significantly > > Feedback from my users was that the maps loaded "instantly" after the > change. > > Mark Ismail > > -Original Message- > From: gavin.montgomery [mailto:gavin.montgom...@live.com] > Sent: 30 June 2015 11:53 > To: geoserver-users@lists.sourceforge.net > Subject: [Geoserver-users] OS Mastermap in Production 1000's of users > > Hi All, > > We are developing a map application which is aiming to serve 1000's of > users Ordnance Survey Master Map data at various scales. > We have scaled our geoserver solution to provide the following: > > 24 instances of geoserver running 4 instances on 6 VMs 8x 2.7 CPUs 64GB > RAM each > > 2 instances of Geowebcache - 128GB RAM available on each GWC serves > pre-built cache at levels 0-10 (1:2m - 1:3100) on British national Grid. > (Level 10 consists of approx 8 million tiles) Any further levels are > cached dynamically As it is OS Mastermap we are required to update our data > every 6 weeks hence a full recache at that time. > > We have an Oracle Node with 12 cores serving our GeoServers as well as a > number of other applications. Nonetheless OSMM requests are responsible for > the majority of CPU usage. > > We are using spatial partitions, up to date statistics as well as > appropriate columns indexing for the WMS queries to take place. > > We request tiles on 256x256 pixels - it has been suggested by our DBAs to > increase this request size - does anybody agree/disagree with this? I would > just expect this increases the size of the request and increase rendering > time. OSMM is quite a complex SLD though is still rather performant. > > Has anybody had experience with full national coverage of OSMM on Oracle? > Did you encounter performance issues at high user load? Did you do > anything to rectify the solution or was it a matter of hardware required to > deal with the demand? > > Any insights appreciated, happy to answer any further questions. > > Regards > > > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that you > need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > This e-mail and any attachments are confidential. It may contain > privileged information and is intended for the named recipient(s) only. It > must not be distributed without consent. If you are not one of the intended > recipients, please notify the sender immediately and do not disclose, > distribute, or retain this email or any part of it and do not take any > action based on it. > > Unless expressly stated, opinions in this email are those of the > individual sender, and not of Knowsley MBC. Legally binding obligations can > only be created for, or be entered into on behalf of, Knowsley MBC by duly > authorised officers or representatives. > > Knowsley MBC excludes any liability whatsoever for any offence caused, any > direct or consequential loss arising from the use, or reliance on, this > e-mail or its contents. We believe but do not warrant that this e-mail and > any attachments are virus free. You must therefore take full responsibility > for virus checking and no responsibility is accepted for loss or damage > arising from viruses or changes made to this message after it was sent. > Knowsley MBC reserves the right to monitor and/or record all e-mail > communications through its network in accordance with relevant legislation. > > > -- > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on gro
[Geoserver-users] Could not list layers for this store (JDBC Image Mosaic)
Hello, I am trying to build an app that utilizes raster files that I have ingested into my PostgreSQL/PostGIS database. The error occurs when trying to make the PostGIS raster data store. The error on the web interface says "Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:glc.postgis.xml and hints null". However the geoserver log reports a connection error. 2015-06-29 09:02:30,681 WARN [data.jdbc] - Could not acquire A BDCP connection pool.:org.geotools.data.DataSourceException: Connection pool improperly set up: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) What is wrong? I know that I have the connection xml defined properly. I am following the following documentation. http://docs.geoserver.org/2.5.x/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html -- David Haynes, Ph.D. Research Associate Terra Populus Minnesota Population Center www.terrapop.org -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Solved: AW: Layer creation using GeoServer Rest API fails with "invalid identifier" using Oracle
Solved, it was just a typo in the layer identifier (case sensitivity was not taken care of). Sorry for the noise. Von: Nachtigall, Jens (init) [mailto:jens.nachtig...@init.de] Gesendet: Dienstag, 30. Juni 2015 13:41 An: geoserver-users@lists.sourceforge.net Betreff: [Geoserver-users] Layer creation using GeoServer Rest API fails with "invalid identifier" using Oracle Hi, using geoserver manager (1.6.0) I ask the GeoServer REST API to create a new Layer. The Oracle DB throws an "ORA-00904: : invalid identifier" error. (We use http://docs.geoserver.org/latest/en/user/data/database/oracle.html, which works fine otherwise) Here is the request that geoserver manager sents out to GeoServer: true EPSG:31468 -74.047185 40.882078 -73.90782 40.679648 EPSG:31468 shp_poly_landmarks The Response I get is: Bad response: code[500] msg[Internal Server Error] url[http://myserver.com:28081/geoserver/rest/workspaces/BNB/datastores/bnb/featuretypes] method[PostMethod]: :Error occurred creating table Any ideas? Is this a bug in GeoServer or the GeoServer Oracle Plugin? I found this issue that PostGIS and Oracle handle identifiers in a different way (http://gis.stackexchange.com/questions/25829/publishing-oracle-spatial-table-in-geoserver) but I am not sure if this is related. Best, Jens PS Here is the traceback as printed by GeoServer (loglevel set to GEOSERVER_DEVELOPER_LOGGING) 2015-06-30 13:15:44,128 INFO [org.geoserver] - Loaded feature type 'shp_poly_landmarks', enabled 2015-06-30 13:15:44,129 WARN [catalog.impl] - Failed to load actual store for FeatureTypeInfoImpl[shp_poly_landmarks] 2015-06-30 13:15:44,199 ERROR [geoserver.rest] - :Error occurred creating table 2015-06-30 13:15:44,200 ERROR [geoserver.rest] - org.geoserver.rest.RestletException: java.io.IOException: Error occurred creating table at org.geoserver.rest.ReflectiveResource.handleException(ReflectiveResource.java:326) at org.geoserver.rest.ReflectiveResource.handlePost(ReflectiveResource.java:124) at org.restlet.Finder.handle(Finder.java:296) at org.geoserver.rest.BeanDelegatingRestlet.handle(BeanDelegatingRestlet.java:38) at org.restlet.Filter.doHandle(Filter.java:105) at org.restlet.Filter.handle(Filter.java:134) at org.restlet.Router.handle(Router.java:444) at org.geoserver.rest.RESTDispatcher$1.handle(RESTDispatcher.java:205) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:129) at org.geoserver.rest.RESTDispatcher.handleRequestInternal(RESTDispatcher.java:87) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75) at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:50) a
[Geoserver-users] Layer creation using GeoServer Rest API fails with "invalid identifier" using Oracle
Hi, using geoserver manager (1.6.0) I ask the GeoServer REST API to create a new Layer. The Oracle DB throws an "ORA-00904: : invalid identifier" error. (We use http://docs.geoserver.org/latest/en/user/data/database/oracle.html, which works fine otherwise) Here is the request that geoserver manager sents out to GeoServer: true EPSG:31468 -74.047185 40.882078 -73.90782 40.679648 EPSG:31468 shp_poly_landmarks The Response I get is: Bad response: code[500] msg[Internal Server Error] url[http://myserver.com:28081/geoserver/rest/workspaces/BNB/datastores/bnb/featuretypes] method[PostMethod]: :Error occurred creating table Any ideas? Is this a bug in GeoServer or the GeoServer Oracle Plugin? I found this issue that PostGIS and Oracle handle identifiers in a different way (http://gis.stackexchange.com/questions/25829/publishing-oracle-spatial-table-in-geoserver) but I am not sure if this is related. Best, Jens PS Here is the traceback as printed by GeoServer (loglevel set to GEOSERVER_DEVELOPER_LOGGING) 2015-06-30 13:15:44,128 INFO [org.geoserver] - Loaded feature type 'shp_poly_landmarks', enabled 2015-06-30 13:15:44,129 WARN [catalog.impl] - Failed to load actual store for FeatureTypeInfoImpl[shp_poly_landmarks] 2015-06-30 13:15:44,199 ERROR [geoserver.rest] - :Error occurred creating table 2015-06-30 13:15:44,200 ERROR [geoserver.rest] - org.geoserver.rest.RestletException: java.io.IOException: Error occurred creating table at org.geoserver.rest.ReflectiveResource.handleException(ReflectiveResource.java:326) at org.geoserver.rest.ReflectiveResource.handlePost(ReflectiveResource.java:124) at org.restlet.Finder.handle(Finder.java:296) at org.geoserver.rest.BeanDelegatingRestlet.handle(BeanDelegatingRestlet.java:38) at org.restlet.Filter.doHandle(Filter.java:105) at org.restlet.Filter.handle(Filter.java:134) at org.restlet.Router.handle(Router.java:444) at org.geoserver.rest.RESTDispatcher$1.handle(RESTDispatcher.java:205) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:129) at org.geoserver.rest.RESTDispatcher.handleRequestInternal(RESTDispatcher.java:87) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75) at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.geoserver.security.filter.GeoServerC
Re: [Geoserver-users] Artifacts in reprojected rasters - has this been fixed?
+1 for fixing this bug ;) W dniu 2015-06-26 o 03:57, Phil Scadden pisze: > On 2.6.1, if a raster is reprojected, then "empty" space (where there is > no corresponding locatoin in the unprojected raster) around the edges of > the projected tile are showing up coloured instead of transparent. I > know is a known bug with Geotools. Has it been fixed in any later version? > -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] OS Mastermap in Production 1000's of users
Hi Gavin Only comment I can add is regarding the use of oracle to store your spatial data. I serve up mastermap data for the Merseyside area . I had a lot of complaints from my users about the speed of the maps loading I had all the mastermap data in an oracle 11 database. I switched to Postgis and the map tile loading time decreased significantly Feedback from my users was that the maps loaded "instantly" after the change. Mark Ismail -Original Message- From: gavin.montgomery [mailto:gavin.montgom...@live.com] Sent: 30 June 2015 11:53 To: geoserver-users@lists.sourceforge.net Subject: [Geoserver-users] OS Mastermap in Production 1000's of users Hi All, We are developing a map application which is aiming to serve 1000's of users Ordnance Survey Master Map data at various scales. We have scaled our geoserver solution to provide the following: 24 instances of geoserver running 4 instances on 6 VMs 8x 2.7 CPUs 64GB RAM each 2 instances of Geowebcache - 128GB RAM available on each GWC serves pre-built cache at levels 0-10 (1:2m - 1:3100) on British national Grid. (Level 10 consists of approx 8 million tiles) Any further levels are cached dynamically As it is OS Mastermap we are required to update our data every 6 weeks hence a full recache at that time. We have an Oracle Node with 12 cores serving our GeoServers as well as a number of other applications. Nonetheless OSMM requests are responsible for the majority of CPU usage. We are using spatial partitions, up to date statistics as well as appropriate columns indexing for the WMS queries to take place. We request tiles on 256x256 pixels - it has been suggested by our DBAs to increase this request size - does anybody agree/disagree with this? I would just expect this increases the size of the request and increase rendering time. OSMM is quite a complex SLD though is still rather performant. Has anybody had experience with full national coverage of OSMM on Oracle? Did you encounter performance issues at high user load? Did you do anything to rectify the solution or was it a matter of hardware required to deal with the demand? Any insights appreciated, happy to answer any further questions. Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives. Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] OS Mastermap in Production 1000's of users
Hi All, We are developing a map application which is aiming to serve 1000's of users Ordnance Survey Master Map data at various scales. We have scaled our geoserver solution to provide the following: 24 instances of geoserver running 4 instances on 6 VMs 8x 2.7 CPUs 64GB RAM each 2 instances of Geowebcache - 128GB RAM available on each GWC serves pre-built cache at levels 0-10 (1:2m - 1:3100) on British national Grid. (Level 10 consists of approx 8 million tiles) Any further levels are cached dynamically As it is OS Mastermap we are required to update our data every 6 weeks hence a full recache at that time. We have an Oracle Node with 12 cores serving our GeoServers as well as a number of other applications. Nonetheless OSMM requests are responsible for the majority of CPU usage. We are using spatial partitions, up to date statistics as well as appropriate columns indexing for the WMS queries to take place. We request tiles on 256x256 pixels - it has been suggested by our DBAs to increase this request size - does anybody agree/disagree with this? I would just expect this increases the size of the request and increase rendering time. OSMM is quite a complex SLD though is still rather performant. Has anybody had experience with full national coverage of OSMM on Oracle? Did you encounter performance issues at high user load? Did you do anything to rectify the solution or was it a matter of hardware required to deal with the demand? Any insights appreciated, happy to answer any further questions. Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
