[Geoserver-users] PostGIS Connection Refused

Ryan_Moody · May 30, 2013, 10:35am

Hello,

I would be very grateful if someone could assist me with the following problem.

I have GeoServer 2.3.2 running on my local machine, and have been able to get it to publish a layer using a PostGIS database as the data store, which is also running on my local machine.

The working datastore.xml is as follows:

= = =

DataStoreInfoImpl–6d343d73:13ef4ab8649:-8000

MyName

MyDescription

PostGIS

true

WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000

5432

20

MyPassword

postgis

localhost

true

false

10

MyDatabase

MyNamespace

public

true

false

1000

50

false

true

MyUser

1

<__default>false</__default>

= = =

I am now trying to reconfigure the data store to use GeoServer’s app-schema plugin, referring to an XML mapping file that provides the PostGIS database connection details.

The modified datastore.xml is as follows:

= = =

DataStoreInfoImpl–6d343d73:13ef4ab8649:-8000

MyName

MyDescription

PostGIS

true

WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000

MyNamespace

file:workspaces/path/to/MyMappingFile.xml

app-schema

<__default>false</__default>

= = =

And the XML mapping file I have defined is as follows:

= = =

<?xml version="1.0" encoding="UTF-8"?>

<as:AppSchemaDataAccess xmlns:as=“http://www.geotools.org/app-schema”

xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xsi:schemaLocation=“http://www.geotools.org/app-schema AppSchemaDataAccess.xsd”>

(…some namespaces…)

datastore

dbtype

postgis

host

localhost

port

5432

database

MyDatabase

user

MyUser

passwd

MyPassword

(…some target types…)

(…some type mappings…)

</as:AppSchemaDataAccess>

= = =

Unfortunately, when I restart GeoServer, I get a Java exception “Connection refused: connect” when it attempts to connect to my data source. I have confirmed that I am able to connect to my PostGIS database via pgAdmin, and I have set listen_addresses=’*’ in the postgresql.conf file. A Google search suggested to check my firewall settings, but the firewall shouldn’t be an issue as GeoServer and the PostGIS database are both running on my local machine. I have double-checked that the datastore parameters in the XML mapping file, especially the user and passwd, are correct.

If anyone can suggest how I may be able to address this issue, I’d be most appreciative

Regards,

Ryan

Ben_Caradoc-Davies · May 31, 2013, 4:16am

Ryan,

I can't see anything obvious. Can we please see the full stack trace from your logs?

Kind regards,
Ben.

On 30/05/13 18:35, Ryan Moody wrote:

Hello,

I would be very grateful if someone could assist me with the following
problem.

I have GeoServer 2.3.2 running on my local machine, and have been able
to get it to publish a layer using a PostGIS database as the data store,
which is also running on my local machine.

The working datastore.xml is as follows:

= = =

<dataStore>

   <id>DataStoreInfoImpl--6d343d73:13ef4ab8649:-8000</id>

   <name>MyName</name>

   <description>MyDescription</description>

   <type>PostGIS</type>

   <enabled>true</enabled>

   <workspace>

     <id>WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000</id>

   </workspace>

   <connectionParameters>

     <entry key="port">5432</entry>

     <entry key="Connection timeout">20</entry>

    <entry key="passwd"> MyPassword </entry>

     <entry key="dbtype">postgis</entry>

     <entry key="host">localhost</entry>

     <entry key="validate connections">true</entry>

     <entry key="encode functions">false</entry>

     <entry key="max connections">10</entry>

     <entry key="database">MyDatabase </entry>

     <entry key="namespace">MyNamespace </entry>

     <entry key="schema">public</entry>

     <entry key="Loose bbox">true</entry>

     <entry key="Expose primary keys">false</entry>

     <entry key="fetch size">1000</entry>

     <entry key="Max open prepared statements">50</entry>

     <entry key="preparedStatements">false</entry>

     <entry key="Estimated extends">true</entry>

     <entry key="user">MyUser</entry>

     <entry key="min connections">1</entry>

   </connectionParameters>

   <__default>false</__default>

</dataStore>

= = =

I am now trying to reconfigure the data store to use GeoServer’s
app-schema plugin, referring to an XML mapping file that provides the
PostGIS database connection details.

The modified datastore.xml is as follows:

= = =

<dataStore>

   <id> DataStoreInfoImpl--6d343d73:13ef4ab8649:-8000</id>

   <name> MyName </name>

   <description> MyDescription </description>

   <type>PostGIS</type>

   <enabled>true</enabled>

   <workspace>

     <id> WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000</id>

   </workspace>

   <connectionParameters>

      <entry key="namespace">MyNamespace</entry>

      <entry key="url">file:workspaces/path/to/MyMappingFile.xml</entry>

      <entry key="dbtype">app-schema</entry>

   </connectionParameters>

   <__default>false</__default>

</dataStore>

= = =

And the XML mapping file I have defined is as follows:

= = =

<?xml version="1.0" encoding="UTF-8"?>

<as:AppSchemaDataAccess xmlns:as="http://www.geotools.org/app-schema"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.geotools.org/app-schema
AppSchemaDataAccess.xsd">

     <namespaces>

                 (…some namespaces…)

    </namespaces>

     <sourceDataStores>

                 <DataStore>

                                 <id>datastore</id>

                                 <parameters>

                                                 <Parameter>

<name>dbtype</name>

<value>postgis</value>

                                                 </Parameter>

                                                 <Parameter>

<name>host</name>

<value>localhost</value>

                                                 </Parameter>

                                                 <Parameter>

<name>port</name>

<value>5432</value>

                                                 </Parameter>

                                                 <Parameter>

<name>database</name>

<value>MyDatabase </value>

                                                 </Parameter>

                                                 <Parameter>

<name>user</name>

<value>MyUser </value>

                                                 </Parameter>

                                                 <Parameter>

<name>passwd</name>

<value>MyPassword</value>

                                                 </Parameter>

                                 </parameters>

                                 </DataStore>

                 </sourceDataStores>

                 <targetTypes>

                                 (…some target types…)

                 </targetTypes>

     <typeMappings>

                 (…some type mappings…)

     </typeMappings>

</as:AppSchemaDataAccess>

= = =

Unfortunately, when I restart GeoServer, I get a Java exception
“Connection refused: connect” when it attempts to connect to my data
source. I have confirmed that I am able to connect to my PostGIS
database via pgAdmin, and I have set listen_addresses=’*’ in the
postgresql.conf file. A Google search suggested to check my firewall
settings, but the firewall shouldn’t be an issue as GeoServer and the
PostGIS database are both running on my local machine. I have
double-checked that the datastore parameters in the XML mapping file,
especially the user and passwd, are correct.

If anyone can suggest how I may be able to address this issue, I’d be
most appreciative

Regards,

Ryan

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ben Caradoc-Davies <Ben.Caradoc-Davies@anonymised.com>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre

Ryan_Moody · May 31, 2013, 8:54am

Hi Ben,

Thanks for your response, please find below the full stack trace and logs when GeoServer is started.

Best Regards,

Ryan

2013-05-31 09:46:43,776 DEBUG [org.geoserver.logging] - Logging output to file 'C:\Program Files (x86)\GeoServer 2.3.2\data_dir\logs\geoserver.log'
2013-05-31 09:46:43,777 DEBUG [org.geoserver.logging] - FINISHED CONFIGURING GEOSERVER LOGGING -------------------------
2013-05-31 09:46:45,246 WARN [org.springframework.beans.factory.config.CustomEditorConfigurer] - Passing PropertyEditor instances into CustomEditorConfigurer is deprecated: use PropertyEditorRegistrars or PropertyEditor class names instead. Offending key [org.geotools.util.Version; offending editor instance: org.geoserver.platform.util.VersionPropertyEditor@...5622...
2013-05-31 09:46:45,556 INFO [org.vfny.geoserver.global] -
----------------------------------
- GEOSERVER_DATA_DIR: C:\Program Files (x86)\GeoServer 2.3.2\data_dir
----------------------------------
2013-05-31 09:46:45,667 INFO [org.geoserver] - Loaded style 'burg'
2013-05-31 09:46:45,668 INFO [org.geoserver] - Loaded style 'capitals'
2013-05-31 09:46:45,669 INFO [org.geoserver] - Loaded style 'cite_lakes'
2013-05-31 09:46:45,670 INFO [org.geoserver] - Loaded style 'dem'
2013-05-31 09:46:45,670 INFO [org.geoserver] - Loaded style 'giant_polygon'
2013-05-31 09:46:45,671 INFO [org.geoserver] - Loaded style 'grass'
2013-05-31 09:46:45,672 INFO [org.geoserver] - Loaded style 'green'
2013-05-31 09:46:45,673 INFO [org.geoserver] - Loaded style 'line'
2013-05-31 09:46:45,674 INFO [org.geoserver] - Loaded style 'poi'
2013-05-31 09:46:45,679 INFO [org.geoserver] - Loaded style 'point'
2013-05-31 09:46:45,679 INFO [org.geoserver] - Loaded style 'polygon'
2013-05-31 09:46:45,691 INFO [org.geoserver] - Loaded style 'poly_landmarks'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'pophatch'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'population'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'rain'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'raster'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'restricted'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'simple_roads'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'simple_streams'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded style 'tiger_roads'
2013-05-31 09:46:45,701 INFO [org.geoserver] - Loaded default workspace bathymetry
2013-05-31 09:46:45,711 INFO [org.geoserver] - Loaded workspace 'bathymetry'
2013-05-31 09:46:45,711 INFO [org.geoserver] - Loaded workspace 'cite'
2013-05-31 09:46:45,711 INFO [org.geoserver] - Loaded workspace 'it.geosolutions'
2013-05-31 09:46:45,711 INFO [org.geoserver] - Loaded workspace 'nurc'
2013-05-31 09:46:45,711 INFO [org.geoserver] - Loaded workspace 'sde'
2013-05-31 09:46:45,721 INFO [org.geoserver] - Loaded workspace 'sf'
2013-05-31 09:46:45,721 INFO [org.geoserver] - Loaded workspace 'tiger'
2013-05-31 09:46:45,721 INFO [org.geoserver] - Loaded workspace 'topp'
2013-05-31 09:46:46,084 INFO [org.geoserver] - Loaded store 'bathymetry_data_source', enabled
2013-05-31 09:46:46,089 INFO [org.geoserver] - Loaded data store 'bathymetry_data_source'
2013-05-31 09:46:51,412 WARN [org.geoserver] - Error connecting to 'bathymetry_data_source'. Disabling.
2013-05-31 09:46:51,412 INFO [org.geoserver] -
java.io.IOException
  at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:579)
  at org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
  at org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:354)
  at org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:226)
  at org.geoserver.config.DefaultGeoServerLoader.loadCatalog(DefaultGeoServerLoader.java:46)
  at org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLoader.java:114)
  at org.geoserver.config.GeoServerLoaderProxy.postProcessBeforeInitialization(GeoServerLoaderProxy.java:58)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1448)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:284)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
  at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
  at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
  at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
  at org.geoserver.platform.GeoServerContextLoaderListener.contextInitialized(GeoServerContextLoaderListener.java:22)
  at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:540)
  at org.mortbay.jetty.servlet.Context.startContext(Context.java:135)
  at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1220)
  at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:510)
  at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448)
  at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
  at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
  at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
  at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
  at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
  at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
  at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
  at org.mortbay.jetty.Server.doStart(Server.java:222)
  at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
  at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:977)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.mortbay.start.Main.invokeMain(Main.java:183)
  at org.mortbay.start.Main.start(Main.java:497)
  at org.mortbay.start.Main.main(Main.java:115)
