Online MD5 Hash Generator

I have developed a Cron job that auto update the file "pool_passwd", similiar to this case from the internet: http://pgpool.net/mantisbt/view.php?id=170

Had set up ".pgpass" file to avoid asking for a password.

And below is the Cron job code running over the pgpool server:

psql -hlocalhost -Upostgres -p9999 -dpostgres -c "\COPY ( SELECT rolname || ':' || rolpassword FROM pg_authid WHERE rolcanlogin = 'TRUE' AND rolpassword != 'NULL' ) TO '/etc/pgpool-II/pool_passwd';"

But, this Cron job runs every minute regardless of users/passwords has been changed so, it doesn't seem the perfect solution.

Everything works fine but, I believe that a trigger that can be executed only when changes on users or passwords occur on the table "pg_authid" would be much better. Also, it can reduce the overhead on the server as it will update less the file "pool_passwd".

My question is how to do it? (is that possible?)

I'm trying to recreate an existing mobile apps into flutter but struggling in the "PBEWithMD5AndDES" encryption on android which I can't seem to find similar way in dart.

This is so far what I've tried to achieve the same using Flutter_Des.dart, Password_Hash.dart and Crypto.dart library but still can't get the same output.

encryptPassword(String keyStr, String passwordStr) async {    if (keyStr.length == 0 || passwordStr.length == 0) {      return "";    }    var generator = new PBKDF2(hashAlgorithm: md5);    String saltStr = generateSaltBase64String();    var hash = generator.generateBase64Key(keyStr, saltStr, round, keyLength);    var encryptBase64 = await FlutterDes.encryptToBase64(passwordStr, hash.toString());    return encryptBase64;  }

Below is what I have currently on Android.

KeySpec keySpec = new PBEKeySpec(str.toCharArray(), salt, iterationCount);        SecretKey key = SecretKeyFactory.getInstance("PBEWithMD5AndDES").generateSecret(keySpec);        AlgorithmParameterSpec paramSpec = new PBEParameterSpec(salt, iterationCount);        ecipher = Cipher.getInstance("PBEWithMD5AndDES");        ecipher.init(Cipher.ENCRYPT_MODE, key, paramSpec);        byte[] utf8 = password.getBytes("UTF8");        byte[] enc = ecipher.doFinal(utf8);        enc = Base64.encode(enc, Base64.DEFAULT);        return new String(enc);

I'm expecting the same output as android so my backend able to decrypt it.

Should I expect these md5sums to be the same?

url = 'http://stackoverflow.com/opensearch.xml'shl = paste0('curl -s ', url, '|md5sum')shell(shl, intern = T)#"1dbeef7406e5054197382916ff72e29b *-"fl = 'temp.xml'download.file(url = url, destfile = fl, mode = 'wb')tools::md5sum(fl)#"96bdf6d80c0bb6e27620079e2f6f7237" 

If not, is comparing files like this generally possible?

Or is there another method to check that files are not corrupted during download if the source does not provide checksum?

UPDATE:

url = 'https://www.ncl.ucar.edu/Applications/Data/bin/latlon.bin'shl = paste0('curl -sL ', url, '|md5sum')shell(shl, intern = T)#"d41d8cd98f00b204e9800998ecf8427e *-"fl = 'temp'download.file(url = url, destfile = fl, mode = 'wb')tools::md5sum(fl)#"1a1eeb7a09418f047588148395096b91" 

It seems to return different md5 values if the file is .bin

I want to convert a string like "abc" to an MD5 hash. I want to do this in iOS and Swift. I have tried using the solutions below but they were not working for me:

Importing CommonCrypto in a Swift framework

How to use CC_MD5 method in swift language.

http://iosdeveloperzone.com/2014/10/03/using-commoncrypto-in-swift/

To be more clear, I want to achieve an output in Swift similar to this PHP code's output:

$str = "Hello";echo md5($str);

Output: 8b1a9953c4611296a827abf8c47804d7

Using C#, I want to create an MD5 hash of a text file. How can I accomplish this?

Update: Thanks to everyone for their help. I've finally settled upon the following code -

// Create an MD5 hash digest of a filepublic string MD5HashFile(string fn){                byte[] hash = MD5.Create().ComputeHash(File.ReadAllBytes(fn));    return BitConverter.ToString(hash).Replace("-", "");            }