Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 302759FA35C for ; Thu, 11 Jan 2007 10:51:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 73558-09 for ; Thu, 11 Jan 2007 10:51:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 105C89FA249 for ; Thu, 11 Jan 2007 10:51:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from vserver0202.onit4u.de (ns.redaex.de [213.133.112.5]) by svr4.postgresql.org (Postfix) with ESMTP id 38D805AF991 for ; Thu, 11 Jan 2007 14:51:37 +0000 (GMT) Received: from joops.com (dslb-088-064-016-081.pools.arcor-ip.net [88.64.16.81]) by vserver0202.onit4u.de (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id l0BFpM521183; Thu, 11 Jan 2007 16:51:23 +0100 Message-ID: <45A64E3B.8030002@joops.com> Date: Thu, 11 Jan 2007 15:48:27 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 X-Accept-Language: en-us, de-de MIME-Version: 1.0 To: "Andy Shellam (Mailing Lists)" Cc: pgsql-admin@postgresql.org Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP References: <450FAE7A.9070408@joops.com> <6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se> <450FC3E0.2030001@joops.com> <6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se> <45A60D3E.1060700@joops.com> <45A61751.6040603@mailnetwork.co.uk> Content-Type: multipart/alternative; boundary="------------040306000703040202030805" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.99 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200701/103 X-Sequence-Number: 24259 --------------040306000703040202030805 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: quoted-printable Hi Andy, here ist the error mesage trying to connect: "Zum Server ist keine Verbindung m=F6glich, oder Login/Passwort sind falsch. Die Anmeldung wurde abgelehnt." Josef Andy Shellam (Mailing Lists) wrote: > Firstly it would be helpful to say what error you're getting on the=20 > client side. > At a quick guess, I would say it's because you've got 2 "0.0.0.0"=20 > declarations in your pg_hba.conf - you only need the one - like this: > > host all all 0.0.0.0/0 md5 > > Regards, > > Andy. > > Josef Springer wrote: > >> Hi folks, >> >> i have a workgroup (not a classic server) with Windows-XP-machines: >> >> the database server machine contains the line >> host all all 0.0.0.0 =20 >> 0.0.0.0 md5 >> in the file pg_hba.conf >> and >> listen_addresses =3D '*' in the file postgresql.conf. >> >> the 'client's host file contain the line >> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress=20 >> of the database server machine and /Labor /is the machine's name. >> >> If i start PGAdmin III on the 'client' machine i can not connect to=20 >> the database on the /Labor/ no matter wether i use the machine's name = >> or the IP-adress. >> >> What to do ? >> >> mit freundlichen Gr=FC=DFen / best regards, >> Josef Springer >> (Gesch=E4ftsleitung/Management) >> >> Postal >> Address >> _Josef.Springer@joops.com _ >> Orlando-di-Lasso Str. 2 >> D-85640 Putzbrunn >> Phone >> Office >> +49 (0)89 600 6920 >> =20 >> =20 >> Phone >> Fax >> +49 (0)89 600 69220 >> =20 >> =20 >> Web >> Web >> http://www.joops.com >> =20 >> =20 >> >> >> JOOPS >> *-- the software company --* >> >> >> =20 >> >> >> !DSPAM:37,45a60e36137102078430163!=20 > > > --------------040306000703040202030805 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Andy,

here ist the error mesage trying to connect:

"Zum Server ist keine Verbindung m=F6glich,

oder Login/Passwort sind falsch.

Die Anmeldung wurde abgelehnt."


Josef

Andy Shellam (Mailing Lists) wrote:
Firstly it would be helpful to say what error you're getting on the client side.= =20
At a quick guess, I would say it's because you've got 2 "0.0.0.0" declar= ations in your pg_hba.conf - you only need the one - like this:

host=A0=A0=A0 all=A0=A0=A0=A0 all=A0=A0=A0=A0 0.0.0.0/0=A0=A0=A0=A0=A0=A0= md5

Regards,

Andy.

Josef Springer wrote:
Hi folks,

i have a workgroup (not a classic server)=A0 with Windows-XP-machines:
the database server machine contains the line
host=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= all=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0.0.0.0=A0=A0=A0=A0=A0=A0=A0 0.0.0= =2E0=A0=A0=A0 md5
in the file pg_hba.conf
and
listen_addresses =3D '*' in the file postgresql.conf.

the 'client's host file contain the line
*/nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress of t= he database server machine and /Labor /is the machine's name.

If i start PGAdmin III on the 'client' machine i can not connect to the database on the /Labor/ no matter wether i use the machine's name or the= IP-adress.

What to do ?

mit freundlichen Gr=FC=DFen / best regards,
Josef Springer
(Gesch=E4ftsleitung/Management)

Postal
=A0=A0=A0=A0Address
=A0=A0=A0=A0_Josef.Springer@joops.com _
=A0=A0=A0=A0Orlando-di-Lasso Str. 2
=A0=A0=A0=A0D-85640 Putzbrunn
Phone
=A0=A0=A0=A0Office
=A0=A0=A0=A0+49 (0)89 600 6920
=A0=A0=A0=A0
=A0=A0=A0=A0
Phone
=A0=A0=A0=A0Fax
=A0=A0=A0=A0+49 (0)89 600 69220
=A0=A0=A0=A0
=A0=A0=A0=A0
Web
=A0=A0=A0=A0Web
=A0=A0=A0=A0http://www.joops.com
=A0=A0=A0=A0
=A0=A0=A0=A0


JOOPS
=A0=A0=A0=A0*-- the software company --*


=A0


!DSPAM:37,45a60e36137102078430163!



--------------040306000703040202030805--