Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 907859FB213 for ; Mon, 15 Jan 2007 05:46:53 -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 10884-10 for ; Mon, 15 Jan 2007 05:46:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id 4A1659FB208 for ; Mon, 15 Jan 2007 05:46:45 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so736578ana for ; Mon, 15 Jan 2007 01:46:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Q3xjbUwcQV5d/2r42sCV43aZOZVVnIZWZ2CfJQzP32lQ+47ftaRLHVVhiPl8bgeuC1yxjQzVkZD7DLq4hpSbhJVzZvMNnMzeQpwMBGgjN1OGgO/c53Uf2NyZwsWzBKedcoJ9z/isZh/vOlukaH90DwHYs16l2/Gunpk5oT91Vyg= Received: by 10.64.125.17 with SMTP id x17mr3433465qbc.1168854403771; Mon, 15 Jan 2007 01:46:43 -0800 (PST) Received: by 10.65.188.5 with HTTP; Mon, 15 Jan 2007 01:46:43 -0800 (PST) Message-ID: Date: Mon, 15 Jan 2007 14:46:43 +0500 From: "Shoaib Mir" To: "Josef Springer" Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP Cc: pgsql-admin@postgresql.org In-Reply-To: <45AB2F54.7010609@joops.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_41319_25230803.1168854403372" 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.176 tagged_above=0 required=5 tests=BAYES_50, HTML_MESSAGE, NORMAL_HTTP_TO_IP, SPF_PASS X-Spam-Level: X-Archive-Number: 200701/118 X-Sequence-Number: 24274 ------=_Part_41319_25230803.1168854403372 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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 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 =3D '*' * > 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=F6glich, * > > * oder Login/Passwort sind falsch.* > > * Die Anmeldung wurde abgelehnt."* > > > Please help me. What to do ? > > mit freundlichen Gr=FC=DFen / best regards, > Josef Springer > (Gesch=E4ftsleitung/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 --* > > > > > ------=_Part_41319_25230803.1168854403372 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 t= he 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, Jo= sef Springer <Josef.Spri= nger@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 =3D '*'
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=F6glich,

oder Login/Passwort sind falsch.

Die Anmeldung wurde abgelehnt."

Please help me. What to do ?

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

Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn

Office
+49 (0)= 89=20 600 6920

Fax
+49 (0)89 600 69220=

= Web
http://www.joops.com

-- the software company --

------=_Part_41319_25230803.1168854403372--