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:[EMAIL PROTECTED]
> Sent: 26 September 2003 22:05
> To: [EMAIL PROTECTED]
> 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
> [EMAIL PROTECTED]
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