Caused by: java.lang.RuntimeException: java.net.ConnectException: Connection refused: connect
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:282)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:212)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:202)
  at org.geotools.xml.AppSchemaCache.resolveLocation(AppSchemaCache.java:307)
  at org.geotools.xml.AppSchemaResolver.resolve(AppSchemaResolver.java:201)
  at org.geotools.data.complex.config.EmfComplexFeatureReader.findSchemaNamespace(EmfComplexFeatureReader.java:138)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.parseGmlSchemas(AppSchemaDataAccessConfigurator.java:563)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:196)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:175)
  at org.geotools.data.complex.AppSchemaDataAccessFactory.createDataStore(AppSchemaDataAccessFactory.java:96)
  at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:107)
  at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:539)
  ... 93 more
Caused by: java.net.ConnectException: Connection refused: connect
  at java.net.DualStackPlainSocketImpl.connect0(Native Method)
  at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
  at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
  at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
  at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
  at java.net.PlainSocketImpl.connect(Unknown Source)
  at java.net.SocksSocketImpl.connect(Unknown Source)
  at java.net.Socket.connect(Unknown Source)
  at java.net.Socket.connect(Unknown Source)
  at sun.net.NetworkClient.doConnect(Unknown Source)
  at sun.net.www.http.HttpClient.openServer(Unknown Source)
  at sun.net.www.http.HttpClient.openServer(Unknown Source)
  at sun.net.www.http.HttpClient.<init>(Unknown Source)
  at sun.net.www.http.HttpClient.New(Unknown Source)
  at sun.net.www.http.HttpClient.New(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:232)
  ... 104 more
