PDA

Vollständige Version anzeigen : MD5 Hashcode erzeugen


Merlin1811
12.07.2006, 08:58
Hallo zusammen,

ich stehe vor folgendem Problem :
Ich habe ein DB Feld, in dem ein Kundenpasswort eingetragen ist.
Nun soll zu diesem Passwort eine Prüfsumme errechnet werden, und zwar ein MD5 Hashcode.
Geht das über Access, wenn ja, wie ?

vielen Dank schon einmal im voraus !

Lars

J_Eilers
12.07.2006, 11:50
Hi,

vielleicht kein MD5 aber ggf reicht dir das hier (http://vb-tec.de/strcode.htm) oder auch das hier (http://www.vbfun.de/vb/index.htm)?

TommyK
12.07.2006, 12:18
Hallo,

oder diese Lösung:
Private lngTrack As Long
Private arrLongConversion(4) As Long
Private arrSplit64(63) As Byte

Private Const OFFSET_4 = 4294967296#
Private Const MAXINT_4 = 2147483647

Private Const S11 = 7
Private Const S12 = 12
Private Const S13 = 17
Private Const S14 = 22
Private Const S21 = 5
Private Const S22 = 9
Private Const S23 = 14
Private Const S24 = 20
Private Const S31 = 4
Private Const S32 = 11
Private Const S33 = 16
Private Const S34 = 23
Private Const S41 = 6
Private Const S42 = 10
Private Const S43 = 15
Private Const S44 = 21

Private Function MD5Round(strRound As String, a As Long, b As Long, _
C As Long, d As Long, x As Long, S As Long, _
ac As Long) As Long
Select Case strRound
Case Is = "FF"
a = MD5LongAdd4(a, (b And C) Or (Not (b) And d), x, ac)
a = MD5Rotate(a, S)
a = MD5LongAdd(a, b)
Case Is = "GG"
a = MD5LongAdd4(a, (b And d) Or (C And Not (d)), x, ac)
a = MD5Rotate(a, S)
a = MD5LongAdd(a, b)
Case Is = "HH"
a = MD5LongAdd4(a, b Xor C Xor d, x, ac)
a = MD5Rotate(a, S)
a = MD5LongAdd(a, b)
Case Is = "II"
a = MD5LongAdd4(a, C Xor (b Or Not (d)), x, ac)
a = MD5Rotate(a, S)
a = MD5LongAdd(a, b)
End Select
End Function

Private Function MD5Rotate(lngValue As Long, lngBits As Long) As Long
Dim lngSign As Long
Dim lngI As Long

lngBits = (lngBits Mod 32)
If lngBits = 0 Then MD5Rotate = lngValue: Exit Function
For lngI = 1 To lngBits
lngSign = lngValue And &HC0000000
lngValue = (lngValue And &H3FFFFFFF) * 2
lngValue = lngValue Or ((lngSign < 0) And 1) Or _
(CBool(lngSign And &H40000000) And &H80000000)
Next
MD5Rotate = lngValue
End Function

Private Function TRID() As String
Dim sngNum As Single, lngnum As Long
Dim strResult As String

sngNum = Rnd(2147483648#)
strResult = CStr(sngNum)
strResult = Replace(strResult, "0.", "")
strResult = Replace(strResult, ".", "")
strResult = Replace(strResult, "E-", "")
TRID = strResult
End Function

Private Function MD564Split(lngLength As Long, bytBuffer() As Byte) As String
Dim lngBytesTotal As Long, lngBytesToAdd As Long
Dim intLoop As Integer, intLoop2 As Integer, lngTrace As Long
Dim intInnerLoop As Integer, intLoop3 As Integer

lngBytesTotal = lngTrack Mod 64
lngBytesToAdd = 64 - lngBytesTotal
lngTrack = (lngTrack + lngLength)
If lngLength >= lngBytesToAdd Then
For intLoop = 0 To lngBytesToAdd - 1
arrSplit64(lngBytesTotal + intLoop) = bytBuffer(intLoop)
Next intLoop
MD5Conversion arrSplit64
lngTrace = (lngLength) Mod 64
For intLoop2 = lngBytesToAdd To lngLength - intLoop - lngTrace Step 64
For intInnerLoop = 0 To 63
arrSplit64(intInnerLoop) = bytBuffer(intLoop2 + intInnerLoop)
Next intInnerLoop
MD5Conversion arrSplit64
Next intLoop2
lngBytesTotal = 0
Else
intLoop2 = 0
End If
For intLoop3 = 0 To lngLength - intLoop2 - 1
arrSplit64(lngBytesTotal + intLoop3) = bytBuffer(intLoop2 + intLoop3)
Next intLoop3
End Function

Private Function MD5StringArray(strInput As String) As Byte()
Dim intLoop As Integer
Dim bytBuffer() As Byte
ReDim bytBuffer(Len(strInput))

For intLoop = 0 To Len(strInput) - 1
bytBuffer(intLoop) = Asc(Mid(strInput, intLoop + 1, 1))
Next intLoop
MD5StringArray = bytBuffer
End Function

Private Sub MD5Conversion(bytBuffer() As Byte)
Dim x(16) As Long, a As Long
Dim b As Long, C As Long
Dim d As Long

a = arrLongConversion(1)
b = arrLongConversion(2)
C = arrLongConversion(3)
d = arrLongConversion(4)
MD5Decode 64, x, bytBuffer
MD5Round "FF", a, b, C, d, x(0), S11, -680876936
MD5Round "FF", d, a, b, C, x(1), S12, -389564586
MD5Round "FF", C, d, a, b, x(2), S13, 606105819
MD5Round "FF", b, C, d, a, x(3), S14, -1044525330
MD5Round "FF", a, b, C, d, x(4), S11, -176418897
MD5Round "FF", d, a, b, C, x(5), S12, 1200080426
MD5Round "FF", C, d, a, b, x(6), S13, -1473231341
MD5Round "FF", b, C, d, a, x(7), S14, -45705983
MD5Round "FF", a, b, C, d, x(8), S11, 1770035416
MD5Round "FF", d, a, b, C, x(9), S12, -1958414417
MD5Round "FF", C, d, a, b, x(10), S13, -42063
MD5Round "FF", b, C, d, a, x(11), S14, -1990404162
MD5Round "FF", a, b, C, d, x(12), S11, 1804603682
MD5Round "FF", d, a, b, C, x(13), S12, -40341101
MD5Round "FF", C, d, a, b, x(14), S13, -1502002290
MD5Round "FF", b, C, d, a, x(15), S14, 1236535329
MD5Round "GG", a, b, C, d, x(1), S21, -165796510
MD5Round "GG", d, a, b, C, x(6), S22, -1069501632
MD5Round "GG", C, d, a, b, x(11), S23, 643717713
MD5Round "GG", b, C, d, a, x(0), S24, -373897302
MD5Round "GG", a, b, C, d, x(5), S21, -701558691
MD5Round "GG", d, a, b, C, x(10), S22, 38016083
MD5Round "GG", C, d, a, b, x(15), S23, -660478335
MD5Round "GG", b, C, d, a, x(4), S24, -405537848
MD5Round "GG", a, b, C, d, x(9), S21, 568446438
MD5Round "GG", d, a, b, C, x(14), S22, -1019803690
MD5Round "GG", C, d, a, b, x(3), S23, -187363961
MD5Round "GG", b, C, d, a, x(8), S24, 1163531501
MD5Round "GG", a, b, C, d, x(13), S21, -1444681467
MD5Round "GG", d, a, b, C, x(2), S22, -51403784
MD5Round "GG", C, d, a, b, x(7), S23, 1735328473
MD5Round "GG", b, C, d, a, x(12), S24, -1926607734
MD5Round "HH", a, b, C, d, x(5), S31, -378558
MD5Round "HH", d, a, b, C, x(8), S32, -2022574463
MD5Round "HH", C, d, a, b, x(11), S33, 1839030562
MD5Round "HH", b, C, d, a, x(14), S34, -35309556
MD5Round "HH", a, b, C, d, x(1), S31, -1530992060
MD5Round "HH", d, a, b, C, x(4), S32, 1272893353
MD5Round "HH", C, d, a, b, x(7), S33, -155497632
MD5Round "HH", b, C, d, a, x(10), S34, -1094730640
MD5Round "HH", a, b, C, d, x(13), S31, 681279174
MD5Round "HH", d, a, b, C, x(0), S32, -358537222
MD5Round "HH", C, d, a, b, x(3), S33, -722521979
MD5Round "HH", b, C, d, a, x(6), S34, 76029189
MD5Round "HH", a, b, C, d, x(9), S31, -640364487
MD5Round "HH", d, a, b, C, x(12), S32, -421815835
MD5Round "HH", C, d, a, b, x(15), S33, 530742520
MD5Round "HH", b, C, d, a, x(2), S34, -995338651
MD5Round "II", a, b, C, d, x(0), S41, -198630844
MD5Round "II", d, a, b, C, x(7), S42, 1126891415
MD5Round "II", C, d, a, b, x(14), S43, -1416354905
MD5Round "II", b, C, d, a, x(5), S44, -57434055
MD5Round "II", a, b, C, d, x(12), S41, 1700485571
MD5Round "II", d, a, b, C, x(3), S42, -1894986606
MD5Round "II", C, d, a, b, x(10), S43, -1051523
MD5Round "II", b, C, d, a, x(1), S44, -2054922799
MD5Round "II", a, b, C, d, x(8), S41, 1873313359
MD5Round "II", d, a, b, C, x(15), S42, -30611744
MD5Round "II", C, d, a, b, x(6), S43, -1560198380
MD5Round "II", b, C, d, a, x(13), S44, 1309151649
MD5Round "II", a, b, C, d, x(4), S41, -145523070
MD5Round "II", d, a, b, C, x(11), S42, -1120210379
MD5Round "II", C, d, a, b, x(2), S43, 718787259
MD5Round "II", b, C, d, a, x(9), S44, -343485551
arrLongConversion(1) = MD5LongAdd(arrLongConversion(1), a)
arrLongConversion(2) = MD5LongAdd(arrLongConversion(2), b)
arrLongConversion(3) = MD5LongAdd(arrLongConversion(3), C)
arrLongConversion(4) = MD5LongAdd(arrLongConversion(4), d)
End Sub

Private Function MD5LongAdd(lngVal1 As Long, lngVal2 As Long) As Long
Dim lngHighWord As Long
Dim lngLowWord As Long
Dim lngOverflow As Long

lngLowWord = (lngVal1 And &HFFFF&) + (lngVal2 And &HFFFF&)
lngOverflow = lngLowWord \ 65536
lngHighWord = (((lngVal1 And &HFFFF0000) \ 65536) + _
((lngVal2 And &HFFFF0000) \ 65536) + _
lngOverflow) And &HFFFF&
MD5LongAdd = MD5LongConversion((lngHighWord * 65536#) + _
(lngLowWord And &HFFFF&))
End Function

Private Function MD5LongAdd4(lngVal1 As Long, lngVal2 As Long, _
lngVal3 As Long, lngVal4 As Long) As Long
Dim lngHighWord As Long
Dim lngLowWord As Long
Dim lngOverflow As Long

lngLowWord = (lngVal1 And &HFFFF&) + (lngVal2 And &HFFFF&) + _
(lngVal3 And &HFFFF&) + (lngVal4 And &HFFFF&)
lngOverflow = lngLowWord \ 65536
lngHighWord = (((lngVal1 And &HFFFF0000) \ 65536) + _
((lngVal2 And &HFFFF0000) \ 65536) + _
((lngVal3 And &HFFFF0000) \ 65536) + _
((lngVal4 And &HFFFF0000) \ 65536) + _
lngOverflow) And &HFFFF&
MD5LongAdd4 = MD5LongConversion((lngHighWord * 65536#) + _
(lngLowWord And &HFFFF&))
End Function

Private Sub MD5Decode(intLength As Integer, lngOutBuffer() As Long, _
bytInBuffer() As Byte)
Dim intDblIndex As Integer
Dim intByteIndex As Integer
Dim dblSum As Double

intDblIndex = 0
For intByteIndex = 0 To intLength - 1 Step 4
dblSum = bytInBuffer(intByteIndex) + _
bytInBuffer(intByteIndex + 1) * 256# + _
bytInBuffer(intByteIndex + 2) * 65536# + _
bytInBuffer(intByteIndex + 3) * 16777216#
lngOutBuffer(intDblIndex) = MD5LongConversion(dblSum)
intDblIndex = (intDblIndex + 1)
Next intByteIndex
End Sub

Private Function MD5LongConversion(dblValue As Double) As Long
If dblValue < 0 Or dblValue >= OFFSET_4 Then Error 6
If dblValue <= MAXINT_4 Then
MD5LongConversion = dblValue
Else
MD5LongConversion = dblValue - OFFSET_4
End If
End Function

Private Sub MD5Finish()
Dim dblBits As Double
Dim arrPadding(72) As Byte
Dim lngBytesBuffered As Long

arrPadding(0) = &H80
dblBits = lngTrack * 8
lngBytesBuffered = lngTrack Mod 64
If lngBytesBuffered <= 56 Then
MD564Split (56 - lngBytesBuffered), arrPadding
Else
MD564Split (120 - lngTrack), arrPadding
End If
arrPadding(0) = MD5LongConversion(dblBits) And &HFF&
arrPadding(1) = MD5LongConversion(dblBits) \ 256 And &HFF&
arrPadding(2) = MD5LongConversion(dblBits) \ 65536 And &HFF&
arrPadding(3) = MD5LongConversion(dblBits) \ 16777216 And &HFF&
arrPadding(4) = 0
arrPadding(5) = 0
arrPadding(6) = 0
arrPadding(7) = 0
MD564Split 8, arrPadding
End Sub

Private Function MD5StringChange(lngnum As Long) As String
Dim bytA As Byte
Dim bytB As Byte
Dim bytC As Byte
Dim bytD As Byte

bytA = lngnum And &HFF&
If bytA < 16 Then
MD5StringChange = "0" & Hex(bytA)
Else
MD5StringChange = Hex(bytA)
End If
bytB = (lngnum And &HFF00&) \ 256
If bytB < 16 Then
MD5StringChange = MD5StringChange & "0" & Hex(bytB)
Else
MD5StringChange = MD5StringChange & Hex(bytB)
End If
bytC = (lngnum And &HFF0000) \ 65536
If bytC < 16 Then
MD5StringChange = MD5StringChange & "0" & Hex(bytC)
Else
MD5StringChange = MD5StringChange & Hex(bytC)
End If
If lngnum < 0 Then
bytD = ((lngnum And &H7F000000) \ 16777216) Or &H80&
Else
bytD = (lngnum And &HFF000000) \ 16777216
End If
If bytD < 16 Then
MD5StringChange = MD5StringChange & "0" & Hex(bytD)
Else
MD5StringChange = MD5StringChange & Hex(bytD)
End If
End Function

Private Function MD5Value() As String
MD5Value = LCase(MD5StringChange(arrLongConversion(1)) & _
MD5StringChange(arrLongConversion(2)) & _
MD5StringChange(arrLongConversion(3)) & _
MD5StringChange(arrLongConversion(4)))
End Function

Public Function FnsCalculateMD5(strMessage As String) As String
Dim bytBuffer() As Byte

bytBuffer = MD5StringArray(strMessage)
MD5Start
MD564Split Len(strMessage), bytBuffer
MD5Finish
FnsCalculateMD5 = MD5Value 'Korrigiert by Willi Wipp
End Function

Private Sub MD5Start()
lngTrack = 0
arrLongConversion(1) = MD5LongConversion(1732584193#)
arrLongConversion(2) = MD5LongConversion(4023233417#)
arrLongConversion(3) = MD5LongConversion(2562383102#)
arrLongConversion(4) = MD5LongConversion(271733878#)
End Sub
Aufruf z.B.:
Debug.Print FnsCalculateMD5("DeinText")

Merlin1811
12.07.2006, 12:38
Hallo Arne,
hallo Tommy,

ich probiere es gerade mit Tommys Code. Es ist doch richtig, dass ich ein neues Modul erzeuge (Name egal ?) und den obersten Code fort hinein füge.
Im Formular rufe ich den 2. Code per Klick auf, oder ?

VG Lars

TommyK
12.07.2006, 12:41
Hallo Lars,

genau so. Das Modul darf nur nicht den Namen einer enthaltenen Prozedur haben.

Merlin1811
12.07.2006, 12:44
Ok, das habe ich verstanden. Wenn ich aber den Hashcode an den Internet Explorer übergeben möchte, wie sähe denn da der Aufruf aus ?

TommyK
12.07.2006, 12:51
Hallo Lars,

da bin ich überfragt. Du kannst ja den Hash Wert erstmal in eine Variable schreiben aber wie weiter, kein Ahnung.

Merlin1811
12.07.2006, 14:39
Hallo !

Vielen Dank für Eure Hilfe, es klappt einwandfrei.
Den Aufruf habe ich so gestaltet :


Private Sub vertrag_drucken_Click()
On Error GoTo Err_Befehl85_Click

Dim stAppName As String

stAppName = "C:\Programme\Internet Explorer\IEXPLORE.EXE http://www.domain.de/antrag.ausgabe.php?kd_id=" & Me!kd_id & "&kd_homedir=" & kd_homedir & "&kd_passwortmd5=" & FnsCalculateMD5(Me!kd_passwort)

Call Shell(stAppName, 1)

Exit_Befehl85_Click:
Exit Sub

Err_Befehl85_Click:
MsgBox Err.Description
Resume Exit_Befehl85_Click

End Su


Viele Grüße
Lars

melodoi
14.08.2007, 13:17
Hi TommyK,
hast du auch die Möglichkeit die md5-Summe von einer Datei zu bilden?

Gruß Sylvio

TommyK
14.08.2007, 14:05
Hallo Sylvio,

Nein, aber eine CRC32 Prüfsumme.

melodoi
14.08.2007, 16:06
Kannste den bitte mal posten?