Re: Can not connect to database in Workgroup-Net on Windows-XP - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: Can not connect to database in Workgroup-Net on Windows-XP
Date
Msg-id bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.com
Whole thread Raw
In response to Re: Can not connect to database in Workgroup-Net on Windows-XP  (Josef Springer <Josef.Springer@joops.com>)
List pgsql-admin
The error you are getting is because of the password not been passed correctly so 'trust' will let you get in the server without specifying the correct password, once you are in now you can change the password as you like using ALTER USER command. Once its done change it back to md5 as it was before.

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/15/07, Josef Springer < Josef.Springer@joops.com> wrote:
Hi Mir,

thanks for your quick answer. We will try this.
For my unterstanding: Why should i use trust instead of md5 ? A configuration at another customer (with a domain setting) using md5 works fine ?

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 --

 


Shoaib Mir wrote:
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)

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 --

 






pgsql-admin by date:

Previous
From: Josef Springer
Date:
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
Next
From: Hélder M. Vieira
Date:
Subject: Pg_dump behaviour