Quantcast

Configuration Mistake

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Configuration Mistake

Chris Woelkers - NOAA Affiliate
I have installed Geonetwork on a linux based server by following the
instructions at http://demo.geo-solutions.it/share/bev/doc/index.html
with a few slight modifications and verified that it was working.
As per the primary user of Geonetwork I added the iso19115-3 schema
and verified that it was still working.

Last week the user added the following code in the admin
console/settings/metadata editor configuration that should have
allowed the linking of attachments.
"iso19115-3":{
  "defaultTab":"default",
  "displayToolTip":false,
  "related":{
    "display":true,
    "categories":[]},
  "suggestion":{"display":true},
  "validation":{"display":true}}

Afterwards Geonetwork was restarted, by request of the same user
because part of the site was no longer working, and now while the
Tomcat server does start the website does not load.

Does anyone know where the settings from above are stored? I have
searched throughout the Geonetwork server directory and cannot find
any location that contains the settings listed.

Chris

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
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
|  
Report Content as Inappropriate

Re: Configuration Mistake

Jo Cook
Hi Chris,

Have you tried the settings table in the database? Also it might be worth
looking at the log files- catalina.out is normally quite helpful about
issues when the site does not load.

Jo

On Mon, Nov 7, 2016 at 7:56 PM, Chris Woelkers - NOAA Affiliate <
[hidden email]> wrote:

> I have installed Geonetwork on a linux based server by following the
> instructions at http://demo.geo-solutions.it/share/bev/doc/index.html
> with a few slight modifications and verified that it was working.
> As per the primary user of Geonetwork I added the iso19115-3 schema
> and verified that it was still working.
>
> Last week the user added the following code in the admin
> console/settings/metadata editor configuration that should have
> allowed the linking of attachments.
> "iso19115-3":{
>   "defaultTab":"default",
>   "displayToolTip":false,
>   "related":{
>     "display":true,
>     "categories":[]},
>   "suggestion":{"display":true},
>   "validation":{"display":true}}
>
> Afterwards Geonetwork was restarted, by request of the same user
> because part of the site was no longer working, and now while the
> Tomcat server does start the website does not load.
>
> Does anyone know where the settings from above are stored? I have
> searched throughout the Geonetwork server directory and cannot find
> any location that contains the settings listed.
>
> Chris
>
> ------------------------------------------------------------
> ------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> 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

--
--
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 1372 744 009 w: 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/services/#training>
Helpdesk and customer portal
<http://support.astuntechnology.com/support/login>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
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
|  
Report Content as Inappropriate

Re: Configuration Mistake

amacar
In reply to this post by Chris Woelkers - NOAA Affiliate
Setting is in database -> table Settings -> metadata/editor/schemaConfig
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Configuration Mistake

Chris Woelkers - NOAA Affiliate
In reply to this post by Jo Cook
Your're right. I checked the settings and it was still set to H2, I
thought I changed that when setting it up but must have forgotten or
missed it.
Once I changed everything to use postgresql, and set up the
credentials, Geonetwork started fine and brought me right back to the
beginning.
Now I have to make a choice, either try to import the H2 database, the
data only as I don't want the settings, recreate the little that I had
done within the new postgresql database, or fix the settings issue in
the H2 database.

Chris

On Tue, Nov 8, 2016 at 9:33 AM, Jo Cook <[hidden email]> wrote:

