241 lines
12 KiB
Plaintext
241 lines
12 KiB
Plaintext
[34m[1m=== C Nostr Relay Server ===[0m
|
||
[32m[SUCCESS][0m Database connection established
|
||
[34m[INFO][0m Starting relay server...
|
||
[34m[INFO][0m Starting libwebsockets-based Nostr relay server...
|
||
[32m[SUCCESS][0m WebSocket relay started on ws://127.0.0.1:8888
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (1) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 5 rows
|
||
[34m[INFO][0m Total events sent: 5
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 17 rows
|
||
[34m[INFO][0m Total events sent: 17
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (1) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 7 rows
|
||
[34m[INFO][0m Total events sent: 7
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (0) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 1 rows
|
||
[34m[INFO][0m Total events sent: 1
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND pubkey IN ('aa4fc8665f5696e33db7e1a572e3b0f5b3d615837b0f362dcb1c8068b098c7b4') ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 17 rows
|
||
[34m[INFO][0m Total events sent: 17
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND created_at >= 1756983802 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 6 rows
|
||
[34m[INFO][0m Total events sent: 6
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 17 rows
|
||
[34m[INFO][0m Total events sent: 17
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (0,1) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 8 rows
|
||
[34m[INFO][0m Total events sent: 8
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (1) ORDER BY created_at DESC LIMIT 1
|
||
[34m[INFO][0m Query returned 1 rows
|
||
[34m[INFO][0m Total events sent: 1
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling EVENT message
|
||
[32m[SUCCESS][0m Event stored in database
|
||
[32m[SUCCESS][0m Event stored successfully
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 22 rows
|
||
[34m[INFO][0m Total events sent: 22
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (1) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 9 rows
|
||
[34m[INFO][0m Total events sent: 9
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (0) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 1 rows
|
||
[34m[INFO][0m Total events sent: 1
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND pubkey IN ('aa4fc8665f5696e33db7e1a572e3b0f5b3d615837b0f362dcb1c8068b098c7b4') ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 22 rows
|
||
[34m[INFO][0m Total events sent: 22
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND created_at >= 1756983945 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 9 rows
|
||
[34m[INFO][0m Total events sent: 9
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 22 rows
|
||
[34m[INFO][0m Total events sent: 22
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (0,1) ORDER BY created_at DESC LIMIT 500
|
||
[34m[INFO][0m Query returned 10 rows
|
||
[34m[INFO][0m Total events sent: 10
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|
||
[34m[INFO][0m WebSocket connection established
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Handling REQ message
|
||
[34m[INFO][0m Executing SQL: SELECT id, pubkey, created_at, kind, content, sig, tags FROM events WHERE 1=1 AND kind IN (1) ORDER BY created_at DESC LIMIT 1
|
||
[34m[INFO][0m Query returned 1 rows
|
||
[34m[INFO][0m Total events sent: 1
|
||
[34m[INFO][0m Received WebSocket message
|
||
[34m[INFO][0m Subscription closed
|
||
[34m[INFO][0m WebSocket connection closed
|