GN 3.8 install

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

GN 3.8 install

hoddih
Hello
I´m trying to move my GN to a new server but I can´t install GN on the new
one.

Ubuntu 18.04
Java 1.8.0_201
Tomcat 9

It seems to be some H2 location permission conflict ( I guess).

The error code:

24-Feb-2020 13:35:48.336 INFO [main]
org.apache.catalina.core.ApplicationContext.log No Spring
WebApplicationInitializer types detected on classpath
2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)


Hope for help
Hóddi



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html


_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

Jo Cook
Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <[hidden email]> wrote:

>
> Hello
> I´m trying to move my GN to a new server but I can´t install GN on the new
> one.
>
> Ubuntu 18.04
> Java 1.8.0_201
> Tomcat 9
>
> It seems to be some H2 location permission conflict ( I guess).
>
> The error code:
>
> 24-Feb-2020 13:35:48.336 INFO [main]
> org.apache.catalina.core.ApplicationContext.log No Spring
> WebApplicationInitializer types detected on classpath
> 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener: Error
> creating bean with name 'entityManagerFactory' defined in URL
> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
> of class 'org.h2.Driver' for connect URL
> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'entityManagerFactory' defined in URL
> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
> of class 'org.h2.Driver' for connect URL
> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>
>
> Hope for help
> Hóddi
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork



--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
-- 
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK 

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/
twitter:@astuntech <https://twitter.com/astuntech>



iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal>





Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.


_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

Francois Prunayre
Hi, it should work with tomcat9 too but you may need to change H2 db
location to a writable space.
A good practice is to put the db in an external data dir by changing
jdbc.database properties.

Cheers.

Francois


Le lun. 24 févr. 2020 à 15:19, Jo Cook <[hidden email]> a
écrit :

> Hi,
>
> I think you need to use tomcat8. I can confirm I have it working with
> Ubuntu 18.04 that way.
>
> Jo
>
> On Mon, Feb 24, 2020 at 2:09 PM hoddih <[hidden email]> wrote:
> >
> > Hello
> > I´m trying to move my GN to a new server but I can´t install GN on the
> new
> > one.
> >
> > Ubuntu 18.04
> > Java 1.8.0_201
> > Tomcat 9
> >
> > It seems to be some H2 location permission conflict ( I guess).
> >
> > The error code:
> >
> > 24-Feb-2020 13:35:48.336 INFO [main]
> > org.apache.catalina.core.ApplicationContext.log No Spring
> > WebApplicationInitializer types detected on classpath
> > 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
> Error
> > creating bean with name 'entityManagerFactory' defined in URL
> >
> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> > Initialization of bean failed; nested exception is
> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
> driver
> > of class 'org.h2.Driver' for connect URL
> >
> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> > org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> > with name 'entityManagerFactory' defined in URL
> >
> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> > Initialization of bean failed; nested exception is
> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
> driver
> > of class 'org.h2.Driver' for connect URL
> >
> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> >         at
> >
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> >         at
> >
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> >         at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
> >         at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
> >         at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
> >         at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
> >
> >
> > Hope for help
> > Hóddi
> >
> >
> >
> > --
> > Sent from:
> http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
> >
> >
> > _______________________________________________
> > GeoNetwork-users mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> > GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>
>
>
> --
> Jo Cook
> t:+44 7930 524 155/twitter:@archaeogeek
> Please note that currently I do not work on Friday afternoons. For
> urgent responses at that time, please visit
> support.astuntechnology.com or phone our office on 01372 744009
>
> --
> --
> *Sign up to our mailing list
> <https://astuntechnology.com/company/#email-updates> for updates on news,
> products, conferences, events and training*
> *
> *
>
> Astun Technology Ltd,
> Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK
>
> t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
> twitter:@astuntech <https://twitter.com/astuntech>
>
>
>
> iShare - enterprise
> geographic intelligence platform <https://astuntechnology.com/ishare/>
>
> GeoServer, PostGIS and QGIS training
> <https://astuntechnology.com/training-courses/>
> Helpdesk and customer
> portal
> <
> https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
> >
>
>
>
>
>
> Company registration no. 5410695. Registered in England and Wales.
> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
> 864201149.
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

hoddih
Thanks
How do I change the location in the file?

I have:
jdbc.username=www-data
jdbc.password=www-data
jdbc.database=gn

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
[hidden email]
+354 462 3357



On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <[hidden email]>
wrote:

