[Geoserver-users] Geoserver monitoring problem

GeoServer GeoServer User
1

Hi,

im working with monitoring hibernate extension. Database for output
informations is set to H2 database. When I try to read the H2 files with
RazorSQL, it says:

Unsupported database file version or invalid file header in file "Old
database:
C:/Program Files (x86)/GeoServer
2.3.1/data_dir/monitoring/monitoring.data.db
- please convert the database to a SQL script
and re-create it." [90048-166]

The same problem was , when i tried to open the monitoring.data.db file with
OpenOffice or attach it to H2 database.

Did someone have experience with this problem ?

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-monitoring-problem-tp5049628.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

On Thu, Apr 25, 2013 at 2:52 PM, gabriel <gpetricek@anonymised.com> wrote:

Hi,

im working with monitoring hibernate extension. Database for output
informations is set to H2 database. When I try to read the H2 files with
RazorSQL, it says:

Unsupported database file version or invalid file header in file "Old
database:
C:/Program Files (x86)/GeoServer
2.3.1/data_dir/monitoring/monitoring.data.db
- please convert the database to a SQL script
and re-create it." [90048-166]

The same problem was , when i tried to open the monitoring.data.db file
with
OpenOffice or attach it to H2 database.

Did someone have experience with this problem ?

Never tried to read the H2 databases with anything other than SquirrelSQL
using the same driver jar GeoServer uses, which of course works, but
we are indeed using a rather old version of H2.

Upgrading it to a more recent version is not exactly an easy task, as we
need to upgrade at the same time GeoTools, GeoWebCache and GeoServer,
plus, hard to get the right version, the db format changed a few times, if
we pick a too recent one those tools might not be able to open it for
the opposite issue (too new of a format)

Cheers
Andrea

--

GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

3

Thank you for your advice. Now i have another problem with Squirrel SQL. I
tried to connect H2 files, but it seems, that at start many db drivers
cannot be found. I have red cross next to each H2 driver except on JDBC ODBC
Bridge. Im using version 3.4.0.

Can you tell me other advices , how to make connection with those H2 files
created by Geoserver?

Best regards

Gabriel

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-monitoring-problem-tp5049628p5049802.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

4

On Fri, Apr 26, 2013 at 8:29 AM, gabriel <gpetricek@anonymised.com> wrote:

Thank you for your advice. Now i have another problem with Squirrel SQL. I
tried to connect H2 files, but it seems, that at start many db drivers
cannot be found. I have red cross next to each H2 driver except on JDBC
ODBC
Bridge. Im using version 3.4.0.

Yes, you have to configure the location of the drivers on disk. Edit the H2
one to
point to the H2 jar contained in the GeoServer own geoserver/WEB-INF/lib
directory

Ah, H2 is an embedded database, so as long as you keep GeoServer running you
won't be able to access it.
If you want concurrent access you better use an external database, such as
postgresql,
see the configuration here:
http://docs.geoserver.org/latest/en/user/extensions/monitoring/db.html#configuration

Cheers
Andrea

--

GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

5

Thank you. Now it works :slight_smile:

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-monitoring-problem-tp5049628p5050157.html
Sent from the GeoServer - User mailing list archive at Nabble.com.