#docker run -d -p 8086:8086 234234234<\/p>\n\n\n\n #docker ps -a | grep 23423423 #netstat -ntap | grep 8086 login into docker and execute some of command in influxdb <\/p>\n\n\n\n # docker exec -it 234234234 \/usr\/bin\/influx -precision rfc3339<\/p>\n\n\n\n Connected to http:\/\/localhost:8086 version 1.7.8 # mkdir -p \/opt\/mtr-exporter-influx<\/p>\n\n\n\n # vi \/opt\/mtr-exporter-influx\/mtr-exporter.sh<\/p>\n\n\n\n Put the script below & save<\/p>\n\n\n\n # chmod +x \/opt\/mtr-exporter-influx\/mtr_exporter.sh<\/p>\n\n\n\n Create List of IP Destination that you will monitor. For example 1.1.1.1 and 8.8.8.8<\/p>\n\n\n\n # vi \/opt\/mtr-exporter-influx\/list-ip-dest<\/p>\n\n\n\n The following format file after file created<\/p>\n\n\n\n # cat \/opt\/mtr-exporter-influx\/list-ip-dest Create a python script for export data mtr into Influxdb, for example the name of file save_data.py and put these script into your have you created<\/p>\n\n\n\n Assuming we have 3 files that have been created<\/p>\n\n\n\n #ls -l Create a linux service mtr-exporter, the example service name is mtr-exporter, create a file mtr-exporter.service<\/strong> in folder \/lib\/systemd\/system<\/strong><\/p>\n\n\n\n [Unit] systemctl daemon-reload<\/p>\n\n\n\n systemctl start mtr-exporter.service<\/p>\n\n\n\n
in this case above, image id docker is 234234234<\/strong>. Run container & make sure the container already up & have exposed to external<\/p>\n\n\n\n
842501af3012 234234234<\/strong> “\/entrypoint.sh infl\u2026” 20 hours ago Up 20 hours 0.0.0.0:8086->8086\/tcp<\/p>\n\n\n\n
tcp6 0 0 :::8086 :::* LISTEN 27816\/docker-proxy<\/p>\n\n\n\n
InfluxDB shell version: 1.7.8
>CREATE DATABASE mtr
>USE mtr
>CREATE USER mtruser with PASSWORD ‘123456’ WITH ALL PRIVILEGES
>GRANT ALL ON mtr TO mtruser<\/p>\n\n\n\n
Create a bash script for collect data mtr, for example the name of file is mtr-exporter.sh<\/strong> in folder \/opt\/mtr-exporter-influx <\/strong>and put these script into those file have you created. in this scenario all files will put in folder \/opt\/mtr-exporter-influx.<\/strong><\/p>\n\n\n\n#!\/bin\/bash\n\nINTERVAL=60\nINFLUXDB_HOST=\"192.168.38.60\"\nINFLUXDB_PORT=8086\n\nfunction monitor_mtr() {\n for MTR_HOST in $(cat \/opt\/mtr-exporter-influx\/list-ip-dest); do\n ( mtr --report --tcp --port=443 --json --report-cycles $CYCLES $MTR_HOST | \/usr\/bin\/python3 \/opt\/mtr-exporter-influx\/save_data.py --host $INFLUXDB_HOST --port $INFLUXDB_PORT ) &\n done\n}\n\nwhich mtr &>\/dev\/null\nif [ $? -eq 1 ]; then\n echo \"mtr not found, please install mtr \"\n exit 1\nelse\necho \"collecting data...\"\nfi \nwhile true; do\n monitor_mtr\n sleep $INTERVAL\ndone<\/pre>\n\n\n\n
1.1.1.1
8.8.8.8
#<\/p>\n\n\n\n#!\/usr\/bin\/env python3\nimport argparse\nimport json\nimport sys\nimport datetime as dt\nimport logging\n\nfrom influxdb import InfluxDBClient, SeriesHelper\n\nlogging.basicConfig(level=logging.INFO)\ndb_name = 'mtr'\nuser = 'mtruser'\npassword = '123456'\n\nclass HubEntry(SeriesHelper):\n class Meta:\n series_name = '{destination}'\n fields = ['time', 'loss', 'snt', 'last', 'avg', 'best', 'wrst', 'stdev']\n tags = ['destination', 'hop']\n \ndef get_cmd_arguments():\n parser = argparse.ArgumentParser(description='JSON parser')\n parser.add_argument('--host', default='192.168.38.60', help='influxdb host')\n parser.add_argument('--port', default=8086, help='influxdb port')\nreturn parser.parse_args()\n\nmtr_result = json.load(sys.stdin)\n# ping destination\ndestination = mtr_result['report']['mtr']['dst']\nreport_time = dt.datetime.utcnow()\nfor hub in mtr_result['report']['hubs']:\n # persist the hub entry\n # Modifying the data if needed so that is can be easily sorted in the event of more than 9 hops.\n if len(hub['count']) < 2:\n hop = \"0\" + hub['count'] + \"-\" + hub['host']\n else:\n hop = hub['count'] + \"-\" + hub['host']\n HubEntry(\n time=report_time,\n destination=destination,\n hop=hop,\n loss=hub['Loss%'],\n snt=hub['Snt'],\n last=hub['Last'],\n avg=hub['Avg'],\n best=hub['Best'],\n wrst=hub['Wrst'],\n stdev=hub['StDev']\n )\nHubEntry.commit()\n\nif name == 'main':\n main()<\/pre>\n\n\n\n
mtr-exporter.sh
save_data.py
list-ip-dest<\/p>\n\n\n\n
Description=mtr exporter
After=multi-user.target
[Service]
Type=idle
ExecStart=\/bin\/bash \/opt\/mtr-exporter-influx\/mtr-export.sh
[Install]
WantedBy=multi-user.target<\/p>\n\n\n\n
Add datasource in Grafana<\/p>\n\n\n\n![\"\"](\"https:\/\/geeksops.com\/wp-content\/uploads\/2019\/09\/image-12.png\")
<\/figure>\n\n\n\n
![\"\"](\"https:\/\/geeksops.com\/wp-content\/uploads\/2019\/09\/image-13-1024x551.png\")
![\"\"](\"https:\/\/geeksops.com\/wp-content\/uploads\/2019\/09\/image-15.png\")
![\"\"](\"https:\/\/geeksops.com\/wp-content\/uploads\/2019\/09\/image-16.png\")
<\/figure>\n\n\n\n