[GeoNetwork-users] GN 3.2.0 Database schema - Oracle

hello list,

i'm trying to setup a new instance of GeoNetwork 3.2.0 (Linux RedHat, TomCat 7, Oracle 11.2) and ran into two problems :

a)
When I connect to a new, empty database scheme the database objects are not created & filled correctly :
There are, at least, tables & a sequence created but they are empty.

When I try to fill the tables with the sql-statement under \web\geonetwork\WEB-INF\classes\setup\sql\data (i even added the commit; statement :slight_smile: ) the application comes up with an error :

Is there a SQL-Script that creates and fills the required database objects correctly ??

b)
to check that the installation itself is working i connect to an database schema that holds an older version of gn (3.0.2 i.e.).
this will work at the first glimpse, i am able to import a MEF File an see the data.

When i try to delete a metadata item nothing happens but in geonetwork.log I get the following messages :

2017-02-02 14:18:52,591 WARN [org.springframework.context.support.ResourceBundleMessageSource] - ResourceBundle [messages] not found for MessageSource: Can't find bundle for base name messages, locale de

2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/host but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/port but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/username but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/password but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/ignorehostlist but null value found. Check the settings table.

b.1 : How can i solve the ResourceBundleMessageSource - thing ?
b.2 : How can a proxy be involved in deleting a record in my database ?

thanks in advance ,

cheers
Christian

Hi

Oracle doesn't really work with Geonetwork 3.2.x, see related issue:
https://github.com/geonetwork/core-geonetwork/issues/1720

The problem is that the fix breaks also other features. Will re-check with
Emmanuel Tajariol to verify if any progress on it.

Regards,
Jose García

On Thu, Feb 2, 2017 at 2:41 PM, Schigl Christian <
christian.schigl@anonymised.com> wrote:

hello list,

i'm trying to setup a new instance of GeoNetwork 3.2.0 (Linux RedHat,
TomCat 7, Oracle 11.2) and ran into two problems :

a)
When I connect to a new, empty database scheme the database objects are
not created & filled correctly :
There are, at least, tables & a sequence created but they are empty.

When I try to fill the tables with the sql-statement under
\web\geonetwork\WEB-INF\classes\setup\sql\data (i even added the commit;
statement :slight_smile: ) the application comes up with an error :

Is there a SQL-Script that creates and fills the required database objects
correctly ??

b)
to check that the installation itself is working i connect to an database
schema that holds an older version of gn (3.0.2 i.e.).
this will work at the first glimpse, i am able to import a MEF File an see
the data.

When i try to delete a metadata item nothing happens but in geonetwork.log
I get the following messages :

2017-02-02 14:18:52,591 WARN [org.springframework.context.support.ResourceBundleMessageSource]
- ResourceBundle [messages] not found for MessageSource: Can't find bundle
for base name messages, locale de

2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting
with name: system/proxy/host but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting
with name: system/proxy/port but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting
with name: system/proxy/username but null value found. Check the settings
table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting
with name: system/proxy/password but null value found. Check the settings
table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting
with name: system/proxy/ignorehostlist but null value found. Check the
settings table.

b.1 : How can i solve the ResourceBundleMessageSource - thing ?
b.2 : How can a proxy be involved in deleting a record in my database ?

thanks in advance ,

cheers
Christian

------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
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

--

*Vriendelijke groeten / Kind regards,Jose García
<http://www.geocat.net/&gt;Veenderweg 136721 WD BennekomThe NetherlandsT: +31
(0)318 416664 <+31318416664> <https://www.facebook.com/geocatbv&gt;
<https://twitter.com/geocat_bv&gt;
<https://plus.google.com/u/1/+GeocatNetbv/posts&gt;Please consider the
environment before printing this email.*

Thanks, Jose,

so it looks like i have to give PostgreSQL a try...
Any news on the Oracle-issue will be welcome !

Cheers,
Christian

Von: Jose Garcia *EXTERN* [mailto:jose.garcia@…444…]
Gesendet: Donnerstag, 02. Februar 2017 16:23
An: Schigl Christian
Cc: geonetwork-users@lists.sourceforge.net
Betreff: Re: [GeoNetwork-users] GN 3.2.0 Database schema - Oracle

Hi

Oracle doesn't really work with Geonetwork 3.2.x, see related issue: https://github.com/geonetwork/core-geonetwork/issues/1720

The problem is that the fix breaks also other features. Will re-check with Emmanuel Tajariol to verify if any progress on it.

Regards,
Jose García

On Thu, Feb 2, 2017 at 2:41 PM, Schigl Christian <christian.schigl@...1097...<mailto:christian.schigl@…1097…>> wrote:
hello list,

i'm trying to setup a new instance of GeoNetwork 3.2.0 (Linux RedHat, TomCat 7, Oracle 11.2) and ran into two problems :

a)
When I connect to a new, empty database scheme the database objects are not created & filled correctly :
There are, at least, tables & a sequence created but they are empty.

When I try to fill the tables with the sql-statement under \web\geonetwork\WEB-INF\classes\setup\sql\data (i even added the commit; statement :slight_smile: ) the application comes up with an error :

Is there a SQL-Script that creates and fills the required database objects correctly ??

b)
to check that the installation itself is working i connect to an database schema that holds an older version of gn (3.0.2 i.e.).
this will work at the first glimpse, i am able to import a MEF File an see the data.

When i try to delete a metadata item nothing happens but in geonetwork.log I get the following messages :

2017-02-02 14:18:52,591 WARN [org.springframework.context.support.ResourceBundleMessageSource] - ResourceBundle [messages] not found for MessageSource: Can't find bundle for base name messages, locale de

2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/host but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/port but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/username but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/password but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/ignorehostlist but null value found. Check the settings table.

b.1 : How can i solve the ResourceBundleMessageSource - thing ?
b.2 : How can a proxy be involved in deleting a record in my database ?

thanks in advance ,

cheers
Christian

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
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

--
Vriendelijke groeten / Kind regards,

Jose García

[https://www.geocat.net/wp-content/uploads/2015/07/GeoCat_small1.png\]<http://www.geocat.net/&gt;
Veenderweg 13
6721 WD Bennekom
The Netherlands
T: +31 (0)318 416664<tel:+31318416664>

[https://www.geocat.net/wp-content/uploads/2015/07/facebook_24.png\]<https://www.facebook.com/geocatbv&gt; [https://www.geocat.net/wp-content/uploads/2015/07/Twitter_icon.png\] <https://twitter.com/geocat_bv&gt; [https://www.geocat.net/wp-content/uploads/2015/07/Google-plus-icon.png\] <https://plus.google.com/u/1/+GeocatNetbv/posts&gt;

Please consider the environment before printing this email.