| Author |
Topic |
|
mystical_sun2000
Starting Member
5 Posts |
 Posted - 2006-06-14 : 09:33:37
|
| Hi there,I am having a table in Sql which has 2 columns which has data in encrypted format. It shows data in junk format (ascii format). But in frontend (tht is in software)it shows data in proper format. Can any one help me in decrypting data.Thanks,Regards,mystical |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-14 : 09:48:45
|
| If the data was encrypted by a strong encryption method, like AES, DES, or PGP, it is very unlikely that you can decrypt the data without knowing the decryption algorithim and the decryption key.CODO ERGO SUM |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-15 : 07:14:49
|
quote:
Originally posted by mystical_sun2000
I am having a table in Sql which has 2 columns which has data in encrypted format. It shows data in junk format (ascii format). But in frontend (tht is in software)it shows data in proper format. Can any one help me in decrypting data.
Do you have have a clue of what the data is? Names? Addresses? Other?Perhaps it is just a simple XOR? Or Mime?Also, in the frontend application, is there an ID for each object you view?Please post here data from table (column names) and data from the front-end application how it looks like decrypted.Peter LarssonHelsingborg, Sweden |
|
|
|
mystical_sun2000
Starting Member
5 Posts |
Posted - 2006-06-16 : 10:00:49
|
| Hi there,Thanks for your kind replies. The encrypted data luks in this way likeFalse luks like b$#.1'True luks like \SquareSymbol SquareSymbol SquareSymbolQVIComponent luks like ^SquareSymbol22~18~*6;~?<1(;STCommand Class luks like _SquareSymbol022>1;SquareSymbol<3>,,RULock luks like 5yZV^SquareSymbolSquareSymbolSquareSymbol8?Unlock luks like 8MVtW[SSquareSymbolSquareSymbol52End luks like 9|W]43% luks like 4SquareSymbol9>[] luks like Okm=:^ luks like ;e61Page_Unload luks like 9iX^\flWUVX] 43Hope this helps you to decrypt it. Please help.Thanking you and waiting for your kind reply.mystical |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-16 : 11:16:56
|
| Damn it, Jim, I’m a DBA, not a cryptanalyst!CODO ERGO SUM |
|
|
|
mystical_sun2000
Starting Member
5 Posts |
Posted - 2006-06-22 : 06:55:22
|
| Can no one help me. Please Help. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-06-22 : 11:43:11
|
| Dude, the point of encryption is to PREVENT you from being able to unscramble it. Duh. And if anybody on the forum did know a way to crack the cipher, I hope they would not go blindly sharing it with some stranger.Before you ask for any more help with this, at least come up with a semi-plausible reason why you need to decrypt this. We are not here to help you break into other people's systems. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-06-22 : 13:41:30
|
| In other words....you're an idiot. Ooooops....sorry, that just kind of slipped out. I take it back, because I don't want to be rude. Why don't you buy a book that covers data encryption and start reading. There's a REASON it's decrypted in the application and not at the database layer. Have you considered talking to the developers, or do you not work for the company?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-06-22 : 15:08:31
|
| On a related question, my bank uses a Sargent & Greenleaf mechanical automatic deadbolt lock on its vault, with a dogging switch and an overlap strike design. Can anybody tell me how to open this without the combination?Anybody? Anybody?Can no one help me? |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-06-22 : 16:32:00
|
quote:
Originally posted by blindman
On a related question, my bank uses a Sargent & Greenleaf mechanical automatic deadbolt lock on its vault, with a dogging switch and an overlap strike design. Can anybody tell me how to open this without the combination?Anybody? Anybody?Can no one help me?
I think you need to use a General Number Field Sieve.rockmoose |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-22 : 19:38:57
|
quote:
Originally posted by blindman
On a related question, my bank uses a Sargent & Greenleaf mechanical automatic deadbolt lock on its vault, with a dogging switch and an overlap strike design. Can anybody tell me how to open this without the combination?Anybody? Anybody?Can no one help me?
Sometimes, the brute force approach is best:http://www.defense-update.com/products/r/rpg.htmCODO ERGO SUM |
|
|
|
mystical_sun2000
Starting Member
5 Posts |
Posted - 2006-06-23 : 01:59:38
|
| hey there who tried to be oversmart. I just asked for help. If u can help then I will be thankful else thanks but i dont require that extra comments and your oversmartness. And Even my tongue can slip and i can go beyond idiot (Even I dont want to be rude). Everyone is specialised in his own field my prob is tht i m new to SQL.. u may b good in SQL doesn't really means u can speak anything.... so be careful... helping someone doesnt mean u can say anything.......if so then thanks I dont require your help I will findout my way."PUT URSELF IN OTHERS SHOE IF IT BITES U IT MAY BITE THT PERSON TOO" |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-06-23 : 03:12:47
|
| I couldn't decrypt that. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2006-06-23 : 08:40:33
|
| What they are trying to tell you is that if the data is encrypted it is because whoever designed it does not want you looking at the data. Also if no one has given you the encryption key it is probably because you are not authorized to see the data. Last if you are trying to do this on your own then you are trying to get yourself fired or thrown in jail.Another Darwin canidate.JimUsers <> Logic |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-06-23 : 09:28:06
|
| My shoe's bark is worse than it's bite. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-06-23 : 09:33:52
|
quote:
Originally posted by blindman
My shoe's bark is worse than it's bite.
You wouldn't be trying to sabotage this thread, wooden shoe? |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-06-23 : 10:18:45
|
| A bi-lingual pun. Excellent! |
|
|
|
|
Decrypting data