Catalog installation

Download new version

• Catalog are created on every commit by http://ci.titellus.net/job/GeoNetwork-eea/
• Download WAR files from http://files.titellus.net/geonetwork/eea/

export CATALOG_DIR=/home/paul/deliveries
cd $CATALOG_DIR

todaydate=$(date +%Y%m%d)
mkdir $todaydate
cd $todaydate

wget http://files.titellus.net/geonetwork/eea/eea-catalogues-3.2.x.tar.gz 
tar zxf eea-catalogues-3.2.x.tar.gz 

Backup databases

cd /var/local/postgresql/backups
dblist="geonetwork_sdi geonetwork_sdi_public geonetwork_sdi_editor"
dbserver=iguana.eea.europa.eu
dbuser=geonetwork
for db in $dblist; do
  pg_dump -h $dbserver -p 5432 -U $dbuser --role $dbuser -f $db\_$todaydate.tar --format tar --blobs --encoding UTF8 -v --inserts  $db
done;

or in PgAdmin

• connect to Iguana
• Backup database (right click on database name)
• Format: Tar
• Encoding: UTF-8
• Rolename: geonetwork
• File: in .../EEA-SDI/catalogue_backup/xyz.tar

Migrate database if needed

Check if any SQL migration scripts available: https://github.com/eea/geonetwork-eea/tree/3.2.x/web/src/main/webapp/WEB-INF/classes/setup/sql-eea

Note: do not use postgres, use the owner (ie. geonetwork)

wget https://github.com/eea/geonetwork-eea/blob/eea-develop/web/src/main/webapp/WEB-INF/classes/setup/sql-eea/db-migrate-201604.sql
for db in $dblist; do
  psql -h $dbserver -p 5432 -U $dbuser -f db-migrate-201604.sql $db
done;

or in PgAdmin

• connect to Iguana
• connect to target database
• open SQL windows and use it to apply the changes.

Update WAR with Tomcat manager

Use Tomcat manager to:

• undeploy catalogue, internal-catalogue, editor-catalogue
• stop Tomcat

sudo pkill -fu tomcat apache-tomcat-7.0.59-catalogues

• start Tomcat

sudo /etc/init.d/tomcat-catalogues start

• deploy the new WARs with:
• context path /catalogue, WAR file /home/paul/deliveries/$todaydate/target/catalogue.war.
• context path /internal-catalogue, WAR file /home/paul/deliveries/$todaydate/target/internal-catalogue.war.
• context path /editor-catalogue, WAR file /home/paul/deliveries/$todaydate/target/editor-catalogue.war.

Update WAR manually

pkill -fr tomcat apache-tomcat-7.0.59-catalogues
rm -rf /usr/local/share/applications/apache-tomcat-7.0.59-catalogues/webapps/*catatalogue*
cp /home/paul/deliveries/$todaydate/target/*.war /usr/local/share/applications/apache-tomcat-7.0.59-catalogues/webapps/.
sudo /etc/init.d/tomcat-catalogues start

Check the app is running

• http://sdi.eea.europa.eu/catalogue/
• https://sdi.eea.europa.eu/internal-catalogue/
• https://sdi.eea.europa.eu/editor-catalogue/

Check the log files

In a console, run:

tail -f /var/local/www-logs/tomcat-catalogues/catalina.out

CTRL+C to stop.