Re: fe_sendsuth: no password supplied

On 16/02/07, David Burleson <david@ephotozine.com> wrote:
> - Three computers with one IP address? Simultaneously? Are you sure?
>
> The three computers are on a local network that connects to the internet
> through a hub, thus having the same outside IP address of 62.6.162.34.
> They all have network IP addresses of 172.20.32.%.

I see.

>
> - How do you know you don't need a password? Could you show us the
> complete pg_hba.conf file?
>
> The reason I say that I don't need a password is that every other
> PGAdmin install doesnt enter a password. That is the only think that has
> led me to conclude that I don't need to pass a password, isn't that
> default for the user 'postgres' anyways? And heres the conf file. Thanks

No, it's not - at least not from the "outside".

[...]
> # "local" is for Unix domain socket connections only
> local   all         all                               trust
> # IPv4 local connections:
> host    all         all         127.0.0.1/32          trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust


As you could see even from your conf file (which is a modified version
of the default one) the default is "allow everyone to login from the
this machine using unix domain sockets, IPv4 or IPv6 and _do not_
require a password". Now, the next lines are added by your DB
administrators and are specific to your configuration.


> # host1. web server
> host    all         all         69.16.237.154/32        trust
>
> # Pete home
> host    all         all         62.190.238.189/32       md5
>
> # Will
> host    all         all         82.71.53.201/32         md5
>


And the next line is relevant to you. It still says you need to supply
a password.

> # Turbine
> host    all         all         62.6.162.34/32          md5
>
> host    all         all         67.43.10.135/32         md5
>
> # Will home
> host    all         all         82.71.53.201/32 md5
>
> # David Home
> host    all         all         84.13.4.175/32          trust
>
> #Ben Home
> host    all         all         80.195.227.249/32       trust
>
[...]


So, when you do supply a password, what is the error message? And
could you look in the server's logs and see what's the error message
there?



Also, when replying, please include the mailing list ("Reply All") so
the other subscribers could follow this thread.

-- 
Milen A. Radev