Data Logger with Filter and Alert Scripts

[Tom10]

i've made two short scripts to log dump1090-mutability data to a mysql database and/or sent daily excel email-reports. vou can filter by latitude, longitude, altitude, transponder-code or flight-number what data is written to database and/or triggers alert-email or alert pushover message ...

you find the scripts on github TomMuc1 - Dump1090-MySQL-Alert-Filter Dump1090-Daily-Aircraft-Report

[Tom10]

Dump1090-Daily-Aircraft-Report

Aggregates Dump1090 messages to a daily report then emails and/or writes log-file and/or writes to MySql database

[Tom10]

Dump1090-MySQL-Alert-Filter

Writes Dump1090-mutability data to MySql database and e-mail/pushover alerts on special events. you can set how often the script writes to database and looks for alert condition. you can specify the area (lat/lon/alt) to be observed and filter for special hex and/or flight numbers. You can globally switch to wildcard-search and then use % as wildcard for missing characters in hex- or flight-text-file. in addition you can set hex/flight filter to operate only within lat/lon/alt limit or within whole range of site

[Tom10]

here is finally post #4 - as i had to make three posts before posting links ... but it still says 'Sorry Tom10, you are not allowed to post links in the forums. You must have a minimum of 4 posts in order to post links. You currently have 4 posts.' great! obviously it was too hard to count up to three for those who wote the forum code ...

[abcd567]

Github links:

https://github.com/TomMuc1/Dump1090-Daily-Aircraft-Report

https://github.com/TomMuc1/Dump1090-MySQL-Alert-Filter

.

[wiedehopf]

Well those need a change to work with newer dump1090-fa and readsb ... , you can use my versions which have a very simple change:

https://github.com/wiedehopf/Dump1090-Daily-Aircraft-Report

https://github.com/wiedehopf/Dump1090-MySQL-Alert-Filter

The URL when using readsb can just be changed from http://127.0.0.1/dump1090/data/ to http://127.0.0.1/tar1090/data/
Or to http://127.0.0.1/skyaware/data/ when using dump1090-fa.

[abcd567]

Well those need a change to work with newer dump1090-fa and readsb ... , you can use my versions which have a very simple change:

https://github.com/wiedehopf/Dump1090-Daily-Aircraft-Report

https://github.com/wiedehopf/Dump1090-MySQL-Alert-Filter

The URL when using readsb can just be changed from http://127.0.0.1/dump1090/data/ to http://127.0.0.1/tar1090/data/
Or to http://127.0.0.1/skyaware/data/ when using dump1090-fa.

True, you are right about using these for dump1090-fa and readsb.

However for use with Pi24 image (which uses dump1090-mutability) and with fr24feed supplied dump1090-mutability, no change will be required..

These scripts were written by TomMuc in 2017 for the dump1090-mutability ver 1.15~dev, which was state-of-the-art at that time. Since Flightradar24 is still using dump1090-mutability ver 1.15~dev, these scripts are still suitable for Pi24 image, and fr24feed installs with setting receiver=dvbt.