Hello,
I installed new version of Geonetwork 3.0.2 on Linux Oracle 6.5 x64
Geonetwork works ok with H2 database and sample data.
But when I tried to configure connection to Postgres or Oracle empty databases I've got error:
"HTTP ERROR: 503 Problem accessing /geonetwork/srv/pol/catalog.search Reason: Service Unavailable"
I' ve made changes in 2 files according to this page:
http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
So how can set a connection to empty databases and how can I create empty structure of tables in Postgres or Oracle ?
In older versions of Geonetwork there was file e.g.: create-db-postgres.sql by means of I can build all structure of tables in database.
In version 3.0.2 I can't find it. There is only file data-db-default.sql (and loc files) with inserts.
Regards,
Piotr
Hi
2015-09-11 15:04 GMT+02:00 Piotr Pachół <piotrpachol@anonymised.com>:
Hello,
I installed new version of Geonetwork 3.0.2 on Linux Oracle 6.5 x64
Geonetwork works ok with H2 database and sample data.
But when I tried to configure connection to Postgres or Oracle empty
databases I've got error:
"HTTP ERROR: 503 Problem accessing /geonetwork/srv/pol/catalog.search
Reason: Service Unavailable"
I' ve made changes in 2 files according to this page:
http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
So how can set a connection to empty databases and how can I create
empty structure of tables in Postgres or Oracle ?
In older versions of Geonetwork there was file e.g.:
create-db-postgres.sql by means of I can build all structure of tables
in database.
In version 3.0.2 I can't find it. There is only file data-db-default.sql
(and loc files) with inserts.
No SQL anymore for that "The database default structure will be created by
the application on startup."
See
http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
HTH.
Francois
Regards,
Piotr
------------------------------------------------------------------------------
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
Hello,
Thanks for answer. But I still have a problem with starting Geonetwork with Postgres/Postgis.
I attached log file. What can I do with this ?
Regards
/2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Raised exception during init
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Exception : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Message : Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,439 FATAL [jeeves.engine] - Stack : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:329)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at jeeves.config.springutil.JeevesContextLoaderListener.contextInitialized(JeevesContextLoaderListener.java:56)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:782)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:774)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1242)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:717)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:39)
at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:494)
at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:141)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:145)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:56)
at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:615)
at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:540)
at org.eclipse.jetty.util.Scanner.scan(Scanner.java:403)
at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:337)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:121)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:555)
at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:230)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.util.component.AggregateLifeCycle.doStart(AggregateLifeCycle.java:81)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:58)
at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:96)
at org.eclipse.jetty.server.Server.doStart(Server.java:282)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1274)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1197)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.eclipse.jetty.start.Main.invokeMain(Main.java:473)
at org.eclipse.jetty.start.Main.start(Main.java:615)
at org.eclipse.jetty.start.Main.main(Main.java:96)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
... 52 more
Caused by: javax.naming.NameNotFoundException; remaining name 'env'
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:449)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:551)
at org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:117)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178)
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95)
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:231)
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:217)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
... 59 more/
W dniu 2015-09-16 o 10:21, Francois Prunayre pisze:
Hi
2015-09-11 15:04 GMT+02:00 Piotr Pachół <piotrpachol@anonymised.com <mailto:piotrpachol@anonymised.com>>:
>
> Hello,
> I installed new version of Geonetwork 3.0.2 on Linux Oracle 6.5 x64
> Geonetwork works ok with H2 database and sample data.
> But when I tried to configure connection to Postgres or Oracle empty
> databases I've got error:
> "HTTP ERROR: 503 Problem accessing /geonetwork/srv/pol/catalog.search
> Reason: Service Unavailable"
>
> I' ve made changes in 2 files according to this page:
> http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
>
> So how can set a connection to empty databases and how can I create
> empty structure of tables in Postgres or Oracle ?
>
> In older versions of Geonetwork there was file e.g.:
> create-db-postgres.sql by means of I can build all structure of tables
> in database.
> In version 3.0.2 I can't find it. There is only file data-db-default.sql
> (and loc files) with inserts.
No SQL anymore for that "The database default structure will be created by the application on startup."
See http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
HTH.
Francois
>
> Regards,
> Piotr
>
> ------------------------------------------------------------------------------
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net <mailto:GeoNetwork-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Hello,
I made many attempts to configure Geonetwork 3.0.2 with Oracle or Postgres/Postgis databases. (System: Linux Oracle 6.5 x64)
Still without success. Geonetwork works only with H2 database.
Logs for Oracle and Postgres are similar - as in the previous email.
Could you suggest something ?
Regards,
Piotr
W dniu 2015-09-18 o 01:14, Piotr Pachół pisze:
Hello,
Thanks for answer. But I still have a problem with starting Geonetwork with Postgres/Postgis.
I attached log file. What can I do with this ?
Regards
/2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Raised exception during init
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Exception : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Message : Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,439 FATAL [jeeves.engine] - Stack : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:329)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at jeeves.config.springutil.JeevesContextLoaderListener.contextInitialized(JeevesContextLoaderListener.java:56)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:782)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:774)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1242)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:717)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:39)
at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:494)
at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:141)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:145)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:56)
at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:615)
at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:540)
at org.eclipse.jetty.util.Scanner.scan(Scanner.java:403)
at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:337)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:121)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:555)
at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:230)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.util.component.AggregateLifeCycle.doStart(AggregateLifeCycle.java:81)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:58)
at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:96)
at org.eclipse.jetty.server.Server.doStart(Server.java:282)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1274)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1197)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.eclipse.jetty.start.Main.invokeMain(Main.java:473)
at org.eclipse.jetty.start.Main.start(Main.java:615)
at org.eclipse.jetty.start.Main.main(Main.java:96)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]: Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'env'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
... 52 more
Caused by: javax.naming.NameNotFoundException; remaining name 'env'
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:449)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:551)
at org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:117)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178)
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95)
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:231)
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:217)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
... 59 more/
W dniu 2015-09-16 o 10:21, Francois Prunayre pisze:
Hi
2015-09-11 15:04 GMT+02:00 Piotr Pachół <piotrpachol@anonymised.com <mailto:piotrpachol@anonymised.com>>:
>
> Hello,
> I installed new version of Geonetwork 3.0.2 on Linux Oracle 6.5 x64
> Geonetwork works ok with H2 database and sample data.
> But when I tried to configure connection to Postgres or Oracle empty
> databases I've got error:
> "HTTP ERROR: 503 Problem accessing /geonetwork/srv/pol/catalog.search
> Reason: Service Unavailable"
>
> I' ve made changes in 2 files according to this page:
> http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
>
> So how can set a connection to empty databases and how can I create
> empty structure of tables in Postgres or Oracle ?
>
> In older versions of Geonetwork there was file e.g.:
> create-db-postgres.sql by means of I can build all structure of tables
> in database.
> In version 3.0.2 I can't find it. There is only file data-db-default.sql
> (and loc files) with inserts.
No SQL anymore for that "The database default structure will be created by the application on startup."
See http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-guide/installing/configuring-database.html
HTH.
Francois
>
> Regards,
> Piotr
>
> ------------------------------------------------------------------------------
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net <mailto:GeoNetwork-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Hi
I am struggling with exactly the same problem.
I think if anybody could help shed some light on this error, it might go a long way towards helping us with a solution ...
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/opt/apache-tomcat-8.0.22/webapps/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]: Initialization of bean failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'org.apache.naming.NamingContext' to required type 'javax.sql.DataSource' for property 'dataSource'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [org.apache.naming.NamingContext] to required type [javax.sql.DataSource] for property 'dataSource': no matching editors or conversion strategy found
Cheers
Erik
-----Original Message-----
From: Piotr Pachół [mailto:piotrpachol@anonymised.com]
Sent: 24 September 2015 10:53 AM
To: Francois Prunayre <fx.prunayre@anonymised.com>
Cc: geonetwork-users <geonetwork-users@lists.sourceforge.net>
Subject: Re: [GeoNetwork-users] creating empty structure in database
Hello,
I made many attempts to configure Geonetwork 3.0.2 with Oracle or Postgres/Postgis databases. (System: Linux Oracle 6.5 x64) Still without success. Geonetwork works only with H2 database.
Logs for Oracle and Postgres are similar - as in the previous email.
Could you suggest something ?
Regards,
Piotr
W dniu 2015-09-18 o 01:14, Piotr Pachół pisze:
Hello,
Thanks for answer. But I still have a problem with starting Geonetwork
with Postgres/Postgis.
I attached log file. What can I do with this ?
Regards
/2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Raised exception
during init
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Exception :
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'jdbcDataSource' defined in URL
[file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]:
Invocation of init method failed; nested exception is
javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,437 FATAL [jeeves.engine] - Message : Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'jdbcDataSource' defined in URL
[file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]:
Invocation of init method failed; nested exception is
javax.naming.NameNotFoundException; remaining name 'env'
2015-09-18 00:08:00,439 FATAL [jeeves.engine] - Stack :
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/usr/local/geonetwork/web/geonetwork/WEB-INF/lib/domain-3.0.2-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'jdbcDataSource' defined in URL
[file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]:
Invocation of init method failed; nested exception is
javax.naming.NameNotFoundException; remaining name 'env'
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:329)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at
jeeves.config.springutil.JeevesContextLoaderListener.contextInitialized(JeevesContextLoaderListener.java:56)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:782)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424)
at
org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:774)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1242)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:717)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at
org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:39)
at
org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
at
org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:494)
at
org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:141)
at
org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:145)
at
org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:56)
at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:615)
at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:540)
at org.eclipse.jetty.util.Scanner.scan(Scanner.java:403)
at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:337)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at
org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:121)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at
org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:555)
at
org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:230)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at
org.eclipse.jetty.util.component.AggregateLifeCycle.doStart(AggregateLifeCycle.java:81)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:58)
at
org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:96)
at org.eclipse.jetty.server.Server.doStart(Server.java:282)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at
org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1274)
at java.security.AccessController.doPrivileged(Native Method)
at
org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1197)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.eclipse.jetty.start.Main.invokeMain(Main.java:473)
at org.eclipse.jetty.start.Main.start(Main.java:615)
at org.eclipse.jetty.start.Main.main(Main.java:96)
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'jdbcDataSource' defined in URL
[file:/usr/local/geonetwork/web/geonetwork/WEB-INF/config-db/jndi-postgres-postgis.xml]:
Invocation of init method failed; nested exception is
javax.naming.NameNotFoundException; remaining name 'env'
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
... 52 more
Caused by: javax.naming.NameNotFoundException; remaining name 'env'
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:449)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:551)
at
org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:117)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at
org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178)
at
org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95)
at
org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
at
org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:231)
at
org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:217)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
... 59 more/
W dniu 2015-09-16 o 10:21, Francois Prunayre pisze:
Hi
2015-09-11 15:04 GMT+02:00 Piotr Pachół <piotrpachol@anonymised.com
<mailto:piotrpachol@anonymised.com>>:
>
> Hello,
> I installed new version of Geonetwork 3.0.2 on Linux Oracle 6.5 x64
> Geonetwork works ok with H2 database and sample data.
> But when I tried to configure connection to Postgres or Oracle
> empty databases I've got error:
> "HTTP ERROR: 503 Problem accessing
> /geonetwork/srv/pol/catalog.search
> Reason: Service Unavailable"
>
> I' ve made changes in 2 files according to this page:
>
http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-g
uide/installing/configuring-database.html
>
>
> So how can set a connection to empty databases and how can I create
> empty structure of tables in Postgres or Oracle ?
>
> In older versions of Geonetwork there was file e.g.:
> create-db-postgres.sql by means of I can build all structure of
> tables in database.
> In version 3.0.2 I can't find it. There is only file
data-db-default.sql
> (and loc files) with inserts.
No SQL anymore for that "The database default structure will be
created by the application on startup."
See
http://geonetwork-opensource.org/manuals/trunk/eng/users/maintainer-g
uide/installing/configuring-database.html
HTH.
Francois
>
>
> Regards,
> Piotr
>
>
---------------------------------------------------------------------
---------
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
<mailto:GeoNetwork-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork