Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitad30d36

Browse files
committed
Document actual string that has to be returned by the client for MD5
authentication.Report and pseudo code by Cyan Ogilvie
1 parent0180bd6 commitad30d36

File tree

1 file changed

+9
-4
lines changed

1 file changed

+9
-4
lines changed

‎doc/src/sgml/protocol.sgml

Lines changed: 9 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -293,10 +293,15 @@
293293
<listitem>
294294
<para>
295295
The frontend must now send a PasswordMessage containing the
296-
password encrypted via MD5, using the 4-character salt
297-
specified in the AuthenticationMD5Password message. If
298-
this is the correct password, the server responds with an
299-
AuthenticationOk, otherwise it responds with an ErrorResponse.
296+
password (with username) encrypted via MD5, then encrypted
297+
again using the 4-byte random salt specified in the
298+
AuthenticationMD5Password message. If this is the correct
299+
password, the server responds with an AuthenticationOk,
300+
otherwise it responds with an ErrorResponse. The actual
301+
PasswordMessage can be computed in SQL as <literal>concat('md5',
302+
md5(concat(md5(concat(password, username)), random-salt)))</>.
303+
(Keep in mind the <function>md5()</> function returns its
304+
result as a hex string.)
300305
</para>
301306
</listitem>
302307
</varlistentry>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp