[GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hello list,

Any ideas ?

Maybe I am posting on the wrong list (developer instead ?) ?

I changed the version with 2.8 RC 2 but still got the same problem with lucene not working and metadatas/templates being throwing errors:
"The metadata document index with id=7 is corrupt/invalid - ignoring it. Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to org.geotools.data.FeatureStore"

Thanks,
Sylvie

On 11/09/2012 06:16 PM, Sylvie Fiat wrote:

Hi,

I just installed last version of GeoNetwork 2.8 on Linux with tomcat
using postgres/postgis with JNDI configuration, using
geonetwork-branch28-2012-11-07.war
<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;\.

I tried to add templates iso19139 using Administration page and after
confirmation tried to add New metadata but I get "No templates
available, import metadata first.".

I also tried to import a metadata file in iso19139 which worked well as
I could edit and view it (even passed to status Approved) but cannot get
it when searching My metadata (or normal search) I can only find it when
"searching for unused".

In the metadata table in postgres I have the records there including the
templates and the metadata file.

When starting tomcat, I have :
"Failure to make _writer, maybe a problem but might also not be an
issue:<error id="error">
<message>org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore</message>
    <class>ClassCastException</class>"
and then
"2012-11-09 15:12:32,714 ERROR [geonetwork.spatial] - Unable to call
reset on Spatial writer: null
2012-11-09 15:12:32,722 ERROR [geonetwork.index] - Rebuilding lucene index"

Then every metadata is ignored with error:
"The metadata document index with id=4 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Finally when I try to rebuild index I have a popup saying "Index
operation already in progress please wait".

I checked database configuration many times and have look through all
the forum and mailing list I could but I can't figure out what is going
wrong.

The spatialindex table is empty in postgres, but I am not sure if it
could be the issue as templates might not use it maybe my metadata file ?

What I am missing ?

I can provide the log file if needed.

Thanks in advance,

Sylvie

<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Sylvie,

Not sure what is going on but to check the config steps I set it up using the latest 2.8.x build:

- place postgresql and postgis jdbc driver jars in your tomcat lib dir (tomcat6)
- place commons-dbcp-1.3.jar and commons-pool-1.5.5.jar in your tomcat lib dir (tomcat6 again)
- configure your tomcat/conf/context.xml something like the following:

<Resource name="jdbc/geonetwork"
              auth="Container"
              type="javax.sql.DataSource"
              username="dbusername"
              password="dbpassword"
              driverClassName="org.postgis.DriverWrapper"
              factory="org.apache.commons.dbcp.BasicDataSourceFactory"
              url="jdbc:postgresql_postGIS://localhost:5432/gndb4"
              maxActive="10"
              maxIdle="10"
              removeAbandoned="true"
              removeAbandonedTimeout="3600"
              logAbandoned="true"
              testOnBorrow="true"
              defaultAutoCommit="false"
              defaultTransactionIsolation="READ_COMMITTED"
              accessToUnderlyingConnectionAllowed="true"
              validationQuery="select 1"/>

- then in webapps/geonetwork/WEB-INF/config.xml you should have:

<resource enabled="true">
      <name>main-db</name>
      <provider>jeeves.resources.dbms.JNDIPool</provider>
      <config>
        <context>java:/comp/env</context>
        <resourceName>jdbc/geonetwork</resourceName>
        <url>jdbc:postgresql_postGIS://localhost:5432/gndb</url>
        <!-- if the database has a spatialindex table with fid, id and
            multipolygon geometry fields (eg. see postgis) then specify true
            here and GeoNetwork will use the database for its spatial index
            otherwise specify false or leave the parameter out and a
            shapefile will be used for the spatial index -->
        <provideDataStore>true</provideDataStore>
        <!-- set this value to -1 if you don't want prepared statements to
        be cached when querying/maintaining the spatial index
        (note this is only applicable when
        provideDataStore is set to true) -->
        <maxOpenPreparedStatements>300</maxOpenPreparedStatements>
        <!-- NOTE any other parameter specified here is ignored as this
        should be handled in the container -->
      </config>
    </resource>

In your logs/catalina.log file you should see things like:

2012-11-24 11:02:26,922 INFO [jeeves.apphand] - - Database connection on jdbc:postgresql_postGIS://localhost:5432/gndb4 ...
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - jdbc:postgresql_postGIS://localhost:5432/gndb4 is an empty database (Metadata table not found).
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - - SQL create file:/usr/local/jakarta/tomcat-geonetwork/webapps/geonetwork/WEB-INF/classes/setup/sql/create prefix:create-db- ...
....

indicating a successful connection to the database and creation of tables needed by GeoNetwork.

These steps should be described in the documentation at http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container but maybe there are things that are not clear (it does use an oracle example. maybe it should have a postgis example too?) so if we can sort this out perhaps we can include steps in there to make sure this doesn't occur for others.

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Thursday, 22 November 2012 10:55 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hello list,

Any ideas ?

Maybe I am posting on the wrong list (developer instead ?) ?

I changed the version with 2.8 RC 2 but still got the same problem with
lucene not working and metadatas/templates being throwing errors:
"The metadata document index with id=7 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Thanks,
Sylvie

On 11/09/2012 06:16 PM, Sylvie Fiat wrote:

Hi,

I just installed last version of GeoNetwork 2.8 on Linux with tomcat
using postgres/postgis with JNDI configuration, using
geonetwork-branch28-2012-11-07.war
<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;\.

I tried to add templates iso19139 using Administration page and after
confirmation tried to add New metadata but I get "No templates
available, import metadata first.".

I also tried to import a metadata file in iso19139 which worked well as
I could edit and view it (even passed to status Approved) but cannot get
it when searching My metadata (or normal search) I can only find it when
"searching for unused".

In the metadata table in postgres I have the records there including the
templates and the metadata file.

When starting tomcat, I have :
"Failure to make _writer, maybe a problem but might also not be an
issue:<error id="error">
<message>org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore</message>
    <class>ClassCastException</class>"
and then
"2012-11-09 15:12:32,714 ERROR [geonetwork.spatial] - Unable to call
reset on Spatial writer: null
2012-11-09 15:12:32,722 ERROR [geonetwork.index] - Rebuilding lucene index"

Then every metadata is ignored with error:
"The metadata document index with id=4 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Finally when I try to rebuild index I have a popup saying "Index
operation already in progress please wait".

I checked database configuration many times and have look through all
the forum and mailing list I could but I can't figure out what is going
wrong.

The spatialindex table is empty in postgres, but I am not sure if it
could be the issue as templates might not use it maybe my metadata file ?

What I am missing ?

I can provide the log file if needed.

Thanks in advance,

Sylvie

<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Dear Simon,

Thank you for your help, I was missing postgis jar in tomcat lib (this might be the missing part in the doc), now geonetwork seems to be using postgis (log file indicating so) but I still have the error:

"The metadata document index with id=7 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

I tried to recreate databasewithout effect, first metadata created is throwing this error and then I have "Timer is already cancelled".

Maybe am I missing lucene librairies somewhere ?

Cheers,

Sylvie

On 11/24/2012 11:14 AM, Simon.Pigot@anonymised.com wrote:

Hi Sylvie,

Not sure what is going on but to check the config steps I set it up using the latest 2.8.x build:

- place postgresql and postgis jdbc driver jars in your tomcat lib dir (tomcat6)
- place commons-dbcp-1.3.jar and commons-pool-1.5.5.jar in your tomcat lib dir (tomcat6 again)
- configure your tomcat/conf/context.xml something like the following:

<Resource name="jdbc/geonetwork"
               auth="Container"
               type="javax.sql.DataSource"
               username="dbusername"
               password="dbpassword"
               driverClassName="org.postgis.DriverWrapper"
               factory="org.apache.commons.dbcp.BasicDataSourceFactory"
               url="jdbc:postgresql_postGIS://localhost:5432/gndb4"
               maxActive="10"
               maxIdle="10"
               removeAbandoned="true"
               removeAbandonedTimeout="3600"
               logAbandoned="true"
               testOnBorrow="true"
               defaultAutoCommit="false"
               defaultTransactionIsolation="READ_COMMITTED"
               accessToUnderlyingConnectionAllowed="true"
               validationQuery="select 1"/>

- then in webapps/geonetwork/WEB-INF/config.xml you should have:

<resource enabled="true">
       <name>main-db</name>
       <provider>jeeves.resources.dbms.JNDIPool</provider>
       <config>
         <context>java:/comp/env</context>
         <resourceName>jdbc/geonetwork</resourceName>
         <url>jdbc:postgresql_postGIS://localhost:5432/gndb</url>
         <!-- if the database has a spatialindex table with fid, id and
             multipolygon geometry fields (eg. see postgis) then specify true
             here and GeoNetwork will use the database for its spatial index
             otherwise specify false or leave the parameter out and a
             shapefile will be used for the spatial index -->
         <provideDataStore>true</provideDataStore>
         <!-- set this value to -1 if you don't want prepared statements to
         be cached when querying/maintaining the spatial index
         (note this is only applicable when
         provideDataStore is set to true) -->
         <maxOpenPreparedStatements>300</maxOpenPreparedStatements>
         <!-- NOTE any other parameter specified here is ignored as this
         should be handled in the container -->
       </config>
     </resource>

In your logs/catalina.log file you should see things like:

2012-11-24 11:02:26,922 INFO [jeeves.apphand] - - Database connection on jdbc:postgresql_postGIS://localhost:5432/gndb4 ...
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - jdbc:postgresql_postGIS://localhost:5432/gndb4 is an empty database (Metadata table not found).
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - - SQL create file:/usr/local/jakarta/tomcat-geonetwork/webapps/geonetwork/WEB-INF/classes/setup/sql/create prefix:create-db- ...
....

indicating a successful connection to the database and creation of tables needed by GeoNetwork.

These steps should be described in the documentation at http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container but maybe there are things that are not clear (it does use an oracle example. maybe it should have a postgis example too?) so if we can sort this out perhaps we can include steps in there to make sure this doesn't occur for others.

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Thursday, 22 November 2012 10:55 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hello list,

Any ideas ?

Maybe I am posting on the wrong list (developer instead ?) ?

I changed the version with 2.8 RC 2 but still got the same problem with
lucene not working and metadatas/templates being throwing errors:
"The metadata document index with id=7 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Thanks,
Sylvie

On 11/09/2012 06:16 PM, Sylvie Fiat wrote:

Hi,

I just installed last version of GeoNetwork 2.8 on Linux with tomcat
using postgres/postgis with JNDI configuration, using
geonetwork-branch28-2012-11-07.war
<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;\.

I tried to add templates iso19139 using Administration page and after
confirmation tried to add New metadata but I get "No templates
available, import metadata first.".

I also tried to import a metadata file in iso19139 which worked well as
I could edit and view it (even passed to status Approved) but cannot get
it when searching My metadata (or normal search) I can only find it when
"searching for unused".

In the metadata table in postgres I have the records there including the
templates and the metadata file.

When starting tomcat, I have :
"Failure to make _writer, maybe a problem but might also not be an
issue:<error id="error">
<message>org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore</message>
     <class>ClassCastException</class>"
and then
"2012-11-09 15:12:32,714 ERROR [geonetwork.spatial] - Unable to call
reset on Spatial writer: null
2012-11-09 15:12:32,722 ERROR [geonetwork.index] - Rebuilding lucene index"

Then every metadata is ignored with error:
"The metadata document index with id=4 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Finally when I try to rebuild index I have a popup saying "Index
operation already in progress please wait".

I checked database configuration many times and have look through all
the forum and mailing list I could but I can't figure out what is going
wrong.

The spatialindex table is empty in postgres, but I am not sure if it
could be the issue as templates might not use it maybe my metadata file ?

What I am missing ?

I can provide the log file if needed.

Thanks in advance,

Sylvie

<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Sylvie,

Can you let me know which version of postgis you have installed in your postgres database? (eg. SELECT PostGIS_Full_Version(); in psql)

Cheers,
Simon

________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Monday, 26 November 2012 6:28 PM
To: Pigot, Simon (CMAR, Hobart)
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Dear Simon,

Thank you for your help, I was missing postgis jar in tomcat lib (this might be the missing part in the doc), now geonetwork seems to be using postgis (log file indicating so) but I still have the error:

"The metadata document index with id=7 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

I tried to recreate database without effect, first metadata created is throwing this error and then I have "Timer is already cancelled".

Maybe am I missing lucene librairies somewhere ?

Cheers,

Sylvie

On 11/24/2012 11:14 AM, Simon.Pigot@anonymised.com<mailto:Simon.Pigot@anonymised.com> wrote:

Hi Sylvie,

Not sure what is going on but to check the config steps I set it up using the latest 2.8.x build:

- place postgresql and postgis jdbc driver jars in your tomcat lib dir (tomcat6)
- place commons-dbcp-1.3.jar and commons-pool-1.5.5.jar in your tomcat lib dir (tomcat6 again)
- configure your tomcat/conf/context.xml something like the following:

<Resource name="jdbc/geonetwork"
              auth="Container"
              type="javax.sql.DataSource"
              username="dbusername"
              password="dbpassword"
              driverClassName="org.postgis.DriverWrapper"
              factory="org.apache.commons.dbcp.BasicDataSourceFactory"
              url="jdbc:postgresql_postGIS://localhost:5432/gndb4"
              maxActive="10"
              maxIdle="10"
              removeAbandoned="true"
              removeAbandonedTimeout="3600"
              logAbandoned="true"
              testOnBorrow="true"
              defaultAutoCommit="false"
              defaultTransactionIsolation="READ_COMMITTED"
              accessToUnderlyingConnectionAllowed="true"
              validationQuery="select 1"/>

- then in webapps/geonetwork/WEB-INF/config.xml you should have:

<resource enabled="true">
      <name>main-db</name>
      <provider>jeeves.resources.dbms.JNDIPool</provider>
      <config>
        <context>java:/comp/env</context>
        <resourceName>jdbc/geonetwork</resourceName>
        <url>jdbc:postgresql_postGIS://localhost:5432/gndb</url>
        <!-- if the database has a spatialindex table with fid, id and
            multipolygon geometry fields (eg. see postgis) then specify true
            here and GeoNetwork will use the database for its spatial index
            otherwise specify false or leave the parameter out and a
            shapefile will be used for the spatial index -->
        <provideDataStore>true</provideDataStore>
        <!-- set this value to -1 if you don't want prepared statements to
        be cached when querying/maintaining the spatial index
        (note this is only applicable when
        provideDataStore is set to true) -->
        <maxOpenPreparedStatements>300</maxOpenPreparedStatements>
        <!-- NOTE any other parameter specified here is ignored as this
        should be handled in the container -->
      </config>
    </resource>

In your logs/catalina.log file you should see things like:

2012-11-24 11:02:26,922 INFO [jeeves.apphand] - - Database connection on jdbc:postgresql_postGIS://localhost:5432/gndb4 ...
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - jdbc:postgresql_postGIS://localhost:5432/gndb4 is an empty database (Metadata table not found).
2012-11-24 11:02:26,940 INFO [jeeves.apphand] - - SQL create file:/usr/local/jakarta/tomcat-geonetwork/webapps/geonetwork/WEB-INF/classes/setup/sql/create prefix:create-db- ...
....

indicating a successful connection to the database and creation of tables needed by GeoNetwork.

These steps should be described in the documentation at http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container but maybe there are things that are not clear (it does use an oracle example. maybe it should have a postgis example too?) so if we can sort this out perhaps we can include steps in there to make sure this doesn't occur for others.

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com<mailto:sylvie.fiat@anonymised.com>]
Sent: Thursday, 22 November 2012 10:55 AM
To: geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@anonymised.comurceforge.net>
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hello list,

