wechat-db-decrypt.html 39 KB
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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>macOS 微信数据库解密 — 完整记录</title>
<style>
  :root {
    --bg: #0f1117;
    --surface: #1a1d27;
    --surface2: #222535;
    --border: #2e3148;
    --accent: #7c6aff;
    --accent2: #38bdf8;
    --green: #4ade80;
    --red: #f87171;
    --yellow: #fbbf24;
    --text: #e2e8f0;
    --text2: #94a3b8;
    --code-bg: #131625;
  }
  * { box-sizing: border-box; margin: 0; padding: 0; }
  body {
    font-family: -apple-system, 'Inter', 'Segoe UI', sans-serif;
    background: var(--bg);
    color: var(--text);
    line-height: 1.7;
    font-size: 15px;
  }
  /* ── Layout ── */
  .sidebar {
    position: fixed; top: 0; left: 0; width: 260px; height: 100vh;
    background: var(--surface); border-right: 1px solid var(--border);
    overflow-y: auto; padding: 24px 0;
    display: flex; flex-direction: column;
  }
  .sidebar-logo {
    padding: 0 20px 24px;
    font-size: 13px; font-weight: 700; letter-spacing: .05em;
    color: var(--accent); text-transform: uppercase;
    border-bottom: 1px solid var(--border);
  }
  .sidebar-logo span { display: block; color: var(--text2); font-weight: 400; font-size: 11px; margin-top: 2px; text-transform: none; }
  nav { padding: 16px 0; flex: 1; }
  nav a {
    display: flex; align-items: center; gap: 8px;
    padding: 7px 20px; color: var(--text2); text-decoration: none;
    font-size: 13px; border-left: 2px solid transparent;
    transition: all .15s;
  }
  nav a:hover, nav a.active { color: var(--text); background: var(--surface2); border-left-color: var(--accent); }
  nav .section-label {
    padding: 18px 20px 6px; font-size: 10px; font-weight: 700;
    letter-spacing: .1em; color: var(--text2); text-transform: uppercase;
  }
  .main { margin-left: 260px; padding: 48px 64px; max-width: 1100px; }

  /* ── Typography ── */
  h1 { font-size: 2rem; font-weight: 800; color: var(--text); margin-bottom: 8px; }
  h2 { font-size: 1.35rem; font-weight: 700; color: var(--text); margin: 48px 0 16px; padding-bottom: 8px; border-bottom: 1px solid var(--border); }
  h3 { font-size: 1.05rem; font-weight: 600; color: var(--accent2); margin: 28px 0 10px; }
  p { color: var(--text2); margin-bottom: 12px; }
  strong { color: var(--text); }
  a { color: var(--accent2); text-decoration: none; }
  a:hover { text-decoration: underline; }

  /* ── Hero ── */
  .hero {
    background: linear-gradient(135deg, #1a1d27 0%, #1e1b3a 100%);
    border: 1px solid var(--border); border-radius: 12px;
    padding: 36px 40px; margin-bottom: 40px;
    position: relative; overflow: hidden;
  }
  .hero::before {
    content: ''; position: absolute; top: -40px; right: -40px;
    width: 200px; height: 200px;
    background: radial-gradient(circle, rgba(124,106,255,.15) 0%, transparent 70%);
  }
  .hero-meta { display: flex; gap: 16px; margin-top: 16px; flex-wrap: wrap; }
  .badge {
    display: inline-flex; align-items: center; gap: 5px;
    padding: 4px 10px; border-radius: 20px;
    font-size: 12px; font-weight: 600; letter-spacing: .03em;
  }
  .badge-green { background: rgba(74,222,128,.12); color: var(--green); border: 1px solid rgba(74,222,128,.25); }
  .badge-blue  { background: rgba(56,189,248,.12); color: var(--accent2); border: 1px solid rgba(56,189,248,.25); }
  .badge-purple{ background: rgba(124,106,255,.12); color: var(--accent); border: 1px solid rgba(124,106,255,.25); }
  .badge-yellow{ background: rgba(251,191,36,.12); color: var(--yellow); border: 1px solid rgba(251,191,36,.25); }

  /* ── Cards ── */
  .card {
    background: var(--surface); border: 1px solid var(--border);
    border-radius: 10px; padding: 20px 24px; margin-bottom: 16px;
  }
  .card-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(220px, 1fr)); gap: 16px; margin: 20px 0; }
  .stat-card {
    background: var(--surface); border: 1px solid var(--border);
    border-radius: 10px; padding: 20px;
  }
  .stat-label { font-size: 12px; color: var(--text2); font-weight: 600; letter-spacing: .05em; text-transform: uppercase; }
  .stat-value { font-size: 1.6rem; font-weight: 800; color: var(--text); margin: 4px 0; }
  .stat-sub { font-size: 12px; color: var(--text2); }

  /* ── Code ── */
  pre {
    background: var(--code-bg); border: 1px solid var(--border);
    border-radius: 8px; padding: 20px 24px; overflow-x: auto;
    font-family: 'JetBrains Mono', 'Fira Code', 'SF Mono', monospace;
    font-size: 13px; line-height: 1.6; margin: 16px 0;
    position: relative;
  }
  .code-header {
    display: flex; align-items: center; justify-content: space-between;
    background: var(--surface2); border: 1px solid var(--border);
    border-bottom: none; border-radius: 8px 8px 0 0;
    padding: 8px 16px; font-size: 12px; color: var(--text2);
  }
  .code-header + pre { border-radius: 0 0 8px 8px; margin-top: 0; }
  .code-dots { display: flex; gap: 6px; }
  .code-dots span { width: 10px; height: 10px; border-radius: 50%; }
  .dot-r { background: #ff5f57; } .dot-y { background: #febc2e; } .dot-g { background: #28c840; }
  code { font-family: 'JetBrains Mono', 'Fira Code', 'SF Mono', monospace; font-size: .9em; }
  p code, li code {
    background: var(--surface2); border: 1px solid var(--border);
    padding: 2px 6px; border-radius: 4px; color: var(--accent2);
  }

  /* ── Syntax highlighting ── */
  .kw  { color: #c792ea; }
  .fn  { color: #82aaff; }
  .st  { color: #c3e88d; }
  .cm  { color: #546e7a; font-style: italic; }
  .nm  { color: #f78c6c; }
  .op  { color: #89ddff; }
  .va  { color: #eeffff; }

  /* ── Steps ── */
  .steps { counter-reset: step; list-style: none; }
  .steps li {
    counter-increment: step; position: relative;
    padding-left: 48px; margin-bottom: 24px;
  }
  .steps li::before {
    content: counter(step);
    position: absolute; left: 0; top: 0;
    width: 32px; height: 32px; border-radius: 50%;
    background: var(--accent); color: #fff;
    display: flex; align-items: center; justify-content: center;
    font-weight: 800; font-size: 13px;
  }
  .steps li h4 { color: var(--text); font-weight: 700; margin-bottom: 6px; }
  .steps li p  { color: var(--text2); font-size: 14px; }

  /* ── Table ── */
  table { width: 100%; border-collapse: collapse; margin: 16px 0; font-size: 14px; }
  th { background: var(--surface2); color: var(--text2); font-weight: 700; font-size: 12px; letter-spacing: .05em; text-transform: uppercase; padding: 10px 16px; text-align: left; border-bottom: 2px solid var(--border); }
  td { padding: 10px 16px; border-bottom: 1px solid var(--border); color: var(--text2); }
  tr:last-child td { border-bottom: none; }
  td strong { color: var(--text); }
  td .check { color: var(--green); font-size: 16px; }
  td .cross { color: var(--red); font-size: 16px; }

  /* ── Alerts ── */
  .alert {
    border-radius: 8px; padding: 14px 20px; margin: 16px 0;
    font-size: 14px; display: flex; gap: 12px; align-items: flex-start;
  }
  .alert-icon { font-size: 18px; flex-shrink: 0; margin-top: 1px; }
  .alert-info    { background: rgba(56,189,248,.08); border: 1px solid rgba(56,189,248,.2); }
  .alert-warning { background: rgba(251,191,36,.08); border: 1px solid rgba(251,191,36,.2); }
  .alert-success { background: rgba(74,222,128,.08); border: 1px solid rgba(74,222,128,.2); }

  /* ── Result box ── */
  .result-box {
    background: #0d1f12; border: 1px solid #1a3a22;
    border-radius: 8px; padding: 20px 24px; font-family: 'JetBrains Mono', monospace;
    font-size: 13px; line-height: 1.8; margin: 16px 0;
  }
  .result-box .r-label { color: #4ade80; font-weight: 700; }
  .result-box .r-val   { color: #86efac; }
  .result-box .r-dim   { color: #166534; }

  /* ── Flow diagram ── */
  .flow {
    display: flex; align-items: center; gap: 0; flex-wrap: wrap;
    margin: 20px 0; padding: 20px; background: var(--surface);
    border: 1px solid var(--border); border-radius: 10px;
  }
  .flow-node {
    background: var(--surface2); border: 1px solid var(--border);
    border-radius: 8px; padding: 10px 16px; font-size: 13px;
    text-align: center; min-width: 110px;
  }
  .flow-node .fn-label { color: var(--text2); font-size: 10px; text-transform: uppercase; letter-spacing: .05em; }
  .flow-node .fn-value { color: var(--text); font-weight: 700; margin-top: 2px; }
  .flow-arrow { color: var(--accent); font-size: 20px; padding: 0 8px; }
  .flow-node.highlight { border-color: var(--accent); background: rgba(124,106,255,.1); }
  .flow-node.highlight .fn-value { color: var(--accent); }

  /* ── Key display ── */
  .key-box {
    background: var(--code-bg); border: 1px solid var(--accent);
    border-radius: 8px; padding: 16px 20px; margin: 16px 0;
    font-family: 'JetBrains Mono', monospace; font-size: 13px;
  }
  .key-db { color: var(--text2); font-size: 11px; text-transform: uppercase; letter-spacing: .08em; margin-bottom: 6px; }
  .key-val { color: var(--green); word-break: break-all; }
  .key-note { color: var(--text2); font-size: 11px; margin-top: 4px; }

  /* ── Footer ── */
  footer {
    margin-top: 80px; padding: 24px 0; border-top: 1px solid var(--border);
    color: var(--text2); font-size: 13px;
  }

  /* ── Scrollbar ── */
  ::-webkit-scrollbar { width: 6px; height: 6px; }
  ::-webkit-scrollbar-track { background: var(--bg); }
  ::-webkit-scrollbar-thumb { background: var(--border); border-radius: 3px; }
  ::-webkit-scrollbar-thumb:hover { background: #3e4468; }
</style>
</head>
<body>

<!-- Sidebar -->
<aside class="sidebar">
  <div class="sidebar-logo">
    WeChat DB Decrypt
    <span>macOS 4.1.7 · SQLCipher v4 · 2026-05-16</span>
  </div>
  <nav>
    <div class="section-label">概览</div>
    <a href="#overview">🎯 目标与环境</a>
    <a href="#tldr">⚡ 三分钟速览</a>

    <div class="section-label">路线探索</div>
    <a href="#failed">❌ 无效路线记录</a>
    <a href="#discovery">🔍 突破口发现</a>

    <div class="section-label">完整流程</div>
    <a href="#step1">1. 定位数据库</a>
    <a href="#step2">2. Frida 环境</a>
    <a href="#step3">3. Hook CCCryptorCreate</a>
    <a href="#step4">4. 提取 enc_key</a>
    <a href="#step5">5. sqlcipher 解密</a>
    <a href="#step6">6. 查询数据</a>

    <div class="section-label">代码</div>
    <a href="#code-frida">Frida JS Hook</a>
    <a href="#code-python">Python 驱动脚本</a>
    <a href="#code-query">SQL 查询示例</a>

    <div class="section-label">结果</div>
    <a href="#keys">密钥映射表</a>
    <a href="#data">真实数据截图</a>
    <a href="#next">后续扩展</a>
  </nav>
</aside>

<!-- Main -->
<main class="main">

  <!-- Hero -->
  <div class="hero" id="overview">
    <h1>macOS 微信数据库解密</h1>
    <p style="color:var(--text2); margin-top:8px; font-size:16px;">
      通过 Frida hook <strong>CCCryptorCreate</strong>,在运行时拦截 WeChat 传入 SQLCipher 的 AES enc_key,无需逆向二进制、无需 root、不触碰 Keychain。
    </p>
    <div class="hero-meta">
      <span class="badge badge-green">✓ 实测成功</span>
      <span class="badge badge-blue">WeChat 4.1.7 (macOS)</span>
      <span class="badge badge-purple">SQLCipher v4</span>
      <span class="badge badge-yellow">Frida 17.9.10</span>
      <span class="badge badge-blue">2026-05-16</span>
    </div>
  </div>

  <!-- Stats -->
  <div class="card-grid">
    <div class="stat-card">
      <div class="stat-label">解密数据库</div>
      <div class="stat-value" style="color:var(--green)">3 / 30+</div>
      <div class="stat-sub">contact · message_0 · session</div>
    </div>
    <div class="stat-card">
      <div class="stat-label">消息表数量</div>
      <div class="stat-value" style="color:var(--accent2)">3,654</div>
      <div class="stat-sub">message_0.db 中的会话分表</div>
    </div>
    <div class="stat-card">
      <div class="stat-label">联系人数量</div>
      <div class="stat-value" style="color:var(--accent)">26 表</div>
      <div class="stat-sub">contact.db 成功打开</div>
    </div>
    <div class="stat-card">
      <div class="stat-label">关键工具</div>
      <div class="stat-value" style="font-size:1.1rem; padding-top:4px">Frida + sqlcipher</div>
      <div class="stat-sub">brew install sqlcipher</div>
    </div>
  </div>

  <!-- TL;DR -->
  <h2 id="tldr">⚡ 三分钟速览(核心结论)</h2>

  <div class="flow">
    <div class="flow-node"><div class="fn-label">微信运行时</div><div class="fn-value">WeChat.app</div></div>
    <div class="flow-arrow">→</div>
    <div class="flow-node"><div class="fn-label">打开数据库</div><div class="fn-value">WCDB/SQLCipher</div></div>
    <div class="flow-arrow">→</div>
    <div class="flow-node highlight"><div class="fn-label">AES 密钥设置</div><div class="fn-value">CCCryptorCreate</div></div>
    <div class="flow-arrow">→</div>
    <div class="flow-node"><div class="fn-label">Frida 拦截</div><div class="fn-value">args[3] = key</div></div>
    <div class="flow-arrow">→</div>
    <div class="flow-node"><div class="fn-label">sqlcipher</div><div class="fn-value">x'<hex>' 打开</div></div>
  </div>

  <div class="alert alert-success">
    <span class="alert-icon">💡</span>
    <div>
      <strong>核心发现</strong>:WeChat 4.x on macOS 使用 <strong>Apple CommonCrypto</strong>(而非 BoringSSL)做 SQLCipher 的 AES 加解密。
      <code>CCCryptorCreate(op, AES, options, <strong>key_ptr</strong>, 32, iv, ref)</code> 的 <code>args[3]</code>
      就是 32 字节的 <strong>raw enc_key</strong>,直接以 <code>x'&lt;hex&gt;'</code> 格式传给 sqlcipher 即可打开数据库。
      不需要 PBKDF2 反推,不需要逆向二进制。
    </div>
  </div>

  <!-- Failed routes -->
  <h2 id="failed">❌ 无效路线(踩过的坑)</h2>

  <table>
    <thead>
      <tr><th>方案</th><th>预期</th><th>实际结果</th><th>原因</th></tr>
    </thead>
    <tbody>
      <tr>
        <td><strong>lldb 内存搜索</strong></td>
        <td>在堆内存暴力扫描 32 字节密钥</td>
        <td><span class="cross">✗</span> 0 MB 被读取</td>
        <td>WeChat 沙箱 + 进程状态问题,GetMemoryRegionInfo 全部失败</td>
      </tr>
      <tr>
        <td><strong>vmmap + salt 定位</strong></td>
        <td>找到 salt 字节 → 在附近找 key</td>
        <td><span class="cross">✗</span> salt 未找到</td>
        <td>vmmap 区域地址与 lldb attach 后的地址不对应</td>
      </tr>
      <tr>
        <td><strong>hook 系统 sqlite3_key</strong></td>
        <td>系统 libsqlite3.dylib 的 sqlite3_key</td>
        <td><span class="cross">✗</span> 从未被调用</td>
        <td>WeChat 静态链接 WCDB,不调用系统 sqlite3_key</td>
      </tr>
      <tr>
        <td><strong>hook EVP/BoringSSL</strong></td>
        <td>微信可能用 BoringSSL 做 AES</td>
        <td><span class="cross">✗</span> 未测到</td>
        <td>SQLCipher 用的是 CommonCrypto,BoringSSL 只用于 TLS</td>
      </tr>
      <tr>
        <td><strong>HMAC Python 验证</strong></td>
        <td>用 HMAC 校验候选 key</td>
        <td><span class="cross">✗</span> 全部 ❌</td>
        <td>验证逻辑看起来正确但有细节偏差;改用 sqlcipher 直接验证</td>
      </tr>
    </tbody>
  </table>

  <!-- Discovery -->
  <h2 id="discovery">🔍 突破口:CCCryptorCreate</h2>
  <p>
    扫描微信进程所有模块的导出符号时,发现 <code>libsqlite3.dylib</code> 的 <code>sqlite3_key</code> 在进程中存在,但从未被 WeChat 调用(静态链接的 WCDB 有自己的副本)。
    随后转向 <strong>更底层的 AES 层</strong>,hook 了 CommonCrypto 的 <code>CCCryptorCreate</code>。
  </p>
  <p>
    这个函数在 WeChat 打开数据库(解密每一页)时被高频调用,<code>alg=0(AES)</code>、<code>keyLen=32(AES-256)</code>,<code>args[3]</code> 直接就是 enc_key。
    10 秒内捕获了 4 个唯一的 32 字节 AES-256 密钥,用 sqlcipher 逐一验证,成功匹配 3 个数据库。
  </p>

  <!-- Step by step -->
  <h2 id="step1">步骤一:定位数据库文件</h2>
  <p>微信 4.x 在 macOS 上的数据库路径(已知账号 <code>yibooo_ac07</code>):</p>
  <pre><code>~/Library/Containers/com.tencent.xinWeChat/Data/Documents/
└── xwechat_files/
    └── yibooo_ac07/
        └── db_storage/
            ├── contact/contact.db        ← 联系人
            ├── message/message_0.db      ← 消息分片 0
            ├── message/message_1.db      ← 消息分片 1
            │   ...
            ├── message/message_10.db     ← 消息分片 10
            ├── session/session.db        ← 会话列表
            ├── sns/sns.db                ← 朋友圈
            └── general/general.db        ← 通用配置</code></pre>

  <div class="alert alert-info">
    <span class="alert-icon">ℹ️</span>
    <div>所有 <code>.db</code> 文件均为 <strong>SQLCipher v4 加密</strong>,文件头不是标准 <code>SQLite format 3</code>,而是随机盐值(前 16 字节)。Page size = 4096,reserved = 48 字节(16 IV + 32 HMAC-SHA256)。</div>
  </div>

  <h2 id="step2">步骤二:确认 Frida 可用</h2>
  <pre><code><span class="cm"># Frida 17.9.10 已通过 pip 安装</span>
python3 -c <span class="st">"import frida; print(frida.__version__)"</span>
<span class="cm"># 17.9.10</span>

<span class="cm"># CLI 工具路径</span>
~/Library/Python/3.9/bin/frida
~/Library/Python/3.9/bin/frida-ps</code></pre>

  <div class="alert alert-warning">
    <span class="alert-icon">⚠️</span>
    <div><strong>必须先打开微信并登录</strong>,Frida 需要附加到运行中的进程。数据库在微信启动后即被打开,CCCryptorCreate 会在读取每一页时被调用。</div>
  </div>

  <h2 id="step3">步骤三:Hook CCCryptorCreate</h2>

  <div class="code-header">
    <div class="code-dots"><span class="dot-r"></span><span class="dot-y"></span><span class="dot-g"></span></div>
    <span>/tmp/wechat_hook.js — Frida 注入脚本</span>
  </div>
  <pre id="code-frida"><code><span class="cm">/*
 * macOS WeChat SQLCipher enc_key 拦截器
 * 原理:hook CommonCrypto 的 CCCryptorCreate,捕获 AES-256 密钥
 * CCCryptorCreate(op, alg, options, key, keyLength, iv, cryptorRef)
 *   alg=0  → AES
 *   op=1   → 解密 (decrypt)
 *   key    → 32 字节 enc_key  ← 我们要的
 */</span>

<span class="kw">var</span> <span class="va">found_keys</span> <span class="op">=</span> {};

<span class="cm">// 找到 CCCryptorCreate 函数地址</span>
<span class="kw">var</span> <span class="va">cc_create</span> <span class="op">=</span> <span class="fn">Module.findExportByName</span>(<span class="nm">null</span>, <span class="st">'CCCryptorCreate'</span>);

<span class="kw">if</span> (<span class="va">cc_create</span>) {
    <span class="fn">Interceptor.attach</span>(<span class="va">cc_create</span>, {
        <span class="fn">onEnter</span>: <span class="kw">function</span>(<span class="va">args</span>) {
            <span class="kw">try</span> {
                <span class="kw">var</span> <span class="va">op</span>     <span class="op">=</span> <span class="va">args</span>[0].<span class="fn">toInt32</span>();  <span class="cm">// 0=encrypt, 1=decrypt</span>
                <span class="kw">var</span> <span class="va">alg</span>    <span class="op">=</span> <span class="va">args</span>[1].<span class="fn">toInt32</span>();  <span class="cm">// 0=AES</span>
                <span class="kw">var</span> <span class="va">keyLen</span> <span class="op">=</span> <span class="va">args</span>[4].<span class="fn">toInt32</span>();

                <span class="cm">// 只关注 AES-256(keyLen=32)</span>
                <span class="kw">if</span> (<span class="va">alg</span> <span class="op">===</span> <span class="nm">0</span> <span class="op">&amp;&amp;</span> <span class="va">keyLen</span> <span class="op">===</span> <span class="nm">32</span>) {
                    <span class="kw">var</span> <span class="va">key</span> <span class="op">=</span> <span class="va">args</span>[3].<span class="fn">readByteArray</span>(<span class="nm">32</span>);
                    <span class="kw">var</span> <span class="va">hex</span> <span class="op">=</span> <span class="fn">Array.from</span>(<span class="kw">new</span> <span class="fn">Uint8Array</span>(<span class="va">key</span>))
                        .<span class="fn">map</span>(<span class="kw">function</span>(<span class="va">b</span>) {
                            <span class="kw">return</span> (<span class="st">'0'</span> <span class="op">+</span> <span class="va">b</span>.<span class="fn">toString</span>(<span class="nm">16</span>)).<span class="fn">slice</span>(<span class="op">-</span><span class="nm">2</span>);
                        }).<span class="fn">join</span>(<span class="st">''</span>);

                    <span class="cm">// 去重后发送</span>
                    <span class="kw">if</span> (<span class="op">!</span><span class="va">found_keys</span>[<span class="va">hex</span>]) {
                        <span class="va">found_keys</span>[<span class="va">hex</span>] <span class="op">=</span> <span class="nm">true</span>;
                        <span class="fn">send</span>({ <span class="va">type</span>: <span class="st">'aes_key'</span>, <span class="va">op</span>: <span class="va">op</span>,
                               <span class="va">len</span>: <span class="va">keyLen</span>, <span class="va">hex</span>: <span class="va">hex</span> });
                    }
                }
            } <span class="kw">catch</span>(<span class="va">e</span>) {}
        }
    });
    <span class="fn">send</span>({ <span class="va">type</span>: <span class="st">'hooked'</span>, <span class="va">func</span>: <span class="st">'CCCryptorCreate'</span>,
           <span class="va">addr</span>: <span class="va">cc_create</span>.<span class="fn">toString</span>() });
}

<span class="fn">send</span>({ <span class="va">type</span>: <span class="st">'ready'</span> });</code></pre>

  <h2 id="step4">步骤四:Python 驱动 + 自动验证</h2>

  <div class="code-header">
    <div class="code-dots"><span class="dot-r"></span><span class="dot-y"></span><span class="dot-g"></span></div>
    <span>/tmp/wechat_frida.py — 驱动脚本</span>
  </div>
  <pre id="code-python"><code><span class="cm">#!/usr/bin/env python3</span>
<span class="kw">import</span> sys, os, time, subprocess

<span class="cm"># Frida 路径(pip 安装在用户目录)</span>
sys.<span class="va">path</span>.<span class="fn">insert</span>(<span class="nm">0</span>, os.<span class="va">path</span>.<span class="fn">expanduser</span>(<span class="st">"~/Library/Python/3.9/lib/python/site-packages"</span>))
<span class="kw">import</span> frida

DB_BASE <span class="op">=</span> os.<span class="va">path</span>.<span class="fn">expanduser</span>(
    <span class="st">"~/Library/Containers/com.tencent.xinWeChat/Data/Documents/"</span>
    <span class="st">"xwechat_files/yibooo_ac07/db_storage/"</span>
)

<span class="kw">def</span> <span class="fn">test_key_with_sqlcipher</span>(<span class="va">key_hex</span>, <span class="va">db_path</span>):
    <span class="cm">"""用 sqlcipher 验证 key 是否能打开数据库"""</span>
    pragma <span class="op">=</span> <span class="st">f"PRAGMA key = \"x'</span>{<span class="va">key_hex</span>}<span class="st">'\";"</span>
    r <span class="op">=</span> subprocess.<span class="fn">run</span>(
        [<span class="st">'sqlcipher'</span>, <span class="va">db_path</span>],
        input<span class="op">=</span><span class="st">f"</span>{<span class="va">pragma</span>}<span class="st">\nSELECT count(*) FROM sqlite_master;\n"</span>,
        capture_output<span class="op">=</span><span class="nm">True</span>, text<span class="op">=</span><span class="nm">True</span>
    )
    lines <span class="op">=</span> [l <span class="kw">for</span> l <span class="kw">in</span> r.<span class="va">stdout</span>.<span class="fn">split</span>(<span class="st">'\n'</span>) <span class="kw">if</span> l.<span class="fn">strip</span>() <span class="kw">and</span> l <span class="op">!=</span> <span class="st">'ok'</span>]
    <span class="kw">if</span> lines <span class="kw">and</span> lines[<span class="nm">0</span>].<span class="fn">isdigit</span>():
        <span class="kw">return</span> <span class="fn">int</span>(lines[<span class="nm">0</span>])  <span class="cm"># 返回表数量</span>
    <span class="kw">return</span> <span class="nm">None</span>

<span class="cm"># 获取微信 PID</span>
pid <span class="op">=</span> <span class="fn">int</span>(subprocess.<span class="fn">run</span>([<span class="st">'pgrep'</span>, <span class="st">'-x'</span>, <span class="st">'WeChat'</span>],
    capture_output<span class="op">=</span><span class="nm">True</span>, text<span class="op">=</span><span class="nm">True</span>).<span class="va">stdout</span>.<span class="fn">strip</span>().<span class="fn">split</span>(<span class="st">'\n'</span>)[<span class="nm">0</span>])
<span class="fn">print</span>(<span class="st">f"[*] 附加到 WeChat PID=</span>{<span class="va">pid</span>}<span class="st">"</span>)

session <span class="op">=</span> frida.<span class="fn">attach</span>(<span class="va">pid</span>)
script  <span class="op">=</span> session.<span class="fn">create_script</span>(<span class="fn">open</span>(<span class="st">'/tmp/wechat_hook.js'</span>).<span class="fn">read</span>())

captured <span class="op">=</span> []
databases <span class="op">=</span> {
    <span class="st">'contact'</span>:  <span class="st">'contact/contact.db'</span>,
    <span class="st">'message0'</span>: <span class="st">'message/message_0.db'</span>,
    <span class="st">'session'</span>:  <span class="st">'session/session.db'</span>,
}

<span class="kw">def</span> <span class="fn">on_message</span>(<span class="va">msg</span>, <span class="va">data</span>):
    <span class="kw">if</span> <span class="va">msg</span>[<span class="st">'type'</span>] <span class="op">!=</span> <span class="st">'send'</span>: <span class="kw">return</span>
    p <span class="op">=</span> <span class="va">msg</span>[<span class="st">'payload'</span>]
    <span class="kw">if</span> p.<span class="fn">get</span>(<span class="st">'type'</span>) <span class="op">==</span> <span class="st">'aes_key'</span>:
        k <span class="op">=</span> p[<span class="st">'hex'</span>]
        <span class="fn">print</span>(<span class="st">f"  捕获 AES key: </span>{k[:<span class="nm">16</span>]}<span class="st">..."</span>)
        <span class="cm"># 验证这个 key 能打开哪些数据库</span>
        <span class="kw">for</span> dbname, relpath <span class="kw">in</span> databases.<span class="fn">items</span>():
            tables <span class="op">=</span> <span class="fn">test_key_with_sqlcipher</span>(k, DB_BASE <span class="op">+</span> relpath)
            <span class="kw">if</span> tables <span class="kw">is not</span> <span class="nm">None</span>:
                <span class="fn">print</span>(<span class="st">f"  ✅ {dbname}: key 匹配!表数量={tables}"</span>)
                captured.<span class="fn">append</span>((<span class="va">k</span>, <span class="va">dbname</span>))
                <span class="fn">open</span>(<span class="st">'/tmp/wechat_key.hex'</span>, <span class="st">'a'</span>).<span class="fn">write</span>(<span class="st">f"</span>{<span class="va">dbname</span>}<span class="st">:</span>{<span class="va">k</span>}<span class="st">\n"</span>)

script.<span class="fn">on</span>(<span class="st">'message'</span>, <span class="va">on_message</span>)
script.<span class="fn">load</span>()
<span class="fn">print</span>(<span class="st">"[*] 监听中,在微信里操作触发数据库读取... (Ctrl+C 退出)"</span>)

<span class="kw">try</span>:
    <span class="kw">while</span> <span class="nm">True</span>: time.<span class="fn">sleep</span>(<span class="nm">1</span>)
<span class="kw">except</span> <span class="va">KeyboardInterrupt</span>: <span class="kw">pass</span>
session.<span class="fn">detach</span>()</code></pre>

  <h2 id="step5">步骤五:用 sqlcipher 打开数据库</h2>

  <div class="code-header">
    <div class="code-dots"><span class="dot-r"></span><span class="dot-y"></span><span class="dot-g"></span></div>
    <span>Shell — 打开解密数据库</span>
  </div>
  <pre><code>DB_BASE=<span class="st">"~/Library/Containers/com.tencent.xinWeChat/Data/Documents/xwechat_files/yibooo_ac07/db_storage"</span>

<span class="cm"># 打开联系人数据库</span>
sqlcipher <span class="st">"$DB_BASE/contact/contact.db"</span> <span class="op">&lt;&lt;</span>SQL
PRAGMA key = <span class="st">"x'1064e7dfb42cc3ea447da335ca848a2381e8738ad1ebc31e76e993456ba1fe2b'"</span>;
SELECT username, nick_name, remark FROM contact WHERE local_type=3 LIMIT 20;
SQL

<span class="cm"># 打开消息数据库</span>
sqlcipher <span class="st">"$DB_BASE/message/message_0.db"</span> <span class="op">&lt;&lt;</span>SQL
PRAGMA key = <span class="st">"x'de0b8d3304e9940e96baa7c9ecfe33a226e68590fa0060d7d09ee088e1a104f8'"</span>;
<span class="cm">-- 消息表名 = "Msg_" + MD5(username)</span>
SELECT local_type, datetime(create_time,'unixepoch','localtime'), message_content
FROM Msg_8f5f8034b0f757ef2701729beabc4770  <span class="cm">-- MD5('dp543831577')</span>
WHERE local_type = 1
ORDER BY create_time DESC LIMIT 20;
SQL</code></pre>

  <h2 id="step6">步骤六:消息表名计算</h2>
  <p>WeChat 的每个聊天对话在 <code>message_N.db</code> 中对应一张表 <code>Msg_&lt;md5&gt;</code>,表名由会话 ID 的 MD5 决定:</p>

  <div class="code-header">
    <div class="code-dots"><span class="dot-r"></span><span class="dot-y"></span><span class="dot-g"></span></div>
    <span>Python — 计算消息表名</span>
  </div>
  <pre id="code-query"><code><span class="kw">import</span> hashlib

<span class="kw">def</span> <span class="fn">msg_table</span>(<span class="va">username</span>):
    md5 <span class="op">=</span> hashlib.<span class="fn">md5</span>(<span class="va">username</span>.<span class="fn">encode</span>()).<span class="fn">hexdigest</span>()
    <span class="kw">return</span> <span class="st">f"Msg_</span>{<span class="va">md5</span>}<span class="st">"</span>

<span class="cm"># 例子</span>
<span class="fn">print</span>(<span class="fn">msg_table</span>(<span class="st">"dp543831577"</span>))
<span class="cm"># → Msg_8f5f8034b0f757ef2701729beabc4770</span>

<span class="fn">print</span>(<span class="fn">msg_table</span>(<span class="st">"44170630061@chatroom"</span>))
<span class="cm"># → Msg_99ce6fe9bc90c6320bb5e75714360da0</span></code></pre>

  <!-- Keys table -->
  <h2 id="keys">密钥映射表</h2>
  <p>以下是本次成功捕获并验证的密钥(<strong>仅本机本账号有效</strong>,每次微信更新或重置后需重新提取):</p>

  <div class="key-box">
    <div class="key-db">contact / contact.db</div>
    <div class="key-val">1064e7dfb42cc3ea447da335ca848a2381e8738ad1ebc31e76e993456ba1fe2b</div>
    <div class="key-note">✓ sqlcipher 验证:26 张表</div>
  </div>

  <div class="key-box">
    <div class="key-db">message / message_0.db</div>
    <div class="key-val">de0b8d3304e9940e96baa7c9ecfe33a226e68590fa0060d7d09ee088e1a104f8</div>
    <div class="key-note">✓ sqlcipher 验证:3654 张 Msg_* 表</div>
  </div>

  <div class="key-box">
    <div class="key-db">session / session.db</div>
    <div class="key-val">f6b305477cda040af70a41f6321c3017b3400a3688e712bb1c9cf7aee50515b8</div>
    <div class="key-note">✓ sqlcipher 验证:14 张表</div>
  </div>

  <div class="key-box" style="border-color: var(--border);">
    <div class="key-db" style="color:var(--text2)">其他数据库(message_1~10, general, sns...)</div>
    <div class="key-val" style="color:var(--text2)">e5364de757971b4ead1db0d667d9e78bd7a6612254f48a19b43ae01247c9d28f</div>
    <div class="key-note" style="color:var(--red)">待确认 — 滚动浏览对应聊天触发后再验证</div>
  </div>

  <!-- Data -->
  <h2 id="data">真实查询结果</h2>

  <h3>联系人列表(contact.db)</h3>
  <div class="result-box">
<span class="r-dim">username                    | nick_name          | remark</span>
<span class="r-dim">─────────────────────────────────────────────────────────────</span>
<span class="r-label">wxid_9802458023412</span>  | <span class="r-val">Kaki</span>           | Kaki 青藤 93 荷兰
<span class="r-label">mali847944</span>          | <span class="r-val">马丽</span>           | 您好,招行个贷马丽
<span class="r-label">wxid_kb6z85qjjrrv21</span>| <span class="r-val">1.26 5</span>         | 我禧瑞春秋物业前台
<span class="r-label">wxid_0puuvbx9df1321</span>| <span class="r-val">Qian</span>           | Qian 青藤 37 财务
<span class="r-label">yuanhanweibo</span>        | <span class="r-val">幸运</span>           | 幸运 lulu 青藤 90摩羯
<span class="r-dim">... 更多联系人 ...</span>
  </div>

  <h3>最近会话(session.db)</h3>
  <div class="result-box">
<span class="r-dim">username                    | 时间              | 最新消息预览</span>
<span class="r-dim">──────────────────────────────────────────────────────────────────</span>
<span class="r-label">3164323182@chatroom</span> | <span class="r-val">15:31:16</span>  | [強][強][強]
<span class="r-label">44170630061@chatroom</span>| <span class="r-val">15:30:55</span>  | @Letty 戈壁大神[呲牙][玫瑰]
<span class="r-label">brandsessionholder</span>  | <span class="r-val">15:31:26</span>  | [38条] 新智元: 突发!OpenAI大规模重组...
<span class="r-label">gh_8391a4921226</span>     | <span class="r-val">15:29:52</span>  | MiniCPM-V4.6登顶 Hugging Face Trending!
<span class="r-label">qqtech</span>              | <span class="r-val">15:26:25</span>  | 稚晖君抛出"三条曲线",讲了一套具身智能出海新逻辑
<span class="r-dim">... 共 20+ 活跃会话 ...</span>
  </div>

  <h3>聊天消息(message_0.db · 特定对话)</h3>
  <div class="result-box">
<span class="r-dim">type | sender | 时间                | 内容</span>
<span class="r-dim">────────────────────────────────────────────────────────────</span>
<span class="r-val">1</span>   | <span class="r-label">543</span>   | 2026-05-16 15:19  | 微信里"拿 DB 数据"之前其实分两类...
<span class="r-val">1</span>   | 15    | 2026-05-15 12:39  | 生产力大于需求
<span class="r-val">1</span>   | 15    | 2026-05-15 12:39  | 短剧卷是肯定的
<span class="r-val">1</span>   | <span class="r-label">543</span>   | 2026-05-15 12:39  | 中国人干死中国人
<span class="r-val">1</span>   | <span class="r-label">543</span>   | 2026-05-15 12:38  | 短剧现在好卷
<span class="r-val">1</span>   | 15    | 2026-05-15 12:38  | 干不过 claude
<span class="r-dim">... local_type=47 是图片/视频,local_type=10000 是系统消息 ...</span>
  </div>

  <h3>群聊消息(44170630061@chatroom)</h3>
  <div class="result-box">
<span class="r-dim">群消息格式:content = "sender_wxid:\n内容"</span>
<span class="r-dim">────────────────────────────────────────────</span>
<span class="r-val">a36269329:</span>
@Letty 戈壁大神[呲牙][玫瑰][玫瑰]

<span class="r-val">wxid_5194951949422:</span>
一起共修

<span class="r-val">a36269329:</span>
Web3 大神 @Ivy [呲牙][玫瑰][玫瑰]
  </div>

  <!-- Next steps -->
  <h2 id="next">后续扩展</h2>

  <ul class="steps">
    <li>
      <h4>获取其余消息分片的密钥</h4>
      <p>在微信里滚动浏览对应的聊天,触发 WeChat 读取 message_1.db~message_10.db,Frida hook 会自动捕获对应的 AES key,用同样的 sqlcipher 验证方法确认后记录。</p>
    </li>
    <li>
      <h4>写 Python 脚本全量导出</h4>
      <p>结合三个密钥,用 Python 的 <code>apsw</code>(支持 SQLCipher)或 subprocess 调 sqlcipher,批量读取所有消息写入自己的 SQLite 或 JSON。</p>
    </li>
    <li>
      <h4>与 Android Frida 方案对接</h4>
      <p>Android 侧已经有 <code>hook h9.r9 / h9.A8</code> 的消息拦截链路,macOS 侧则补充了历史数据的解密能力,两路数据可合并到同一个 SessionDB / read_history.db。</p>
    </li>
    <li>
      <h4>配置 Frida 持久化 Hook</h4>
      <p>将 hook 脚本和 Python 驱动写成 launchd plist 或 shell 别名,每次启动微信后自动运行 10 秒捕获密钥,无需手动操作。</p>
    </li>
  </ul>

  <h2>Android vs macOS 方案对比</h2>
  <table>
    <thead>
      <tr><th>维度</th><th>Android(已实现)</th><th>macOS(本次)</th></tr>
    </thead>
    <tbody>
      <tr>
        <td><strong>Hook 目标</strong></td>
        <td><code>h9.r9 / h9.A8</code> (Java)</td>
        <td><code>CCCryptorCreate</code> (C)</td>
      </tr>
      <tr>
        <td><strong>获取数据</strong></td>
        <td>实时消息对象(D0/O0/j 字段)</td>
        <td>SQLCipher AES enc_key → 离线全量</td>
      </tr>
      <tr>
        <td><strong>数据库</strong></td>
        <td>不直接解密 EnMicroMsg.db</td>
        <td>直接解密 contact/message/session.db</td>
      </tr>
      <tr>
        <td><strong>Frida 工具</strong></td>
        <td>frida-server on Android + Python client in Debian proot</td>
        <td>frida Python 17.9.10 on macOS</td>
      </tr>
      <tr>
        <td><strong>密钥格式</strong></td>
        <td>Java passphrase(hook WCDB open 可拿)</td>
        <td>32 字节 raw AES enc_key → <code>x'hex'</code></td>
      </tr>
      <tr>
        <td><strong>稳定性</strong></td>
        <td>高(hook 消息对象,不触碰 DB)</td>
        <td>中(依赖 CCCryptorCreate,WeChat 更新后需重验)</td>
      </tr>
    </tbody>
  </table>

  <div class="alert alert-warning" style="margin-top:32px">
    <span class="alert-icon">⚠️</span>
    <div>
      <strong>注意事项</strong>:密钥为 <strong>运行时动态值</strong>,不存储在任何磁盘文件中(Keychain 无记录)。
      WeChat 版本更新后 AES 密钥 <em>可能</em> 变化,需重新运行 Frida hook 提取。
      本文档和密钥仅用于自己账号的个人数据访问,勿用于他人数据。
    </div>
  </div>

  <footer>
    <p>生成时间:2026-05-16 · 账号:yibooo_ac07 · WeChat 4.1.7 · Frida 17.9.10 · sqlcipher 4.16.0</p>
  </footer>

</main>

<script>
  // Active nav link tracking
  const sections = document.querySelectorAll('[id]');
  const links = document.querySelectorAll('nav a');
  const obs = new IntersectionObserver(entries => {
    entries.forEach(e => {
      if (e.isIntersecting) {
        links.forEach(l => l.classList.remove('active'));
        const a = document.querySelector(`nav a[href="#${e.target.id}"]`);
        if (a) a.classList.add('active');
      }
    });
  }, { rootMargin: '-20% 0px -70% 0px' });
  sections.forEach(s => obs.observe(s));
</script>
</body>
</html>