Speed Test

Tool retrieves performance metrics testing against preset offside servers. The tool also gatherers devices in the local network which could interfere with your test results. Last but not least the metrics are send to a predefined Google Sheet.

Feature

• Use speedtest-cli to test against servers around the world
  • Ping
  • Upload
  • Download
• Use nmap to detected other systems in your network
• Upload data to a Google Sheet
  • Authenticate using service account

Output Example

Datetime	Hosts	Ping	Upload	Bytes_sent	Download	Bytes_Recived
2018-01-14T04:00:03	5	195,063	8275863,909	10543104	37012522,13	48261155
2018-01-14T05:00:02	4	188,495	8988076,69	11419648	39828286,1	51851794
2018-01-14T06:00:03	4	191,288	8423028,37	10706944	38117436,57	48588272
2018-01-14T07:00:02	6	192,431	8140989,79	10412032	40067664,01	51025955

Run

• Clone repository
• Create a Google Cloud service account and copy credentials as JSON
• Google Spreadsheet
  • Setup sheet inside your account
  • Use service account client_email to share sheet (found in credential JSON)
  • Create one tab for each server testing against
• Configuration in speed_test_conf.json
  • Set credential path
  • Copy sheet id
  • Configure network mask
  • Use Speedtest homepage to gather server ids and enter them along with a sheet tab name as location
• Install packages needed sudo apt-get install python3-pip nmap
• Optional use virtualenv and run
  • virtualenv -p /usr/local/bin/python3 venv --no-site-packages
  • source venv/bin/activate
• Install python packages pip install -r requirements.txt
• ./speed_test.py

Automate (on Raspberry)

• Append the following lines to /boot/config.txt to disable wifi and Bluetooth

  # ---- Config
  dtoverlay=pi3-disable-wifi
  dtoverlay=pi3-disable-bt
  

• Run crontab -e and add the following entry to execute every hour

  PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/games:/usr/games
  0 * * * *  /opt/speed_test/speed_test.py 2>&1 | /usr/bin/logger -t speed_test