Any ideas ?

Maybe I am posting on the wrong list (developer instead ?) ?

I changed the version with 2.8 RC 2 but still got the same problem with
lucene not working and metadatas/templates being throwing errors:
"The metadata document index with id=7 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Thanks,
Sylvie

On 11/09/2012 06:16 PM, Sylvie Fiat wrote:

Hi,

I just installed last version of GeoNetwork 2.8 on Linux with tomcat
using postgres/postgis with JNDI configuration, using
geonetwork-branch28-2012-11-07.war
<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;&lt;http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;\.

I tried to add templates iso19139 using Administration page and after
confirmation tried to add New metadata but I get "No templates
available, import metadata first.".

I also tried to import a metadata file in iso19139 which worked well as
I could edit and view it (even passed to status Approved) but cannot get
it when searching My metadata (or normal search) I can only find it when
"searching for unused".

In the metadata table in postgres I have the records there including the
templates and the metadata file.

When starting tomcat, I have :
"Failure to make _writer, maybe a problem but might also not be an
issue:<error id="error">
<message>org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore</message>
    <class>ClassCastException</class>"
and then
"2012-11-09 15:12:32,714 ERROR [geonetwork.spatial] - Unable to call
reset on Spatial writer: null
2012-11-09 15:12:32,722 ERROR [geonetwork.index] - Rebuilding lucene index"

