Skip site navigation (1) Skip section navigation (2)

Re: Can not connect to database in Workgroup-Net on Windows-XP

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
Date: 2007-01-11 14:48:27
Message-ID: 45A64E3B.8030002@joops.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Andy,

here ist the error mesage trying to connect:

"Zum Server ist keine Verbindung möglich,

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.
> 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(dot)Springer(at)joops(dot)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! 
>
>
>

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-01-11 15:35:42
Subject: Re: configuring the postmaster.log
Previous:From: Adam WitneyDate: 2007-01-11 14:17:18
Subject: Re: Please help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group