Skip to content

Latest commit

 

History

History
117 lines (76 loc) · 2.65 KB

README.md

File metadata and controls

117 lines (76 loc) · 2.65 KB
Raw

World Map

qbit-peers

Forked from: https://github.com/Roadeo/qbittorrent-peers-location-grafana

A python script (along with instructions) to display the locations of all the peers your qBittorrent client is connected to in a Grafana worldmap dashboard.

Pre-requisites

The following instructions are assuming:

  • Docker is already running and configured
  • Grafana is already running and configured

Instructions

Clone the repository

git clone https://github.com/kaizensh/qbit-peers && cd qbit-peers

Download the IP2Location database

Configure the docker compose file

docker-compose.yml

  • Change /opt/qbit-peers to your desired location
  • Change the password for the MariaDB root user

Configure the python script

qbit-peers.py

  • Configure the qbittorrent server ip, port, username and password
  • Configure the MariaDB host, port, user, password and database name

Run the docker compose file

docker-compose up -d

Stop the qbit-peers container to avoid any potential issues before importing the IP2Location database

docker stop qbit-peers

Import the IP2Location database

IP2LOCATION-LITE-DB5.CSV

Enter the MariaDB container

docker exec -it qbit-peers-mariadb mariadb -uroot -p<password>
USE ip2location;
LOAD DATA LOCAL INFILE '/tmp/IP2LOCATION-LITE-DB5.CSV'
INTO TABLE ip2location_db5
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';
EXIT;

Start the qbit-peers container

docker start qbit-peers

Configure Grafana

Add the MariaDB datasource

In Grafana, go to Connections > Data Sources > Add new source > MySQL

  • Name: qbit-peers-mariadb
  • Host: qbit-peers-mariadb
  • Database: ip2location
  • User: root
  • Password: <password>

Save & Test

Add the Worldmap Panel

Install the Worldmap Panel plugin: https://grafana.com/grafana/plugins/grafana-worldmap-panel/

Create a new Dashboard

  • Add a new Panel
  • Change Visualization to Worldmap Panel
  • Change the Datasource to qbit-peers-mariadb
  • Change the Format to Table
  • Change the Dataset to ip2location
  • Change the Table to peer_list
  • Change the Column value to geohash

Configure the Worldmap Panel

  • Change the Min circle size to 1 (or your desired size)
  • Change the Max circle size to 1 (or your desired size)
  • Change the Location data to geohash
  • Change the Field mapping to geohash