[GeoNetwork-users] Geonetwork & PostgreSQL/PostGIS

Hello everyone,

I want to set up Geonetwork (2.6.4 on Windows XP) for a specific country and try to adapt the drop-down-menu for the countries in the search function. The default db handling with mckoi is insufficient for me, so I want to use PostgreSQL for the database stuff.
I followed the instructions in the link (http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf), but after configuration the drop-down-menu shows only the values '- Any -' and '- User defined -'. Furthermore, the application categories in the left menu are missing.
When I open the database geonetwork with pgAdmin, there are 25 tables including regions and regionsdes. Those look exactly like the basic tables in mckoi. Does anybody know a solution?

Cheers,

D. Stroeer

##### config.xml #####

<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>
<user>geonetwork</user>
<password>geonetwork</password>
<driver>org.postgresql.Driver</driver>

<url>jdbc:postgresql://127.0.0.1/geonetwork</url>
<poolSize>10</poolSize>
</config>
</resource>

##### pg_hba.conf #####

# IPv4 local connections:
host all all 127.0.0.1/32 md5

Hi Dennis

Please check the log files, if categories are not displayed seems a
database connection issue.

Seem from what you say that tables are in the database, can you verify also
if tables contain data?

Regards,
Jose García

On Fri, May 11, 2012 at 4:50 PM, Dennis Ströer
<dennis.stroeer@anonymised.com>wrote:

Hello everyone,

I want to set up Geonetwork (2.6.4 on Windows XP) for a specific country
and try to adapt the drop-down-menu for the countries in the search
function. The default db handling with mckoi is insufficient for me, so
I want to use PostgreSQL for the database stuff.
I followed the instructions in the link
(
http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf
),
but after configuration the drop-down-menu shows only the values '- Any
-' and '- User defined -'. Furthermore, the application categories in
the left menu are missing.
When I open the database geonetwork with pgAdmin, there are 25 tables
including regions and regionsdes. Those look exactly like the basic
tables in mckoi. Does anybody know a solution?

Cheers,

D. Stroeer

##### config.xml #####

<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>
<user>geonetwork</user>
<password>geonetwork</password>
<driver>org.postgresql.Driver</driver>

<url>jdbc:postgresql://127.0.0.1/geonetwork</url>
<poolSize>10</poolSize>
</config>
</resource>

##### pg_hba.conf #####

# IPv4 local connections:
host all all 127.0.0.1/32 md5

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
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;

*

Am 11.05.2012 17:18, schrieb Jose Garcia:

Hi Dennis

Please check the log files, if categories are not displayed seems a database connection issue.

Seem from what you say that tables are in the database, can you verify also if tables contain data?

Regards,
Jose García

On Fri, May 11, 2012 at 4:50 PM, Dennis Ströer <dennis.stroeer@anonymised.com <mailto:dennis.stroeer@anonymised.com>> wrote:

    Hello everyone,

    I want to set up Geonetwork (2.6.4 on Windows XP) for a specific
    country
    and try to adapt the drop-down-menu for the countries in the search
    function. The default db handling with mckoi is insufficient for
    me, so
    I want to use PostgreSQL for the database stuff.
    I followed the instructions in the link
    (http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf),
    but after configuration the drop-down-menu shows only the values
    '- Any
    -' and '- User defined -'. Furthermore, the application categories in
    the left menu are missing.
    When I open the database geonetwork with pgAdmin, there are 25 tables
    including regions and regionsdes. Those look exactly like the basic
    tables in mckoi. Does anybody know a solution?

    Cheers,

    D. Stroeer

    ##### config.xml #####

    <resource enabled="true">
    <name>main-db</name>
    <provider>jeeves.resources.dbms.DbmsPool</provider>
    <config>
    <user>geonetwork</user>
    <password>geonetwork</password>
    <driver>org.postgresql.Driver</driver>

    <url>jdbc:postgresql://127.0.0.1/geonetwork
    <http://127.0.0.1/geonetwork&gt;&lt;/url&gt;
    <poolSize>10</poolSize>
    </config>
    </resource>

    ##### pg_hba.conf #####

    # IPv4 local connections:
    host all all 127.0.0.1/32 <http://127.0.0.1/32&gt; md5
    ------------------------------------------------------------------------------
    Live Security Virtual Conference
    Exclusive live event will cover all the ways today's security and
    threat landscape has changed and how IT managers can respond.
    Discussions
    will include endpoint security, mobile security and the latest in
    malware
    threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
    _______________________________________________
    GeoNetwork-users mailing list
    GeoNetwork-users@lists.sourceforge.net
    <mailto: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ía
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net/&gt;

***

Hello Jose,

thanks for your advice. The log file contained a reference for the solution. The owner of the new database was correct but the owner of the single tables was wrong! After changing that, everything works fine.

Cheers,
D. Stroeer