Skip to content

Instantly share code, notes, and snippets.

@svperfecta

svperfecta/gist:5ad7aaadafac9a4ce2b11f2a012fe06e

Last active August 31, 2016 04:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save svperfecta/5ad7aaadafac9a4ce2b11f2a012fe06e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save svperfecta/5ad7aaadafac9a4ce2b11f2a012fe06e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
+---------------------+------------------------------------------------------------------------+-----------+----------------------------------------+
| created_at | username | kind | txt |
+---------------------+------------------------------------------------------------------------+-----------+----------------------------------------+
| 2016-08-31 04:02:04 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Chatter! |
| 2016-08-31 03:43:24 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | ZZZZZZZZZZZZ |
| 2016-08-31 03:43:17 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Another message |
| 2016-08-31 03:42:50 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | AAAAAAAAAAA |
| 2016-08-31 03:42:45 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Trying to send a message |
| 2016-08-31 01:53:36 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Guild Chat Solo |
| 2016-08-31 01:48:58 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Guild Chat 8/30 18:48 |
| 2016-08-31 01:48:45 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean2 testing Guild Chat 8/30 18:48 |
| 2016-08-30 23:45:03 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Guild Chat at 8/30 16:45 |
| 2016-08-30 03:07:51 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 21 |
| 2016-08-30 03:07:49 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 20 |
| 2016-08-30 03:07:47 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 19 |
| 2016-08-30 03:07:45 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 18 |
| 2016-08-30 03:07:43 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 17 |
| 2016-08-30 03:07:42 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 16 |
| 2016-08-30 03:07:40 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 15 |
| 2016-08-30 03:07:39 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 14 |
| 2016-08-30 03:07:37 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 13 |
| 2016-08-30 03:07:35 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 12 |
| 2016-08-30 03:07:34 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | 11 |
+---------------------+------------------------------------------------------------------------+-----------+----------------------------------------+
mysql> select created_at, username, kind, txt from archive order by timestamp desc limit 10;
+---------------------+------------------------------------------------------------------------+-----------+------------------------------------------------------------------------------+
| created_at | username | kind | txt |
+---------------------+------------------------------------------------------------------------+-----------+------------------------------------------------------------------------------+
| 2016-08-31 03:46:11 | #947d62f0-6f2a-11e6-b36b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Team Chat 1? |
| 2016-08-31 03:44:36 | a666abce-6b07-11e6-b9a2-06567476c2f5 | chat | 2v2 |
| 2016-08-31 03:43:24 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | ZZZZZZZZZZZZ |
| 2016-08-31 03:43:17 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Another message |
| 2016-08-31 03:42:50 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | AAAAAAAAAAA |
| 2016-08-31 03:42:45 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Trying to send a message |
| 2016-08-31 03:33:17 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | chat | Only this one showed up |
| 2016-08-31 03:33:17 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | chat | Only this one showed up |
| 2016-08-31 03:30:32 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | chat | I sent one in this channel... one to Cheezy4... one to Team and one to Guild |
| 2016-08-31 03:30:32 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | chat | I sent one in this channel... one to Cheezy4... one to Team and one to Guild |
+---------------------+------------------------------------------------------------------------+-----------+------------------------------------------------------------------------------+
10 rows in set (0.00 sec)
+---------------------+--------------------------------------+------------------------------------------------------------------------------------+------+------------------------------------------------------------------------------+
| 2016-08-31 03:33:17 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | [email protected]/15045378015013208761111 | chat | Only this one showed up |
| 2016-08-31 03:33:17 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | [email protected] | chat | Only this one showed up |
| 2016-08-31 03:30:32 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | [email protected]/4876545535378280098498 | chat | I sent one in this channel... one to Cheezy4... one to Team and one to Guild |
| 2016-08-31 03:30:32 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | [email protected] | chat | I sent one in this channel... one to Cheezy4... one to Team and one to Guild |
| 2016-08-31 03:30:13 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | [email protected]/15045378015013208761111 | chat | I got one message |
| 2016-08-31 03:30:13 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | [email protected] | chat | I got one message |
| 2016-08-31 03:29:39 | 9615396e-6b04-11e6-8ac4-06567476c2f5 | [email protected]/4876545535378280098498 | chat | Can you see this 8/30 20:29? |
| 2016-08-31 03:29:39 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | [email protected] | chat | Can you see this 8/30 20:29? |
| 2016-08-31 03:29:28 | ea42eeca-6b07-11e6-9892-06567476c2f5 | [email protected]/4876545535378280098498 | chat | Can you see this chat? 8/30 20:29 |
| 2016-08-31 03:29:28 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | [email protected] | chat | Can you see this chat? 8/30 20:29 |
+---------------------+--------------------------------------+------------------------------------------------------------------------------------+------+------------------------------------------------------------------------------+
mysql> select created_at, username, kind, txt from archive order by timestamp desc limit 100;
+---------------------+------------------------------------------------------------------------+-----------+-------------------------------------------+
| created_at | username | kind | txt |
+---------------------+------------------------------------------------------------------------+-----------+-------------------------------------------+
| 2016-08-31 02:37:41 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | Test Verbose |
| 2016-08-31 02:37:32 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | Test verbose |
| 2016-08-31 02:33:05 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | asdf |
| 2016-08-31 02:31:59 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | Hi |
| 2016-08-31 02:14:15 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | qwer |
| 2016-08-31 02:14:11 | #c6383bbc-6f20-11e6-9f49-06567476c2f5@conference.superevilmegacorp.net | groupchat | asdf |
| 2016-08-31 02:12:19 | 75ae0f3c-6a6b-11e6-aba6-06567476c2f5 | chat | Sean2 testing personal chat at 8/30 19:12 |
| 2016-08-31 02:12:19 | 808e876c-6f1e-11e6-a738-06567476c2f5 | chat | Sean2 testing personal chat at 8/30 19:12 |
| 2016-08-31 01:59:30 | 75ae0f3c-6a6b-11e6-aba6-06567476c2f5 | chat | Sean1 testing personal chat at 8/30 18:59 |
| 2016-08-31 01:59:07 | 75ae0f3c-6a6b-11e6-aba6-06567476c2f5 | chat | Sean2 testing personal chat at 8/30 18:59 |
| 2016-08-31 01:59:07 | 808e876c-6f1e-11e6-a738-06567476c2f5 | chat | Sean2 testing personal chat at 8/30 18:59 |
| 2016-08-31 01:53:57 | #ebcd9916-6b20-11e6-b79d-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Team Chat Solo |
| 2016-08-31 01:53:36 | #d26b9e78-6b20-11e6-9b5b-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Guild Chat Solo |
| 2016-08-31 01:52:16 | #a973f190-6f1d-11e6-972f-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean2 testing Party chat 8/30 18:52 |
| 2016-08-31 01:52:06 | #a973f190-6f1d-11e6-972f-06567476c2f5@conference.superevilmegacorp.net | groupchat | Sean1 testing Party chat 8/30 18:52 |
| 2016-08-31 01:51:50 | 3aeae68c-6b19-11e6-9cc3-06567476c2f5 | chat | Sean1 testing personal chat 8/30 18:49 |
2016-08-31 02:31:42.751 [info] <0.885.0>@ejabberd_c2s:terminate:1779 ({socket_state,ezlib,{zlibsock,gen_tcp,#Port<0.27214>,#Port<0.27490>},<0.884.0>}) Close session for [email protected]/16626767305926764803362
2016-08-31 02:31:42.753 [info] <0.885.0>@ejabberd_c2s:handle_unacked_stanzas:2876 2 stanzas were not acknowledged by [email protected]/16626767305926764803362
2016-08-31 02:31:49.459 [info] <0.773.0>@ejabberd_listener:accept:333 (#Port<0.27878>) Accepted connection ::FFFF:10.9.0.145:27493 -> ::FFFF:10.9.2.62:5222
2016-08-31 02:31:55.053 [info] <0.773.0>@ejabberd_listener:accept:333 (#Port<0.27879>) Accepted connection ::FFFF:10.9.0.145:27497 -> ::FFFF:10.9.2.62:5222
2016-08-31 02:31:55.320 [info] <0.948.0>@ejabberd_c2s:wait_for_feature_request:761 ({socket_state,ezlib,{zlibsock,gen_tcp,#Port<0.27879>,#Port<0.27983>},<0.947.0>}) Accepted authentication for ea42eeca-6b07-11e6-9892-06567476c2f5 by ejabberd_auth_http from ::FFFF:10.9.0.145
2016-08-31 02:31:55.477 [info] <0.948.0>@ejabberd_c2s:open_session:1113 ({socket_state,ezlib,{zlibsock,gen_tcp,#Port<0.27879>,#Port<0.27983>},<0.947.0>}) Opened session for [email protected]/1950526622156306918366
2016-08-31 02:31:55.563 [info] <0.948.0>@ejabberd_c2s:handle_enable:2701 Stream management with resumption enabled for [email protected]/1950526622156306918366
2016-08-31 02:31:56.104 [info] <0.773.0>@ejabberd_listener:accept:333 (#Port<0.28192>) Accepted connection ::FFFF:10.9.2.17:39890 -> ::FFFF:10.9.2.62:5222
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment