4,082
questions
0
votes
2
answers
27
views
Performing data validation using hash comparison on snowflake tables
Here is the scenario:
I have data in two schemas within Snowflake, aiming to validate that both tables contain identical data values. I’ve set up a dynamic SQL approach in Snowflake to accomplish this....
1
vote
1
answer
107
views
Is there a way to speed up my code to find an md5 hash that starts with all zeros?
It is just for a hobby, no official or serious stuff involved. I do have a question though; when running this code, it computes around 400 million md5 hashes in the first second, then it drops down to ...
user12316363
0
votes
0
answers
18
views
Why is echo "string" | md5 AND md5 -s "string", give different has values? [duplicate]
echo 'string' | md5 and md5 <<< 'string' both give the result:
b80fa55b1234f1935cea559d9efbc39a
Whereas md5 -s 'string' gives the result: b45cffe084dd3d20d928bee85e7b0f21
Why is this so?
Edit:...
- 23
0
votes
1
answer
78
views
Problem with PgBouncer auth method not same type
I have some issues with the auth method in PgBouncer and Postgresql.
Error:
2024-09-28 10:49:28.750 UTC [120] LOG process up: PgBouncer 1.23.1, libevent 2.1.12-stable (epoll), adns: evdns2, tls: ...
- 135
-1
votes
1
answer
83
views
How to turn MD5 into hexadecimal?
I am doing an advent of code problem and need to convert MD5 into hex, and I have no clue where to begin.
I tried multiple websites, but none helped, but there were some stack overflow questions that ...
- 3
0
votes
1
answer
100
views
Why such a token is considered to have a weak entropy? [closed]
I am using the following code in my code to send a password reset token to a user.
$token = md5($user_id . time());
Why this is considered as a bad approach being cited as it has a weak entropy? The ...
- 1,763
1
vote
0
answers
65
views
hash from openssl and MySQL for MD5 and SHA256 is different
echo -n 'yourstring' | openssl dgst -md5
MD5(stdin)= 5d7aed02367214a092f9eefed33f86d7
SELECT MD5('yourstring');
0653fc45290cd602be895bb8d054942c
echo -n 'yourdata' | openssl dgst -sha256
SHA2-256(...
0
votes
2
answers
82
views
Check the md5sum of a file with bash
I am currently working on the LFS project along with the book and a video to guide me through some parts of it. However, as I came across checking the MD5 of some packages the verification of this ...
0
votes
0
answers
27
views
How can I re-generate an MD5 hash for an XML section?
I have the following XML code snippet:
<DeviceDataSection SectionType="1" Version="1" DataLength="32" SectionLength="64" MD5="...
- 187
0
votes
0
answers
49
views
Swift md5 from image
I want convert to md5 hash my image. I have created data from image. let data = image.jpegData(compressionQuality: 1) And i convert it with extension but appears to be different from the hash ...
- 11
0
votes
1
answer
67
views
Is it possible to get md5 of the entire table in SQL Server? E.g., by hashbytes
We want to get the md5 checksum of the entire table to verify the consistency of data, e.g. using the hashbytes() function of SQL Server.
As an intermediate step in the proof of concept, we figured ...
- 55
0
votes
0
answers
32
views
How to write a MD5 SQL Code in Oracle similar to Informatica Expression Logic for Validation
My requirement is to write a sql code to replicate the MD5 Logic used in informatica expression transformation for Validation Purpose . The MD5 used in Informatica is MD5(TRIM(AGRMNT_NO)||TRIM(SRC_CD))...
- 251
0
votes
1
answer
105
views
System.Security.Cryptography.MD5 Hash is producing two different hashes for same file contents created at different times
I have a very simple application that's attempting to compute the MD5 hashes of two different files.
The contents of the files is just the text: abc (I checked for spaces and newlines - they are ...
2
votes
1
answer
90
views
Generate UTF-8 MD5 hash for Chinese in SQL Server
SELECT LOWER(CONVERT(VARCHAR(32), HASHBYTES('MD5', 'a'), 2));
Result : 0cc175b9c0f1b6a831c399e269772661
This is OK.
SELECT LOWER(CONVERT(VARCHAR(32), HASHBYTES('MD5', '啊'), 2));
Result : ...
- 21
-1
votes
1
answer
88
views
AzCopy log file - MD5 mismatch
I'm using AzCopy --check-md5 while downloading files from storage account.
However, I case of Md5 mismatch, how can I check this in the azcopy.log file? How is the Md5 mismatch error logged in the ...
- 1