> Hi, it should work with tomcat9 too but you may need to change H2 db
> location to a writable space.
> A good practice is to put the db in an external data dir by changing
> jdbc.database properties.
>
> Cheers.
>
> Francois
>
>
> Le lun. 24 févr. 2020 à 15:19, Jo Cook <[hidden email]> a
> écrit :
>
>> Hi,
>>
>> I think you need to use tomcat8. I can confirm I have it working with
>> Ubuntu 18.04 that way.
>>
>> Jo
>>
>> On Mon, Feb 24, 2020 at 2:09 PM hoddih <[hidden email]> wrote:
>> >
>> > Hello
>> > I´m trying to move my GN to a new server but I can´t install GN on the
>> new
>> > one.
>> >
>> > Ubuntu 18.04
>> > Java 1.8.0_201
>> > Tomcat 9
>> >
>> > It seems to be some H2 location permission conflict ( I guess).
>> >
>> > The error code:
>> >
>> > 24-Feb-2020 13:35:48.336 INFO [main]
>> > org.apache.catalina.core.ApplicationContext.log No Spring
>> > WebApplicationInitializer types detected on classpath
>> > 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
>> Error
>> > creating bean with name 'entityManagerFactory' defined in URL
>> >
>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>> > Initialization of bean failed; nested exception is
>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>> driver
>> > of class 'org.h2.Driver' for connect URL
>> >
>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>> > org.springframework.beans.factory.BeanCreationException: Error creating
>> bean
>> > with name 'entityManagerFactory' defined in URL
>> >
>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>> > Initialization of bean failed; nested exception is
>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>> driver
>> > of class 'org.h2.Driver' for connect URL
>> >
>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>> >         at
>> >
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>> >         at
>> >
>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>> >         at
>> >
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
>> >         at
>> >
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
>> >         at
>> >
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
>> >         at
>> >
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>> >
>> >
>> > Hope for help
>> > Hóddi
>> >
>> >
>> >
>> > --
>> > Sent from:
>> http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>> >
>> >
>> > _______________________________________________
>> > GeoNetwork-users mailing list
>> > [hidden email]
>> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> > GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>>
>>
>> --
>> Jo Cook
>> t:+44 7930 524 155/twitter:@archaeogeek
>> Please note that currently I do not work on Friday afternoons. For
>> urgent responses at that time, please visit
>> support.astuntechnology.com or phone our office on 01372 744009
>>
>> --
>> --
>> *Sign up to our mailing list
>> <https://astuntechnology.com/company/#email-updates> for updates on
>> news,
>> products, conferences, events and training*
>> *
>> *
>>
>> Astun Technology Ltd,
>> Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK
>>
>> t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
>> twitter:@astuntech <https://twitter.com/astuntech>
>>
>>
>>
>> iShare - enterprise
>> geographic intelligence platform <https://astuntechnology.com/ishare/>
>>
>> GeoServer, PostGIS and QGIS training
>> <https://astuntechnology.com/training-courses/>
>> Helpdesk and customer
>> portal
>> <
>> https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>> >
>>
>>
>>
>>
>>
>> Company registration no. 5410695. Registered in England and Wales.
>> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
>> 864201149.
>>
>>
>> _______________________________________________
>> GeoNetwork-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

Francois Prunayre
See http://www.h2database.com/html/tutorial.html
jdbc:h2:~/test
to put it in your user folder.

Francois

Le lun. 24 févr. 2020 à 16:12, Hólmgrímur Helgason <[hidden email]> a écrit :

> Thanks
> How do I change the location in the file?
>
> I have:
> jdbc.username=www-data
> jdbc.password=www-data
> jdbc.database=gn
>
> Hólmgrímur Helgason (Hóddi)
> CAFF - Data Manager
> [hidden email]
> +354 462 3357
>
>
>
> On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <[hidden email]>
> wrote:
>
>> Hi, it should work with tomcat9 too but you may need to change H2 db
>> location to a writable space.
>> A good practice is to put the db in an external data dir by changing
>> jdbc.database properties.
>>
>> Cheers.
>>
>> Francois
>>
>>
>> Le lun. 24 févr. 2020 à 15:19, Jo Cook <[hidden email]> a
>> écrit :
>>
>>> Hi,
>>>
>>> I think you need to use tomcat8. I can confirm I have it working with
>>> Ubuntu 18.04 that way.
>>>
>>> Jo
>>>
>>> On Mon, Feb 24, 2020 at 2:09 PM hoddih <[hidden email]> wrote:
>>> >
>>> > Hello
>>> > I´m trying to move my GN to a new server but I can´t install GN on the
>>> new
>>> > one.
>>> >
>>> > Ubuntu 18.04
>>> > Java 1.8.0_201
>>> > Tomcat 9
>>> >
>>> > It seems to be some H2 location permission conflict ( I guess).
>>> >
>>> > The error code:
>>> >
>>> > 24-Feb-2020 13:35:48.336 INFO [main]
>>> > org.apache.catalina.core.ApplicationContext.log No Spring
>>> > WebApplicationInitializer types detected on classpath
>>> > 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
>>> Error
>>> > creating bean with name 'entityManagerFactory' defined in URL
>>> >
>>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>>> > Initialization of bean failed; nested exception is
>>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>>> driver
>>> > of class 'org.h2.Driver' for connect URL
>>> >
>>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>>> > org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean
>>> > with name 'entityManagerFactory' defined in URL
>>> >
>>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>>> > Initialization of bean failed; nested exception is
>>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>>> driver
>>> > of class 'org.h2.Driver' for connect URL
>>> >
>>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
>>> >         at
>>> >
>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>>> >
>>> >
>>> > Hope for help
>>> > Hóddi
>>> >
>>> >
>>> >
>>> > --
>>> > Sent from:
>>> http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>>> >
>>> >
>>> > _______________________________________________
>>> > GeoNetwork-users mailing list
>>> > [hidden email]
>>> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>>> > GeoNetwork OpenSource is maintained at
>>> http://sourceforge.net/projects/geonetwork
>>>
>>>
>>>
>>> --
>>> Jo Cook
>>> t:+44 7930 524 155/twitter:@archaeogeek
>>> Please note that currently I do not work on Friday afternoons. For
>>> urgent responses at that time, please visit
>>> support.astuntechnology.com or phone our office on 01372 744009
>>>
>>> --
>>> --
>>> *Sign up to our mailing list
>>> <https://astuntechnology.com/company/#email-updates> for updates on
>>> news,
>>> products, conferences, events and training*
>>> *
>>> *
>>>
>>> Astun Technology Ltd,
>>> Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK
>>>
>>> t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
>>> twitter:@astuntech <https://twitter.com/astuntech>
>>>
>>>
>>>
>>> iShare - enterprise
>>> geographic intelligence platform <https://astuntechnology.com/ishare/>
>>>
>>> GeoServer, PostGIS and QGIS training
>>> <https://astuntechnology.com/training-courses/>
>>> Helpdesk and customer
>>> portal
>>> <
>>> https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>>> >
>>>
>>>
>>>
>>>
>>>
>>> Company registration no. 5410695. Registered in England and Wales.
>>> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
>>> 864201149.
>>>
>>>
>>> _______________________________________________
>>> GeoNetwork-users mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>>> GeoNetwork OpenSource is maintained at
>>> http://sourceforge.net/projects/geonetwork
>>>
>>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

hoddih
OK
It's in the h2.xml file:
<bean id="jdbcURL" class="java.lang.String">
    <constructor-arg
       value="jdbc:h2:/path/to/database/

Thanks.

It works,  but still error.
The database is created but GN will not start. Maybe Tomacat vs Apache2
conflict?
2020-02-24 15:49:57,076 ERROR [jeeves] - JeevesContextLoaderListener: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create
PoolableConnectionFactory (Syntax error in SQL statement "SELECT1";
expected "SELECT, SET, SAVEPOINT, SCRIPT, SHUTDOWN, SHOW, {"; SQL statement:
SELECT1 [42001-174])
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create
PoolableConnectionFactory (Syntax error in SQL statement "SELECT1";
expected "SELECT, SET, SAVEPOINT, SCRIPT, SHUTDOWN, SHOW, {"; SQL statement:
SELECT1 [42001-174])
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)

Hóddi

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
[hidden email]
+354 462 3357



On Mon, 24 Feb 2020 at 15:28, Francois Prunayre <[hidden email]>
wrote:

