From: Shoaib Mir <shoaibmir@gmail.com>
To: Josef Springer <Josef.Springer@joops.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
Date: Mon, 15 Jan 2007 14:46:43 +0500
Message-ID: <bf54be870701150146w6dd37d1dj30b598abf0825307@mail.gmail.com> (raw)
In-Reply-To: <45AB2F54.7010609@joops.com>
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>
<45AB2F54.7010609@joops.com>
I can understand the exact error as its not in english :) but it seems like
an authentication problem. Please change 'md5' to 'trust' in pg_hba.conf
file and then use:
pg_ctl -D <path to data folder> reload
That will reload the settings for authentication.
Now once the settings are reloaded try reconnecting to the database and it
should go fine this time....
----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Josef Springer <Josef.Springer@joops.com> 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 clients' 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 machine Labor no matter wether i use the machine's
> name
> or the IP-adress. Instead i get the message
>
> * "Zum Server ist keine Verbindung möglich, *
>
> * oder Login/Passwort sind falsch.*
>
> * Die Anmeldung wurde abgelehnt."*
>
>
> Please help me. What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [image: Postal]
> Address
> *Josef.Springer@joops.com*
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> [image: Phone]
> Office
> +49 (0)89 600 6920
>
>
> [image: Phone]
> Fax
> +49 (0)89 600 69220
>
>
> [image: Web]
> Web
> http://www.joops.com
>
>
>
> [image: JOOPS]
> *-- the software company --*
>
>
>
>
>
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: shoaibmir@gmail.com, Josef.Springer@joops.com
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
In-Reply-To: <bf54be870701150146w6dd37d1dj30b598abf0825307@mail.gmail.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