如何解密此 SQLite 数据库文件中的数据

逆向工程 加密 解密 未知数据
2021-06-24 17:29:51

我有这个 SQLite 数据库文件

https://we.tl/t-RwKqYyS3D7

当我在记事本++中打开它时,我得到了一些解码的字符串。我试图清理它并只显示没有符号的字符串但后来我找到了这个网站

https://filex.com/online-file-viewer.html

当我在那里打开该文件时,它会显示一个 db 表,而文本列只有数字。

我在想,也许这是加密的字符串?

希望有人对这些数字有一个解释,也许是一种解密它的方法。

数字示例

92,91,72,49,93,32,32,39,97,98,32,32,97,119,98,60,98,114,62,10,60,98,114,62,10,97,32,112,114,105,109,105,116,105,118,101,32,119,111,114,100,59,60,98,114,62,10,60,98,114,62,10,102,97,116,104,101,114,44,32,105,110,32,97,32,108,105,116,101,114,97,108,32,97,110,100,32,105,109,109,101,100,105,97,116,101,44,32,111,114,32,102,105,103,117,114,97,116,105,118,101,32,97,110,100,32,114,101,109,111,116,101,32,97,112,112,108,105,99,97,116,105,111,110,41,46,32,67,111,109,112,97,114,101,32,110,97,109,101,115,32,105,110,32,34,65,98,105,45,34,46,60,98,114,62,10,60,98,114,62,10,60,98,114,62,10,75,74,86,58,32,99,104,105,101,102,44,32,40,102,111,114,101,45,41,102,97,116,104,101,114,40,45,108,101,115,115,41,44,32,88,32,32,112,97,116,114,105,109,111,110,121,44,32,112,114,105,110,99,105,112,97,108,46,60,98,114,62,10

或者也许是一个正则表达式来清理所有文件

谢谢!

2个回答

您可以使用 SQLiteStudio 打开该文件以获取该信息。

脚步:

  1. 下载 SQLiteStudio并安装它
  2. 将文件 (Strong.isa_lex) 拖到 SQLiteStudio 的左侧边栏中,然后单击“确定”
  3. 双击新数据库(“强”)
  4. 您将看到 2 个表,“引理”和“TBInfo”,每个表都有 2 列。
  5. 右键单击表“引理”并为表生成查询 > SELECT
  6. 按F9
  7. 也对 TBInfo 执行步骤 5 和 6

现在您拥有了所有数据。

如果您有任何问题,请告诉我。

您粘贴的那些数字是相应字符的序数

92 是转义反斜杠的序数

ord('\\')
92

您可以在带有 python 的 blah 构造中使用 for i 来打印它们

python
Python 3.9.1 (tags/v3.9.1:1e5d33e, Dec  7 2020, 17:08:21) [MSC v.1927 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> input = [92,91,72,49,93,32,32,39,97,98,32,32,97,119,98,60,98,114,62,10,60,98,114,62,10,97,32,112,114,105,109,105,116,105,118,101,32,119,111,114,100,59,60,98,114,62,10,60,98,114,62,10,102,97,116,104,101,114,44,32,105,110,32,97,32,108,105,116,101,114,97,108,32,97,110,100,32,105,109,109,101,100,105,97,116,101,44,32,111,114,32,102,105,103,117,114,97,116,105,118,101,32,97,110,100,32,114,101,109,111,116,101,32,97,112,112,108,105,99,97,116,105,111,110,41,46,32,67,111,109,112,97,114,101,32,110,97,109,101,115,32,105,110,32,34,65,98,105,45,34,46,60,98,114,62,10,60,98,114,62,10,60,98,114,62,10,75,74,86,58,32,99,104,105,101,102,44,32,40,102,111,114,101,45,41,102,97,116,104,101,114,40,45,108,101,115,115,41,44,32,88,32,32,112,97,116,114,105,109,111,110,121,44,32,112,114,105,110,99,105,112,97,108,46,60,98,114,62,10]
>>> for i in input:
...     print(chr(i),end="")
...
\[H1]  'ab  awb<br>
<br>
a primitive word;<br>
<br>
father, in a literal and immediate, or figurative and remote application). Compare names in "Abi-".<br>
<br>
<br>
KJV: chief, (fore-)father(-less), X  patrimony, principal.<br>
>>>

或者您可以通过使用 python 重定向将数据库转储到文本文件

import sqlite3
conn = sqlite3.connect(".\copysql")
cur = conn.cursor()

res = cur.execute("SELECT * FROM Lexicon")
for a in res:
    print(a)

res = cur.execute("SELECT * FROM TBinfo")
for a in res:
    print(a)