> See http://www.h2database.com/html/tutorial.html
> jdbc:h2:~/test
> to put it in your user folder.
>
> Francois
>
> Le lun. 24 févr. 2020 à 16:12, Hólmgrímur Helgason <[hidden email]> a
> écrit :
>
>> Thanks
>> How do I change the location in the file?
>>
>> I have:
>> jdbc.username=www-data
>> jdbc.password=www-data
>> jdbc.database=gn
>>
>> Hólmgrímur Helgason (Hóddi)
>> CAFF - Data Manager
>> [hidden email]
>> +354 462 3357
>>
>>
>>
>> On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <[hidden email]>
>> wrote:
>>
>>> Hi, it should work with tomcat9 too but you may need to change H2 db
>>> location to a writable space.
>>> A good practice is to put the db in an external data dir by changing
>>> jdbc.database properties.
>>>
>>> Cheers.
>>>
>>> Francois
>>>
>>>
>>> Le lun. 24 févr. 2020 à 15:19, Jo Cook <[hidden email]> a
>>> écrit :
>>>
>>>> Hi,
>>>>
>>>> I think you need to use tomcat8. I can confirm I have it working with
>>>> Ubuntu 18.04 that way.
>>>>
>>>> Jo
>>>>
>>>> On Mon, Feb 24, 2020 at 2:09 PM hoddih <[hidden email]> wrote:
>>>> >
>>>> > Hello
>>>> > I´m trying to move my GN to a new server but I can´t install GN on
>>>> the new
>>>> > one.
>>>> >
>>>> > Ubuntu 18.04
>>>> > Java 1.8.0_201
>>>> > Tomcat 9
>>>> >
>>>> > It seems to be some H2 location permission conflict ( I guess).
>>>> >
>>>> > The error code:
>>>> >
>>>> > 24-Feb-2020 13:35:48.336 INFO [main]
>>>> > org.apache.catalina.core.ApplicationContext.log No Spring
>>>> > WebApplicationInitializer types detected on classpath
>>>> > 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
>>>> Error
>>>> > creating bean with name 'entityManagerFactory' defined in URL
>>>> >
>>>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>>>> > Initialization of bean failed; nested exception is
>>>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>>>> driver
>>>> > of class 'org.h2.Driver' for connect URL
>>>> >
>>>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>>>> > org.springframework.beans.factory.BeanCreationException: Error
>>>> creating bean
>>>> > with name 'entityManagerFactory' defined in URL
>>>> >
>>>> [jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-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:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
>>>> > Initialization of bean failed; nested exception is
>>>> > java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
>>>> driver
>>>> > of class 'org.h2.Driver' for connect URL
>>>> >
>>>> '/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
>>>> >         at
>>>> >
>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>>>> >
>>>> >
>>>> > Hope for help
>>>> > Hóddi
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > Sent from:
>>>> http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>>>> >
>>>> >
>>>> > _______________________________________________
>>>> > GeoNetwork-users mailing list
>>>> > [hidden email]
>>>> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>>>> > GeoNetwork OpenSource is maintained at
>>>> http://sourceforge.net/projects/geonetwork
>>>>
>>>>
>>>>
>>>> --
>>>> Jo Cook
>>>> t:+44 7930 524 155/twitter:@archaeogeek
>>>> Please note that currently I do not work on Friday afternoons. For
>>>> urgent responses at that time, please visit
>>>> support.astuntechnology.com or phone our office on 01372 744009
>>>>
>>>> --
>>>> --
>>>> *Sign up to our mailing list
>>>> <https://astuntechnology.com/company/#email-updates> for updates on
>>>> news,
>>>> products, conferences, events and training*
>>>> *
>>>> *
>>>>
>>>> Astun Technology Ltd,
>>>> Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK
>>>>
>>>> t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/
>>>> >
>>>> twitter:@astuntech <https://twitter.com/astuntech>
>>>>
>>>>
>>>>
>>>> iShare - enterprise
>>>> geographic intelligence platform <https://astuntechnology.com/ishare/>
>>>>
>>>> GeoServer, PostGIS and QGIS training
>>>> <https://astuntechnology.com/training-courses/>
>>>> Helpdesk and customer
>>>> portal
>>>> <
>>>> https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>>>> >
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Company registration no. 5410695. Registered in England and Wales.
>>>> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT
>>>> no.
>>>> 864201149.
>>>>
>>>>
>>>> _______________________________________________
>>>> GeoNetwork-users mailing list
>>>> [hidden email]
>>>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>>>> GeoNetwork OpenSource is maintained at
>>>> http://sourceforge.net/projects/geonetwork
>>>>
>>>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN 3.8 install

hoddih
In reply to this post by Jo Cook
Hi Jo

I switched to tomcat 8.5 and everything works great then. It seems to be
some "bugs" with GN on Tomcat 9!  
Thanks Jo for your advice.

And thanks to you to Francois, for helping with H2 db location issue.

You are great.
Hóddi





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html


_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork