Keys Found from a Database Search

[A_n_g_e_l_a]

It is not a question of "--key", kid:key, the kid of new and old secret keys is the same, the difference is the key.

Do you have an example?

[A_n_g_e_l_a]

Had a chat with 'Nony just now and got this:-

Re: failures, some OTTs, most notably AMZN and DSNP and the bigger dogs often reencode stuff so this is the reason. I've also known same vod on AMZN to be dished up via different CDNs to have diff keys for each diff cdn. So anyone with any knowledge of the game shouldn't be complaining

[pteque]

I reworked your database into a normalized schema to remove the duplicated keys, which brings down the sqlite file size to 171MB (containing 269327 pssh values, doesn't include the vdocipher identifiers). The new schema:

CREATE TABLE pssh (id INTEGER PRIMARY KEY, data TEXT NOT NULL UNIQUE) WITHOUT ROWID
CREATE TABLE key (id INTEGER PRIMARY KEY, data TEXT NOT NULL UNIQUE) WITHOUT ROWID
CREATE TABLE pssh_key(pssh_id REFERENCES pssh(id), key_id REFERENCES key(id), PRIMARY KEY(pssh_id, key_id)) WITHOUT ROWID

Available here: https://desiupload.co/fnlb7ci9r6g7

and a query script in Python (use like this: query.py normalized.db 'psshvalue'):

#!/usr/bin/env python3

import sys
import sqlite3

if len(sys.argv) != 3:
    print("Usage: {} normalized.db pssh".format(sys.argv[0]))
    sys.exit(1)
con = sqlite3.connect(sys.argv[1])
cur = con.cursor()
res = cur.execute("""SELECT k.data FROM key K
   JOIN pssh_key PK ON K.id = PK.key_id 
   JOIN pssh P ON P.id = PK.pssh_id 
   WHERE P.data = ?""", (sys.argv[2],))
rows = res.fetchall()
for r in rows:
    print(r[0])
if len(rows) == 0:
    res = cur.execute("SELECT COUNT(*) FROM pssh")
    num = res.fetchone()
    number = num[0]
    print(f"Nothing found!\nYet there are {number} pssh entries in the database.")

[piaohua]

PSSH.
AAAAR3Bzc2gAAAAA7e+LqXnWSs6jyCfc1R0h7QAAACcIARIQXA qYcOWejLMgnxKqYxUZLRoDdHZiIgxOREEyTnpNeE5Td3c=

The key obtained from the database is
5c0a9870e59e8cb3209f12aa6315192d:ab456df4aabc10c87 d9e70d184d19c3e

The key obtained by CDRM is
5c0a9870e59e8cb3209f12aa6315192d:6563e421e058eee3f dbf828886d0ab1d

[pteque]

I don't know the reason for this; perhaps the key in the database is from getWvKeys rather than CDRM?

[lomero]

sure. only these 2 make up the database

[A_n_g_e_l_a]

PSSH.
AAAAR3Bzc2gAAAAA7e+LqXnWSs6jyCfc1R0h7QAAACcIARIQXA qYcOWejLMgnxKqYxUZLRoDdHZiIgxOREEyTnpNeE5Td3c=

The key obtained from the database is
5c0a9870e59e8cb3209f12aa6315192d:ab456df4aabc10c87 d9e70d184d19c3e

The key obtained by CDRM is
5c0a9870e59e8cb3209f12aa6315192d:6563e421e058eee3f dbf828886d0ab1d

I don't know the reason for this; perhaps the key in the database is from getWvKeys rather than CDRM?

see post https://forum.videohelp.com/threads/409682-Keys-Found-from-a-Database-Search/page2#post2693794 There is no uniqueness such that one pssh matches only one key, as I am coming to understand widevine.

[A_n_g_e_l_a]

I reworked your database into a normalized schema to remove the duplicated keys, which brings down the sqlite file size to 171MB (containing 269327 pssh values, doesn't include the vdocipher identifiers). The new schema:

Nice thanks. That is a bit of a trip down memory lane and the hair tugging at inner and outer joins. I am not sure at the wisdom of enforcing uniqueness everywhere; I deliberately chose not to. I think pssh and keys may be unique from one Content Delivery Network, but there are hundreds of those. I have no idea how pssh key pairs are generated but the fact that each CDN creates their own and SERVES their own, to me, suggests they are not unique.

I discovered on Friday that cdrm project included the keys from getwvkeys when they first set-up. That accounts for all the duplication. It shouldn't matter too much in use as you throw all the keys at your decryptor and it will use the right one.

[pteque]

Regarding uniqueness in the SQL schema: the UNIQUE on the pssh and key tables is just a way of checking that there is no redundant data stored. However, the link between pssh and key (in the pssh_key table) is not constrained: one pssh can be linked to multiple keys, and the same key might be used for multiple psshes.

[A_n_g_e_l_a]

Regarding uniqueness in the SQL schema: the UNIQUE on the pssh and key tables is just a way of checking that there is no redundant data stored. However, the link between pssh and key (in the pssh_key table) is not constrained: one pssh can be linked to multiple keys, and the same key might be used for multiple psshes.

Thanks for clarifying.

[extream87]

A_n_g_e_l_a fantastic... This is awesome for first lookup.
Do you plan to keep db updated?

[A_n_g_e_l_a]

Do you plan to keep db updated?

That was the original intention. three things have happened:-

1. Notaghost: refused to release an up-to-date copy of kid/key or pssh/key data from the database held by getwvkeys.cc
2. TPD49: The automated bot that provides a database copy on the Discord Channel of cdrm-project has been out of action since a week after this thread was started. TPD94, the owner of cdm and cdrm projects knows it is out of action.
   [edit] The project seems to be dying - asking for money; getting rancorous; no TPD94 activity since 14 June.
   
   [Attachment 72130 - Click to enlarge]
   People are realising just what an amoral a-hole the boy is
   
3. I asked contacts, via a private forum for a copy of their vine-trimmer database kid/keys. Only one responded.

Without co-operation and data I cannot update the database. If the situation should change so will the database released here.

Edit: Just found this. 403 K keys database - seems scammers are selling it .

[Attachment 72127 - Click to enlarge]

[k2000]

is it possible to get the database of keys from VT (Vinetrimmer)?

[T33V33]

is it possible to get the database of keys from VT (Vinetrimmer)?

VT uses a local DB for any keys you have got through it. It only uses a remote database if you have access to one and have set it up in the config file

[gift4bd]

Great job! But how often or interval of this db file update.

Thanks!

[Jusinsilhan]

Do you plan to keep db updated?

That was the original intention. three things have happened:-

1. Notaghost: refused to release an up-to-date copy of kid/key or pssh/key data from the database held by getwvkeys.cc
2. TPD49: The automated bot that provides a database copy on the Discord Channel of cdrm-project has been out of action since a week after this thread was started. TPD94, the owner of cdm and cdrm projects knows it is out of action.
   [edit] The project seems to be dying - asking for money; getting rancorous; no TPD94 activity since 14 June.
   
   [Attachment 72130 - Click to enlarge]
   People are realising just what an amoral a-hole the boy is
   
3. I asked contacts, via a private forum for a copy of their vine-trimmer database kid/keys. Only one responded.

Without co-operation and data I cannot update the database. If the situation should change so will the database released here.

Edit: Just found this. 403 K keys database - seems scammers are selling it .

[Attachment 72127 - Click to enlarge]

So you’re the reason Cdrm is down?? Please end this beef. We need that!

[iamghost]

So you’re the reason Cdrm is down?? Please end this beef. We need that!

he will fix all of things tomorrow 14th

[Attachment 72396 - Click to enlarge]

[A_n_g_e_l_a]

So you’re the reason Cdrm is down?? Please end this beef. We need that!

Hilarious non sequitur! Silly boy.

[Magicians]

Do you plan to keep db updated?

That was the original intention. three things have happened:-

1. Notaghost: refused to release an up-to-date copy of kid/key or pssh/key data from the database held by getwvkeys.cc
2. TPD49: The automated bot that provides a database copy on the Discord Channel of cdrm-project has been out of action since a week after this thread was started. TPD94, the owner of cdm and cdrm projects knows it is out of action.
   [edit] The project seems to be dying - asking for money; getting rancorous; no TPD94 activity since 14 June.
   
   [Attachment 72130 - Click to enlarge]
   People are realising just what an amoral a-hole the boy is
   
3. I asked contacts, via a private forum for a copy of their vine-trimmer database kid/keys. Only one responded.

Without co-operation and data I cannot update the database. If the situation should change so will the database released here.

Edit: Just found this. 403 K keys database - seems scammers are selling it .

[Attachment 72127 - Click to enlarge]

So you’re the reason Cdrm is down?? Please end this beef. We need that!

TPD is a ****. I helped him setup cdrm and he deleted all our telegram chat and blocked me.

Worthless waste of space in the community

[andrez4zv]

Ugh! A year ago I gave up. I tried again when I saw new information and methods from Angela and cendric, but it seems that life wants me to start recording the screen.

Can anyone please confirm for me if there is still a way to download videos from Vdocipher? I can dedicate another couple of days to try again.

By the way, I tried again to test the CDM with Android, I got the files client_id_blob and the other file generated by Dump, but reading several users, they said that an emulator didn't work with vdocpher... and I got discouraged again.

[gwe202]

Hello, by any chance does anyone have the database with the KEY:KID downloaded and can pass it to me?
I'm trying to download it and I get 404 not found
Thank you very much

[A_n_g_e_l_a]

Hello, by any chance does anyone have the database with the KEY:KID downloaded and can pass it to me?
I'm trying to download it and I get 404 not found
Thank you very much

https://anonymfile.com/AakJA/keyvault-wn24.db

[senkron24]

Hello, by any chance does anyone have the database with the KEY:KID downloaded and can pass it to me?
I'm trying to download it and I get 404 not found
Thank you very much

https://anonymfile.com/AakJA/keyvault-wn24.db

Thank you

Long life democrati

[devilbingo]

Hi does anyone have the database file? Anonfiles has shutdown so I can't access those links and the one above from anonymfile doesn't exist now.
@senkron24 can you help here?

[A_n_g_e_l_a]

Dead and buried now. The database increasingly became historic. And without the cooperation of getwvkeys the idea had no-legs.

[Neurobcn]

Here are 200 open FTP servers, without a password. It's possible to extract around 10,000 in case you want to upload the file again.

117.72.17.141:21
128.193.72.31:21
170.84.206.243:21
3.223.74.226:21
160.16.67.243:21
85.11.67.55:21
192.175.120.168:21
160.16.215.149:21
165.22.91.146:21
94.152.58.154:21
195.5.106.240:21
198.20.86.204:21
131.233.0.151:21
211.72.164.108:21
94.152.41.82:21
177.69.209.139:21
128.171.90.62:21
42.159.121.218:21
13.53.83.250:21
94.152.49.16:21
14.41.80.2:21
122.116.147.23:21
61.64.127.72:21
47.100.55.21:21
164.70.165.173:21
213.174.163.90:21
88.99.149.36:21
91.235.200.18:21
62.171.162.243:21
1.36.157.22:21
94.152.43.89:21
24.49.146.52:21
103.231.135.52:21
148.66.115.108:21
3.122.58.134:21
72.32.45.19:21
104.41.168.87:21
94.152.47.157:21
211.142.246.88:21
68.183.198.106:21
46.28.110.208:21
128.14.181.202:21
207.178.219.88:21
193.108.103.11:21
181.112.153.91:21
190.111.162.209:21
51.38.186.119:21
112.18.109.108:21
208.109.188.234:21
59.126.137.126:21
159.203.55.188:21
200.91.244.238:21
188.166.196.32:21
209.172.43.24:21
47.243.77.187:21
130.208.58.75:21
89.200.86.200:21
64.49.237.103:21
52.37.1.147:21
199.231.235.234:21
77.32.123.144:21
94.152.164.227:21
82.64.89.192:21
172.104.134.10:21
57.128.173.43:21
86.111.115.70:21
45.185.54.209:21
107.155.108.241:21
194.29.157.44:21
193.93.50.3:21
125.137.243.87:21
51.103.50.219:21
52.77.207.193:21
209.177.95.138:21
115.71.236.128:21
111.70.11.105:21
139.59.126.50:21
70.15.249.84:21
184.154.41.228:21
71.171.98.137:21
185.219.164.121:21
200.155.57.169:21
172.104.57.45:21
47.89.24.73:21
97.64.40.35:21
154.117.174.236:21
8.10.97.40:21
154.27.73.96:21
64.180.116.170:21
195.221.235.12:21
18.220.133.80:21
79.1.73.3:21
209.38.246.80:21
210.71.250.3:21
134.246.142.21:21
178.168.123.64:21
151.3.100.19:21
212.221.23.13:21
64.202.230.8:21
36.139.63.178:21
94.152.46.130:21
218.103.234.11:21
193.147.152.110:21
47.95.2.11:21
194.149.234.2:21
47.254.122.10:21
206.189.42.100:21
190.111.163.187:21
95.216.236.72:21
94.152.44.189:21
195.201.201.68:21
128.171.90.73:21
194.141.118.93:21
45.185.52.178:21
109.196.164.109:21
45.79.70.112:21
94.152.8.44:21
61.82.135.27:21
121.226.122.49:21
198.199.87.148:21
45.185.53.178:21
144.76.201.197:21
200.229.61.196:21
45.185.54.211:21
13.235.42.137:21
94.152.51.140:21
209.160.50.99:21
113.31.106.235:21
133.242.190.212:21
79.33.92.53:21
94.152.195.160:21
94.152.216.21:21
211.251.239.200:21
117.24.95.68:21
77.81.229.60:21
133.155.218.39:21
201.49.21.46:21
61.41.9.41:21
80.93.208.119:21
47.87.206.175:21
128.171.90.178:21
128.111.100.23:21
94.152.60.110:21
94.152.58.40:21
182.163.92.154:21
193.118.58.74:21
49.212.145.251:21
147.147.116.160:21
50.7.239.238:21
134.209.96.71:21
45.65.200.7:21
219.142.48.149:21
203.162.19.247:21
115.71.232.90:21
94.152.33.130:21
160.16.235.47:21
94.152.178.42:21
198.58.99.127:21
150.158.83.114:21
117.102.180.7:21
192.99.151.169:21
128.193.115.22:21
92.83.60.86:21
152.136.113.202:21
3.109.155.27:21
94.152.46.113:21
94.152.193.232:21
120.55.43.151:21
35.183.42.220:21
118.163.94.33:21
37.35.246.92:21
213.171.187.47:21
43.243.237.89:21
94.152.36.107:21
106.14.71.143:21
144.202.49.179:21
83.68.37.213:21
63.251.169.57:21
103.191.152.48:21
165.227.15.243:21
94.152.39.253:21
94.152.48.3:21
94.152.165.250:21
209.148.81.168:21
106.122.194.65:21
157.245.133.185:21
82.100.228.206:21
195.80.166.203:21
51.141.76.205:21
66.103.226.171:21
209.148.81.210:21
3.145.32.234:21
86.97.142.16:21
94.152.49.224:21
66.162.83.131:21
200.73.116.88:21
94.152.45.116:21
217.82.186.211:21
94.152.60.109:21
159.223.44.0:21 

[Fallito]

I Upload to Gofile the keyVault_WN24 database. Here is the link:

https://store1.gofile.io/download/3781b542-ac13-4e14-8243-1e8ff64d57a1/keyVault_WN24.db

Hope it helps.

[senkron24]

here i have write one php code thad allow you sourch in kid or pssh on database



[Attachment 73695 - Click to enlarge]

<!DOCTYPE html>
<html>
<head>
    <title>Senkron24 KID or PSSH </title>
</head>
<body>
    <h1>Senkron24 KID or PSSH </h1>
    <form method="post" action="">
        <label for="kid_pssh">KID or PSSH:</label>
        <input type="text" id="kid_pssh" name="kid_pssh" required>
        <br>
        <input type="submit" value="search">
    </form>

    <?php
    if ($_SERVER["REQUEST_METHOD"] == "POST") {

        $kid_pssh = htmlspecialchars($_POST["kid_pssh"]);

        $databaseFile = 'keyVault_WN24.db';
        $pdo = new PDO("sqlite:$databaseFile");

        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        try {
            $sql = "SELECT KID, PSSH, time, keys FROM DATABASE WHERE KID = :kid OR pssh = :pssh";
            $stmt = $pdo->prepare($sql);

            $stmt->bindValue(':kid', $kid_pssh);
            $stmt->bindValue(':pssh', $kid_pssh);
            $stmt->execute();

            $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

            if ($results) {
                echo "<p>Sonuçlar:</p>";
                foreach ($results as $result) {
                    $kid = $result['KID'];
                    $pssh = $result['pssh'];
                    $time = $result['time'];
                    $keys = json_decode($result['keys'], true);

                    echo "<p>KID: $kid</p>";
                    echo "<p>PSSH: $pssh</p>";
                    echo "<p>Time: $time</p>";
                    
                    if ($keys) {
                        echo "<p>Keys:</p>";
                        echo "<ul>";
                        foreach ($keys as $key) {
                            echo "<li>{$key['key']}</li>";
                        }
                        echo "</ul>";
                    } else {
                        echo "<p>Keys bulunamadı.</p>";
                    }
                    
                    echo "<hr>";
                }
            } else {
                echo "<p>Sonuç bulunamadı.</p>";
            }
        } catch (PDOException $e) {
            echo "Hata: " . $e->getMessage();
        }

        $pdo = null;
    }
    ?>
</body>
</html>

this its for the db what here exist
on linux need to be installed apache2, sqlite3 and php thad is and copy the php file in same direcktory as the db all workimg fine

kind regarts

[A_n_g_e_l_a]

here i have write one php code thad allow you sourch in kid or pssh on database
on linux need to be installed apache2, sqlite3 and php thad is and copy the php file in same direcktory as the db all workimg fine

kind regarts

And that is easier than using the python script supplied at post #1?

[senkron24]

here i have write one php code thad allow you sourch in kid or pssh on database
on linux need to be installed apache2, sqlite3 and php thad is and copy the php file in same direcktory as the db all workimg fine

kind regarts

And that is easier than using the python script supplied at post #1?

ahh sorry i glad not coreckt chack this bud i will be sure. test this to, bud mybe samtime its easy with php its up to how you want it handel

bud big thanks for you efort and sharing with us on all steps and learn us how to

big respekt from me ...

kind regarts

ps: i chack it right now 100% work very easy you got a kis ))

python pss-data-chack.py
PSSH? AAAAyXBzc2gAAAAA7e+LqXnWSs6jyCfc1R0h7QAAAKkSEP/7hIR6bTfspxqhzLeJD6AilAF7InYiOiIyIiwiZmlkIjoicHBiZ DAwMDU3Iiwic3ZpZCI6ImRpZ2l0YWwiLCJwbCI6ImV5SndhV1F pT2lKd2NHSmtNREF3TlRka2JDSXNJbVJsYkdsMlpYSjVYM1I1Y 0dVaU9pSmtiQ0o5IiwiY3MiOiI5YjU5YTMxMGE3YjNkNzNkZWU 2YmJmZjI5NmYzOWUzMiJ9

[{"key": "fffb84847a6d37eca71aa1ccb7890fa0:08e412657dfdce93 735e069650d9ace7"}]