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 <
chris.woelkers@anonymised.com> 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 <jocook@anonymised.com>
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
> <chris.woelkers@anonymised.com> 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 <jocook@anonymised.com>
>> 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
>> > <chris.woelkers@anonymised.com> 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 <jocook@anonymised.com>
>> >> 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
>> >> > <chris.woelkers@anonymised.com> 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
>> >> >> GeoNetwork-users@lists.sourceforge.net
>> >> >> 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.