pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 15:15:35 +0500
Message-ID: <bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.com> (raw)
In-Reply-To: <45AB516F.3090907@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>
	<bf54be870701150146w6dd37d1dj30b598abf0825307@mail.gmail.com>
	<45AB516F.3090907@joops.com>

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)
>
>   [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 --*
>
>
>
>
> 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)
> >
> >   [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 --*
> >
> >
> >
> >
> >
>
>
>

view thread (8+ messages)

Message-ID: <bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.com>
Permalink:  ../bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.com/
Also on:    postgresql.org/message-id/bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  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: <bf54be870701150215u70c57c05y39c11acc6694e068@mail.gmail.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> <bf54be870701150146w6dd37d1dj30b598abf0825307@mail.gmail.com> <45AB516F.3090907@joops.com> <bf54be870701150215u70c57c05y39c11acc6694e068@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