I have pgAdmin III 1.6 and am trying to connect to my pgsql database
through it, but i keep getting the following error:

An error has occurred:
Error connecting to server: fe_sendauth: no password supplied

I have checked my pg_hba.conf file and I have to correct line
host all all 62.6.162.34/32 md5

This problem is on a new computer (xp home). PgAdmin is able to connect
to a local pgsql server, but to this remote one it doesnt. I have
checked the IP address and it is correct, checked my network connection
settings and they match the other computers on the network. The thing
is, 3 other computers on the same network ,with the same ip address can
access this postgres without a problem.

I don't need a password for the user postgres but when I uncheck store
password in pgadmin, it asks me to enter a password, which I have tried
leaving blank and putting things in and both end up in this error.

Thanks for any help and direction in advance.

David



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

David Burleson написа:
> I have pgAdmin III 1.6 and am trying to connect to my pgsql database
> through it, but i keep getting the following error:
>
> An error has occurred:
> Error connecting to server: fe_sendauth: no password supplied
>
> I have checked my pg_hba.conf file and I have to correct line
> host all all 62.6.162.34/32 md5

Which means "allow login attempts for every login role from this and
_only_ this IP address, _require_ a password, and negotiate to be sent
hashed".

So you need to send a password.

>
> This problem is on a new computer (xp home). PgAdmin is able to connect
> to a local pgsql server, but to this remote one it doesnt. I have
> checked the IP address and it is correct, checked my network connection
> settings and they match the other computers on the network. The thing
> is, 3 other computers on the same network ,with the same ip address can
> access this postgres without a problem.

Three computers with one IP address? Simultaneously? Are you sure?

> I don't need a password for the user postgres but when I uncheck store

How do you know you don't need a password? Could you show us the
complete pg_hba.conf file?

> password in pgadmin, it asks me to enter a password, which I have tried
> leaving blank and putting things in and both end up in this error.



--
Milen A. Radev

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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?

I have been checking the server and have found that there are no log
files. It seems the configuration was set not to write any.

The error message either way is the fe_sendauth: no password supplied

David


Milen A. Radev wrote:
> 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.
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend