From: Dennis S. <den...@ge...> - 2012-05-11 15:03:24
|
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 |
From: Jose G. <jos...@ge...> - 2012-05-11 15:18:49
|
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 <den...@ge...>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 > Geo...@li... > 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 <http://geocat.net/> * |
From: Dennis S. <den...@ge...> - 2012-05-14 08:23:24
|
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 > <den...@ge... <mailto:den...@ge...>> 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></url> > <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> 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 > Geo...@li... > <mailto:Geo...@li...> > 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/> for details. > _________________________ > Jose García > GeoCat bv > Veenderweg 13 > 6721 WD Bennekom > The Netherlands > http://GeoCat.net <http://geocat.net/> > > *** 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 |