[NAS-2673] Create script referred to in NAS 5.2 Postgresql installation documentation contains error Created: 20/Sep/17  Updated: 02/Jul/18  Resolved: 02/Jul/18

Status: Ready for release test
Project: NetarchiveSuite
Component/s: None
Affects Version/s: 5.2.2, 5.3, 5.3.1
Fix Version/s: 5.4

Type: Bug Priority: Minor
Reporter: Søren Vejrup Carlsen (Inactive) Assignee: Søren Vejrup Carlsen (Inactive)
Resolution: Fixed  
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to NAS-2681 Improve the Postgresql documentation Resolved
Organization:
SB/KB
External reference:

https://sbprojects.statsbiblioteket.dk/jira/browse/NARK-1345

 Description   

It seems that the scripts bundled with NAS release 5.2.2 release in scripts/sql/createHarvestDB.pgsql
have errors.
cf. https://sbforge.org/display/NASDOC52/Choose+an+Installation+Scenario#ChooseanInstallationScenario-PostgreSQLDatabase

The 'harvestdefinitions' table created has the wrong schemaversion '4'
Also the harvestchannel lacks a 'issnapshot' field

A workaround for this is the following

drop table harvestchannel;
delete from schemaversions where tablename='harvestchannel';
update schemaversions set version='3' where tablename='harvestdefinitions';
\q

The run update_external_harvest_database.sh again

 Comments   
Comment by Søren Vejrup Carlsen (Inactive) [ 28/Jun/18 ]

Code in branch https://github.com/netarchivesuite/netarchivesuite/tree/NAS-2673 has now been merged with master

Comment by Søren Vejrup Carlsen (Inactive) [ 28/Jun/18 ]

The two scripts

scripts/postgresql/createHarvestDB.pgsql
scripts/postgresql/createAdminDB.pgsql

are now the primary scripts used by the postgresql installation.

Furthemore the documentation on https://sbforge.org/display/NASDOC54/Choose+an+Installation+Scenario#ChooseanInstallationScenario-PostgreSQLDatabase

now refers to a deploy configuration script for an quickstart installation using postgresql as database backend.

Comment by Søren Vejrup Carlsen (Inactive) [ 25/Oct/17 ]

The solution is to fix the scripts in the scripts/postgresql instead of referring to the scripts in the scripts/sql folder as the current documentation does.

Comment by Søren Vejrup Carlsen (Inactive) [ 20/Sep/17 ]

You still need to add default_orderxml template before you can start Netarchivesuite.
The GUIApplication will die with an exception

11:09:07.220 ERROR d.n.h.w.DefinitionsSiteSection - The default order template 'default_orderxml' does not exist in the template DAO. Please use the dk.netarkivet.harvester.tools.HarvestTemplateApplicationV tool to upload this template before loading the Definitions site section in the GUIApplication
11:09:07.230 ERROR d.n.common.utils.ApplicationUtils - Could not start class dk.netarkivet.common.webinterface.GUIWebServer

Use the dk.netarkivet.harvester.tools.HarvestTemplateApplication tool to upload at least one template named 'default_orderxml'
described here: https://sbforge.org/display/NASDOC52/Tools+in+the+Harvester+Module

Comment by Søren Vejrup Carlsen (Inactive) [ 20/Sep/17 ]

This gives us the default harvestchannel LOWPRIORITY and HIGHPRIORITY
The harvesters in your configuration must be allocated one of these channels using the harvesting.channel setting

<harvesting> <channel>HIGHPRIORITY</channel>
...
</harvesting>

Otherwise they will just sit around idle forever

Generated at Thu Apr 25 11:22:53 CEST 2024 using Jira 9.4.15#940015-sha1:bdaa9cbecfb6791ea579749728cab771f0dfe90b.