From: Josef Springer <Josef.Springer@joops.com>
To: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
Date: Thu, 11 Jan 2007 13:48:43 +0100
Message-ID: <45A6322B.7070806@joops.com> (raw)
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>
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!
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Josef.Springer@joops.com, andy.shellam-lists@mailnetwork.co.uk
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
In-Reply-To: <45A6322B.7070806@joops.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox