[GeoNetwork-users] Upgrading doesn't seem to change version

GeoNetwork GeoNetwork User
,
1

Hello,

I'm in the process of upgrading a geonetwork 2.10.3 install to 2.10.4. I am
using tomcat6 and a war file, and my database is postgis. Thanks to some
good advice I received a while ago on the list, I have a good procedure for
doing the upgrade, by cloning my database, deploying a new war and pointing
the new war at the new database. However, this doesn't seem to increase the
version number- although I can confirm in the administration settings that
I am viewing my new installation with my new database.

I can see that the version number is stored in the settings table in the
database, and I can see that
WEB-INF/classes/setup/sql/migrate/v2100/migrate-default.sql includes the
SQL statement to upgrade the database, so I assume this isn't being called.
I have checked the other upgrades in migrate-db-postgis.sql and everything
looks correct. When I restart tomcat6 my new geonetwork installation and my
old one are both working side by side, and I can't see any obvious errors
in the log files.

So, I was wondering what the procedure is that calls the
migrate-default.sql- so I can check whether that's happening or not?

Thanks

Jo

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

2

Hi Jo

When GeoNetwork startups, checks the information from WEB-INF/server.prop
againts the settings table

In WEB-INF/server.prop of 2.10.4:
version=2.10.4-0

If your database has a version 2.10.3, that should trigger the migration,
checking in WEB-INF/classes/setup/sql/migrate/v2104 the migrations to apply.

But WEB-INF/classes/setup/sql/migrate/ contains only the folder v2100. This
means that no db changes is the minor releases of 2.10. In any case should
be created a folder v2101, v2102, etc. for each minor release that contains
the update sql from the version in the settings table.

Regards,
Jose García

On Fri, Jan 23, 2015 at 2:30 PM, Jo Cook <jocook@anonymised.com> wrote:

Hello,

I'm in the process of upgrading a geonetwork 2.10.3 install to 2.10.4. I am
using tomcat6 and a war file, and my database is postgis. Thanks to some
good advice I received a while ago on the list, I have a good procedure for
doing the upgrade, by cloning my database, deploying a new war and pointing
the new war at the new database. However, this doesn't seem to increase the
version number- although I can confirm in the administration settings that
I am viewing my new installation with my new database.

I can see that the version number is stored in the settings table in the
database, and I can see that
WEB-INF/classes/setup/sql/migrate/v2100/migrate-default.sql includes the
SQL statement to upgrade the database, so I assume this isn't being called.
I have checked the other upgrades in migrate-db-postgis.sql and everything
looks correct. When I restart tomcat6 my new geonetwork installation and my
old one are both working side by side, and I can't see any obvious errors
in the log files.

So, I was wondering what the procedure is that calls the
migrate-default.sql- so I can check whether that's happening or not?

Thanks

Jo

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
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

--

*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/&gt; for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*

3

Hi Jose,

Thanks for the quick response- so is it safe to update the settings table
so that the correct version is reported in the administration section?

Jo

On Fri, Jan 23, 2015 at 2:58 PM, Jose Garcia <jose.garcia@anonymised.com> wrote:

Hi Jo

When GeoNetwork startups, checks the information from WEB-INF/server.prop
againts the settings table

In WEB-INF/server.prop of 2.10.4:
version=2.10.4-0

If your database has a version 2.10.3, that should trigger the migration,
checking in WEB-INF/classes/setup/sql/migrate/v2104 the migrations to apply.

But WEB-INF/classes/setup/sql/migrate/ contains only the folder v2100.
This means that no db changes is the minor releases of 2.10. In any case
should be created a folder v2101, v2102, etc. for each minor release that
contains the update sql from the version in the settings table.

Regards,
Jose García

On Fri, Jan 23, 2015 at 2:30 PM, Jo Cook <jocook@anonymised.com>
wrote:

Hello,

I'm in the process of upgrading a geonetwork 2.10.3 install to 2.10.4. I
am
using tomcat6 and a war file, and my database is postgis. Thanks to some
good advice I received a while ago on the list, I have a good procedure
for
doing the upgrade, by cloning my database, deploying a new war and
pointing
the new war at the new database. However, this doesn't seem to increase
the
version number- although I can confirm in the administration settings that
I am viewing my new installation with my new database.

I can see that the version number is stored in the settings table in the
database, and I can see that
WEB-INF/classes/setup/sql/migrate/v2100/migrate-default.sql includes the
SQL statement to upgrade the database, so I assume this isn't being
called.
I have checked the other upgrades in migrate-db-postgis.sql and everything
looks correct. When I restart tomcat6 my new geonetwork installation and
my
old one are both working side by side, and I can't see any obvious errors
in the log files.

So, I was wondering what the procedure is that calls the
migrate-default.sql- so I can check whether that's happening or not?

Thanks

Jo

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
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

--

*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/&gt; for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

4

Hi Jo

I guess so, you'll have to restart GeoNetwork after the database change as
the settings are keep in memory.

Regards,
Jose García

On Fri, Jan 23, 2015 at 4:11 PM, Jo Cook <jocook@anonymised.com> wrote:

Hi Jose,

Thanks for the quick response- so is it safe to update the settings table
so that the correct version is reported in the administration section?

Jo

On Fri, Jan 23, 2015 at 2:58 PM, Jose Garcia <jose.garcia@anonymised.com>
wrote:

Hi Jo

When GeoNetwork startups, checks the information from WEB-INF/server.prop
againts the settings table

In WEB-INF/server.prop of 2.10.4:
version=2.10.4-0

If your database has a version 2.10.3, that should trigger the migration,
checking in WEB-INF/classes/setup/sql/migrate/v2104 the migrations to apply.

But WEB-INF/classes/setup/sql/migrate/ contains only the folder v2100.
This means that no db changes is the minor releases of 2.10. In any case
should be created a folder v2101, v2102, etc. for each minor release that
contains the update sql from the version in the settings table.

Regards,
Jose García

On Fri, Jan 23, 2015 at 2:30 PM, Jo Cook <jocook@anonymised.com>
wrote:

Hello,

I'm in the process of upgrading a geonetwork 2.10.3 install to 2.10.4. I
am
using tomcat6 and a war file, and my database is postgis. Thanks to some
good advice I received a while ago on the list, I have a good procedure
for
doing the upgrade, by cloning my database, deploying a new war and
pointing
the new war at the new database. However, this doesn't seem to increase
the
version number- although I can confirm in the administration settings
that
I am viewing my new installation with my new database.

I can see that the version number is stored in the settings table in the
database, and I can see that
WEB-INF/classes/setup/sql/migrate/v2100/migrate-default.sql includes the
SQL statement to upgrade the database, so I assume this isn't being
called.
I have checked the other upgrades in migrate-db-postgis.sql and
everything
looks correct. When I restart tomcat6 my new geonetwork installation and
my
old one are both working side by side, and I can't see any obvious errors
in the log files.

So, I was wondering what the procedure is that calls the
migrate-default.sql- so I can check whether that's happening or not?

Thanks

Jo

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
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

--

*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata
on GeoServer and GeoNetwork. Visit http://geocat.net
<http://geocat.net/&gt; for details. _________________________Jose
GarcíaGeoCat bvVeenderweg 136721 WD BennekomThe
Netherlandshttp://GeoCat.net/>*

--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/&gt;

*****************************************

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

--

*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/&gt; for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*