I have installed Geonetwork 2.8.2 (branch28-2012-11-26) in Tomcat 7.0 and
using PostgreSQL 8.4 for the database.
In the config file I have set the database up to use postgres but instead of
naming the database 'geonetwork' I called it 'gn282' as I'm testing this
setup at the moment. Therefore the connection url is
<url>jdbc:postgresql://xxx.xxx.x.xx:5432/gn282</url>.
When Geonetwork starts the categories don't show and the dropdown list for
region only as 'Any' & 'User-Defined'. The log shows the standard "no
pg_hba.conf entry" error but instead of the database name 'gn282' being used
it's trying with the default database name 'geonetwork'.
/FATAL: no pg_hba.conf entry for host "192.168.0.50", user "PAC_GNET_USR",
database "geonetwork", SSL off/
I'm fine to return to using 'geonetwork' as my database name. But, if I can
choose to declare a different database name in the config file it should be
recognized across the application. Is there another way to declare the
database name to use?
Abe.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/new-postgresql-database-name-not-fully-recognized-tp5021563.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
Hi Abe,
Did you run web\geonetwork\WEB-INF\classes\setup\sql\data\loc-eng-default.sql
or the loc-<yourLanguage>-default.sql file?
This adds localised categories, regions
etc. to the db tables. Could be the reason you don't see the categories listed.
Pretty sure you can use any name you like for the postgres db, it doesn't
have to be 'geonetwork'
HTH
Andrew
----- Original Message ----- From: "rac88" <rac88@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Saturday, December 08, 2012 11:33 AM
Subject: [GeoNetwork-users] new postgresql database name not fully recognized
I have installed Geonetwork 2.8.2 (branch28-2012-11-26) in Tomcat 7.0 and
using PostgreSQL 8.4 for the database.
In the config file I have set the database up to use postgres but instead of
naming the database 'geonetwork' I called it 'gn282' as I'm testing this
setup at the moment. Therefore the connection url is
<url>jdbc:postgresql://xxx.xxx.x.xx:5432/gn282</url>.
When Geonetwork starts the categories don't show and the dropdown list for
region only as 'Any' & 'User-Defined'. The log shows the standard "no
pg_hba.conf entry" error but instead of the database name 'gn282' being used
it's trying with the default database name 'geonetwork'.
/FATAL: no pg_hba.conf entry for host "192.168.0.50", user "PAC_GNET_USR",
database "geonetwork", SSL off/
I'm fine to return to using 'geonetwork' as my database name. But, if I can
choose to declare a different database name in the config file it should be
recognized across the application. Is there another way to declare the
database name to use?
Abe.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/new-postgresql-database-name-not-fully-recognized-tp5021563.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
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
Hi Abe
Please check the connection you have configured has the enable attribute to
true and no other database connection has the same value.
Regards,
Jose García
On Sun, Dec 9, 2012 at 11:37 PM, andrew walsh <awalsh@anonymised.com> wrote:
Hi Abe,
Did you run
web\geonetwork\WEB-INF\classes\setup\sql\data\loc-eng-default.sql
or the loc-<yourLanguage>-default.sql file?
This adds localised categories, regions
etc. to the db tables. Could be the reason you don't see the categories
listed.
Pretty sure you can use any name you like for the postgres db, it doesn't
have to be 'geonetwork'
HTH
Andrew
----- Original Message -----
From: "rac88" <rac88@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Saturday, December 08, 2012 11:33 AM
Subject: [GeoNetwork-users] new postgresql database name not fully
recognized
>I have installed Geonetwork 2.8.2 (branch28-2012-11-26) in Tomcat 7.0 and
> using PostgreSQL 8.4 for the database.
>
> In the config file I have set the database up to use postgres but
instead of
> naming the database 'geonetwork' I called it 'gn282' as I'm testing this
> setup at the moment. Therefore the connection url is
> <url>jdbc:postgresql://xxx.xxx.x.xx:5432/gn282</url>.
>
> When Geonetwork starts the categories don't show and the dropdown list
for
> region only as 'Any' & 'User-Defined'. The log shows the standard "no
> pg_hba.conf entry" error but instead of the database name 'gn282' being
used
> it's trying with the default database name 'geonetwork'.
>
> /FATAL: no pg_hba.conf entry for host "192.168.0.50", user
"PAC_GNET_USR",
> database "geonetwork", SSL off/
>
> I'm fine to return to using 'geonetwork' as my database name. But, if I
can
> choose to declare a different database name in the config file it should
be
> recognized across the application. Is there another way to declare the
> database name to use?
>
> Abe.
>
>
>
>
>
> --
> View this message in context:
>
http://osgeo-org.1560.n6.nabble.com/new-postgresql-database-name-not-fully-recognized-tp5021563.html
> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>
>
------------------------------------------------------------------------------
> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
> Remotely access PCs and mobile devices and provide instant support
> Improve your efficiency, and focus on delivering more value-add services
> Discover what IT Professionals Know. Rescue delivers
> http://p.sf.net/sfu/logmein_12329d2d
> _______________________________________________
> 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
>
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
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/>
*