API tools faq
paste
Advertisement
monte-monte

Shinobi_7fe4d3c_SQL_debug

monte-monte
Mar 13th, 2019
256
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.24 KB | None | 0 0
raw download clone embed print report
  1. 0|camera | Shinobi is Exiting...
  2. 0|camera | No "ffbinaries". Continuing.
  3. 0|camera | Run "npm install ffbinaries" to get this static FFmpeg downloader.
  4. 0|camera | No "ffmpeg-static".
  5.  
  6. 1|cron | s.sqlQuery QUERY SELECT ke,uid,details,mail FROM Users WHERE details NOT LIKE '%"sub"%'
  7. 0|camera | Available Hardware Acceleration Methods : vdpau, vaapi
  8. 1|cron | Shinobi : cron.js started
  9. 1|cron | RowDataPacket {
  10. 1|cron | ke: 'z0GfsMx6qQ',
  11. 1|cron | uid: 'Q86uKI9jky',
  12. 1|cron | details: '{"factorAuth":"0","size":"2000000","days":"30","event_days":"30","log_days":"","max_camera":"","permissions":"all","edit_size":"1","edit_days":"1","edit_event_days":"1","edit_log_days":"1","use_admin":"1","use_aws_s3":"1","use_whcs":"1","use_sftp":"1","use_webdav":"1","use_discordbot":"1","use_ldap":"1","aws_use_global":"0","b2_use_global":"0","webdav_use_global":"0","monitorOrder":{"z0GfsMx6qQsdjkfhkjsdh":{"ke":"z0GfsMx6qQ","mid":"sdjkfhkjsdh","x":"0","y":"0","height":"5","width":"3"}}}',
  13. 1|cron | mail: '***@gmail.com' } ''
  14. 1|cron | s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  15. 1|cron | s.sqlQuery QUERY DELETE FROM Logs WHERE ke='z0GfsMx6qQ' AND `time` < 'Sun Mar 03 2019 22:46:43 GMT+0200 (EET)'
  16. 1|cron | --- deleteOldLogs Complete
  17. 1|cron | s.sqlQuery QUERY SELECT * FROM Files WHERE ke='z0GfsMx6qQ' AND `time` < 'Sun Mar 03 2019 22:46:43 GMT+0200 (EET)'
  18. 1|cron | --- deleteOldFileBins Complete
  19. 1|cron | s.sqlQuery QUERY DELETE FROM Events WHERE ke='z0GfsMx6qQ' AND `time` < 'Mon Feb 11 2019 22:46:43 GMT+0200 (EET)'
  20. 1|cron | --- deleteOldEvents Complete
  21. 1|cron | Filters
  22. 1|cron | { id: 'deleteOldVideosByCron',
  23. 1|cron | name: 'deleteOldVideosByCron',
  24. 1|cron | sort_by: 'time',
  25. 1|cron | sort_by_direction: 'ASC',
  26. 1|cron | limit: '',
  27. 1|cron | enabled: '1',
  28. 1|cron | archive: '0',
  29. 1|cron | email: '0',
  30. 1|cron | delete: '1',
  31. 1|cron | execute: '',
  32. 1|cron | where: [ { p1: 'end', p2: '<=', p3: 2019-02-11T20:46:43.353Z } ] } ''
  33. 1|cron | s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND status != 0 AND details NOT LIKE '%"archived":"1"%' AND (end <= 'Mon Feb 11 2019 22:46:43 GMT+0200 (EET)') ORDER BY `time` ASC
  34. 1|cron | --- checkFilterRules Complete
  35. 1|cron | s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND status!=0 AND details NOT LIKE '%"archived":"1"%' AND time < 'Wed Mar 13 2019 22:36:43 GMT+0200 (EET)'
  36. 0|camera | FFmpeg version : 3.2.12-1~deb9u1
  37. 0|camera | Node.js version : v9.11.2
  38. 0|camera | 2019-03-13T22:46:43+02:00 s.sqlQuery QUERY CREATE TABLE IF NOT EXISTS `Presets` ( `ke` varchar(50) DEFAULT NULL, `name` text, `details` text, `type` varchar(50) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  39. 0|camera | 2019-03-13T22:46:43+02:00 s.sqlQuery QUERY CREATE TABLE IF NOT EXISTS `Schedules` (`ke` varchar(50) DEFAULT NULL,`name` text,`details` text,`start` varchar(10) DEFAULT NULL,`end` varchar(10) DEFAULT NULL,`enabled` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40. 0|camera | 2019-03-13T22:46:43+02:00 s.sqlQuery QUERY CREATE TABLE IF NOT EXISTS `Cloud Videos` (`mid` varchar(50) NOT NULL,`ke` varchar(50) DEFAULT NULL,`href` text NOT NULL,`size` float DEFAULT NULL,`time` timestamp NULL DEFAULT NULL,`end` timestamp NULL DEFAULT NULL,`status` int(1) DEFAULT '0',`details` text) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  41. 0|camera | 2019-03-13T22:46:43+02:00 s.sqlQuery QUERY CREATE TABLE IF NOT EXISTS `Files` (`ke` varchar(50) NOT NULL,`mid` varchar(50) NOT NULL,`name` tinytext NOT NULL,`size` float NOT NULL DEFAULT '0',`details` text NOT NULL,`status` int(1) NOT NULL DEFAULT '0',`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  42. 0|camera | Shinobi : Web Server Listening on 80
  43. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY ALTER TABLE `Presets` CHANGE COLUMN `type` `type` VARCHAR(50) NULL DEFAULT NULL AFTER `details`;
  44. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY ALTER TABLE `Files` ADD COLUMN `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`;
  45. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY SELECT ke,uid,auth,mail,details FROM Users WHERE ke='z0GfsMx6qQ' AND auth='cfb2fd5a81af09d1cb2facbfa2481c3e' AND uid='Q86uKI9jky'
  46. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('z0GfsMx6qQ','$USER','{"type":"Websocket Connected","msg":{"mail":"***@gmail.com","id":"Q86uKI9jky","ip":"::ffff:192.168.80.2"}}')
  47. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE ke='z0GfsMx6qQ' AND details NOT LIKE '%"sub"%'
  48. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY SELECT * FROM API WHERE ke='z0GfsMx6qQ' AND uid='Q86uKI9jky'
  49. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  50. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"CRON : ","msg":{"f":"deleteLogs","msg":"0 SQL rows older than 10 days deleted","ke":"z0GfsMx6qQ","time":"2019-03-13T20:46:43.349Z"}}')
  51. 0|camera | 2019-03-13T22:46:44+02:00 CRON : { f: 'deleteLogs',
  52. 0|camera | msg: '0 SQL rows older than 10 days deleted',
  53. 0|camera | ke: 'z0GfsMx6qQ',
  54. 0|camera | time: '2019-03-13T20:46:43.349Z' }
  55. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"CRON : ","msg":{"f":"deleteEvents","msg":"0 SQL rows older than 30 days deleted","ke":"z0GfsMx6qQ","time":"2019-03-13T20:46:43.355Z"}}')
  56. 0|camera | 2019-03-13T22:46:44+02:00 CRON : { f: 'deleteEvents',
  57. 0|camera | msg: '0 SQL rows older than 30 days deleted',
  58. 0|camera | ke: 'z0GfsMx6qQ',
  59. 0|camera | time: '2019-03-13T20:46:43.355Z' }
  60. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"CRON : ","msg":{"f":"deleteNoVideo","msg":"0 SQL rows with no file deleted","ke":"z0GfsMx6qQ","time":"2019-03-13T20:46:43.361Z"}}')
  61. 0|camera | 2019-03-13T22:46:44+02:00 CRON : { f: 'deleteNoVideo',
  62. 0|camera | msg: '0 SQL rows with no file deleted',
  63. 0|camera | ke: 'z0GfsMx6qQ',
  64. 0|camera | time: '2019-03-13T20:46:43.361Z' }
  65. 0|camera | 2019-03-13T22:46:44+02:00 s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  66. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE details NOT LIKE '%"sub"%'
  67. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"***@gmail.com : Checking Disk Used..","msg":""}')
  68. 0|camera | 2019-03-13T22:46:45+02:00 ***@gmail.com : Checking Disk Used..
  69. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND status!=
  70. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"***@gmail.com : Checking Disk Used..","msg":""}')
  71. 0|camera | 2019-03-13T22:46:45+02:00 ***@gmail.com : Checking Disk Used..
  72. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND status!=
  73. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"***@gmail.com : Completed Checking Disk Used. : 14","msg":577867067}')
  74. 0|camera | 2019-03-13T22:46:45+02:00 ***@gmail.com : Completed Checking Disk Used. : 14 577867067
  75. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE ke='z0GfsMx6qQ' AND details NOT LIKE '%"sub"%'
  76. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"***@gmail.com : Completed Checking Disk Used. : 14","msg":577867067}')
  77. 0|camera | 2019-03-13T22:46:45+02:00 ***@gmail.com : Completed Checking Disk Used. : 14 577867067
  78. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE ke='z0GfsMx6qQ' AND details NOT LIKE '%"sub"%'
  79. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM `Cloud Videos` WHERE ke='z0GfsMx6qQ' AND status!=
  80. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM `Cloud Videos` WHERE ke='z0GfsMx6qQ' AND status!=
  81. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"Starting Monitors... Please Wait...","msg":""}')
  82. 0|camera | 2019-03-13T22:46:45+02:00 Starting Monitors... Please Wait...
  83. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Monitors
  84. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND mid='sdjkfhkjsdh' AND time='2019-03-13 19:36:23' LIMIT 1
  85. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND mid='sdjkfhkjsdh' AND time='2019-03-13 22:09:16' LIMIT 1
  86. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"Orphaned Videos Found and Inserted : {\"z0GfsMx6qQ\":{\"sdjkfhkjsdh\":0}}","msg":""}')
  87. 0|camera | 2019-03-13T22:46:45+02:00 Orphaned Videos Found and Inserted : {"z0GfsMx6qQ":{"sdjkfhkjsdh":0}}
  88. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"Shinobi is ready.","msg":""}')
  89. 0|camera | 2019-03-13T22:46:45+02:00 Shinobi is ready.
  90. 0|camera | 2019-03-13T22:46:45+02:00 s.sqlQuery QUERY SELECT * FROM Schedules
  91. 1|cron | --- deleteRowsWithNoVideo Complete
  92. 1|cron | RowDataPacket {
  93. 1|cron | ke: 'z0GfsMx6qQ',
  94. 1|cron | uid: 'kNTiorebR8',
  95. 1|cron | details: '{"factorAuth":"0","size":"2000000","days":"30","event_days":"30","log_days":"","max_camera":"","permissions":"all","edit_size":"1","edit_days":"1","edit_event_days":"1","edit_log_days":"1","use_admin":"1","use_aws_s3":"1","use_whcs":"1","use_sftp":"1","use_webdav":"1","use_discordbot":"1","use_ldap":"1","aws_use_global":"0","b2_use_global":"0","webdav_use_global":"0"}',
  96. 1|cron | mail: '***@gmail.com' } ''
  97. 1|cron | s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  98. 1|cron | s.sqlQuery QUERY DELETE FROM Logs WHERE ke='z0GfsMx6qQ' AND `time` < 'Sun Mar 03 2019 22:46:46 GMT+0200 (EET)'
  99. 1|cron | --- deleteOldLogs Complete
  100. 1|cron | s.sqlQuery QUERY SELECT * FROM Files WHERE ke='z0GfsMx6qQ' AND `time` < 'Sun Mar 03 2019 22:46:46 GMT+0200 (EET)'
  101. 0|camera | 2019-03-13T22:46:46+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"CRON : ","msg":{"f":"deleteLogs","msg":"0 SQL rows older than 10 days deleted","ke":"z0GfsMx6qQ","time":"2019-03-13T20:46:46.366Z"}}')
  102. 1|cron | --- deleteOldFileBins Complete
  103. 1|cron | s.sqlQuery QUERY DELETE FROM Events WHERE ke='z0GfsMx6qQ' AND `time` < 'Mon Feb 11 2019 22:46:46 GMT+0200 (EET)'
  104. 0|camera | 2019-03-13T22:46:46+02:00 CRON : { f: 'deleteLogs',
  105. 0|camera | msg: '0 SQL rows older than 10 days deleted',
  106. 0|camera | ke: 'z0GfsMx6qQ',
  107. 0|camera | time: '2019-03-13T20:46:46.366Z' }
  108. 1|cron | --- deleteOldEvents Complete
  109. 1|cron | Filters
  110. 1|cron | { id: 'deleteOldVideosByCron',
  111. 1|cron | name: 'deleteOldVideosByCron',
  112. 1|cron | sort_by: 'time',
  113. 1|cron | sort_by_direction: 'ASC',
  114. 1|cron | limit: '',
  115. 1|cron | enabled: '1',
  116. 1|cron | archive: '0',
  117. 1|cron | email: '0',
  118. 1|cron | delete: '1',
  119. 1|cron | execute: '',
  120. 1|cron | where: [ { p1: 'end', p2: '<=', p3: 2019-02-11T20:46:46.368Z } ] } ''
  121. 1|cron | s.sqlQuery QUERY SELECT * FROM Videos WHERE ke='z0GfsMx6qQ' AND status != 0 AND details NOT LIKE '%"archived":"1"%' AND (end <= 'Mon Feb 11 2019 22:46:46 GMT+0200 (EET)') ORDER BY `time` ASC
  122. 1|cron | --- checkFilterRules Complete
  123. 1|cron | --- deleteRowsWithNoVideo Complete
  124. 0|camera | 2019-03-13T22:46:46+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('$','$SYSTEM','{"type":"CRON : ","msg":{"f":"deleteEvents","msg":"0 SQL rows older than 30 days deleted","ke":"z0GfsMx6qQ","time":"2019-03-13T20:46:46.368Z"}}')
  125. 0|camera | 2019-03-13T22:46:46+02:00 CRON : { f: 'deleteEvents',
  126. 0|camera | msg: '0 SQL rows older than 30 days deleted',
  127. 0|camera | ke: 'z0GfsMx6qQ',
  128. 0|camera | time: '2019-03-13T20:46:46.368Z' }
  129. 0|camera | 2019-03-13T22:47:10+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE mail='***@gmail.com' AND pass='850d4a0726b899fc129cbb275bcafdee0606069beb9ebd811c042a1d389be87e'
  130. 0|camera | 2019-03-13T22:47:10+02:00 s.sqlQuery QUERY UPDATE Users SET auth='171e13cbe3b72cd86e76c2d51c27ae5f' WHERE ke='z0GfsMx6qQ' AND uid='Q86uKI9jky'
  131. 0|camera | 2019-03-13T22:47:10+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('z0GfsMx6qQ','$USER','{"type":"New Authentication Token","msg":{"for":"dash","mail":"***@gmail.com","id":"Q86uKI9jky","ip":"::ffff:192.168.80.2"}}')
  132. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT ke,uid,auth,mail,details FROM Users WHERE ke='z0GfsMx6qQ' AND auth='171e13cbe3b72cd86e76c2d51c27ae5f' AND uid='Q86uKI9jky'
  133. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY INSERT INTO Logs (ke,mid,info) VALUES ('z0GfsMx6qQ','$USER','{"type":"Websocket Connected","msg":{"mail":"***@gmail.com","id":"Q86uKI9jky","ip":"::ffff:192.168.80.2"}}')
  134. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT * FROM Users WHERE ke='z0GfsMx6qQ' AND details NOT LIKE '%"sub"%'
  135. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT * FROM API WHERE ke='z0GfsMx6qQ' AND uid='Q86uKI9jky'
  136. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  137. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT * FROM Monitors WHERE ke='z0GfsMx6qQ'
  138. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT * FROM `Videos` WHERE ke='z0GfsMx6qQ' and mid='sdjkfhkjsdh' ORDER BY `time` DESC LIMIT 10
  139. 0|camera | 2019-03-13T22:47:13+02:00 s.sqlQuery QUERY SELECT COUNT(*) FROM `Videos` WHERE ke='z0GfsMx6qQ' and mid='sdjkfhkjsdh'
  140. 0|camera | 2019-03-13T22:47:23+02:00 s.sqlQuery QUERY SELECT * FROM `Videos` WHERE ke='z0GfsMx6qQ' and mid='sdjkfhkjsdh' AND `time` >= 1552423632000 AND `end` <= 1552596432000 ORDER BY `time` DESC LIMIT 0,100
  141. 0|camera | 2019-03-13T22:47:23+02:00 s.sqlQuery QUERY SELECT COUNT(*) FROM `Videos` WHERE ke='z0GfsMx6qQ' and mid='sdjkfhkjsdh' AND `time` >= 1552423632000 AND `end` <= 1552596432000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!