py-PL-SQL-unwrapper/plsql_unwrap.py at master · ReneNyffenegger/py-PL-SQL-unwrapper · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
#!/usr/bin/python3
#
# https://renenyffenegger.ch/notes/Linux/fhs/u01/app/oracle/product/vv-v-v/dbhome_n/bin/wrap/
#
# This script unwraps Oracle wrapped plb packages, does not support 9g
#
# Originally written by niels at teusink net / blog.teusink.net for Python 2
# See https://github.com/DarkAngelStrike/UnwrapperPLSQL
#
# V.1 Adapted by René Nyffenegger for Python 3
# V.2 Add extract_interesting()
#
# License: Public domain
#
import base64
import zlib
import re

charmap = [0x3d, 0x65, 0x85, 0xb3, 0x18, 0xdb, 0xe2, 0x87, 0xf1, 0x52, 0xab, 0x63, 0x4b, 0xb5, 0xa0, 0x5f,
           0x7d, 0x68, 0x7b, 0x9b, 0x24, 0xc2, 0x28, 0x67, 0x8a, 0xde, 0xa4, 0x26, 0x1e, 0x03, 0xeb, 0x17,
           0x6f, 0x34, 0x3e, 0x7a, 0x3f, 0xd2, 0xa9, 0x6a, 0x0f, 0xe9, 0x35, 0x56, 0x1f, 0xb1, 0x4d, 0x10,
           0x78, 0xd9, 0x75, 0xf6, 0xbc, 0x41, 0x04, 0x81, 0x61, 0x06, 0xf9, 0xad, 0xd6, 0xd5, 0x29, 0x7e,
           0x86, 0x9e, 0x79, 0xe5, 0x05, 0xba, 0x84, 0xcc, 0x6e, 0x27, 0x8e, 0xb0, 0x5d, 0xa8, 0xf3, 0x9f,
           0xd0, 0xa2, 0x71, 0xb8, 0x58, 0xdd, 0x2c, 0x38, 0x99, 0x4c, 0x48, 0x07, 0x55, 0xe4, 0x53, 0x8c,
           0x46, 0xb6, 0x2d, 0xa5, 0xaf, 0x32, 0x22, 0x40, 0xdc, 0x50, 0xc3, 0xa1, 0x25, 0x8b, 0x9c, 0x16,
           0x60, 0x5c, 0xcf, 0xfd, 0x0c, 0x98, 0x1c, 0xd4, 0x37, 0x6d, 0x3c, 0x3a, 0x30, 0xe8, 0x6c, 0x31,
           0x47, 0xf5, 0x33, 0xda, 0x43, 0xc8, 0xe3, 0x5e, 0x19, 0x94, 0xec, 0xe6, 0xa3, 0x95, 0x14, 0xe0,
           0x9d, 0x64, 0xfa, 0x59, 0x15, 0xc5, 0x2f, 0xca, 0xbb, 0x0b, 0xdf, 0xf2, 0x97, 0xbf, 0x0a, 0x76,
           0xb4, 0x49, 0x44, 0x5a, 0x1d, 0xf0, 0x00, 0x96, 0x21, 0x80, 0x7f, 0x1a, 0x82, 0x39, 0x4f, 0xc1,
           0xa7, 0xd7, 0x0d, 0xd1, 0xd8, 0xff, 0x13, 0x93, 0x70, 0xee, 0x5b, 0xef, 0xbe, 0x09, 0xb9, 0x77,
           0x72, 0xe7, 0xb2, 0x54, 0xb7, 0x2a, 0xc7, 0x73, 0x90, 0x66, 0x20, 0x0e, 0x51, 0xed, 0xf8, 0x7c,
           0x8f, 0x2e, 0xf4, 0x12, 0xc6, 0x2b, 0x83, 0xcd, 0xac, 0xcb, 0x3b, 0xc4, 0x4e, 0xc0, 0x69, 0x36,
           0x62, 0x02, 0xae, 0x88, 0xfc, 0xaa, 0x42, 0x08, 0xa6, 0x45, 0x57, 0xd3, 0x9a, 0xbd, 0xe1, 0x23,
           0x8d, 0x92, 0x4a, 0x11, 0x89, 0x74, 0x6b, 0x91, 0xfb, 0xfe, 0xc9, 0x01, 0xea, 0x1b, 0xf7, 0xce]


def extract_interesting(wrapped):
  #
  #  Wrapped code containts two parts which are separated by the regular expression
  # (i. e. two hexadecimal numbers):
  #     ^[0-9a-f]+ ([0-9a-f]+)$'
    pattern = re.compile(r'^[0-9a-f]+ ([0-9a-f]+)$', re.MULTILINE)

  #
  #  The text before this pattern is uninteresting for unwrapping.
  #  The value of the second number specifies the length in bytes of
  #  the interesting part.

    match = pattern.search(wrapped)

    if match:
  #
  #   If the regular expression was found
  #   into the two parts.
  #   The length of the second part:
  #
      base64_len   = int(match.groups()[0], 16)
  #
  #   The start of the interesting part is where the match ends:
  #
      base64_start = match.end()

  #
  #   Return the interesting part (which is base64 encoded)
      return wrapped[ base64_start:base64_start+base64_len+1 ].strip()


  # We didn't find the regular expression:
    return None

def unwrap(wrapped):

    interesting = extract_interesting(wrapped)

  # Skip the 20 chars (which is believed to be a SHA1 hash. No need to do anything with it)
    base64dec = base64.decodebytes(bytearray(interesting.encode('latin-1')))[20:]
    decoded = ''
    for byte in range(0, len(base64dec)):
        decoded += chr(charmap[ord(chr(base64dec[byte]))])


    unwrapped = zlib.decompress(bytearray(decoded.encode('latin-1'))).decode('latin-1')

  #
  # TODO: Why's that?
  #
    if unwrapped.endswith(chr(0)):
       unwrapped = unwrapped[:-1]
    return unwrapped