[GeoNetwork-devel] : Connect Geonetwork 3.0 to external DB (Postgres+postgis)

Dear geonetwork developers,

Let me first thank you for a great job, you’ve done in geonetwork project within last decade. I’ve been using the GeoNetwork application within my research works since my master thesis in 2007.

I have recently deployed the last version of GNK and found changes in the external DB configuration. Firstly, I could not find SQL script which creates the GN database, and then I could not understand how to configure the JNDI connection.
I tried to search in the documentation, but could not find any hints.

Could you guide me how to do it?
Many thanks,
Tomas

···

[

Tomas Kliment on about.me

Ing. Tomas Kliment, PhD.
about.me/klimeto

](http://about.me/klimeto)

http://osgeo-org.1560.x6.nabble.com/create-scripts-in-3-0-td5205280.html

may help.

Francois

···

2015-05-20 11:05 GMT+02:00 Tomas Kliment <tomas.kliment@anonymised.com>:

Dear geonetwork developers,

Let me first thank you for a great job, you’ve done in geonetwork project within last decade. I’ve been using the GeoNetwork application within my research works since my master thesis in 2007.

I have recently deployed the last version of GNK and found changes in the external DB configuration. Firstly, I could not find SQL script which creates the GN database, and then I could not understand how to configure the JNDI connection.
I tried to search in the documentation, but could not find any hints.

Could you guide me how to do it?
Many thanks,
Tomas


[

Tomas Kliment on about.me

Ing. Tomas Kliment, PhD.
about.me/klimeto

](http://about.me/klimeto)

One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y


GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

On Wed, May 20, 2015 at 11:05 AM, Tomas Kliment <tomas.kliment@anonymised.com>
wrote:

Dear geonetwork developers,

Let me first thank you for a great job, you've done in geonetwork project
within last decade. I've been using the GeoNetwork application within my
research works since my master thesis in 2007.

I have recently deployed the last version of GNK and found changes in the
external DB configuration. Firstly, I could not find SQL script which
creates the GN database, and then I could not understand how to configure
the JNDI connection.
I tried to search in the documentation, but could not find any hints.

Could you guide me how to do it?
Many thanks,
Tomas
--

Hi Tomas,

Take a look here:
https://github.com/geonetwork/core-geonetwork/tree/develop/web/src/main/webapp/WEB-INF/config-db

I think you need to modify this files:
https://github.com/geonetwork/core-geonetwork/blob/develop/web/src/main/webapp/WEB-INF/config-db/jdbc.properties
https://github.com/geonetwork/core-geonetwork/blob/develop/web/src/main/webapp/WEB-INF/config-node/srv.xml

Now we have multinode, and each node has its own database configuration.
The default usecase is a GeoNetwork with only one node called "srv".

But you are right, we should update the configuration and make this more
explicit.

Regards,
María.

Hi guys,

Thanks for prompt answers, however I also managed only direct JDBC to postgres and failed to connect via JNDI.

Maria, did you manage JNDI within your multinode instance configuration?

In addition, I’d ask another question related to previous 2.8 which I use to run several instance where I collect metadata from OGC service I meta search from Google SE.
For the catalogues managing records up to 100k they work fine, however for my CSW Catalogue I have collected more than half million of metadata records and after certain period neither GUI nor CSW interface shows any record. Is this related to some lucene issue, or Tomcat memory configurations? In other words, does GN have problems to handle such a number of MD records? Here I use JNDI connection to Postgres/Postgis.

Thank you again,
Tomas

···

On 20 May 2015 at 11:17, María Arias de Reyna <delawen@anonymised.com> wrote:

On Wed, May 20, 2015 at 11:05 AM, Tomas Kliment <tomas.kliment@anonymised.com> wrote:

Dear geonetwork developers,

Let me first thank you for a great job, you’ve done in geonetwork project within last decade. I’ve been using the GeoNetwork application within my research works since my master thesis in 2007.

I have recently deployed the last version of GNK and found changes in the external DB configuration. Firstly, I could not find SQL script which creates the GN database, and then I could not understand how to configure the JNDI connection.
I tried to search in the documentation, but could not find any hints.

Could you guide me how to do it?
Many thanks,
Tomas

Hi Tomas,

Take a look here: https://github.com/geonetwork/core-geonetwork/tree/develop/web/src/main/webapp/WEB-INF/config-db

I think you need to modify this files:
https://github.com/geonetwork/core-geonetwork/blob/develop/web/src/main/webapp/WEB-INF/config-db/jdbc.properties
https://github.com/geonetwork/core-geonetwork/blob/develop/web/src/main/webapp/WEB-INF/config-node/srv.xml

Now we have multinode, and each node has its own database configuration. The default usecase is a GeoNetwork with only one node called “srv”.

But you are right, we should update the configuration and make this more explicit.

Regards,
María.


[

Tomas Kliment on about.me

Ing. Tomas Kliment, PhD.
about.me/klimeto

](http://about.me/klimeto)