Then every metadata is ignored with error:
"The metadata document index with id=4 is corrupt/invalid - ignoring it.
Error: org.geotools.jdbc.JDBCFeatureSource cannot be cast to
org.geotools.data.FeatureStore"

Finally when I try to rebuild index I have a popup saying "Index
operation already in progress please wait".

I checked database configuration many times and have look through all
the forum and mailing list I could but I can't figure out what is going
wrong.

The spatialindex table is empty in postgres, but I am not sure if it
could be the issue as templates might not use it maybe my metadata file ?

What I am missing ?

I can provide the log file if needed.

Thanks in advance,

Sylvie

<http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;&lt;http://nightlybuild.geonetwork-opensource.org/28branch/geonetwork-branch28-2012-11-07.war&gt;

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:
> SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
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

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
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

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

(attachments)

geonetwork_20121127.log (16.3 KB)

Hi Sylvie,

I could reproduce your problem by deleting the gt_pk_metadata table in my postgres table (you probably don't have such a table in your postgis db). It's not created by GeoNetwork at the moment, you can create it as follows:

CREATE TABLE gt_pk_metadata
  (
    table_schema VARCHAR(32) NOT NULL,
    table_name VARCHAR(256) NOT NULL,
    pk_column VARCHAR(32) NOT NULL,
    pk_column_idx INTEGER,
    pk_policy VARCHAR(32),
    pk_sequence VARCHAR(64),
    unique (table_schema, table_name, pk_column),
    check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
  );

INSERT into gt_pk_metadata values ( '', 'spatialindex', 'fid', null, 'assigned', null );

I suspect this is the missing step we were looking for. I'm thinking we could add this to the create-db-*.sql setup script and insert the row in the data-db-default.sql stuff. The table shouldn't cause any trouble for other databases and (so far) it seems that the table is only required for postgis - oracle can get on well without it (I'll check this further).

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 10:15 AM
To: Kai Liu
Cc: Pigot, Simon (CMAR, Hobart); geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
Best Open Source Mac Front-Ends 2024
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Sylvie,

I could reproduce your problem by deleting the gt_pk_metadata table in my postgis db (you probably don't have such a table in your postgis db). It's not created by GeoNetwork at the moment, you can create it as follows:

CREATE TABLE gt_pk_metadata
  (
    table_schema VARCHAR(32) NOT NULL,
    table_name VARCHAR(256) NOT NULL,
    pk_column VARCHAR(32) NOT NULL,
    pk_column_idx INTEGER,
    pk_policy VARCHAR(32),
    pk_sequence VARCHAR(64),
    unique (table_schema, table_name, pk_column),
    check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
  );

INSERT into gt_pk_metadata values ( '', 'spatialindex', 'fid', null, 'assigned', null );

I suspect this is the missing step we were looking for. I'm thinking we could add this to the create-db-*.sql setup script and insert the row in the data-db-default.sql stuff. The table shouldn't cause any trouble for other databases and (so far) it seems that the table is only required for postgis - oracle can get on well without it (I'll check this further).

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 10:15 AM
To: Kai Liu
Cc: Pigot, Simon (CMAR, Hobart); geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
Best Open Source Mac Front-Ends 2024
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Simon,

Thanks a lot, that was the missing step, You should probably document it at http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container which otherwise id pretty well done.

Cheers,

Sylvie

On 11/27/2012 12:50 PM, Simon.Pigot@anonymised.com wrote:

Hi Sylvie,

I could reproduce your problem by deleting the gt_pk_metadata table in my postgis db (you probably don't have such a table in your postgis db). It's not created by GeoNetwork at the moment, you can create it as follows:

CREATE TABLE gt_pk_metadata
   (
     table_schema VARCHAR(32) NOT NULL,
     table_name VARCHAR(256) NOT NULL,
     pk_column VARCHAR(32) NOT NULL,
     pk_column_idx INTEGER,
     pk_policy VARCHAR(32),
     pk_sequence VARCHAR(64),
     unique (table_schema, table_name, pk_column),
     check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
   );

INSERT into gt_pk_metadata values ( '', 'spatialindex', 'fid', null, 'assigned', null );

I suspect this is the missing step we were looking for. I'm thinking we could add this to the create-db-*.sql setup script and insert the row in the data-db-default.sql stuff. The table shouldn't cause any trouble for other databases and (so far) it seems that the table is only required for postgis - oracle can get on well without it (I'll check this further).

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 10:15 AM
To: Kai Liu
Cc: Pigot, Simon (CMAR, Hobart); geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
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

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Sylvie,

Just to clarify: I'm not sure that this is a failure to document - more something that geotools needs. After reading up on it I really am kind of puzzled by the need for this gt_pk_metadata thing at all in our db as I understand it is only needed when working with views - see https://getsatisfaction.com/opengeo/topics/postgis_index_in_opengeo

So yes, looks like this can be fixed by sticking this table in but it kind of feels odd and needs more work to see why it is necessary at all!

Cheers,
Simon

________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 4:18 PM
To: Pigot, Simon (CMAR, Hobart)
Cc: kliu4@anonymised.com; geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

Thanks a lot, that was the missing step, You should probably document it
at
http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container
which otherwise id pretty well done.

Cheers,

Sylvie

On 11/27/2012 12:50 PM, Simon.Pigot@anonymised.com wrote:

Hi Sylvie,

I could reproduce your problem by deleting the gt_pk_metadata table in my postgis db (you probably don't have such a table in your postgis db). It's not created by GeoNetwork at the moment, you can create it as follows:

CREATE TABLE gt_pk_metadata
   (
     table_schema VARCHAR(32) NOT NULL,
     table_name VARCHAR(256) NOT NULL,
     pk_column VARCHAR(32) NOT NULL,
     pk_column_idx INTEGER,
     pk_policy VARCHAR(32),
     pk_sequence VARCHAR(64),
     unique (table_schema, table_name, pk_column),
     check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
   );

INSERT into gt_pk_metadata values ( '', 'spatialindex', 'fid', null, 'assigned', null );

I suspect this is the missing step we were looking for. I'm thinking we could add this to the create-db-*.sql setup script and insert the row in the data-db-default.sql stuff. The table shouldn't cause any trouble for other databases and (so far) it seems that the table is only required for postgis - oracle can get on well without it (I'll check this further).

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 10:15 AM
To: Kai Liu
Cc: Pigot, Simon (CMAR, Hobart); geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
Best Open Source Mac Front-Ends 2024
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Ever more complex: this is all to do with geotools deciding whether the spatialindex table is writable or not (ie. can it be used as a feature store as opposed to a read only feature source). If geotools decides that spatialindex is not writable then everything fails as a read only feature source is useless to GeoNetwork. One of the tests to determine whether spatialindex is writable is identifying its primary keys.

Turns out that the gt_pk_metadata table we've been discussing is the first choice for geotools in identifying primary keys of spatialindex ie. if it exists then it is used. If it doesn't exist then geotools uses java.sql.Database to get info (including primary keys) from the database. For postgres/postgis it seems that the query to get the primary keys actually fails! What this means is that we have to have the gt_pk_metadata table present, otherwise geotools can't identify the primary keys and will decide that spatialindex is not writable causing GeoNetwork to fail.

Hmm. Ok - I've rigged up a fix for the create-db-postgis.sql file that creates gt_pk_metadata and populates it correctly (taking into account it might already exist etc). However I'll try a few other paths to see whether we can do this the normal/proper way before suggesting we apply this fix (already tried lots of jdbc driver versions - which didn't help) as we shouldn't need to build/maintain the gt_pk_metadata table.

Cheers,
Simon
________________________________________
From: Pigot, Simon (CMAR, Hobart)
Sent: Tuesday, 27 November 2012 4:42 PM
To: sylvie.fiat@anonymised.com
Cc: kliu4@anonymised.com; geonetwork-users@lists.sourceforge.net
Subject: RE: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Sylvie,

Just to clarify: I'm not sure that this is a failure to document - more something that geotools needs. After reading up on it I really am kind of puzzled by the need for this gt_pk_metadata thing at all in our db as I understand it is only needed when working with views - see https://getsatisfaction.com/opengeo/topics/postgis_index_in_opengeo

So yes, looks like this can be fixed by sticking this table in but it kind of feels odd and needs more work to see why it is necessary at all!

Cheers,
Simon

________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 4:18 PM
To: Pigot, Simon (CMAR, Hobart)
Cc: kliu4@anonymised.com; geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

Thanks a lot, that was the missing step, You should probably document it
at
http://geonetwork-opensource.org/manuals/trunk/eng/users/admin/advanced-configuration/index.html#database-connection-pool-managed-by-the-container
which otherwise id pretty well done.

Cheers,

Sylvie

On 11/27/2012 12:50 PM, Simon.Pigot@anonymised.com wrote:

Hi Sylvie,

I could reproduce your problem by deleting the gt_pk_metadata table in my postgis db (you probably don't have such a table in your postgis db). It's not created by GeoNetwork at the moment, you can create it as follows:

CREATE TABLE gt_pk_metadata
   (
     table_schema VARCHAR(32) NOT NULL,
     table_name VARCHAR(256) NOT NULL,
     pk_column VARCHAR(32) NOT NULL,
     pk_column_idx INTEGER,
     pk_policy VARCHAR(32),
     pk_sequence VARCHAR(64),
     unique (table_schema, table_name, pk_column),
     check (pk_policy in ('sequence', 'assigned', 'autoincrement'))
   );

INSERT into gt_pk_metadata values ( '', 'spatialindex', 'fid', null, 'assigned', null );

I suspect this is the missing step we were looking for. I'm thinking we could add this to the create-db-*.sql setup script and insert the row in the data-db-default.sql stuff. The table shouldn't cause any trouble for other databases and (so far) it seems that the table is only required for postgis - oracle can get on well without it (I'll check this further).

Cheers and thanks,
Simon
________________________________________
From: Sylvie Fiat [sylvie.fiat@anonymised.com]
Sent: Tuesday, 27 November 2012 10:15 AM
To: Kai Liu
Cc: Pigot, Simon (CMAR, Hobart); geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Seems to be connected successfully, please find attached the log file.

Regards,
Sylvie

On 11/27/2012 10:00 AM, Kai Liu wrote:

Plz check the first lines of output.log if the geonetwork connected to the main_db successfully.

Kai
Joint Center for Intelligent Spatial Computing
703-395-2337

----- Original Message -----
From: Sylvie Fiat <sylvie.fiat@anonymised.com>
Date: Monday, November 26, 2012 4:10 pm
Subject: Re: [GeoNetwork-users] Cannot find metadata - Lucene or postgres error ?

Hi Simon,

There it is:

POSTGIS="1.5.3" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September
2009" LIBXML="2.6.26" USE_STATS

Cheers,

Sylvie

On 11/26/2012 11:38 PM, Simon.Pigot@anonymised.com wrote:

SELECT PostGIS_Full_Version()

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-
Pacifique"Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

-------------------------------------------------------------------
-----------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
Best Open Source Mac Front-Ends 2024
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

--
Sylvie Fiat
Ingénieur d'étude
Unité 227 "Biocomplexité des écosystèmes coralliens de l'Indo-Pacifique"
Institut de Recherche pour le Développement
B.P. A5
98848, Nouméa Cedex
Nouvelle-Calédonie
Tél. : (687) 26 07 95

Hi Andrew,

Not available yet from a URL - but you can build the zip files to use with any of the three methods by running ant after checking out the schemaPlugins (2.8.x branch) from the git repo.

eg.

git clone --recursive GitHub - geonetwork/schema-plugins schema-plugins-test
cd schema-plugins-test
git checkout -b 2.8.x origin/2.8.x
ant

This will create the zip files for each schema plugin in a dist subdirectory of schema-plugins-test.

Maybe the release committee can build the schema plugins using this method and make the zip archives available in sourceforge with the release?

AU/NZ users can also use the ANZMEST config and package of 2.8.x (see http://anzlicmet.bluenet.utas.edu.au) which includes the plugins commonly used in AU/NZ.

Cheers,
Simon
________________________________________
From: Andrew Watkins [Andrew.Watkins@anonymised.com]
Sent: Friday, 25 January 2013 6:42 AM
To: Pigot, Simon (CMAR, Hobart)
Cc: geonetwork-users@lists.sourceforge.net
Subject: Installing Schema Plugins

I'm looking at upgrading our ANZMEST geonetwork to the main 2.4.8 version
and will need to install the schema plugins for anzlic and mcp.

I note in the documentation that:

Schemas can also added to GeoNetwork dynamically if a zip archive of the
schema directory is created and then uploaded to GeoNetwork in one of
following ways using functions in the Administration menu:

1. Server file path (specified using file chooser)
2. HTTP URL (eg. http://somehost/somedirectory/iso19139.mcp.zip)
3. As an online resource attached to an iso19139 metadata record

I also can see these folders on github

But could not see any documentation that closes the gap. Are there any
locations where http://somehost/somedirectory/iso19139.mcp.zip is really
available so that I can do a direct installation?

If not is there an instruction page to move from the github folder to the
installed schemas.

This may not need to be more than a few lines - but it will save a lot of
time in guessing.

Thanks Andrew.

--
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.