Adrian Schmutzler
f26f01f73c
statistics.html/gws.html: Show gwinfo version of gateways
...
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2019-05-11 23:49:14 +02:00
Adrian Schmutzler
0bdb90d020
gwinfo: Actually use rewritten stats_page variable
...
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2019-05-11 23:49:09 +02:00
Adrian Schmutzler
7e34a20451
gwinfo: Delete IP addresses for old netif entries
...
This ensures that only the latest addresses are shown on the
gateway overview page.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-11-23 13:14:51 +01:00
Adrian Schmutzler
bc3460f2e0
Global: Change MAC address storage to use BIGINT
...
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-11-23 13:14:41 +01:00
Adrian Schmutzler
478c0fb8dd
gwinfo: Support internal IPv4/IPv6 and DHCP ranges (v1.4)
...
This updates gwinfo script AND evaluation code.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-11-22 18:37:30 +01:00
Adrian Schmutzler
c8178beedd
gwinfo and scripts/deletestats: Delete old netif data
...
Netif information is deleted 48 hours after the MAC addresses
have changed.
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-04-16 12:42:35 +02:00
Adrian Schmutzler
0b04098629
api/gwinfo: Switch from ON DUPLICATE KEY UPDATE to if/else
...
This prevents excessive use of AUTO_INCREMENT
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-02-02 13:01:28 +01:00
Adrian Schmutzler
662bec1a16
Change GWinfo to store vpnmac instead of vpnif
...
This is required to uniquely find the relation between VPN and
bat after change of MAC adresses.
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-02-02 01:09:49 +01:00
Adrian Schmutzler
0dea6339e2
api/gwinfo: Stop filtering br-* interfaces
...
Keep br-* interfaces, throw away l2tp.
Seems like batctl gwl only shows br-* or fff*, but never l2tp*.
Seems to be required to support V1 gateways with L2TP.
The main impact on table size is done by l2tp*.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-02-02 01:04:49 +01:00
Adrian Schmutzler
823858d981
scripts: Add deleteunlinked.py
...
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-01-15 12:30:09 +01:00
Adrian Schmutzler
669895cd7b
router.html/statistics.html: Display gateway/batX where available
...
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-01-15 12:30:08 +01:00
Adrian Schmutzler
898c06d8c6
Introduce infrastructure to receive and process gateway information
...
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2018-01-15 12:30:08 +01:00