2013-05-31 09:46:51,626 INFO [org.geoserver] - Loaded feature type 'townssurvey_poly', enabled
2013-05-31 09:46:51,658 INFO [org.geoserver] - Loaded feature type 'bathymetry_data_source'
2013-05-31 09:46:51,678 INFO [org.geoserver] - Loaded layer 'townssurvey_poly'
2013-05-31 09:46:51,700 INFO [org.geoserver] - Loaded store 'arcGridSample', enabled
2013-05-31 09:46:51,708 INFO [org.geoserver] - Loaded coverage store 'arcGridSample'
2013-05-31 09:46:52,052 WARN [org.geotools.referencing.factory] - Axis elements found in a wkt definition, the force longitude first axis order hint might not be respected:
PROJCS["WGS84 / Simple Mercator", GEOGCS["WGS 84", DATUM["WGS_1984", SPHEROID["WGS_1984", 6378137.0, 298.257223563]], PRIMEM["Greenwich", 0.0], UNIT["degree", 0.017453292519943295]], PROJECTION["Mercator_1SP_Google"], PARAMETER["latitude_of_origin", 0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor", 1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0], UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH], AUTHORITY["EPSG","54004"]]
2013-05-31 09:46:52,159 INFO [org.geoserver] - Loaded coverage 'Arc_Sample', enabled
2013-05-31 09:46:52,169 INFO [org.geoserver] - Loaded coverage 'arcGridSample'
2013-05-31 09:46:52,849 INFO [org.geoserver] - Loaded layer 'Arc_Sample'
2013-05-31 09:46:52,856 INFO [org.geoserver] - Loaded store 'img_sample2', disabled
2013-05-31 09:46:52,857 INFO [org.geoserver] - Loaded coverage store 'img_sample2'
2013-05-31 09:46:53,086 INFO [org.geoserver] - Loaded coverage 'Pk50095', disabled
2013-05-31 09:46:53,087 INFO [org.geoserver] - Loaded coverage 'img_sample2'
2013-05-31 09:46:53,089 INFO [org.geoserver] - Loaded layer 'Pk50095'
2013-05-31 09:46:53,097 INFO [org.geoserver] - Loaded store 'mosaic', enabled
2013-05-31 09:46:53,098 INFO [org.geoserver] - Loaded coverage store 'mosaic'
2013-05-31 09:46:53,103 INFO [org.geoserver] - Loaded coverage 'mosaic', enabled
2013-05-31 09:46:53,104 INFO [org.geoserver] - Loaded coverage 'mosaic'
2013-05-31 09:46:53,156 WARN [org.geotools.gce.imagemosaic.catalog] - BBOXFilterExtractor::extractBasicProperties(): passed typename is null, using: mosaic
2013-05-31 09:46:53,604 WARN [class org.geotools.gce.imagemosaic.Utils] - Unable to find sample image for path C:\Program Files (x86)\GeoServer 2.3.2\data_dir\coverages\mosaic_sample\sample_image
2013-05-31 09:46:53,604 WARN [org.geotools.gce.imagemosaic] - Unable to find sample image for path file:/C:/Program%20Files%20(x86)/GeoServer%202.3.2/data_dir/coverages/mosaic_sample/mosaic.shp
2013-05-31 09:46:53,605 INFO [org.geoserver] - Loaded layer 'mosaic'
2013-05-31 09:46:53,619 INFO [org.geoserver] - Loaded store 'worldImageSample', enabled
2013-05-31 09:46:53,620 INFO [org.geoserver] - Loaded coverage store 'worldImageSample'
2013-05-31 09:46:53,624 INFO [org.geoserver] - Loaded coverage 'Img_Sample', enabled
2013-05-31 09:46:53,624 INFO [org.geoserver] - Loaded coverage 'worldImageSample'
2013-05-31 09:46:53,644 INFO [org.geoserver] - Loaded layer 'Img_Sample'
2013-05-31 09:46:53,680 INFO [org.geoserver] - Loaded store 'sf', enabled
2013-05-31 09:46:53,681 INFO [org.geoserver] - Loaded data store 'sf'
2013-05-31 09:46:53,736 INFO [org.geoserver] - Loaded feature type 'archsites', enabled
2013-05-31 09:46:53,737 INFO [org.geoserver] - Loaded feature type 'sf'
2013-05-31 09:46:53,738 INFO [org.geoserver] - Loaded layer 'archsites'
2013-05-31 09:46:53,746 INFO [org.geoserver] - Loaded feature type 'bugsites', enabled
2013-05-31 09:46:53,747 INFO [org.geoserver] - Loaded feature type 'sf'
2013-05-31 09:46:53,748 INFO [org.geoserver] - Loaded layer 'bugsites'
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded feature type 'restricted', enabled
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded feature type 'sf'
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded layer 'restricted'
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded feature type 'roads', enabled
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded feature type 'sf'
2013-05-31 09:46:53,774 INFO [org.geoserver] - Loaded layer 'roads'
2013-05-31 09:46:53,784 INFO [org.geoserver] - Loaded feature type 'streams', enabled
2013-05-31 09:46:53,784 INFO [org.geoserver] - Loaded feature type 'sf'
2013-05-31 09:46:53,784 INFO [org.geoserver] - Loaded layer 'streams'
2013-05-31 09:46:53,794 INFO [org.geoserver] - Loaded store 'sfdem', enabled
2013-05-31 09:46:53,794 INFO [org.geoserver] - Loaded coverage store 'sfdem'
2013-05-31 09:46:53,794 INFO [org.geoserver] - Loaded coverage 'sfdem', enabled
2013-05-31 09:46:53,794 INFO [org.geoserver] - Loaded coverage 'sfdem'
2013-05-31 09:46:53,946 INFO [org.geoserver] - Loaded layer 'sfdem'
2013-05-31 09:46:53,955 INFO [org.geoserver] - Loaded store 'nyc', enabled
2013-05-31 09:46:53,956 INFO [org.geoserver] - Loaded data store 'nyc'
2013-05-31 09:46:53,975 INFO [org.geoserver] - Loaded feature type 'giant_polygon', enabled
2013-05-31 09:46:53,976 INFO [org.geoserver] - Loaded feature type 'nyc'
2013-05-31 09:46:53,977 INFO [org.geoserver] - Loaded layer 'giant_polygon'
2013-05-31 09:46:53,978 INFO [org.geoserver] - Loaded feature type 'poi', enabled
2013-05-31 09:46:53,979 INFO [org.geoserver] - Loaded feature type 'nyc'
2013-05-31 09:46:53,980 INFO [org.geoserver] - Loaded layer 'poi'
2013-05-31 09:46:53,982 INFO [org.geoserver] - Loaded feature type 'poly_landmarks', enabled
2013-05-31 09:46:53,982 INFO [org.geoserver] - Loaded feature type 'nyc'
2013-05-31 09:46:53,984 INFO [org.geoserver] - Loaded layer 'poly_landmarks'
2013-05-31 09:46:54,006 INFO [org.geoserver] - Loaded feature type 'tiger_roads', enabled
2013-05-31 09:46:54,006 INFO [org.geoserver] - Loaded feature type 'nyc'
2013-05-31 09:46:54,006 INFO [org.geoserver] - Loaded layer 'tiger_roads'
2013-05-31 09:46:54,016 INFO [org.geoserver] - Loaded store 'states_shapefile', enabled
2013-05-31 09:46:54,016 INFO [org.geoserver] - Loaded data store 'states_shapefile'
2013-05-31 09:46:54,026 INFO [org.geoserver] - Loaded feature type 'states', enabled
2013-05-31 09:46:54,026 INFO [org.geoserver] - Loaded feature type 'states_shapefile'
2013-05-31 09:46:54,026 INFO [org.geoserver] - Loaded layer 'states'
2013-05-31 09:46:54,036 INFO [org.geoserver] - Loaded store 'taz_shapes', enabled
2013-05-31 09:46:54,036 INFO [org.geoserver] - Loaded data store 'taz_shapes'
2013-05-31 09:46:54,056 INFO [org.geoserver] - Loaded feature type 'tasmania_cities', enabled
2013-05-31 09:46:54,056 INFO [org.geoserver] - Loaded feature type 'taz_shapes'
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded layer 'tasmania_cities'
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded feature type 'tasmania_roads', enabled
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded feature type 'taz_shapes'
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded layer 'tasmania_roads'
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded feature type 'tasmania_state_boundaries', enabled
2013-05-31 09:46:54,066 INFO [org.geoserver] - Loaded feature type 'taz_shapes'
2013-05-31 09:46:54,076 INFO [org.geoserver] - Loaded layer 'tasmania_state_boundaries'
2013-05-31 09:46:54,076 INFO [org.geoserver] - Loaded feature type 'tasmania_water_bodies', enabled
2013-05-31 09:46:54,076 INFO [org.geoserver] - Loaded feature type 'taz_shapes'
2013-05-31 09:46:54,076 INFO [org.geoserver] - Loaded layer 'tasmania_water_bodies'
2013-05-31 09:46:54,076 WARN [org.geoserver] - Ignoring store directory 'tut_data_source'
2013-05-31 09:46:54,086 INFO [org.geoserver] - Loaded layer group 'spearfish'
2013-05-31 09:46:54,096 INFO [org.geoserver] - Loaded layer group 'tasmania'
2013-05-31 09:46:54,096 INFO [org.geoserver] - Loaded layer group 'tiger-ny'
2013-05-31 09:46:54,462 INFO [org.geoserver.gwc.layer] - Initializing GWC configuration based on GeoServer's Catalog
2013-05-31 09:46:54,463 INFO [org.geoserver.gwc.layer] - GeoServer TileLayer store base directory is: C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers
2013-05-31 09:46:54,464 INFO [org.geoserver.gwc.layer] - Loading tile layers from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers
2013-05-31 09:46:54,464 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fab.xml
2013-05-31 09:46:54,476 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'spearfish'
2013-05-31 09:46:54,476 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fac.xml
2013-05-31 09:46:54,477 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tasmania'
2013-05-31 09:46:54,477 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fad.xml
2013-05-31 09:46:54,478 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tiger-ny'
2013-05-31 09:46:54,478 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--4a9eec43_132d48aac79_-7fff.xml
2013-05-31 09:46:54,481 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'nurc:mosaic'
2013-05-31 09:46:54,481 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fae.xml
2013-05-31 09:46:54,482 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'nurc:Img_Sample'
2013-05-31 09:46:54,483 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb0.xml
2013-05-31 09:46:54,483 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:sfdem'
2013-05-31 09:46:54,483 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb4.xml
2013-05-31 09:46:54,484 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'nurc:Pk50095'
2013-05-31 09:46:54,484 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb6.xml
2013-05-31 09:46:54,488 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'nurc:Arc_Sample'
2013-05-31 09:46:54,489 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb8.xml
2013-05-31 09:46:54,489 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'topp:tasmania_water_bodies'
2013-05-31 09:46:54,490 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fba.xml
2013-05-31 09:46:54,490 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'topp:tasmania_state_boundaries'
2013-05-31 09:46:54,490 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fbc.xml
2013-05-31 09:46:54,492 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'topp:tasmania_roads'
2013-05-31 09:46:54,492 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fbe.xml
2013-05-31 09:46:54,493 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'topp:tasmania_cities'
2013-05-31 09:46:54,494 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc0.xml
2013-05-31 09:46:54,494 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'topp:states'
2013-05-31 09:46:54,494 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc2.xml
2013-05-31 09:46:54,495 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:streams'
2013-05-31 09:46:54,496 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc4.xml
2013-05-31 09:46:54,497 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:roads'
2013-05-31 09:46:54,497 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc6.xml
2013-05-31 09:46:54,498 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:restricted'
2013-05-31 09:46:54,498 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc8.xml
2013-05-31 09:46:54,499 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:bugsites'
2013-05-31 09:46:54,499 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fca.xml
2013-05-31 09:46:54,507 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'sf:archsites'
2013-05-31 09:46:54,507 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fcc.xml
2013-05-31 09:46:54,509 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tiger:tiger_roads'
2013-05-31 09:46:54,510 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fce.xml
2013-05-31 09:46:54,510 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tiger:poly_landmarks'
2013-05-31 09:46:54,510 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fd0.xml
2013-05-31 09:46:54,511 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tiger:poi'
2013-05-31 09:46:54,511 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fd2.xml
2013-05-31 09:46:54,512 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'tiger:giant_polygon'
2013-05-31 09:46:54,513 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl-39154e6b_13ef0ec49f8_-7ffc.xml
2013-05-31 09:46:54,513 DEBUG [org.geoserver.gwc.layer] - Loaded tile layer 'bathymetry:townssurvey_poly'
2013-05-31 09:46:54,547 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fae.xml
2013-05-31 09:46:54,554 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fce.xml
2013-05-31 09:46:54,555 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--4a9eec43_132d48aac79_-7fff.xml
2013-05-31 09:46:54,556 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fbe.xml
2013-05-31 09:46:54,561 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fca.xml
2013-05-31 09:46:54,562 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fbc.xml
2013-05-31 09:46:54,565 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fcc.xml
2013-05-31 09:46:54,566 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fba.xml
2013-05-31 09:46:54,566 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fad.xml
2013-05-31 09:46:54,567 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fac.xml
2013-05-31 09:46:54,568 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerGroupInfoImpl--570ae188_124761b8d78_-7fab.xml
2013-05-31 09:46:54,578 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb4.xml
2013-05-31 09:46:54,578 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb6.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc8.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb8.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl-39154e6b_13ef0ec49f8_-7ffc.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc6.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc4.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fd2.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc2.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fc0.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fb0.xml
2013-05-31 09:46:54,588 DEBUG [org.geoserver.gwc.layer] - Depersisting GeoServerTileLayerInfo from C:\Program Files (x86)\GeoServer 2.3.2\data_dir\gwc-layers\LayerInfoImpl--570ae188_124761b8d78_-7fd0.xml
2013-05-31 09:46:54,588 INFO [org.geoserver.gwc.layer] - GWC configuration based on GeoServer's Catalog loaded successfuly
2013-05-31 09:46:54,778 INFO [org.geoserver] - Loaded service 'wcs', enabled
2013-05-31 09:46:54,808 INFO [org.geoserver] - Loaded service 'wfs', enabled
2013-05-31 09:46:54,860 INFO [org.geoserver] - Loaded service 'wms', enabled
2013-05-31 09:46:54,870 INFO [org.geoserver.gwc.config] - Initializing GeoServer specific GWC configuration from gwc-gs.xml
2013-05-31 09:46:54,880 DEBUG [org.geoserver.gwc.config] - GWC GeoServer specific configuration loaded from gwc-gs.xml
2013-05-31 09:46:54,951 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/gwc/service/**] onto handler 'dispatcher'
2013-05-31 09:46:55,195 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/ows/**] onto handler 'dispatcher'
2013-05-31 09:46:55,195 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/ows] onto handler 'dispatcher'
2013-05-31 09:46:55,210 INFO [org.geoserver] - GeoServer configuration lock is enabled
2013-05-31 09:46:55,380 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wcs] onto handler 'dispatcher'
2013-05-31 09:46:55,381 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wcs/**] onto handler 'dispatcher'
2013-05-31 09:46:56,180 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wfs/*] onto handler 'dispatcher'
2013-05-31 09:46:56,180 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/TestWfsPost] onto handler 'wfsTestServlet'
2013-05-31 09:46:56,180 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wfs] onto handler 'dispatcher'
2013-05-31 09:46:56,517 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wms/*] onto handler 'dispatcher'
2013-05-31 09:46:56,517 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/wms] onto handler 'dispatcher'
2013-05-31 09:46:56,765 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/kml] onto handler 'dispatcher'
2013-05-31 09:46:56,766 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/kml/*] onto handler 'dispatcher'
2013-05-31 09:46:56,767 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/animate] onto handler 'dispatcher'
2013-05-31 09:46:56,767 INFO [org.geoserver.ows.OWSHandlerMapping] - Mapped URL path [/animate/*] onto handler 'dispatcher'
2013-05-31 09:46:57,207 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - Line 1: /**:GET=ADMIN
2013-05-31 09:46:57,208 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - ~~~~~~~~~~ name= /**:GET firstColonIndex= 3
2013-05-31 09:46:57,208 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - ~~~~~~~~~~ name= /**:GET antPath= /** methods= GET
2013-05-31 09:46:57,208 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - methodList = [GET]
2013-05-31 09:46:57,210 DEBUG [org.geoserver.security.RESTfulPathBasedFilterInvocationDefinitionMap] - Added Ant path: /**; attributes: [ADMIN], httpMethods: [GET]
2013-05-31 09:46:57,210 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - Line 1: /**:POST,DELETE,PUT=ADMIN
2013-05-31 09:46:57,210 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - ~~~~~~~~~~ name= /**:POST,DELETE,PUT firstColonIndex= 3
2013-05-31 09:46:57,210 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - ~~~~~~~~~~ name= /**:POST,DELETE,PUT antPath= /** methods= POST,DELETE,PUT
2013-05-31 09:46:57,211 DEBUG [org.geoserver.security.RESTfulDefinitionSource] - methodList = [POST, DELETE, PUT]
2013-05-31 09:46:57,211 DEBUG [org.geoserver.security.RESTfulPathBasedFilterInvocationDefinitionMap] - Added Ant path: /**; attributes: [ADMIN], httpMethods: [POST, DELETE, PUT]

-----Original Message-----
From: Ben Caradoc-Davies [mailto:Ben.Caradoc-Davies@…367…]
Sent: 31 May 2013 05:17
To: Ryan Moody
Cc: geoserver-users@lists.sourceforge.net; Ian Turton; Neil Kirk
Subject: Re: [Geoserver-users] PostGIS Connection Refused

Ryan,

I can't see anything obvious. Can we please see the full stack trace from your logs?

Kind regards,
Ben.

On 30/05/13 18:35, Ryan Moody wrote:

Hello,

I would be very grateful if someone could assist me with the following
problem.

I have GeoServer 2.3.2 running on my local machine, and have been able
to get it to publish a layer using a PostGIS database as the data
store, which is also running on my local machine.

The working datastore.xml is as follows:

= = =

<dataStore>

   <id>DataStoreInfoImpl--6d343d73:13ef4ab8649:-8000</id>

   <name>MyName</name>

   <description>MyDescription</description>

   <type>PostGIS</type>

   <enabled>true</enabled>

   <workspace>

     <id>WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000</id>

   </workspace>

   <connectionParameters>

     <entry key="port">5432</entry>

     <entry key="Connection timeout">20</entry>

    <entry key="passwd"> MyPassword </entry>

     <entry key="dbtype">postgis</entry>

     <entry key="host">localhost</entry>

     <entry key="validate connections">true</entry>

     <entry key="encode functions">false</entry>

     <entry key="max connections">10</entry>

     <entry key="database">MyDatabase </entry>

     <entry key="namespace">MyNamespace </entry>

     <entry key="schema">public</entry>

     <entry key="Loose bbox">true</entry>

     <entry key="Expose primary keys">false</entry>

     <entry key="fetch size">1000</entry>

     <entry key="Max open prepared statements">50</entry>

     <entry key="preparedStatements">false</entry>

     <entry key="Estimated extends">true</entry>

     <entry key="user">MyUser</entry>

     <entry key="min connections">1</entry>

   </connectionParameters>

   <__default>false</__default>

</dataStore>

= = =

I am now trying to reconfigure the data store to use GeoServer’s
app-schema plugin, referring to an XML mapping file that provides the
PostGIS database connection details.

The modified datastore.xml is as follows:

= = =

<dataStore>

   <id> DataStoreInfoImpl--6d343d73:13ef4ab8649:-8000</id>

   <name> MyName </name>

   <description> MyDescription </description>

   <type>PostGIS</type>

   <enabled>true</enabled>

   <workspace>

     <id> WorkspaceInfoImpl-39154e6b:13ef0ec49f8:-8000</id>

   </workspace>

   <connectionParameters>

      <entry key="namespace">MyNamespace</entry>

      <entry
key="url">file:workspaces/path/to/MyMappingFile.xml</entry>

      <entry key="dbtype">app-schema</entry>

   </connectionParameters>

   <__default>false</__default>

</dataStore>

= = =

And the XML mapping file I have defined is as follows:

= = =

<?xml version="1.0" encoding="UTF-8"?>

<as:AppSchemaDataAccess xmlns:as="http://www.geotools.org/app-schema"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.geotools.org/app-schema
AppSchemaDataAccess.xsd">

     <namespaces>

                 (…some namespaces…)

    </namespaces>

     <sourceDataStores>

                 <DataStore>

                                 <id>datastore</id>

                                 <parameters>

                                                 <Parameter>

<name>dbtype</name>

<value>postgis</value>

                                                 </Parameter>

                                                 <Parameter>

<name>host</name>

<value>localhost</value>

                                                 </Parameter>

                                                 <Parameter>

<name>port</name>

<value>5432</value>

                                                 </Parameter>

                                                 <Parameter>

<name>database</name>

<value>MyDatabase </value>

                                                 </Parameter>

                                                 <Parameter>

<name>user</name>

<value>MyUser </value>

                                                 </Parameter>

                                                 <Parameter>

<name>passwd</name>

<value>MyPassword</value>

                                                 </Parameter>

                                 </parameters>

                                 </DataStore>

                 </sourceDataStores>

                 <targetTypes>

                                 (…some target types…)

                 </targetTypes>

     <typeMappings>

                 (…some type mappings…)

     </typeMappings>

</as:AppSchemaDataAccess>

= = =

Unfortunately, when I restart GeoServer, I get a Java exception
“Connection refused: connect” when it attempts to connect to my data
source. I have confirmed that I am able to connect to my PostGIS
database via pgAdmin, and I have set listen_addresses=’*’ in the
postgresql.conf file. A Google search suggested to check my firewall
settings, but the firewall shouldn’t be an issue as GeoServer and the
PostGIS database are both running on my local machine. I have
double-checked that the datastore parameters in the XML mapping file,
especially the user and passwd, are correct.

If anyone can suggest how I may be able to address this issue, I’d be
most appreciative

Regards,

Ryan

----------------------------------------------------------------------
-------- Introducing AppDynamics Lite, a free troubleshooting tool for
Java/.NET Get 100% visibility into your production application - at no
cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ben Caradoc-Davies <Ben.Caradoc-Davies@...367...> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre

Ben_Caradoc-Davies · June 4, 2013, 2:22am

Aha! Here is the culprit. It is not the connection to your database that is failing, but GeoServer's attempt to download your application schemas.

What is your mapping schemaUri?

When a GeoServer app-schema data store is loaded for the first time, it will download and cache all required application schemas in app-schema-cache in your data directory:
http://docs.geoserver.org/latest/en/user/data/app-schema/app-schema-resolution.html

Either the web server is refusing connections from the GeoServer or a firewall is blocking it. A tool like nmap ("nmap -p 80 www.example.org") can help diagnose this. If your schema is not published you can instead use an OASIS catalog, as described in the link above.

The current development GeoServer prints better diagnostic information about which schema has caused the problem; sorry, this is not in 2.3.2.

Kind regards,
Ben.

On 31/05/13 16:54, Ryan Moody wrote:

Caused by: java.lang.RuntimeException: java.net.ConnectException: Connection refused: connect
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:282)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:212)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:202)
  at org.geotools.xml.AppSchemaCache.resolveLocation(AppSchemaCache.java:307)
  at org.geotools.xml.AppSchemaResolver.resolve(AppSchemaResolver.java:201)
  at org.geotools.data.complex.config.EmfComplexFeatureReader.findSchemaNamespace(EmfComplexFeatureReader.java:138)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.parseGmlSchemas(AppSchemaDataAccessConfigurator.java:563)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:196)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:175)
  at org.geotools.data.complex.AppSchemaDataAccessFactory.createDataStore(AppSchemaDataAccessFactory.java:96)
  at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:107)
  at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:539)

--
Ben Caradoc-Davies <Ben.Caradoc-Davies@anonymised.com>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre

Ryan_Moody · June 5, 2013, 12:59pm

Hello,

Emmanuel - I have confirmed that localhost resolves to ::1, and that my PostGIS database allows connections from anywhere ( pg_hba.conf contains the line host all all 0.0.0.0/0 trust, and postgresql.conf contains the line listen_addresses = '*' ).

Ben - I checked my mapping's schemaURI and realised that it was pointing to an invalid location. I have now corrected the path to the .xsd schema.

Thanks both for your assistance, the "Connection refused" error no longer occurs

Best Regards,

Ryan

-----Original Message-----
From: Ben Caradoc-Davies [mailto:Ben.Caradoc-Davies@…367…]
Sent: 04 June 2013 03:23
To: Ryan Moody
Cc: geoserver-users@lists.sourceforge.net; Ian Turton; Neil Kirk
Subject: Re: [Geoserver-users] PostGIS Connection Refused

Aha! Here is the culprit. It is not the connection to your database that is failing, but GeoServer's attempt to download your application schemas.

What is your mapping schemaUri?

When a GeoServer app-schema data store is loaded for the first time, it will download and cache all required application schemas in app-schema-cache in your data directory:
http://docs.geoserver.org/latest/en/user/data/app-schema/app-schema-resolution.html

Either the web server is refusing connections from the GeoServer or a firewall is blocking it. A tool like nmap ("nmap -p 80 www.example.org") can help diagnose this. If your schema is not published you can instead use an OASIS catalog, as described in the link above.

The current development GeoServer prints better diagnostic information about which schema has caused the problem; sorry, this is not in 2.3.2.

Kind regards,
Ben.

On 31/05/13 16:54, Ryan Moody wrote:

Caused by: java.lang.RuntimeException: java.net.ConnectException: Connection refused: connect
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:282)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:212)
  at org.geotools.xml.AppSchemaCache.download(AppSchemaCache.java:202)
  at org.geotools.xml.AppSchemaCache.resolveLocation(AppSchemaCache.java:307)
  at org.geotools.xml.AppSchemaResolver.resolve(AppSchemaResolver.java:201)
  at org.geotools.data.complex.config.EmfComplexFeatureReader.findSchemaNamespace(EmfComplexFeatureReader.java:138)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.parseGmlSchemas(AppSchemaDataAccessConfigurator.java:563)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:196)
  at org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:175)
  at org.geotools.data.complex.AppSchemaDataAccessFactory.createDataStore(AppSchemaDataAccessFactory.java:96)
  at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:107)
  at
org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:539)

--
Ben Caradoc-Davies <Ben.Caradoc-Davies@...367...> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre

Paras.k · August 3, 2018, 11:22am

hello ,

Ryan Moody - i am facing the same issue will you help me how to resolve
the issue .

Best Regards,

Paras

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Bart_van_den_Eijnde1 · August 4, 2018, 2:08am

Paras,

you are replying to a thread from 2013. Ryan reported:

"I checked my mapping's schemaURI and realised that it was pointing to an invalid location. I have now corrected the path to the .xsd schema. Thanks both for your assistance, the "Connection refused" error no longer occurs :-)"

Are you using the app-schema plugin? Have you checked your PostGIS credentials with pgadmin? Are there any firewalls that could be blocking your connection? Is postgres configured to accept tcp connections from your host? Have you tested these with nmap? Do you have any relevant stack traces from the GeoServer logs?

Kind regards,
Ben.

On 03/08/18 23:22, Paras.k wrote:

hello ,

Ryan Moody - i am facing the same issue will you help me how to resolve
the issue .

Best Regards,

Paras

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <https://transient.nz/>
New Zealand

Paras.k · August 6, 2018, 9:41am

Hi Ryan Moody,

Thanks for your response , I am new to this that's why i don't know how to
check mapping's schemaURI will you explian how i am able check

kind regards,
Paras

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

Bart_van_den_Eijnde1 · August 6, 2018, 9:33pm

Paras,

- Are you using the app-schema plugin? schemaUri is only used for the app-schema plugin.

The following questions are applicable for all attempt to connect to PostGIS (not just app-schema):

- Have you checked your PostGIS credentials with pgadmin?

- Are there any firewalls that could be blocking your connection?

- Is postgres configured to accept tcp connections from your host?

- Have you tested these with nmap?

- Do you have any relevant stack traces from the GeoServer logs?

These are the same questions that I asked in my previous email.

Kind regards,
Ben.

On 06/08/18 21:41, Paras.k wrote:

Thanks for your response , I am new to this that's why i don't know how to
check mapping's schemaURI will you explian how i am able check

--
Ben Caradoc-Davies <ben@anonymised.com>
Director
Transient Software Limited <https://transient.nz/>
New Zealand