Hello geonetwork-users!
This is my first post on this list, so i introduce myself as geologist and
gdi-administrator in a civil engineering company in germany. I have about
20 years experience with GIS and about 10-15 years with OGC-Webservices and
postgres.
I like to evaluate geonetwork because we need the ability to host a
metadata catalogue and some maps as documentation for our customers.
I have a preexisting tomcat 7 with geoserver and postgresql/postgis
9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
I have installed the geonetwork.war file, which worked. I configured the
database connection in 'WEB-INF/config-node/srv.xml', then i configured
the connection in 'WEB-INF/config-db/jdbc.properties'.
But when i try to start the application in tomcat the following error is
found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
The pg_hba-entry seems also correct because i can login with psql with the
given parameters from the tomcat machine.
So i am a little bit clueless and hope you can help me with some hints.
Thank you in advance for your help.
Uwe Seher
http://pastebin.com/0K1U2Yqj
Hi Uwe
Seem an issue of your Postgres configuration. See this error:
FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
database "geonetwork", SSL off
Check to add the proper configuration, you need to authorise the host/user
to access. Is the database in the same server as GeoNetwork? If so try to
configure the connection with localhost.
Regards,
Jose García
On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com> wrote:
Hello geonetwork-users!
This is my first post on this list, so i introduce myself as geologist and
gdi-administrator in a civil engineering company in germany. I have about
20 years experience with GIS and about 10-15 years with OGC-Webservices and
postgres.
I like to evaluate geonetwork because we need the ability to host a
metadata catalogue and some maps as documentation for our customers.
I have a preexisting tomcat 7 with geoserver and postgresql/postgis
9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
I have installed the geonetwork.war file, which worked. I configured the
database connection in 'WEB-INF/config-node/srv.xml', then i configured
the connection in 'WEB-INF/config-db/jdbc.properties'.
But when i try to start the application in tomcat the following error is
found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
The pg_hba-entry seems also correct because i can login with psql with the
given parameters from the tomcat machine.
So i am a little bit clueless and hope you can help me with some hints.
Thank you in advance for your help.
Uwe Seher
http://pastebin.com/0K1U2Yqj
------------------------------------------------------------------------------
_______________________________________________
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
--
*Vriendelijke groeten / Kind regards,Jose García
<http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT: +31
(0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31655818332>
<https://www.facebook.com/geocatbv> <https://twitter.com/geocat_bv>
<https://plus.google.com/u/1/+GeocatNetbv/posts>Please consider the
environment before printing this email.*
No, the database is on another server. But i can log in with psql from the
tomcat-server with the given credentials. Other applications like geoserver
and jasperreports which run on the same server like geonetwork do not have
problems. Altering the entry in pg_hba has the predicted effect. I had
restarted the database after changes, also the tomcat.
So this is a little strange to me.
Uwe
2015-09-15 16:40 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Uwe
Seem an issue of your Postgres configuration. See this error:
FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
database "geonetwork", SSL off
Check to add the proper configuration, you need to authorise the host/user
to access. Is the database in the same server as GeoNetwork? If so try to
configure the connection with localhost.
Regards,
Jose García
On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com> wrote:
Hello geonetwork-users!
This is my first post on this list, so i introduce myself as geologist and
gdi-administrator in a civil engineering company in germany. I have about
20 years experience with GIS and about 10-15 years with OGC-Webservices
and
postgres.
I like to evaluate geonetwork because we need the ability to host a
metadata catalogue and some maps as documentation for our customers.
I have a preexisting tomcat 7 with geoserver and postgresql/postgis
9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
I have installed the geonetwork.war file, which worked. I configured the
database connection in 'WEB-INF/config-node/srv.xml', then i configured
the connection in 'WEB-INF/config-db/jdbc.properties'.
But when i try to start the application in tomcat the following error is
found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
The pg_hba-entry seems also correct because i can login with psql with the
given parameters from the tomcat machine.
So i am a little bit clueless and hope you can help me with some hints.
Thank you in advance for your help.
Uwe Seher
http://pastebin.com/0K1U2Yqj
------------------------------------------------------------------------------
_______________________________________________
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
--
*Vriendelijke groeten / Kind regards,Jose García
<http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT: +31
(0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31655818332>
<https://www.facebook.com/geocatbv> <https://twitter.com/geocat_bv>
<https://plus.google.com/u/1/+GeocatNetbv/posts>Please consider the
environment before printing this email.*
Hi again!
As i said, login with psql or pgadmin using the geonetwork-user is working
in the local network.
This is the relvant entry in pg_hba.conf:
host geonetwork +gdi,+web 192.168.1.0/24 md5
CU
Uwe
2015-09-15 19:59 GMT+02:00 gannebamm <gannebamm@anonymised.com>:
http://dba.stackexchange.com/questions/83984/connect-to-postgresql-server-fatal-no-pg-hba-conf-entry-for-host
I had this issue with PostgreSQL and needed to add my ip to the conf file
Sent from mobile
---- Uwe Seher schrieb ----
No, the database is on another server. But i can log in with psql from the
tomcat-server with the given credentials. Other applications like geoserver
and jasperreports which run on the same server like geonetwork do not have
problems. Altering the entry in pg_hba has the predicted effect. I had
restarted the database after changes, also the tomcat.
So this is a little strange to me.
Uwe
2015-09-15 16:40 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
> Hi Uwe
>
> Seem an issue of your Postgres configuration. See this error:
>
> FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
> database "geonetwork", SSL off
>
> Check to add the proper configuration, you need to authorise the
host/user
> to access. Is the database in the same server as GeoNetwork? If so try to
> configure the connection with localhost.
>
> Regards,
> Jose García
>
> On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com> wrote:
>
>> Hello geonetwork-users!
>>
>> This is my first post on this list, so i introduce myself as geologist
and
>> gdi-administrator in a civil engineering company in germany. I have
about
>> 20 years experience with GIS and about 10-15 years with OGC-Webservices
>> and
>> postgres.
>> I like to evaluate geonetwork because we need the ability to host a
>> metadata catalogue and some maps as documentation for our customers.
>> I have a preexisting tomcat 7 with geoserver and postgresql/postgis
>> 9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
>> I have installed the geonetwork.war file, which worked. I configured
the
>> database connection in 'WEB-INF/config-node/srv.xml', then i
configured
>> the connection in 'WEB-INF/config-db/jdbc.properties'.
>> But when i try to start the application in tomcat the following error is
>> found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
>> The pg_hba-entry seems also correct because i can login with psql with
the
>> given parameters from the tomcat machine.
>> So i am a little bit clueless and hope you can help me with some hints.
>>
>> Thank you in advance for your help.
>>
>> Uwe Seher
>>
>>
>> http://pastebin.com/0K1U2Yqj
>>
>>
------------------------------------------------------------------------------
>> _______________________________________________
>> 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
>>
>
>
>
> --
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *Vriendelijke groeten / Kind regards,Jose García
> <http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT:
+31
> (0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31%20(0)655%20818332>
<+31655818332>
> <https://www.facebook.com/geocatbv>&nbsp; <
https://twitter.com/geocat_bv>
> <https://plus.google.com/u/1/+GeocatNetbv/posts>Please
<https://plus.google.com/u/1/+GeocatNetbv/posts>Please> consider the
> environment before printing this email.*
>
------------------------------------------------------------------------------
_______________________________________________
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 Uwe
See comments inline.
Regards,
Jose García
On Wed, Sep 16, 2015 at 8:19 AM, Uwe Seher <uwe.seher@anonymised.com> wrote:
Hi again!
As i said, login with psql or pgadmin using the geonetwork-user is working
in the local network.
Sure, but most probably these applications use local connections instead of
host (tcp/ip). If you check in your file, you should have another entry
like this:
local geonetwork ...
or
local all ...
That explains why these applications worked, but no GeoNetwork that
requires tcp/ip access.
This is the relvant entry in pg_hba.conf:
host geonetwork +gdi,+web 192.168.1.0/24 md5
CU
Uwe
2015-09-15 19:59 GMT+02:00 gannebamm <gannebamm@anonymised.com>:
>
>
http://dba.stackexchange.com/questions/83984/connect-to-postgresql-server-fatal-no-pg-hba-conf-entry-for-host
>
> I had this issue with PostgreSQL and needed to add my ip to the conf file
>
> Sent from mobile
>
>
> ---- Uwe Seher schrieb ----
>
> No, the database is on another server. But i can log in with psql from
the
> tomcat-server with the given credentials. Other applications like
geoserver
> and jasperreports which run on the same server like geonetwork do not
have
> problems. Altering the entry in pg_hba has the predicted effect. I had
> restarted the database after changes, also the tomcat.
> So this is a little strange to me.
>
> Uwe
>
>
>
>
> 2015-09-15 16:40 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
>
> > Hi Uwe
> >
> > Seem an issue of your Postgres configuration. See this error:
> >
> > FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
> > database "geonetwork", SSL off
> >
> > Check to add the proper configuration, you need to authorise the
> host/user
> > to access. Is the database in the same server as GeoNetwork? If so try
to
> > configure the connection with localhost.
> >
> > Regards,
> > Jose García
> >
> > On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com>
wrote:
> >
> >> Hello geonetwork-users!
> >>
> >> This is my first post on this list, so i introduce myself as geologist
> and
> >> gdi-administrator in a civil engineering company in germany. I have
> about
> >> 20 years experience with GIS and about 10-15 years with
OGC-Webservices
> >> and
> >> postgres.
> >> I like to evaluate geonetwork because we need the ability to host a
> >> metadata catalogue and some maps as documentation for our customers.
> >> I have a preexisting tomcat 7 with geoserver and postgresql/postgis
> >> 9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
> >> I have installed the geonetwork.war file, which worked. I configured
> the
> >> database connection in 'WEB-INF/config-node/srv.xml', then i
> configured
> >> the connection in 'WEB-INF/config-db/jdbc.properties'.
> >> But when i try to start the application in tomcat the following error
is
> >> found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
> >> The pg_hba-entry seems also correct because i can login with psql with
> the
> >> given parameters from the tomcat machine.
> >> So i am a little bit clueless and hope you can help me with some
hints.
> >>
> >> Thank you in advance for your help.
> >>
> >> Uwe Seher
> >>
> >>
> >> http://pastebin.com/0K1U2Yqj
> >>
> >>
>
------------------------------------------------------------------------------
> >> _______________________________________________
> >> 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
> >>
> >
> >
> >
> > --
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > *Vriendelijke groeten / Kind regards,Jose García
> > <http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT:
> +31
> > (0)318 416664 <+31318416664>M: +31 (0)655 818332
<+31%20(0)655%20818332>
> <+31655818332>
> > <https://www.facebook.com/geocatbv>&nbsp; <
> https://twitter.com/geocat_bv>
> > <https://plus.google.com/u/1/+GeocatNetbv/posts>Please
> <https://plus.google.com/u/1/+GeocatNetbv/posts>Please> consider the
> > environment before printing this email.*
>
> >
>
>
------------------------------------------------------------------------------
> _______________________________________________
> 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
>
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
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
--
*Vriendelijke groeten / Kind regards,Jose García
<http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT: +31
(0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31655818332>
<https://www.facebook.com/geocatbv> <https://twitter.com/geocat_bv>
<https://plus.google.com/u/1/+GeocatNetbv/posts>Please consider the
environment before printing this email.*
local is for socket connections which works only on the same machine.
pg_hba.conf is processed on line after the other until a match occurs. If
no match occurs the above error is raised. If i comment the local-enties
out it remains all the same. I pushed the geonetwork-entry to the first
line and allowed trusted access for all but the error still remains with
geonetwork while other connection are processed in the right way. I can see
the access-attempt in the postgres-log, and i can connect to the
geonetwork-database with geoserver, which runs on the same machine with the
same tomcat.
At this point in time i only edited in config-db/jdbc.properties and
config-node/srv.xml. This seems to be correct, because i can watch the
connection attempt on both sides. Also the changed entries are visible. But
maybe i have something missed or forgotten?
Now i will try to get it up on my laptop, where i can test the local-issue.
This is a really strange thing.
CU Uwe
2015-09-16 8:26 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
Hi Uwe
See comments inline.
Regards,
Jose García
On Wed, Sep 16, 2015 at 8:19 AM, Uwe Seher <uwe.seher@anonymised.com> wrote:
Hi again!
As i said, login with psql or pgadmin using the geonetwork-user is working
in the local network.
Sure, but most probably these applications use local connections instead
of host (tcp/ip). If you check in your file, you should have another entry
like this:
local geonetwork ...
or
local all ...
That explains why these applications worked, but no GeoNetwork that
requires tcp/ip access.
This is the relvant entry in pg_hba.conf:
host geonetwork +gdi,+web 192.168.1.0/24 md5
CU
Uwe
2015-09-15 19:59 GMT+02:00 gannebamm <gannebamm@anonymised.com>:
>
>
http://dba.stackexchange.com/questions/83984/connect-to-postgresql-server-fatal-no-pg-hba-conf-entry-for-host
>
> I had this issue with PostgreSQL and needed to add my ip to the conf
file
>
> Sent from mobile
>
>
> ---- Uwe Seher schrieb ----
>
> No, the database is on another server. But i can log in with psql from
the
> tomcat-server with the given credentials. Other applications like
geoserver
> and jasperreports which run on the same server like geonetwork do not
have
> problems. Altering the entry in pg_hba has the predicted effect. I had
> restarted the database after changes, also the tomcat.
> So this is a little strange to me.
>
> Uwe
>
>
>
>
> 2015-09-15 16:40 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
>
> > Hi Uwe
> >
> > Seem an issue of your Postgres configuration. See this error:
> >
> > FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
> > database "geonetwork", SSL off
> >
> > Check to add the proper configuration, you need to authorise the
> host/user
> > to access. Is the database in the same server as GeoNetwork? If so
try to
> > configure the connection with localhost.
> >
> > Regards,
> > Jose García
> >
> > On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com>
wrote:
> >
> >> Hello geonetwork-users!
> >>
> >> This is my first post on this list, so i introduce myself as
geologist
> and
> >> gdi-administrator in a civil engineering company in germany. I have
> about
> >> 20 years experience with GIS and about 10-15 years with
OGC-Webservices
> >> and
> >> postgres.
> >> I like to evaluate geonetwork because we need the ability to host a
> >> metadata catalogue and some maps as documentation for our customers.
> >> I have a preexisting tomcat 7 with geoserver and postgresql/postgis
> >> 9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
> >> I have installed the geonetwork.war file, which worked. I configured
> the
> >> database connection in 'WEB-INF/config-node/srv.xml', then i
> configured
> >> the connection in 'WEB-INF/config-db/jdbc.properties'.
> >> But when i try to start the application in tomcat the following
error is
> >> found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
> >> The pg_hba-entry seems also correct because i can login with psql
with
> the
> >> given parameters from the tomcat machine.
> >> So i am a little bit clueless and hope you can help me with some
hints.
> >>
> >> Thank you in advance for your help.
> >>
> >> Uwe Seher
> >>
> >>
> >> http://pastebin.com/0K1U2Yqj
> >>
> >>
>
------------------------------------------------------------------------------
> >> _______________________________________________
> >> 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
> >>
> >
> >
> >
> > --
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > *Vriendelijke groeten / Kind regards,Jose García
> > <http://www.geocat.net/>Veenderweg 136721 WD BennekomThe
NetherlandsT:
> +31
> > (0)318 416664 <+31318416664>M: +31 (0)655 818332
<+31%20(0)655%20818332>
> <+31655818332>
> > <https://www.facebook.com/geocatbv>&nbsp; <
> https://twitter.com/geocat_bv>
> > <https://plus.google.com/u/1/+GeocatNetbv/posts>Please
> <https://plus.google.com/u/1/+GeocatNetbv/posts>Please> consider the
> > environment before printing this email.*
>
> >
>
>
------------------------------------------------------------------------------
> _______________________________________________
> 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
>
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
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
--
*Vriendelijke groeten / Kind regards,Jose García
<http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT: +31
(0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31655818332>
<https://www.facebook.com/geocatbv> <https://twitter.com/geocat_bv>
<https://plus.google.com/u/1/+GeocatNetbv/posts>Please consider the
environment before printing this email.*
Hi Uwe,
is there a typo in your configured username? It seems there's an additional
blank in "gdi_admin ". At least that's what shows up in the stack trace:
(FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin ",
database "geonetwork", SSL off)
Cheers, Michael
2015-09-16 10:37 GMT+02:00 Uwe Seher <uwe.seher@anonymised.com>:
local is for socket connections which works only on the same machine.
pg_hba.conf is processed on line after the other until a match occurs. If
no match occurs the above error is raised. If i comment the local-enties
out it remains all the same. I pushed the geonetwork-entry to the first
line and allowed trusted access for all but the error still remains with
geonetwork while other connection are processed in the right way. I can see
the access-attempt in the postgres-log, and i can connect to the
geonetwork-database with geoserver, which runs on the same machine with the
same tomcat.
At this point in time i only edited in config-db/jdbc.properties and
config-node/srv.xml. This seems to be correct, because i can watch the
connection attempt on both sides. Also the changed entries are visible. But
maybe i have something missed or forgotten?
Now i will try to get it up on my laptop, where i can test the local-issue.
This is a really strange thing.
CU Uwe
2015-09-16 8:26 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
> Hi Uwe
>
> See comments inline.
>
> Regards,
> Jose García
>
> On Wed, Sep 16, 2015 at 8:19 AM, Uwe Seher <uwe.seher@anonymised.com> wrote:
>
>> Hi again!
>>
>> As i said, login with psql or pgadmin using the geonetwork-user is
working
>> in the local network.
>>
>
> Sure, but most probably these applications use local connections instead
> of host (tcp/ip). If you check in your file, you should have another
entry
> like this:
>
> local geonetwork ...
>
> or
>
> local all ...
>
> That explains why these applications worked, but no GeoNetwork that
> requires tcp/ip access.
>
>
>> This is the relvant entry in pg_hba.conf:
>>
>> host geonetwork +gdi,+web 192.168.1.0/24 md5
>>
>> CU
>>
>> Uwe
>>
>>
>> 2015-09-15 19:59 GMT+02:00 gannebamm <gannebamm@anonymised.com>:
>>
>> >
>> >
>>
http://dba.stackexchange.com/questions/83984/connect-to-postgresql-server-fatal-no-pg-hba-conf-entry-for-host
>> >
>> > I had this issue with PostgreSQL and needed to add my ip to the conf
>> file
>> >
>> > Sent from mobile
>> >
>> >
>> > ---- Uwe Seher schrieb ----
>> >
>> > No, the database is on another server. But i can log in with psql from
>> the
>> > tomcat-server with the given credentials. Other applications like
>> geoserver
>> > and jasperreports which run on the same server like geonetwork do not
>> have
>> > problems. Altering the entry in pg_hba has the predicted effect. I had
>> > restarted the database after changes, also the tomcat.
>> > So this is a little strange to me.
>> >
>> > Uwe
>> >
>> >
>> >
>> >
>> > 2015-09-15 16:40 GMT+02:00 Jose Garcia <jose.garcia@anonymised.com>:
>> >
>> > > Hi Uwe
>> > >
>> > > Seem an issue of your Postgres configuration. See this error:
>> > >
>> > > FATAL: no pg_hba.conf entry for host "192.168.1.2", user "gdi_admin
",
>> > > database "geonetwork", SSL off
>> > >
>> > > Check to add the proper configuration, you need to authorise the
>> > host/user
>> > > to access. Is the database in the same server as GeoNetwork? If so
>> try to
>> > > configure the connection with localhost.
>> > >
>> > > Regards,
>> > > Jose García
>> > >
>> > > On Tue, Sep 15, 2015 at 4:34 PM, Uwe Seher <uwe.seher@anonymised.com>
>> wrote:
>> > >
>> > >> Hello geonetwork-users!
>> > >>
>> > >> This is my first post on this list, so i introduce myself as
>> geologist
>> > and
>> > >> gdi-administrator in a civil engineering company in germany. I have
>> > about
>> > >> 20 years experience with GIS and about 10-15 years with
>> OGC-Webservices
>> > >> and
>> > >> postgres.
>> > >> I like to evaluate geonetwork because we need the ability to host a
>> > >> metadata catalogue and some maps as documentation for our
customers.
>> > >> I have a preexisting tomcat 7 with geoserver and postgresql/postgis
>> > >> 9.3/2.1.3 in use. All is running on OpenSuse 13.1 Machines.
>> > >> I have installed the geonetwork.war file, which worked. I
configured
>> > the
>> > >> database connection in 'WEB-INF/config-node/srv.xml', then i
>> > configured
>> > >> the connection in 'WEB-INF/config-db/jdbc.properties'.
>> > >> But when i try to start the application in tomcat the following
>> error is
>> > >> found in /var/log/tomcat/geonetwork.log (see pastebin-link below).
>> > >> The pg_hba-entry seems also correct because i can login with psql
>> with
>> > the
>> > >> given parameters from the tomcat machine.
>> > >> So i am a little bit clueless and hope you can help me with some
>> hints.
>> > >>
>> > >> Thank you in advance for your help.
>> > >>
>> > >> Uwe Seher
>> > >>
>> > >>
>> > >> http://pastebin.com/0K1U2Yqj
>> > >>
>> > >>
>> >
>>
------------------------------------------------------------------------------
>> > >> _______________________________________________
>> > >> 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
>> > >>
>> > >
>> > >
>> > >
>> > > --
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > *Vriendelijke groeten / Kind regards,Jose García
>> > > <http://www.geocat.net/>Veenderweg 136721 WD BennekomThe
>> NetherlandsT:
>> > +31
>> > > (0)318 416664 <+31318416664>M: +31 (0)655 818332
>> <+31%20(0)655%20818332>
>> > <+31655818332>
>> > > <https://www.facebook.com/geocatbv>&nbsp; <
>> > https://twitter.com/geocat_bv>
>> > > <https://plus.google.com/u/1/+GeocatNetbv/posts>Please
>> > <https://plus.google.com/u/1/+GeocatNetbv/posts>Please> consider
the
>> > > environment before printing this email.*
>> >
>> > >
>> >
>> >
>>
------------------------------------------------------------------------------
>> > _______________________________________________
>> > 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
>> >
>>
>>
------------------------------------------------------------------------------
>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>> Get real-time metrics from all of your servers, apps and tools
>> in one place.
>> SourceForge users - Click here to start your Free Trial of Datadog now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
>> _______________________________________________
>> 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
>>
>
>
>
> --
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *Vriendelijke groeten / Kind regards,Jose García
> <http://www.geocat.net/>Veenderweg 136721 WD BennekomThe NetherlandsT:
+31
> (0)318 416664 <+31318416664>M: +31 (0)655 818332 <+31655818332>
> <https://www.facebook.com/geocatbv> <https://twitter.com/geocat_bv>
> <https://plus.google.com/u/1/+GeocatNetbv/posts>Please consider the
> environment before printing this email.*
>
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
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
--
-----------------------------------------------------------
Michael Schulz
Ok, i hunted it down. There has been a space at the end of the username, a
small nothing with a great effect.
I thank you all for your help and continue banging my head on the table 
Bye
Uwe