[Geoserver-users] Failed to connect to the EPSG database

I posted a message several days ago about a "Translator Error" and never
really reached a resolution. I have moved backwards though and found that on
a completely virgin 1.5.4 installation I get the following message during
startup. This seems to be the crux of my problems. Does anyone know how this
works?

Thanks.

10486 [WARNING] DefaultFactory - Unavailable authority factory: European
Petroleum Survey Group
org.opengis.referencing.FactoryException: Failed to connect to the EPSG
database.

--
View this message in context: http://www.nabble.com/Failed-to-connect-to-the-EPSG-database-tf4731154.html#a13528218
Sent from the GeoServer - User mailing list archive at Nabble.com.

What user are you running this as? Have you tried just downloading a binary install into a completely normal user account?

Kevin@anonymised.com wrote:

I posted a message several days ago about a "Translator Error" and never
really reached a resolution. I have moved backwards though and found that on
a completely virgin 1.5.4 installation I get the following message during
startup. This seems to be the crux of my problems. Does anyone know how this
works?

Thanks.

10486 [WARNING] DefaultFactory - Unavailable authority factory: European
Petroleum Survey Group
org.opengis.referencing.FactoryException: Failed to connect to the EPSG
database.

I created a new user 'geoserver', made them the owner of the geoserver directory, and executed startup.sh as that user. No dice.

Maybe an explanation of what is happening here will shed some light on why it is failing. ?

Kevin

6682 [WARNING] DefaultFactory - Unavailable authority factory: European Petroleum Survey Group
org.opengis.referencing.FactoryException: Failed to connect to the EPSG database.
         at org.geotools.referencing.factory.epsg.DefaultFactory.createBackingStore(DefaultFactory.java:368)
         at org.geotools.referencing.factory.DeferredAuthorityFactory.getBackingStore(DeferredAuthorityFactory.java:136)
         at org.geotools.referencing.factory.BufferedAuthorityFactory.isAvailable(BufferedAuthorityFactory.java:206)
         at org.geotools.referencing.factory.DeferredAuthorityFactory.isAvailable(DeferredAuthorityFactory.java:124)
         at org.geotools.factory.FactoryRegistry$DefaultFilter.filter(FactoryRegistry.java:76)
         at javax.imageio.spi.FilterIterator.advance(ServiceRegistry.java:789)
         at javax.imageio.spi.FilterIterator.<init>(ServiceRegistry.java:783)
         at javax.imageio.spi.ServiceRegistry.getServiceProviders(ServiceRegistry.java:490)
         at org.geotools.factory.FactoryRegistry.getServiceProviders(FactoryRegistry.java:177)
         at org.geotools.factory.FactoryRegistry.getServiceProviders(FactoryRegistry.java:117)
         at org.geotools.factory.FactoryCreator.getServiceProvider(FactoryCreator.java:161)
         at org.geotools.referencing.FactoryFinder.getAuthorityFactory(FactoryFinder.java:235)
         at org.geotools.referencing.FactoryFinder.getCoordinateOperationAuthorityFactory(FactoryFinder.java:540)
         at org.geotools.referencing.operation.AuthorityBackedFactory.getAuthorityFactory(AuthorityBackedFactory.java:167)
         at org.geotools.referencing.operation.AuthorityBackedFactory.isAvailable(AuthorityBackedFactory.java:442)
         at org.geotools.factory.FactoryRegistry$DefaultFilter.filter(FactoryRegistry.java:76)
         at javax.imageio.spi.FilterIterator.advance(ServiceRegistry.java:789)
         at javax.imageio.spi.FilterIterator.next(ServiceRegistry.java:807)
         at org.geotools.factory.FactoryRegistry.getServiceProvider(FactoryRegistry.java:276)
         at org.geotools.factory.FactoryRegistry.getServiceProvider(FactoryRegistry.java:254)
         at org.geotools.factory.FactoryCreator.getServiceProvider(FactoryCreator.java:115)
         at org.geotools.referencing.FactoryFinder.getFactory(FactoryFinder.java:212)
         at org.geotools.referencing.FactoryFinder.getCoordinateOperationFactory(FactoryFinder.java:364)
         at org.geotools.referencing.CRS.findMathTransform(CRS.java:145)
         at org.vfny.geoserver.util.CoverageStoreUtils.getWGS84LonLatEnvelope(CoverageStoreUtils.java:288)
         at org.vfny.geoserver.global.xml.XMLConfigReader.loadCoverageDTOFromXML(XMLConfigReader.java:1748)
         at org.vfny.geoserver.global.xml.XMLConfigReader.loadCoverage(XMLConfigReader.java:1630)
         at org.vfny.geoserver.global.xml.XMLConfigReader.loadCoverages(XMLConfigReader.java:1581)
         at org.vfny.geoserver.global.xml.XMLConfigReader.loadCatalog(XMLConfigReader.java:363)
         at org.vfny.geoserver.global.xml.XMLConfigReader.load(XMLConfigReader.java:197)
         at org.vfny.geoserver.global.xml.XMLConfigReader.<init>(XMLConfigReader.java:155)
         at org.vfny.geoserver.global.Config.setApplicationContext(Config.java:69)
         at org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:84)
         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:248)
         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:362)
         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveConstructorArguments(AbstractAutowireCapableBeanFactory.java:713)
         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:611)
         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:329)
         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)
         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:318)
         at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
         at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:230)
         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:156)
         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
         at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:450)
         at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1129)
         at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:420)
         at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:457)
         at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:38)
         at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:156)
         at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:120)
         at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:38)
         at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:156)
         at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:38)
         at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:119)
         at org.mortbay.jetty.Server.doStart(Server.java:210)
         at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:38)
         at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:905)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:324)
         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.sql.SQLException: User not found: SA
         at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
         at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
         at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
         at org.hsqldb.jdbc.jdbcDataSource.getConnection(Unknown Source)
         at org.geotools.referencing.factory.epsg.HSQLDataSource.getConnection(HSQLDataSource.java:299)
         at org.geotools.referencing.factory.epsg.HSQLDataSource.createFactory(HSQLDataSource.java:391)
         at org.geotools.referencing.factory.epsg.DefaultFactory.createFactory(DefaultFactory.java:242)
         at org.geotools.referencing.factory.epsg.DefaultFactory.createFactory(DefaultFactory.java:296)
         at org.geotools.referencing.factory.epsg.DefaultFactory.createBackingStore(DefaultFactory.java:361)
         ... 70 more

At 08:46 AM 11/1/2007, Chris Holmes wrote:

What user are you running this as? Have you tried just downloading a binary install into a completely normal user account?

Kevin@anonymised.com wrote:

I posted a message several days ago about a "Translator Error" and never
really reached a resolution. I have moved backwards though and found that on
a completely virgin 1.5.4 installation I get the following message during
startup. This seems to be the crux of my problems. Does anyone know how this
works?
Thanks.
10486 [WARNING] DefaultFactory - Unavailable authority factory: European
Petroleum Survey Group
org.opengis.referencing.FactoryException: Failed to connect to the EPSG
database.

----
Kevin Johnson University of Texas, Institute for Geophysics
Senior Systems Analyst J.J. Pickle Research Campus, Bldg. 196 (ROC)
(512) 471-0410 10100 Burnet Rd. (R2200), Austin, TX 78758-4445
mailto:kevin@anonymised.com http://www.ig.utexas.edu