> Hi Chris,
>
> I don't think it's configured to use postgresql because if it is, it should
> have 51 (at least) tables in it. My guess is that it's actually using the
> built-in h2 database. Those geosolutions instructions are not the approach I
> would normally take to be honest, so I'm not totally sure how to check.
> Normally I would ignore all those instructions, and in a standard install
> edit /var/lib/tomcat/webapps/geonetwork/WEB-INF/config-node/srv.xml and
> uncomment the appropriate database type, and then edit
> ../config-db/jdbc.properties to set the credentials. In your case I guess
> you need to check the files in this section and downwards:
> http://demo.geo-solutions.it/share/bev/doc/gn-install/geonet_install.html#config-file-config-overrides-xml.
> However be careful of the paths because I don't know where the
> /var/lib/tomcat/geonetwork/gn path comes from, it's not standard. I think
> those paths should all say WEB-INF rather than gn.
>
> If you do manage to establish the database type and it is h2 then I'm pretty
> sure you can still get in to edit the settings table- I'd have to google
> that as I never use h2 but this Stack Exchange article seems helpful:
> http://stackoverflow.com/questions/2760887/frontend-tool-to-manage-h2-database.
>
> Hope that helps- happy to try and help some more if you're still stuck
> though :-)
>
> Jo
>
> On Tue, Nov 8, 2016 at 1:25 PM, Chris Woelkers - NOAA Affiliate
> <[hidden email]> wrote:
>>
>> It's postgresql. The database name is geonetwork and it contains only
>> three tables, spatial_ref_sys, layer, and topology.
>> Maybe the lack of a settings table is causing the issue, although how
>> it got deleted is still up in the air.
>>
>> Chris
>>
>> On Tue, Nov 8, 2016 at 8:03 AM, Jo Cook <[hidden email]>
>> wrote:
>> > Hi Chris,
>> >
>> > What database are you using? I'm using postgresql and there's definitely
>> > a
>> > settings table in there.
>> >
>> > Jo
>> >
>> > On Tue, Nov 8, 2016 at 12:23 PM, Chris Woelkers - NOAA Affiliate
>> > <[hidden email]> wrote:
>> >>
>> >> Thanks for the response Jo.
>> >>
>> >> The database doesn't seem to have a table named settings.
>> >>
>> >> As for the log file, it shows the following warnings and error.
>> >>
>> >> 2016-11-02 11:44:05,589 WARN  [geonetwork.data.directory] -     - Data
>> >> directory properties is not set. Use geonetwork.dir or geonetwork.dir
>> >> properties.
>> >> 2016-11-02 11:44:05,602 WARN  [geonetwork.data.directory] -     - Data
>> >> directory provided could not be used. Using default location:
>> >> /var/lib/tomcats/geonetwork/webapps/geonetwork/WEB-INF/data
>> >> 2016-11-02 11:44:07,257 WARN  [geonetwork.schemamanager] - Cannot
>> >> resolve http://www.w3.org/2001/xml.xsd: will append last component to
>> >> current path (not sure it will help though!)
>> >> 2016-11-02 11:44:07,992 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-02 11:44:09,786 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-02 11:44:09,960 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-02 11:44:09,965 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:VerticalDatum
>> >> 2016-11-02 11:44:09,968 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:CoordinateSystemAxis
>> >> 2016-11-02 11:44:09,970 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:VerticalCS
>> >> 2016-11-02 11:44:09,973 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:CoordinateSystemAxis
>> >> 2016-11-02 11:44:10,383 WARN  [geonetwork.schemamanager] - Cannot
>> >> resolve http://www.w3.org/2001/03/xml.xsd: will append last component
>> >> to current path (not sure it will help though!)
>> >> 2016-11-02 11:44:12,779 WARN  [geonetwork.lucene] - Stopwords file
>> >> with incorrect ISO 639-2 language as filename: README
>> >> 2016-11-02 11:44:29,117 WARN  [geonetwork.lucene.tracking] -
>> >> LuceneIndexLanguageTracker:destroy() called, closing indexes ...
>> >> 2016-11-02 11:44:29,126 WARN  [geonetwork.lucene.tracking] -
>> >> LuceneIndexLanguageTracker:destroy() Done.
>> >> 2016-11-07 19:55:02,133 WARN  [geonetwork.data.directory] -     - Data
>> >> directory properties is not set. Use geonetwork.dir or geonetwork.dir
>> >> properties.
>> >> 2016-11-07 19:55:02,133 WARN  [geonetwork.data.directory] -     - Data
>> >> directory provided could not be used. Using default location:
>> >> /var/lib/tomcats/geonetwork/webapps/geonetwork/WEB-INF/data
>> >> 2016-11-07 19:55:03,391 WARN  [geonetwork.schemamanager] - Cannot
>> >> resolve http://www.w3.org/2001/xml.xsd: will append last component to
>> >> current path (not sure it will help though!)
>> >> 2016-11-07 19:55:04,062 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-07 19:55:05,869 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-07 19:55:06,031 WARN  [geonetwork.schemamanager] - WARNING:
>> >> gco:Record is a global element without a type - assuming a string
>> >> 2016-11-07 19:55:06,037 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:VerticalDatum
>> >> 2016-11-07 19:55:06,040 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:CoordinateSystemAxis
>> >> 2016-11-07 19:55:06,041 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:VerticalCS
>> >> 2016-11-07 19:55:06,044 WARN  [geonetwork.schemamanager] - WARNING:
>> >> schema-substitutions.xml has wiped out XSD substitution list for
>> >> gml:CoordinateSystemAxis
>> >> 2016-11-07 19:55:06,378 WARN  [geonetwork.schemamanager] - Cannot
>> >> resolve http://www.w3.org/2001/03/xml.xsd: will append last component
>> >> to current path (not sure it will help though!)
>> >> 2016-11-07 19:55:08,593 WARN  [geonetwork.lucene] - Stopwords file
>> >> with incorrect ISO 639-2 language as filename: README
>> >> 2016-11-07 19:55:26,266 ERROR [geonetwork.wro4j] - Error occurred
>> >> during a wro4j request handling
>> >> ro.isdc.wro.WroRuntimeException: No such group available in the model:
>> >> gn_search_complete
>> >>         at
>> >>
>> >> ro.isdc.wro.model.group.processor.GroupsProcessor.process(GroupsProcessor.java:74)
>> >>         at
>> >>
>> >> ro.isdc.wro.cache.support.DefaultSynchronizedCacheStrategyDecorator.loadValue(DefaultSynchronizedCacheStrategyDecorator.java:101)
>> >>         at
>> >>
>> >> ro.isdc.wro.cache.support.DefaultSynchronizedCacheStrategyDecorator.loadValue(DefaultSynchronizedCacheStrategyDecorator.java:35)
>> >>         at
>> >>
>> >> ro.isdc.wro.cache.support.AbstractSynchronizedCacheStrategyDecorator.get(AbstractSynchronizedCacheStrategyDecorator.java:55)
>> >>         at
>> >>
>> >> ro.isdc.wro.manager.ResourceBundleProcessor.serveProcessedBundle(ResourceBundleProcessor.java:63)
>> >>         at ro.isdc.wro.manager.WroManager.process(WroManager.java:159)
>> >>         at
>> >> ro.isdc.wro.http.WroFilter.processRequest(WroFilter.java:335)
>> >>         at ro.isdc.wro.http.WroFilter.doFilter(WroFilter.java:289)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>> >>         at
>> >>
>> >> org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
>> >>         at
>> >> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
>> >>         at
>> >>
>> >> org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
>> >>         at
>> >>
>> >> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>> >>         at
>> >>
>> >> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:186)
>> >>         at
>> >>
>> >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
>> >>         at
>> >>
>> >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>> >>         at
>> >>
>> >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
>> >>         at
>> >>
>> >> jeeves.config.springutil.JeevesDelegatingFilterProxy.doFilter(JeevesDelegatingFilterProxy.java:104)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>> >>         at
>> >>
>> >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
>> >>         at
>> >>
>> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>> >>         at
>> >>
>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>> >>         at
>> >>
>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
>> >>         at
>> >>
>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
>> >>         at
>> >>
>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>> >>         at
>> >>
>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>> >>         at
>> >>
>> >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
>> >>         at
>> >>
>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
>> >>         at
>> >>
>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>> >>         at
>> >> org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193)
>> >>         at
>> >>
>> >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
>> >>         at
>> >>
>> >> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
>> >>         at
>> >>
>> >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> >>         at
>> >>
>> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> >>         at
>> >>
>> >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>> >>         at java.lang.Thread.run(Thread.java:745)
>> >>
>> >> Chris
>> >>
>> >> On Tue, Nov 8, 2016 at 5:03 AM, Jo Cook <[hidden email]>
>> >> wrote:
>> >> > Hi Chris,
>> >> >
>> >> > Have you tried the settings table in the database? Also it might be
>> >> > worth
>> >> > looking at the log files- catalina.out is normally quite helpful
>> >> > about
>> >> > issues when the site does not load.
>> >> >
>> >> > Jo
>> >> >
>> >> > On Mon, Nov 7, 2016 at 7:56 PM, Chris Woelkers - NOAA Affiliate
>> >> > <[hidden email]> wrote:
>> >> >>
>> >> >> I have installed Geonetwork on a linux based server by following the
>> >> >> instructions at
>> >> >> http://demo.geo-solutions.it/share/bev/doc/index.html
>> >> >> with a few slight modifications and verified that it was working.
>> >> >> As per the primary user of Geonetwork I added the iso19115-3 schema
>> >> >> and verified that it was still working.
>> >> >>
>> >> >> Last week the user added the following code in the admin
>> >> >> console/settings/metadata editor configuration that should have
>> >> >> allowed the linking of attachments.
>> >> >> "iso19115-3":{
>> >> >>   "defaultTab":"default",
>> >> >>   "displayToolTip":false,
>> >> >>   "related":{
>> >> >>     "display":true,
>> >> >>     "categories":[]},
>> >> >>   "suggestion":{"display":true},
>> >> >>   "validation":{"display":true}}
>> >> >>
>> >> >> Afterwards Geonetwork was restarted, by request of the same user
>> >> >> because part of the site was no longer working, and now while the
>> >> >> Tomcat server does start the website does not load.
>> >> >>
>> >> >> Does anyone know where the settings from above are stored? I have
>> >> >> searched throughout the Geonetwork server directory and cannot find
>> >> >> any location that contains the settings listed.
>> >> >>
>> >> >> Chris
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> ------------------------------------------------------------------------------
>> >> >> Developer Access Program for Intel Xeon Phi Processors
>> >> >> Access to Intel Xeon Phi processor-based developer platforms.
>> >> >> With one year of Intel Parallel Studio XE.
>> >> >> Training and support from Colfax.
>> >> >> Order your platform today. http://sdm.link/xeonphi
>> >> >> _______________________________________________
>> >> >> 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
>> >> >
>> >> >
>> >> > --
>> >> > Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
>> >> > KT18
>> >> > 7RL, UK
>> >> > t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
>> >> >
>> >> > iShare - enterprise geographic intelligence platform
>> >> > GeoServer, PostGIS and QGIS training
>> >> > Helpdesk and customer portal
>> >> >
>> >> > Company registration no. 5410695. Registered in England and Wales.
>> >> > Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT
>> >> > no.
>> >> > 864201149.
>> >
>> >
>> >
>> >
>> > --
>> > Jo Cook
>> > t:+44 7930 524 155/twitter:@archaeogeek
>> >
>> >
>> > --
>> > Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
>> > KT18
>> > 7RL, UK
>> > t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
>> >
>> > iShare - enterprise geographic intelligence platform
>> > GeoServer, PostGIS and QGIS training
>> > Helpdesk and customer portal
>> >
>> > Company registration no. 5410695. Registered in England and Wales.
>> > Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
>> > 864201149.
>
>
>
>
> --
> Jo Cook
> t:+44 7930 524 155/twitter:@archaeogeek
>
>
> --
> Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
> 7RL, UK
> t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
>
> iShare - enterprise geographic intelligence platform
> GeoServer, PostGIS and QGIS training
> Helpdesk and customer portal
>
> Company registration no. 5410695. Registered in England and Wales.
> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
> 864201149.

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
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
|  
Report Content as Inappropriate

