[GeoNetwork-devel] Updating Settings table but old values still in administrative System Information page

GeoNetwork GeoNetwork Developer
1

Hi,

I'm running GeoNetwork 2.8.0 with Tomcat 6. I have a sysadmin procedure that updates the Settings table directly via SQL to set some of the System Information parameters.

For example:

  UPDATE Settings
  SET VALUE = 'My Custom GeoNetwork Catalog'
  WHERE NAME = 'name' AND PARENTID = (
    SELECT ID
    FROM settings
    WHERE NAME = 'site' AND PARENTID = (
      SELECT ID
      FROM settings
      WHERE NAME = 'system' AND PARENTID = (
        SELECT ID
        FROM settings
        WHERE NAME = 'root' AND PARENTID IS NULL
      )
    )
  );

This SQL updates that Settings table correctly, but the Administration's System Information page still shows the old values. Even after restarting the Tomcat server. I cannot find a WEB-INF/config*.xml file that has these settings information -- although they are in the initialization script WEB-INF/classes/setup/sql/data/data-db-default.sql.

So, my question is how do I refresh the Administration interface to use the Settings table data after an update?

Thanks,
-Darren

--
Darren Hardy
drh@anonymised.com
GIS Software Engineer
Digital Library Systems and Services
Stanford University

2

Hi Darren

The settings are keep in memory cache and are not reloaded from database while GeoNetwork is running, so the only way is to update them while GeoNetwork is running is from UI.

But is bizarre what you say about updating directly the database and restart GeoNetwork. Then the changes should be taken, as the information is loaded from the database on startup (at least it use to work). I know probably you already checked, but just in case, verify GeoNetwork is using the database you’re updating. In Administration > System information you can verify the database connection used.

Regards,
Jose García

On Tue, Apr 2, 2013 at 8:25 PM, Darren Hardy <drh@anonymised.com> wrote:

Hi,

I’m running GeoNetwork 2.8.0 with Tomcat 6. I have a sysadmin procedure that updates the Settings table directly via SQL to set some of the System Information parameters.

For example:

UPDATE Settings
SET VALUE = ‘My Custom GeoNetwork Catalog’
WHERE NAME = ‘name’ AND PARENTID = (
SELECT ID
FROM settings
WHERE NAME = ‘site’ AND PARENTID = (
SELECT ID
FROM settings
WHERE NAME = ‘system’ AND PARENTID = (
SELECT ID
FROM settings
WHERE NAME = ‘root’ AND PARENTID IS NULL
)
)
);

This SQL updates that Settings table correctly, but the Administration’s System Information page still shows the old values. Even after restarting the Tomcat server. I cannot find a WEB-INF/config*.xml file that has these settings information – although they are in the initialization script WEB-INF/classes/setup/sql/data/data-db-default.sql.

So, my question is how do I refresh the Administration interface to use the Settings table data after an update?

Thanks,
-Darren

–
Darren Hardy
drh@anonymised.com
GIS Software Engineer
Digital Library Systems and Services
Stanford University

Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html

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

–

GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net for details.

Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net

3

Hi again,

I've tried kicking the GeoNetwork web app via the Tomcat manager, purging the sessions, restarting Tomcat entirely, and restarting Apache too. But none of these methods causes the system configuration to change. The only way to change the values is to use the UI directly as far as I can see.

Perhaps there's some cache or modification date setting in the database that needs to be purged?

Thanks,
-Darren

--
FYI -- the geonetwork.log says:

2013-04-04 10:39:14,971 INFO [jeeves.request] - HTML Request (from 171.66.16.184) : /geonetwork/srv/eng/xml.config.get
2013-04-04 10:39:14,971 DEBUG [jeeves.request] - Method : POST
2013-04-04 10:39:14,971 DEBUG [jeeves.request] - Content type : application/xml
2013-04-04 10:39:14,971 DEBUG [jeeves.request] - Accept : text/javascript, text/html, application/xml, text/xml, */*
2013-04-04 10:39:14,971 DEBUG [jeeves.request] - Session id is 7C834D6431C6AACDD024AD64EC16D77F
2013-04-04 10:39:14,973 INFO [jeeves.service] - Dispatching : xml.config.get
2013-04-04 10:39:14,973 DEBUG [jeeves.service] - -> no input parameters
2013-04-04 10:39:14,978 INFO [jeeves.service] - -> dispatching to output for : xml.config.get
2013-04-04 10:39:14,978 INFO [jeeves.service] - -> writing xml for : xml.config.get
2013-04-04 10:39:14,979 DEBUG [jeeves.service] - Service xml is :
<config>
  <site>
    <name>My GeoNetwork name...</name> <--- *** This is the OLD value ***
    <siteId>46f5596d-2bfe-44c8-ad38-6afdf719d231</siteId>
    <organization>My org...</organization>
    <svnUuid>741b1e73-fef7-428a-b479-932a878b72fa</svnUuid>
  </site>
[...]
--
Darren Hardy
drh@anonymised.com
GIS Software Engineer
Digital Library Systems & Services
Stanford University Libraries

On Apr 2, 2013, at 11:35 AM, Jose Garcia <jose.garcia@anonymised.com> wrote:

Hi Darren

The settings are keep in memory cache and are not reloaded from database while GeoNetwork is running, so the only way is to update them while GeoNetwork is running is from UI.

But is bizarre what you say about updating directly the database and restart GeoNetwork. Then the changes should be taken, as the information is loaded from the database on startup (at least it use to work). I know probably you already checked, but just in case, verify GeoNetwork is using the database you're updating. In Administration > System information you can verify the database connection used.

Regards,
Jose García

On Tue, Apr 2, 2013 at 8:25 PM, Darren Hardy <drh@anonymised.com> wrote:
Hi,

I'm running GeoNetwork 2.8.0 with Tomcat 6. I have a sysadmin procedure that updates the Settings table directly via SQL to set some of the System Information parameters.

For example:

  UPDATE Settings
  SET VALUE = 'My Custom GeoNetwork Catalog'
  WHERE NAME = 'name' AND PARENTID = (
    SELECT ID
    FROM settings
    WHERE NAME = 'site' AND PARENTID = (
      SELECT ID
      FROM settings
      WHERE NAME = 'system' AND PARENTID = (
        SELECT ID
        FROM settings
        WHERE NAME = 'root' AND PARENTID IS NULL
      )
    )
  );

This SQL updates that Settings table correctly, but the Administration's System Information page still shows the old values. Even after restarting the Tomcat server. I cannot find a WEB-INF/config*.xml file that has these settings information -- although they are in the initialization script WEB-INF/classes/setup/sql/data/data-db-default.sql.

So, my question is how do I refresh the Administration interface to use the Settings table data after an update?

Thanks,
-Darren

--
Darren Hardy
drh@anonymised.com
GIS Software Engineer
Digital Library Systems and Services
Stanford University

------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net for details.
_________________________
Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net