Re: Incompatible encryption protocols using pg 7.3.4 / pgAdminIII?

Hi Gene,

pgAdmin uses the libpq PostgreSQL library to talk to the server. It
sends authentication data back to the server in the format requested by
the server:

Client -> Server {Startup, Database: dbname, User: username}
Server -> Client {Error or AuthenticationType Required}

The AuthenticationType required is determined from the pg_hba.conf file
on the server using the client address and the information in the
startup packet. What authentication type is specified in your
pg_hba.conf file?

Regards, Dave.

> -----Original Message-----
> From: Gene Quinn [mailto:QUINNG00(at)dcor(dot)state(dot)ga(dot)us]
> Sent: 26 September 2003 22:05
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Incompatible encryption protocols
> using pg 7.3.4 / pgAdminIII?
>
>
> Hello.
>
> I am running pg 7.3.4, installed from RPM supplied by RedHat
> under RH Enterprise Server 3.x (beta)
>
> I just installed pgAdmin III on a Windows 2000 box
> When I attempt to connect to the server, I get:
>
> Error connecting to server: FATAL: Password authentication
> failed for user "smith"
>
> In the log files on the server, I find this:
> LOG: Password is stored MD5 encrypted. 'crypt' auth method
> cannot be used.
> FATAL: Password authentication failed for user "smith"
>
> It would appear that the server expects MD5 encryption, while
> the client is using crypt. How does one configure pgAdmin III
> to use MD5?
>
> Thanks in advance for any assistance.
>
> Regards
>
> Gene
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>