API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2019
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.88 KB | None | 0 0
raw download clone embed print report
  1. pi@raspberrypi:~ $ systemctl status influxdb
  2. ● influxdb.service - InfluxDB is an open-source, distributed, time series database
  3. Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
  4. Active: active (running) since Sun 2019-06-23 09:59:34 EEST; 3h 3min ago
  5. Docs: https://docs.influxdata.com/influxdb/
  6. Main PID: 482 (influxd)
  7. CGroup: /system.slice/influxdb.service
  8. └─482 /usr/bin/influxd -config /etc/influxdb/influxdb.conf
  9.  
  10. Jun 23 13:02:58 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:02:57 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22humidity%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19213 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 13ac8ee1-959e-11e9-91f3-b827ebe93ba8 275453
  11. Jun 23 13:02:58 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:02:57 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22temperature%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19951 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 13ac8ee1-959e-11e9-91f2-b827ebe93ba8 300658
  12. Jun 23 13:03:07 raspberrypi influxd[482]: ts=2019-06-23T10:03:07.902195Z lvl=info msg="Executing query" log_id=0GCmzIeW000 service=query query="SELECT mean(humidity) FROM ruuvi.autogen.ruuvi_measurements WHERE time >= now() - 3h GROUP BY time(5s), \"name\""
  13. Jun 23 13:03:07 raspberrypi influxd[482]: ts=2019-06-23T10:03:07.903821Z lvl=info msg="Executing query" log_id=0GCmzIeW000 service=query query="SELECT mean(temperature) FROM ruuvi.autogen.ruuvi_measurements WHERE time >= now() - 3h GROUP BY time(5s), \"name\""
  14. Jun 23 13:03:08 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:03:07 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22humidity%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19207 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 19a32688-959e-11e9-91f4-b827ebe93ba8 369821
  15. Jun 23 13:03:08 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:03:07 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22temperature%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19950 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 19a37509-959e-11e9-91f5-b827ebe93ba8 382828
  16. Jun 23 13:03:17 raspberrypi influxd[482]: ts=2019-06-23T10:03:17.905244Z lvl=info msg="Executing query" log_id=0GCmzIeW000 service=query query="SELECT mean(humidity) FROM ruuvi.autogen.ruuvi_measurements WHERE time >= now() - 3h GROUP BY time(5s), \"name\""
  17. Jun 23 13:03:17 raspberrypi influxd[482]: ts=2019-06-23T10:03:17.906049Z lvl=info msg="Executing query" log_id=0GCmzIeW000 service=query query="SELECT mean(temperature) FROM ruuvi.autogen.ruuvi_measurements WHERE time >= now() - 3h GROUP BY time(5s), \"name\""
  18. Jun 23 13:03:18 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:03:17 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22humidity%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19205 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 1f9978a4-959e-11e9-91f6-b827ebe93ba8 279496
  19. Jun 23 13:03:18 raspberrypi influxd[482]: [httpd] 192.168.1.212, 192.168.1.212,::1 - - [23/Jun/2019:13:03:17 +0300] "GET /query?db=ruuvi&epoch=ms&q=SELECT+mean%28%22temperature%22%29+FROM+%22ruuvi_measurements%22+WHERE+time+%3E%3D+now%28%29+-+3h+GROUP+BY+time%285s%29%2C+%22name%22+fill%28null%29 HTTP/1.1" 200 19944 "http://192.168.1.190:3000/d/CzU27mmgk/ruuvi?orgId=1&from=now-3h&to=now&refresh=10s" "Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" 1f997f67-959e-11e9-91f7-b827ebe93ba8 302678
  20. pi@raspberrypi:~ $ influx -precision rfc3339 -database ruuvi -execute "select last(temperature),mac from ruuvi_measurements"
  21. name: ruuvi_measurements
  22. time last mac
  23. ---- ---- ---
  24. 2019-06-23T09:26:49.786293626Z 18.23 DFE5676531E9
  25. pi@raspberrypi:~ $ atsar -s 12:20 -e 12:30 -p
  26.  
  27. Linux raspberrypi 4.19.42-v7+ #1219 SMP Tue May 14 21:20:58 BST 2019 armv7l 06/23/2019
  28.  
  29. 12:20:01 pagein/s pageout/s swapin/s swapout/s fork/s _page_
  30. 12:20:16 0.00 18.13 0.00 0.00 0.00
  31. 12:20:31 0.00 24.53 0.00 0.00 0.13
  32. 12:20:46 0.00 24.27 0.00 0.00 0.00
  33. 12:21:01 0.00 20.27 0.00 0.00 0.07
  34. 12:21:16 0.00 21.07 0.00 0.00 0.00
  35. 12:21:31 0.00 25.33 0.00 0.00 0.00
  36. 12:21:46 0.00 21.87 0.00 0.00 0.07
  37. 12:22:01 0.00 22.13 0.00 0.00 0.07
  38. 12:22:16 0.00 31.73 0.00 0.00 0.00
  39. 12:22:31 0.00 21.07 0.00 0.00 0.07
  40. 12:22:46 0.00 15.73 0.00 0.00 0.00
  41. 12:23:01 0.00 40.80 0.00 0.00 0.00
  42. 12:23:16 0.00 14.13 0.00 0.00 0.00
  43. 12:23:31 0.00 26.40 0.00 0.00 0.00
  44. 12:23:46 0.00 22.67 0.00 0.00 0.00
  45. 12:24:01 0.00 17.33 0.00 0.00 0.00
  46. 12:24:16 0.00 24.80 0.00 0.00 0.00
  47. 12:24:31 0.00 24.80 0.00 0.00 0.80
  48. 12:24:46 0.00 33.07 0.00 0.00 0.00
  49. 12:25:01 0.00 18.93 0.00 0.00 0.00
  50. 12:25:16 0.00 33.33 0.00 0.00 0.00
  51. 12:25:31 0.00 17.87 0.00 0.00 0.00
  52. 12:25:46 0.00 24.53 0.00 0.00 0.00
  53. 12:26:01 0.00 29.33 0.00 0.00 0.07
  54. 12:26:16 0.00 16.80 0.00 0.00 0.07
  55. 12:26:31 0.00 23.73 0.00 0.00 0.07
  56. 12:26:46 0.00 19.20 0.00 0.00 0.00
  57. 12:27:01 0.80 24.00 0.00 0.00 0.53
  58. 12:27:16 0.00 7.47 0.00 0.00 0.00
  59. 12:27:31 0.00 21.60 0.00 0.00 0.07
  60. 12:27:46 0.00 7.47 0.00 0.00 0.00
  61. 12:28:01 0.00 10.67 0.00 0.00 0.07
  62. 12:28:16 0.00 16.80 0.00 0.00 0.07
  63. 12:28:31 0.00 10.13 0.00 0.00 0.07
  64. 12:28:46 0.00 13.33 0.00 0.00 0.80
  65. 12:29:01 0.00 16.00 0.00 0.00 0.00
  66. 12:29:16 0.00 7.47 0.00 0.00 0.00
  67. 12:29:31 0.00 13.60 0.00 0.00 0.00
  68. 12:30:01 0.00 17.60 0.00 0.00 0.60
  69. 12:30:16 0.00 15.73 0.00 0.00 0.07
  70. 12:30:31 0.00 10.93 0.00 0.00 0.00
  71. 12:30:46 0.00 15.20 0.00 0.00 0.00
  72.  
  73. pi@raspberrypi:~ $
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!