[GeoNetwork-users] troubleshooting geonetwork

GeoNetwork GeoNetwork User
1

Hi All,

I had to restart my server, and usually geonetwork comes back up no
problem. This time instead the interface comes back up (the jetty server is
working therefore I guess) but I am getting no rreturns on my searches, so
I think it's either not connecting to the mckoi database or something?

I tried googling it and searching the geonetwork manual, but didn't find a
quick troubleshooting answer. How can I quickly check the DB connection
works? Is that something I can do from GAST? I used Druid to connect to
Mckoi and saw that indeed it connects and found some of my added fields to
some of the tables (categories, etc) so I guess the DB is working? Any help
would be much appreciated.

Thanks

G

2

Did you try looking at the log files in the jetty/logs folder.

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/troubleshooting-geonetwork-tp5036797p5036801.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

3

I had that problem recently. I had a java update that broke the database connection. I wound up dropping back to an older version of java and haven't had any more issues.

----------------------------------
Greg Miller
US Geological Survey
600 4th St. South
Saint Petersburg, FL 33701

gmiller@anonymised.com
(508) 287-7610 - cell

On Feb 25, 2013, at 5:02 PM, Giuseppe Molinario <g.molinario@anonymised.com> wrote:

Hi All,

I had to restart my server, and usually geonetwork comes back up no
problem. This time instead the interface comes back up (the jetty server is
working therefore I guess) but I am getting no rreturns on my searches, so
I think it's either not connecting to the mckoi database or something?

I tried googling it and searching the geonetwork manual, but didn't find a
quick troubleshooting answer. How can I quickly check the DB connection
works? Is that something I can do from GAST? I used Druid to connect to
Mckoi and saw that indeed it connects and found some of my added fields to
some of the tables (categories, etc) so I guess the DB is working? Any help
would be much appreciated.

Thanks

G
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
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

4

Hi Ian,

What am I looking for in the logs?

Essentially since jetty and the geonetwork interface work correctly, the
problem should either be that the connection to the database is broken, or
the database server is not on ? does the mckoi DB have an on and off state
? Sorry if that's a stupid question.

Thanks

G

On Mon, Feb 25, 2013 at 5:21 PM, ianwallen <ianwallen@anonymised.com> wrote:

Did you try looking at the log files in the jetty/logs folder.

--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/troubleshooting-geonetwork-tp5036797p5036801.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
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

5

Also - if this might help you frame the problem, the layers under "recent
changes" appear in the list, if I click on them the data appears in the
metadata view, and I can also access the "edit" page for it. But those are
the only layers I see, if i search for anything the layers don't display in
the metadata area.

also i know the DB is working because I can see that it pulls my custom
country layers and my custom data categories.

this is the link

congo.iluci.org/dataexplorer

thanks

g

On Wed, Feb 27, 2013 at 11:49 AM, Giuseppe Molinario
<g.molinario@anonymised.com>wrote:

Hi Ian,

What am I looking for in the logs?

Essentially since jetty and the geonetwork interface work correctly, the
problem should either be that the connection to the database is broken, or
the database server is not on ? does the mckoi DB have an on and off state
? Sorry if that's a stupid question.

Thanks

G

On Mon, Feb 25, 2013 at 5:21 PM, ianwallen <ianwallen@anonymised.com> wrote:

Did you try looking at the log files in the jetty/logs folder.

--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/troubleshooting-geonetwork-tp5036797p5036801.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
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

6

Hi Giuseppe

A fast way to check if database is working is to login in GeoNetwork. If
using 2.6.x you'll get most probably a NullPointerException if database
connection is not working.

If you can log in the system, try to reindex the catalog, most probably the
problem of no results is related to a problem with lucene index. Login as
Administrator user, go to Administration page and hit the button to
Reindex the catalog. After that check if search works again.

Also for a production site I would recommend to use Postgres/MySql
databases instead of McKoi. McKoi is not a bad database, but lack of tools
to manage it properly.

Regards,
Jose gGarcía

On Wed, Feb 27, 2013 at 5:57 PM, Giuseppe Molinario
<g.molinario@anonymised.com>wrote:

Also - if this might help you frame the problem, the layers under "recent
changes" appear in the list, if I click on them the data appears in the
metadata view, and I can also access the "edit" page for it. But those are
the only layers I see, if i search for anything the layers don't display in
the metadata area.

also i know the DB is working because I can see that it pulls my custom
country layers and my custom data categories.

this is the link

congo.iluci.org/dataexplorer

thanks

g

On Wed, Feb 27, 2013 at 11:49 AM, Giuseppe Molinario
<g.molinario@anonymised.com>wrote:

> Hi Ian,
>
> What am I looking for in the logs?
>
> Essentially since jetty and the geonetwork interface work correctly, the
> problem should either be that the connection to the database is broken,
or
> the database server is not on ? does the mckoi DB have an on and off
state
> ? Sorry if that's a stupid question.
>
> Thanks
>
> G
>
>
>
> On Mon, Feb 25, 2013 at 5:21 PM, ianwallen <ianwallen@anonymised.com>
wrote:
>
>> Did you try looking at the log files in the jetty/logs folder.
>>
>>
>>
>> --
>> View this message in context:
>>
http://osgeo-org.1560.n6.nabble.com/troubleshooting-geonetwork-tp5036797p5036801.html
>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>
>>
>>
------------------------------------------------------------------------------
>> Everyone hates slow websites. So do we.
>> Make your web apps faster with AppDynamics
>> Download AppDynamics Lite for free today:
>> http://p.sf.net/sfu/appdyn_d2d_feb
>> _______________________________________________
>> 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
>>
>
>

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
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 for details.
_________________________
Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net/&gt;

*