|
YouretheMadest and the b
|
| #hastext; #hastitle; #signed |
|---|
|
YouretheMadest and the best..may the muse always be with you..jw |
|
;
⏳;
99098073;
like;
flag;
remove
; |
|
Comment
|
|
ItemAttributes
|
|
| attribute | value |
|---|---|
| Checksum: | Yes |
| SHA1 (chain.log): | 990980738cf04ec65a4f14f4d1f4a1ef59393828 |
| Next: | YouretheMadest a |
| Previous: | Public Key for G |
| Sequence: | 135 |
| Notarized: | 1730435530.24524 |
| File Time: | 1730435530 |
| File: | /txt/99/09/990980738cf04ec65a4f14f4d1f4a1ef59393828.txt 1730435530; 748 bytes |
| File Size: | 748 |
| Signature: | ⏳ C4735929A14FBE34 |
| Signed: | 1675473536 |
| Type: | txt |
| SHA1 (Perl, Digest::SHA): | 990980738cf04ec65a4f14f4d1f4a1ef59393828 |
| Title: | YouretheMadest and the best..may the muse always be with you..j |
SELECT DISTINCT attribute, value FROM item_attribute WHERE attribute not in ('cookie', 'client') AND file_hash LIKE '990980738cf04ec65a4f14f4d1f4a1ef59393828%' ORDER BY attribute
| |
|
Search
|
| Google Perplexity DuckDuckGo Bing Brave A1go1ia Wikipedia English Wikipedia Russian Wikipedia Ukrainian Tildes Lobsters |
|
Publish
|
localhost:2784 |
|
Share
|
|
Classify
|
|
|
|
Related
|
|||||||
| item_title | add_timestamp | file_hash | attribute_list | attribute_count |
|||
|---|---|---|---|---|---|---|---|
| YouretheMadest and the best..may the muse always be with you..j | 03268a00 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | 033270bb | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | 28e8d9c8 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | 53a20c95 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | 60d5b67c | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | b27353c6 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | b3f24bf1 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | caa45f44 | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | d306b9bf | title | 1 | ||||
| YouretheMadest and the best..may the muse always be with you..j | 99098073 | title | 1 | ||||
SELECT
COALESCE(NULLIF(item_title,''), 'Untitled') AS item_title,
item_flat.add_timestamp AS add_timestamp,
item_attribute_chain.value AS chain_timestamp,
(item_flat.file_hash = '990980738cf04ec65a4f14f4d1f4a1ef59393828') AS this_row,
'' AS cart,
item_flat.file_hash AS file_hash,
GROUP_CONCAT(related_list.attribute) AS attribute_list,
COUNT(related_list.attribute) AS attribute_count
FROM
item_flat
JOIN
(
SELECT
file_hash,
attribute
FROM
item_attribute
WHERE (
attribute||'='||value IN (
SELECT
attribute||'='||value
FROM
item_attribute
WHERE
file_hash IN ('990980738cf04ec65a4f14f4d1f4a1ef59393828') AND
attribute IN (
'http',
'https',
'url_domain',
'title',
'cookie_id',
'client_id',
'url_domain',
'message_hash'
)
)
)
) AS related_list ON (item_flat.file_hash = related_list.file_hash)
JOIN item_attribute AS item_attribute_chain ON (item_flat.file_hash = item_attribute_chain.file_hash)
WHERE
labels_list NOT LIKE '%notext%'
AND
item_attribute_chain.attribute = 'chain_timestamp'
GROUP BY
item_title, add_timestamp, this_row, item_flat.file_hash
ORDER BY
attribute_count DESC, add_timestamp DESC
LIMIT 25
| |||||||
|
Chain
|
|
| Sequence: | 135 |
| Next: | YouretheMadest a |
| Previous: | Public Key for G |
SELECT
attribute,
value
FROM
item_attribute
JOIN item_flat ON (item_attribute.file_hash = item_flat.file_hash)
WHERE
item_attribute.file_hash = '990980738cf04ec65a4f14f4d1f4a1ef59393828' AND
attribute IN ('chain_next', 'chain_previous', 'chain_sequence')
ORDER BY
NOT (attribute = 'chain_sequence')
| |
|
Timestamps
|
|
| Notarized: | 1730435530.24524 |
| File Time: | 1730435530 |
| Signed: | 1675473536 |
SELECT attribute, value FROM item_attribute WHERE file_hash = '990980738cf04ec65a4f14f4d1f4a1ef59393828' AND attribute LIKE '%_timestamp'
| |
|
Hashes
|
|
| SHA1 (chain.log): | 990980738cf04ec65a4f14f4d1f4a1ef59393828 |
| SHA1 (Perl, Digest::SHA): | 990980738cf04ec65a4f14f4d1f4a1ef59393828 |
SELECT attribute, value FROM item_attribute WHERE file_hash = '990980738cf04ec65a4f14f4d1f4a1ef59393828' AND attribute IN('sha1', 'sha1sum', 'chain_hash')
| |
|
index_log
|
| indexing begins file hash = 990980738cf04ec65a4f14f4d1f4a1ef59393828 file stat: size = 748; mod time = 1730435530 --- finished finding tokens tokens found: 0 --- item timestamp: 1730435530.24524 |
|
Verify
|
|
This item includes a PGP signature.
curl -s -o chain.log http://localhost:2784/chain.log
# download chain and save it as chain.log
curl -s -o chain_log_verify.py http://localhost:2784/chain_log_verify.txt
# download chain log verification script and save it as chain_log_verify.py
python3 chain_log_verify.py chain.log
# use python to run the chain log verification script
curl -s -o pubkey.txt http://localhost:2784
# download author's public key and save as author_pubkey.txt
sha1sum author_pubkey.txt
# print hash of author_pubkey.txt
sha1sum author_pubkey.txt | cut -d ' ' -f 1 | xargs -I {} grep {} chain.log
# verify that hash of author_pubkey.txt is is in chain.log
gpg --import author_pubkey.txt
# import public key into GnuPG keychain
curl -s -o message.txt http://localhost:2784/txt/99/09/990980738cf04ec65a4f14f4d1f4a1ef59393828.txt
# download the message file and save it as message.txt
sha1sum message.txt
# print the hash of message.txt
sha1sum message.txt | cut -d ' ' -f 1 | xargs -I {} grep {} chain.log
# verify that the hash is in chain.log
gpg --verify message.txt
# verify message signature with GnuPG
|
|
gpg_stderr
|
| gpg: Signature made Fri Feb 3 17:18:56 2023 PST gpg: using RSA key C4735929A14FBE34 gpg: Can't check signature: No public key |
|
Cart
|
