Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 41B239FA372 for ; Thu, 11 Jan 2007 08:52:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 95454-09 for ; Thu, 11 Jan 2007 08:51:56 -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 93F849F95CB for ; Thu, 11 Jan 2007 08:52:11 -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 69B305AF943 for ; Thu, 11 Jan 2007 12:52:10 +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 l0BDpi516220; Thu, 11 Jan 2007 14:51:48 +0100 Message-ID: <45A6322B.7070806@joops.com> Date: Thu, 11 Jan 2007 13:48:43 +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="------------040208030202030905070709" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.079 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200701/99 X-Sequence-Number: 24255 --------------040208030202030905070709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Hi Andi, i get an error message "Can not connect to database..." or similar. I=20 will ask the customer. The system at another customer runs with host all all =20 0.0.0.0/0 md5 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 > > > --------------040208030202030905070709 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Andi,

i get an error message "Can not connect to database..." or similar.  I will ask the customer.
The system at another customer runs with host    all     all     0.0.0.0/0       md5

Josef

Andy Shellam (Mailing Lists) wrote:
Firstly it would be helpful to say what error you're getting on the client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0" 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        0.0.0.0    md5
in the file pg_hba.conf
and
listen_addresses = '*' 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 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 the database on the /Labor/ no matter wether i use the machine's name or the IP-adress.

What to do ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
    Address
    _Josef.Springer@joops.com _
    Orlando-di-Lasso Str. 2
    D-85640 Putzbrunn
Phone
    Office
    +49 (0)89 600 6920
    
    
Phone
    Fax
    +49 (0)89 600 69220
    
    
Web
    Web
    http://www.joops.com
    
    


JOOPS
    *-- the software company --*


 


!DSPAM:37,45a60e36137102078430163!


--------------040208030202030905070709--