Re: [Geoserver-users] (no subject)
Richard, Not a real clue, but so far I haven't had any problems with the combination: - win 2008 R2 - Java 1.7 - TomCat 7 - GeoServer 2.2 What kind of requests do you run to 'kill' it? regards, Casper On Tue, Oct 15, 2013 at 9:55 AM, Richard Duivenvoorde rdmaili...@duif.netwrote: Hi List, we have had Geoserver running on Tomcat on Windows Server 2008 R2, for a while without problems. Recently we upgraded both Tomcat, JDK and Geoserver (2.3.3), and find crashes regularly now. We already downgraded to JDK 1.6 after finding messages that 1.7 was still not supported. The crashes are such that the Tomcat service stops and does not start up anymore. Only Geoserver is running in Tomcat. After the crash there is a log file named hs_err_pid2728.log I copied one of those to here: http://pastebin.com/JX56DeW7 It looks like there is something going wrong with outputting the images: InternalAprOutputBuffer.flushBuffer Anybody a clue? Regards, Richard Duivenvoorde ps it is an open service, if needed I can provide a service url -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60135031iu=/4140/ostg.clktrk ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60135031iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] SQL Server 2008 e Geoserver
Mark, If nothing related to SQL Server is showing on the datastore creation, then the sql server plugin was not found. check if it's in: (GeoServer or tomcat)\webapps\geoserver\WEB-INF\lib For 2.2.5 the file is called: gt-jdbc-sqlserver-8.7.jar Doublecheck if you have the plugin belonging to the correct geoserver version. You can download older versions here: http://geoserver.org/display/GEOS/All+Releases Initially I also had some problems setting things up, but I succeeded by following the docs: http://docs.geoserver.org/2.3.0/user/data/database/sqlserver.html Casper On Tue, Jun 11, 2013 at 5:45 PM, Mark Paulson ma...@proseals.com wrote: Hi Casper, I have tried that until I'm blue in the face. And I see nothing at all referring to SQL Server. I don't even have a hint why it has not showing. I am running GeoServer as a service. I also updated to 2.3.2 and notice that I have two instances of GeoServer running being 2.3.1 and 2.3.2 which I don't understand since both are installed the same directory. I have tried with each version of the service and still no Sql Server is showing up. Pulling my hair out. Mark From: Casper Span i...@spatially-oriented.com Date: Tuesday, June 11, 2013 4:04 AM To: Mark R. Paulson ma...@proseals.com Cc: geoserver-users@lists.sourceforge.net geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] SQL Server 2008 e Geoserver I have it working on multiple machines. It's really only: - Installing the sql server plugin (copy to web-inf\lib) - Copy sqljdbc4.jarto web-inf\lib - copy sqljdbc_auth.dll sqljdbc_xa.dll to c:\windows\system32\ You should copy the 64-bit dll's to C:\Windows\SysWOW64 if you are using a 64-bit JRE (and thus not running geoserver as a service) If you are using the 32-bit JRE, you should also use the 32-bit sql dll's. Then if you reboot geoserver (or restart service) you should be able to see 2 entries of SQL server on the create datastore page. If you only see 1 (JNDI), then the dll's can't be found. Hope this helps! Casper On Tue, Jun 11, 2013 at 12:30 AM, txrpls ma...@proseals.com wrote: I am having the same issue. I am running Windows Server 2008 R2 and SQL Server 2008 R2. I have installed the files as directed with no luck. I am not running Tomcat. installed so the first file is installed in D:\Program Files (x86)\GeoServer 2.3.1\WEB-INF\lib the others as in step two below. I have restarted GeoServer, SQl Server and Windows Server and nothing is showing up. Server is the 64 bit version BTW -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-2008-e-Geoserver-tp4664552p5059240.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] SQL Server 2008 e Geoserver
I have it working on multiple machines. It's really only: - Installing the sql server plugin (copy to web-inf\lib) - Copy sqljdbc4.jarto web-inf\lib - copy sqljdbc_auth.dll sqljdbc_xa.dll to c:\windows\system32\ You should copy the 64-bit dll's to C:\Windows\SysWOW64 if you are using a 64-bit JRE (and thus not running geoserver as a service) If you are using the 32-bit JRE, you should also use the 32-bit sql dll's. Then if you reboot geoserver (or restart service) you should be able to see 2 entries of SQL server on the create datastore page. If you only see 1 (JNDI), then the dll's can't be found. Hope this helps! Casper On Tue, Jun 11, 2013 at 12:30 AM, txrpls ma...@proseals.com wrote: I am having the same issue. I am running Windows Server 2008 R2 and SQL Server 2008 R2. I have installed the files as directed with no luck. I am not running Tomcat. installed so the first file is installed in D:\Program Files (x86)\GeoServer 2.3.1\WEB-INF\lib the others as in step two below. I have restarted GeoServer, SQl Server and Windows Server and nothing is showing up. Server is the 64 bit version BTW -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-2008-e-Geoserver-tp4664552p5059240.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Sql server 2008 + empty layer brings errors
Nobody has any experience with geoserver + sql server? On Fri, Sep 7, 2012 at 9:16 AM, Casper Span i...@spatially-oriented.comwrote: Hi List, Just a quick question, I'm not particularly sure if this is a geoserver or SQL Server (or JDBC driver) issue, but as I have to start my search somewhere, I might as well do it here. :-) I have a SQL Server 2008 installation, with some layers in it. One of them happens to have some rows, but all records have a NULL as geometry value. I will call this layer A. I have Geoserver 2.1 with a store pointing at my SQL Server and I created some layers there. Creating is all working. Ofcourse, on layer A I cannot compute bounding box from data, so I filled in the entire scope of the RD (EPSG:28992) coordinate system and translated it to WGS84. No problems there either. Now, I go to the layer preview and I get a nice ServiceException: Rendering process failed com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate quot;geometryquot;: System.FormatException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 99. System.FormatException: bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid) bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid) bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid) bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) . A .NET Framework error occurred during execution of user-defined routine or aggregate quot;geometryquot;: System.FormatException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 99. System.FormatException: bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid) bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid) bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid) bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) Is there a way to trick either SQL Server, the JDBC driver or Geoserver to just return an empty image when the layer contains no geometries? Regards, Casper Span -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Sql server 2008 + empty layer brings errors
Andrea, I think that should solve this issue indeed. Let me know when/if I should test things. I'm afraid I don't have much time to help coding, but I'm more then happy to take a crack at trying to break stuff :) Regards, Casper On Mon, Sep 10, 2012 at 10:17 AM, Andrea Aime andrea.a...@geo-solutions.itwrote: On Mon, Sep 10, 2012 at 10:01 AM, Casper Span i...@spatially-oriented.com wrote: Nobody has any experience with geoserver + sql server? Some certainly do (I worked on its code for example) but never worked against empty tables. It's probably some oddity that affects sql server only (most of the code is shared among all spatial databases) and likely requires a specific fix in the code. This week we should be working on adding a geometry columns like table for the SQL Server store that will allow people to declare the type of geometry contained in the table, and its native srid, that might also help solve your issue Cheers Andrea -- == Our support, Your Success! Visit http://opensdi.geo-solutions.it 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 962313 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Sql server 2008 + empty layer brings errors
Hi List, Just a quick question, I'm not particularly sure if this is a geoserver or SQL Server (or JDBC driver) issue, but as I have to start my search somewhere, I might as well do it here. :-) I have a SQL Server 2008 installation, with some layers in it. One of them happens to have some rows, but all records have a NULL as geometry value. I will call this layer A. I have Geoserver 2.1 with a store pointing at my SQL Server and I created some layers there. Creating is all working. Ofcourse, on layer A I cannot compute bounding box from data, so I filled in the entire scope of the RD (EPSG:28992) coordinate system and translated it to WGS84. No problems there either. Now, I go to the layer preview and I get a nice ServiceException: Rendering process failed com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate quot;geometryquot;: System.FormatException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 99. System.FormatException: bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid) bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid) bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid) bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) . A .NET Framework error occurred during execution of user-defined routine or aggregate quot;geometryquot;: System.FormatException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 99. System.FormatException: bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid) bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid) bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid) bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) Is there a way to trick either SQL Server, the JDBC driver or Geoserver to just return an empty image when the layer contains no geometries? Regards, Casper Span -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Unsubscribing
Fill in your email on the bottom most input and click unsubscribe or edit options. On the next page there is an unsubscribe button which should do the trick. Also, it might be interesting to just edit your account to receive a digest instead of seperate mails. That way you will still receive the list but only with a single mail a day. Just check the option: Would you like to receive list mail batched in a daily digest? regards, Casper On Fri, May 25, 2012 at 10:35 AM, Chris Morgan ch...@lynxinfo.co.uk wrote: How the hell do I unsubscribe from this list? It was interesting for a while, but is now getting overwhelming with the number of emails received. I have looked on https://lists.sourceforge.net/lists/listinfo/geoserver-users but this just says I am already subscribed when I enter my email address. Thanks -- _ Chris Morgan Software Manager Lynx Information Systems Ltd Tel: +44 (0)20 8780 2634 Email: ch...@lynxinfo.co.uk Web: http://www.lynxinfo.co.uk _ Incoming and outgoing emails are checked for viruses by Sophos AntiVirus. This email may contain confidential information which is intended for the named recipient(s) only. Â If you are not the named recipient you should not take any action in relation to this email, other than to notify us that you have received it in error. Lynx Information Systems Ltd 93-99 Upper Richmond Rd London SW15 2TG United Kingdom Web: http://www.lynxinfo.co.uk Email: l...@lynxinfo.co.uk Tel: +44 (0)20 8780 2634 Fax: +44 (0)20 8780 0931 Registered in England Number 2454130 VAT Number GB 561 8979 88 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver and SQL Server 2008
Did you place the dlls sqljdbc_auth.dll and sqljdbc_xa.dll in your windows\sysWOW64 folder? If I did that, plus copy the sqljdbc4.jar in WEB-INF/lib (and the geoserver plugin, ofcourse) it works for me. You should have new store types: Microsoft SQL Server - Microsoft SQL Server Microsoft SQL Server (JNDI) - Microsoft SQL Server (JNDI) The first one should work now. I testes this on JRE67, both work. Regards, Casper -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com On Fri, Mar 30, 2012 at 1:46 PM, agnkol agnkolkiew...@gmail.com wrote: Hi, If you did everything as it's decribed in the docs and it's still not working then try using jre7. It's worked for my configuration. BR, AK -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Geoserver-and-SQL-Server-2008-tp4666801p4671053.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver GeoWebCache 28992
___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Casper Span T: @Span_Droid https://twitter.com/#%21/Span_Droid W: http://www.spatially-oriented.com M: i...@spatially-oriented.com -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Geoserver MS SQL Server 2008 (SOLVED)
Hi List, We just discovered a nasty problem. When using Geoserver 2.1.2 and Ms SQL Server 2008, creating a new SQL Server store... well... it doesn't work. We get a timeout, Wicket kills the thread and nothing gets created. Creating the xml files by hand (or in our case, copying it from a working version) kills the GeoServer proces. Luckely, we had a working 2.1.2 situation, so we started comparing. We found out that this is a problem caused by the JAVA JRE 1.6.0 Update 29! When we downgraded the JRE to update 26, Geoserver could connect to MS SQL without any problems. I'm not sure yet where the real problem lies. It could either be with the JRE update, or within the MS SQL .JAR file. We will investigate that as well. For now, downgrading the JRE to update 26 is good enough for our development, so it might take some time before we start ripping down our development installation. :) I hope I helped a few who were struggling with this problem. Regards, Casper PS As I found some posts on this list that looked really simular to our situation, I'll add some tags for people to find this post with: MSSQL 2008, org.apache.wicket.WicketRuntimeException: After 1 minute the Pageman null is still lock by. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