Re: Configuration Mistake

Jo Cook
Hi Chris,

You could back up the postgresql settings table, then dump everything from
h2 to postgresql, then overwrite with the good settings table.
Alternatively as amacar said, the setting you want is in table Settings,
entry metadata/editor/schemaConfig. You should be able to fix that in h2 I
guess?

Jo


On Tue, Nov 8, 2016 at 3:14 PM, Chris Woelkers - NOAA Affiliate <
[hidden email]> wrote:

> Your're right. I checked the settings and it was still set to H2, I
> thought I changed that when setting it up but must have forgotten or
> missed it.
> Once I changed everything to use postgresql, and set up the
> credentials, Geonetwork started fine and brought me right back to the
> beginning.
> Now I have to make a choice, either try to import the H2 database, the
> data only as I don't want the settings, recreate the little that I had
> done within the new postgresql database, or fix the settings issue in
> the H2 database.
>
> Chris
>
> On Tue, Nov 8, 2016 at 9:33 AM, Jo Cook <[hidden email]>
> wrote:
> > Hi Chris,
> >
> > I don't think it's configured to use postgresql because if it is, it
> should
> > have 51 (at least) tables in it. My guess is that it's actually using the
> > built-in h2 database. Those geosolutions instructions are not the
> approach I
> > would normally take to be honest, so I'm not totally sure how to check.
> > Normally I would ignore all those instructions, and in a standard install
> > edit /var/lib/tomcat/webapps/geonetwork/WEB-INF/config-node/srv.xml and
> > uncomment the appropriate database type, and then edit
> > ../config-db/jdbc.properties to set the credentials. In your case I guess
> > you need to check the files in this section and downwards:
> > http://demo.geo-solutions.it/share/bev/doc/gn-install/
> geonet_install.html#config-file-config-overrides-xml.
> > However be careful of the paths because I don't know where the
> > /var/lib/tomcat/geonetwork/gn path comes from, it's not standard. I think
> > those paths should all say WEB-INF rather than gn.
> >
> > If you do manage to establish the database type and it is h2 then I'm
> pretty
> > sure you can still get in to edit the settings table- I'd have to google
> > that as I never use h2 but this Stack Exchange article seems helpful:
> > http://stackoverflow.com/questions/2760887/frontend-
> tool-to-manage-h2-database.
> >
> > Hope that helps- happy to try and help some more if you're still stuck
> > though :-)
> >
> > Jo
> >
> > On Tue, Nov 8, 2016 at 1:25 PM, Chris Woelkers - NOAA Affiliate
> > <[hidden email]> wrote:
> >>
> >> It's postgresql. The database name is geonetwork and it contains only
> >> three tables, spatial_ref_sys, layer, and topology.
> >> Maybe the lack of a settings table is causing the issue, although how
> >> it got deleted is still up in the air.
> >>
> >> Chris
> >>
> >> On Tue, Nov 8, 2016 at 8:03 AM, Jo Cook <[hidden email]>
> >> wrote:
> >> > Hi Chris,
> >> >
> >> > What database are you using? I'm using postgresql and there's
> definitely
> >> > a
> >> > settings table in there.
> >> >
> >> > Jo
> >> >
> >> > On Tue, Nov 8, 2016 at 12:23 PM, Chris Woelkers - NOAA Affiliate
> >> > <[hidden email]> wrote:
> >> >>
> >> >> Thanks for the response Jo.
> >> >>
> >> >> The database doesn't seem to have a table named settings.
> >> >>
> >> >> As for the log file, it shows the following warnings and error.
> >> >>
> >> >> 2016-11-02 11:44:05,589 WARN  [geonetwork.data.directory] -     -
> Data
> >> >> directory properties is not set. Use geonetwork.dir or geonetwork.dir
> >> >> properties.
> >> >> 2016-11-02 11:44:05,602 WARN  [geonetwork.data.directory] -     -
> Data
> >> >> directory provided could not be used. Using default location:
> >> >> /var/lib/tomcats/geonetwork/webapps/geonetwork/WEB-INF/data
> >> >> 2016-11-02 11:44:07,257 WARN  [geonetwork.schemamanager] - Cannot
> >> >> resolve http://www.w3.org/2001/xml.xsd: will append last component
> to
> >> >> current path (not sure it will help though!)
> >> >> 2016-11-02 11:44:07,992 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-02 11:44:09,786 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-02 11:44:09,960 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-02 11:44:09,965 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:VerticalDatum
> >> >> 2016-11-02 11:44:09,968 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:CoordinateSystemAxis
> >> >> 2016-11-02 11:44:09,970 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:VerticalCS
> >> >> 2016-11-02 11:44:09,973 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:CoordinateSystemAxis
> >> >> 2016-11-02 11:44:10,383 WARN  [geonetwork.schemamanager] - Cannot
> >> >> resolve http://www.w3.org/2001/03/xml.xsd: will append last
> component
> >> >> to current path (not sure it will help though!)
> >> >> 2016-11-02 11:44:12,779 WARN  [geonetwork.lucene] - Stopwords file
> >> >> with incorrect ISO 639-2 language as filename: README
> >> >> 2016-11-02 11:44:29,117 WARN  [geonetwork.lucene.tracking] -
> >> >> LuceneIndexLanguageTracker:destroy() called, closing indexes ...
> >> >> 2016-11-02 11:44:29,126 WARN  [geonetwork.lucene.tracking] -
> >> >> LuceneIndexLanguageTracker:destroy() Done.
> >> >> 2016-11-07 19:55:02,133 WARN  [geonetwork.data.directory] -     -
> Data
> >> >> directory properties is not set. Use geonetwork.dir or geonetwork.dir
> >> >> properties.
> >> >> 2016-11-07 19:55:02,133 WARN  [geonetwork.data.directory] -     -
> Data
> >> >> directory provided could not be used. Using default location:
> >> >> /var/lib/tomcats/geonetwork/webapps/geonetwork/WEB-INF/data
> >> >> 2016-11-07 19:55:03,391 WARN  [geonetwork.schemamanager] - Cannot
> >> >> resolve http://www.w3.org/2001/xml.xsd: will append last component
> to
> >> >> current path (not sure it will help though!)
> >> >> 2016-11-07 19:55:04,062 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-07 19:55:05,869 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-07 19:55:06,031 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> gco:Record is a global element without a type - assuming a string
> >> >> 2016-11-07 19:55:06,037 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:VerticalDatum
> >> >> 2016-11-07 19:55:06,040 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:CoordinateSystemAxis
> >> >> 2016-11-07 19:55:06,041 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:VerticalCS
> >> >> 2016-11-07 19:55:06,044 WARN  [geonetwork.schemamanager] - WARNING:
> >> >> schema-substitutions.xml has wiped out XSD substitution list for
> >> >> gml:CoordinateSystemAxis
> >> >> 2016-11-07 19:55:06,378 WARN  [geonetwork.schemamanager] - Cannot
> >> >> resolve http://www.w3.org/2001/03/xml.xsd: will append last
> component
> >> >> to current path (not sure it will help though!)
> >> >> 2016-11-07 19:55:08,593 WARN  [geonetwork.lucene] - Stopwords file
> >> >> with incorrect ISO 639-2 language as filename: README
> >> >> 2016-11-07 19:55:26,266 ERROR [geonetwork.wro4j] - Error occurred
> >> >> during a wro4j request handling
> >> >> ro.isdc.wro.WroRuntimeException: No such group available in the
> model:
> >> >> gn_search_complete
> >> >>         at
> >> >>
> >> >> ro.isdc.wro.model.group.processor.GroupsProcessor.
> process(GroupsProcessor.java:74)
> >> >>         at
> >> >>
> >> >> ro.isdc.wro.cache.support.DefaultSynchronizedCacheStrate
> gyDecorator.loadValue(DefaultSynchronizedCacheStrategyDecorator.java:101)
> >> >>         at
> >> >>
> >> >> ro.isdc.wro.cache.support.DefaultSynchronizedCacheStrate
> gyDecorator.loadValue(DefaultSynchronizedCacheStrategyDecorator.java:35)
> >> >>         at
> >> >>
> >> >> ro.isdc.wro.cache.support.AbstractSynchronizedCacheStrat
> egyDecorator.get(AbstractSynchronizedCacheStrategyDecorator.java:55)
> >> >>         at
> >> >>
> >> >> ro.isdc.wro.manager.ResourceBundleProcessor.serveProcessedBundle(
> ResourceBundleProcessor.java:63)
> >> >>         at ro.isdc.wro.manager.WroManager.process(WroManager.
> java:159)
> >> >>         at
> >> >> ro.isdc.wro.http.WroFilter.processRequest(WroFilter.java:335)
> >> >>         at ro.isdc.wro.http.WroFilter.doFilter(WroFilter.java:289)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> >> >>         at
> >> >>
> >> >> org.tuckey.web.filters.urlrewrite.RuleChain.
> handleRewrite(RuleChain.java:176)
> >> >>         at
> >> >> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(
> RuleChain.java:145)
> >> >>         at
> >> >>
> >> >> org.tuckey.web.filters.urlrewrite.UrlRewriter.
> processRequest(UrlRewriter.java:92)
> >> >>         at
> >> >>
> >> >> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.
> doFilter(UrlRewriteFilter.java:381)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> >> >>         at
> >> >>
> >> >> org.springframework.security.web.FilterChainProxy.doFilterInternal(
> FilterChainProxy.java:186)
> >> >>         at
> >> >>
> >> >> org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> >> >>         at
> >> >>
> >> >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(
> DelegatingFilterProxy.java:346)
> >> >>         at
> >> >>
> >> >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:262)
> >> >>         at
> >> >>
> >> >> jeeves.config.springutil.JeevesDelegatingFilterProxy.doFilter(
> JeevesDelegatingFilterProxy.java:104)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> >> >>         at
> >> >>
> >> >> org.springframework.web.filter.CharacterEncodingFilter.
> doFilterInternal(CharacterEncodingFilter.java:121)
> >> >>         at
> >> >>
> >> >> org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:171)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:102)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:950)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> >> >>         at
> >> >>
> >> >> org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:408)
> >> >>         at
> >> >> org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193)
> >> >>         at
> >> >>
> >> >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:607)
> >> >>         at
> >> >>
> >> >> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:314)
> >> >>         at
> >> >>
> >> >> java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> >> >>         at
> >> >>
> >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> >> >>         at
> >> >>
> >> >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> >> >>         at java.lang.Thread.run(Thread.java:745)
> >> >>
> >> >> Chris
> >> >>
> >> >> On Tue, Nov 8, 2016 at 5:03 AM, Jo Cook <[hidden email]>
> >> >> wrote:
> >> >> > Hi Chris,
> >> >> >
> >> >> > Have you tried the settings table in the database? Also it might be
> >> >> > worth
> >> >> > looking at the log files- catalina.out is normally quite helpful
> >> >> > about
> >> >> > issues when the site does not load.
> >> >> >
> >> >> > Jo
> >> >> >
> >> >> > On Mon, Nov 7, 2016 at 7:56 PM, Chris Woelkers - NOAA Affiliate
> >> >> > <[hidden email]> wrote:
> >> >> >>
> >> >> >> I have installed Geonetwork on a linux based server by following
> the
> >> >> >> instructions at
> >> >> >> http://demo.geo-solutions.it/share/bev/doc/index.html
> >> >> >> with a few slight modifications and verified that it was working.
> >> >> >> As per the primary user of Geonetwork I added the iso19115-3
> schema
> >> >> >> and verified that it was still working.
> >> >> >>
> >> >> >> Last week the user added the following code in the admin
> >> >> >> console/settings/metadata editor configuration that should have
> >> >> >> allowed the linking of attachments.
> >> >> >> "iso19115-3":{
> >> >> >>   "defaultTab":"default",
> >> >> >>   "displayToolTip":false,
> >> >> >>   "related":{
> >> >> >>     "display":true,
> >> >> >>     "categories":[]},
> >> >> >>   "suggestion":{"display":true},
> >> >> >>   "validation":{"display":true}}
> >> >> >>
> >> >> >> Afterwards Geonetwork was restarted, by request of the same user
> >> >> >> because part of the site was no longer working, and now while the
> >> >> >> Tomcat server does start the website does not load.
> >> >> >>
> >> >> >> Does anyone know where the settings from above are stored? I have
> >> >> >> searched throughout the Geonetwork server directory and cannot
> find
> >> >> >> any location that contains the settings listed.
> >> >> >>
> >> >> >> Chris
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> ------------------------------------------------------------
> ------------------
> >> >> >> Developer Access Program for Intel Xeon Phi Processors
> >> >> >> Access to Intel Xeon Phi processor-based developer platforms.
> >> >> >> With one year of Intel Parallel Studio XE.
> >> >> >> Training and support from Colfax.
> >> >> >> Order your platform today. http://sdm.link/xeonphi
> >> >> >> _______________________________________________
> >> >> >> 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
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Astun Technology Ltd, The Coach House, 17 West Street, Epsom,
> Surrey,
> >> >> > KT18
> >> >> > 7RL, UK
> >> >> > t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
> >> >> >
> >> >> > iShare - enterprise geographic intelligence platform
> >> >> > GeoServer, PostGIS and QGIS training
> >> >> > Helpdesk and customer portal
> >> >> >
> >> >> > Company registration no. 5410695. Registered in England and Wales.
> >> >> > Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN
> VAT
> >> >> > no.
> >> >> > 864201149.
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > Jo Cook
> >> > t:+44 7930 524 155/twitter:@archaeogeek
> >> >
> >> >
> >> > --
> >> > Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
> >> > KT18
> >> > 7RL, UK
> >> > t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
> >> >
> >> > iShare - enterprise geographic intelligence platform
> >> > GeoServer, PostGIS and QGIS training
> >> > Helpdesk and customer portal
> >> >
> >> > Company registration no. 5410695. Registered in England and Wales.
> >> > Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT
> no.
> >> > 864201149.
> >
> >
> >
> >
> > --
> > Jo Cook
> > t:+44 7930 524 155/twitter:@archaeogeek
> >
> >
> > --
> > Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
> KT18
> > 7RL, UK
> > t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
> >
> > iShare - enterprise geographic intelligence platform
> > GeoServer, PostGIS and QGIS training
> > Helpdesk and customer portal
> >
> > Company registration no. 5410695. Registered in England and Wales.
> > Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
> > 864201149.
>



--
*Jo Cook*
t:+44 7930 524 155/twitter:@archaeogeek

--
--
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 1372 744 009 w: 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/services/#training>
Helpdesk and customer portal
<http://support.astuntechnology.com/support/login>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Loading...