get mysql aes_encrypt equivalent in .net

Question

4.33/5 (2 votes)

See more:

, +

how can I encrypt or decrypt a text string using aes in .net that is equivalent to mysql_encrypt() and mysql_decrypt() ? .

I had simulated mysql_encrypt and mysql_decrypt using following code:

PHP

<?php
 // Key Function
 define('MY_KEY','keyfor$am@naT@480IsHere');
function mysql_aes_key($key)
{
    $new_key = str_repeat(chr(0), 16);
    for($i=0,$len=strlen($key);$i<$len;$i++)
    {
        $new_key[$i%16] = $new_key[$i%16] ^ $key[$i];
    }

    return $new_key;
}

//  AES Encryption
function aes_encrypt($val)
{
    $key = mysql_aes_key(MY_KEY);
    //echo $key gives     [, . Aam@naT@48
    $pad_value = 16-(strlen($val) % 16);
    $val = str_pad($val, (16*(floor(strlen($val) / 16)+1)), chr($pad_value));

    $encodedVal=mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $key, $val, MCRYPT_MODE_ECB, mcrypt_create_iv( mcrypt_get_iv_size(MCRYPT_RIJNDAEL_128, MCRYPT_MODE_ECB), MCRYPT_DEV_URANDOM));
    //this is main incoding block  which take string and gives encoded byte
    //$encodedVal  encoded byte
    return base64_encode($encodedVal); //return $encodedVal as string
}


//  AES Decryption
function aes_decrypt($v)
{
    $key = mysql_aes_key(MY_KEY);
    $val=base64_decode((string)($v));  // $v is string , this convert string to byte

    $decodedVal = mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $val, MCRYPT_MODE_ECB, mcrypt_create_iv( mcrypt_get_iv_size(MCRYPT_RIJNDAEL_128, MCRYPT_MODE_ECB), MCRYPT_DEV_URANDOM));

    //this is main incoding block  which take byte and gives decoded string
    return rtrim($decodedVal, "\0..\16");
}



?>

PHP

<?php
 $aesData=aes_encrypt("RajanAdhikari");
 $aesDataBack= aes_decrypt($aesData);


 $aesData2=aes_encrypt("Zoltan zorgo");
 $aesDataBack2= aes_decrypt($aesData2);

  echo "Static Key is ".MY_KEY ."<br>";
      //gives Static Key is keyfor$am@naT@480IsHere
  echo  "modified Key by mysql_aes_key is ".mysql_aes_key(MY_KEY) ."<br><br>";
      //gives modified Key by mysql_aes_key is [, . Aam@naT@48

  echo "Aes is   ".$aesData ."<br>";
      // gives  Aes is Vk5UxUzn5xAye5R/xqcvxA==
  echo "Data is   ".$aesDataBack ."<br> <br>";
      // gives Data is RajanAdhikari
  echo "Aes2 is   ".$aesData2 ."<br>";
      // gives  Aes is Vk5UxUzn5xAye5R/xqcvxA==
  echo "Data2 is   ".$aesDataBack2 ."<br>";
      // gives Data is RajanAdhikari
  ?>

Problem is i have encrypt some data by web (using php) and stored in mysql database.
now i have to fetch , decrypt and show that data in vb.net desktop application .

Now I have to get this in vb.net (or in c#.net).
how to achieve this?
is it possible? if then how?
thanks in advanced.

Posted 1-Jun-13 21:09pm

Surendra Adhikari SA

Updated 3-Jun-13 5:43am

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-06-01T23:37:00

I assume you didn't visit google in this topic... pity :(
http://www.dreamincode.net/forums/topic/156922-aes-encryption-and-c%23/[^]

[update]
This is working for me:

C#

string decrypt_function(byte[] Cipher_Text, byte[] Key)
        {
            RijndaelManaged Crypto = null;
            MemoryStream MemStream = null;
            ICryptoTransform Decryptor = null;
            CryptoStream Crypto_Stream = null;
            StreamReader Stream_Read = null;
             string Plain_Text;

             try
             {
                Crypto = new RijndaelManaged();
                Crypto.Key = Key;
		Crypto.Mode = CipherMode.ECB;

                MemStream = new MemoryStream(Cipher_Text);

                 //Create Decryptor make sure if you are decrypting that this is here and you did not copy paste encryptor.
                 Decryptor = Crypto.CreateDecryptor(Crypto.Key, Crypto.IV);

                 //This is different from the encryption look at the mode make sure you are reading from the stream.
                 Crypto_Stream = new CryptoStream(MemStream, Decryptor, CryptoStreamMode.Read);

                //I used the stream reader here because the ReadToEnd method is easy and because it return a string, also easy.
                 Stream_Read = new StreamReader(Crypto_Stream);
                 Plain_Text = Stream_Read.ReadToEnd();
             }
            finally
            {
                if (Crypto != null)
                    Crypto.Clear();

                MemStream.Flush();
                MemStream.Close();

            }
            return Plain_Text;
        }

byte[] mkey(string skey)
{
	Encoding winLatinCodePage = Encoding.GetEncoding(1252);
	byte[] key = Encoding.UTF8.GetBytes(skey);
	byte[] k = new byte[16] {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
	for(int i=0;i<key.Length;i++)
	{
	k[i%16] = (byte)(k[i%16] ^ key[i]);
	}
		
	return k;
}


void Main()
{
string sk="keyfor$am@naT@480IsHere";
string enc="Vk5UxUzn5xAye5R/xqcvxA==";
string dec = decrypt_function(System.Convert.FromBase64String(enc), mkey(sk));

dec.Dump();
}

This is a linqpad test, but the code is there. I had done a little modification to the code from the link to: I have changed the mode.