c# - decrypt an encrypted value? -
i have old paradox database (i can convert access 2007) contains more 200,000 records. database has 2 columns: first 1 named "word" , second 1 named "mean". dictionary database , client wants convert old database asp.net , sql.
however, don't know key or method used encrypt or encode "mean" column in unicode format. software has been written in delphi 7 , don't have source code. client knows credentials logging in database. problem decoding mean column.
what have compiled windows application , paradox database. software can decode "mean" column each "word" method and/or key in own compiled code(.exe) or 1 of files in directory.
for example, know in following row "zymurgy" means "مبحث عمل تخمیر در شیمی علمی, تخمیر شناسی" since application translates that. here record looks when open database in access:
word mean zymurgy 5obnggukpddad7l2lnvd9lnf1mdd2zdbqrxngscuirk5h91svmy0kprcue/+ql9ormp99mn/qz4=
therefore we're trying discover how value in mean column converted "مبحث عمل تخمیر در شیمی علمی, تخمیر شناسی". think "mean" column value in above row encoded in base64 string format, decoding base64 string not yet result in expected text.
the extensions files in win app directory dll, ccc, dat, exe (other main app file), sys, fam, mb, px, tv, val.
any kind of appreciated.
here 2 more example , remember double quotes @ start , end not part of strings:
word: "abdominal" coded value: "vwtj0bmj7jdf9ss8sbrialbokmdvtbprafgg4gp/g9glx5iu/e98rq==" translation in farsi: "شکمی, بطنی, وریدهای شکمی, ماهیان بطنی" word: "cart" coded value: "khockdsindb6okjxvxsh+ti+ia/zqp9sz28e4/cqzmyli+topbiloaecwq8xkxtz" translation in farsi: "ارابه, گاری, دوچرخه, چرخ, با گاری بردن"
here result in different encodings:
1- in unicode result is: "ᩧ訋퀽矀箖�柖�섰᱁艧껀늊螹泝汖銴岔也捆鹁" 2- in utf32 result is: "��������������" 3- in utf7 result is: "äàg\v=ÐÀw²ö{Ýô¹ßÖg]Û0ÁagÀ®²¹Ýlvl´\\¹ïþª_nfcýôÉÿa" 4- in utf8 result is: "��g\v�=��w���{����g]�0�ag��������lvl���\\����_nfc����a�" 5- in 1256 result is: "نàg\vٹ=ذہw²ِ–{فô¹كضg]غ0ءag‚ہ®ٹ²¹‡فlvl´’”\\¹ïھ_nfcôةےa"
yet discovered paradox database system complex when comes key management , of time keys "compound keys" , that's why it's problematic , that's why it's abandoned!
update: i'm trying automation using autoit v3 because decryption process understand can't done in 1 or 2 days. have problem related text/font. when copy translated text notepad change unrecognizable text unless change font of notepad font of translation software. if type in notepad in farsi show correctly regardless of font i've been chosen. more interesting when copy text other program ms office word it'll shown correctly no matter font choose.
so how can around ?
in situation, think writing script/program pull data out through existing program.
you write application send keypresses app select , copy each value in turn.
it take while run, leave overnight (how big database?) , has run once.
not sure how easy be, since haven't seen app of course - might work?
Comments
Post a Comment