Since events do not cost much, the number stored and displayed
is drastically increased.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Sometimes two queries want to insert the same entry into the
router stats table, although we check for that right before the
query is made. One can suppress this by using ON DUPLICATE KEY UPDATE
to ignore the second (redundant) entry.
This is no fix, but will work until this is examined more thoroughly.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Since the gaps between alfred calls have been fixed, we can
reduce the waiting time before a router gets offline.
We now only tolerate a single missing data point, but not two
like before.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This reverts commit 3ff1117653.
Purpose: Test impact of utcnow() and router_rate_limit_list patches.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
With router_rate_limit_list, routers were not processed if the
time difference between calls was less than 5 minutes for the
same MAC address.
While this is generally not bad, there are some drawbacks:
- Not having been aware of this fact, we have established other
mechanisms to dilute data density, which might have interfered
- With KeyXchangeV2, two gateways will send data with less than
5 min. difference. As gateways are not connected, we know that
we alternately receive newer and older data. With
router_rate_limit_list, some of this data has been discarded
before its "age" was evaluated. This caused an unwanted additional
dilution of data which might have caused "offline" routers not
being actually offline (for a short period)
- With KeyXchangeV1, if the second call was a little earlier, the
a big share of the data would not be "new enough" and just be
discarded
- With KeyXchangeV1, the same would happen for the order of records
varying between alfred calls, were some records would have more and
some less than 5 minutes time difference
To get rid of these issues, we remove router_rate_limit_list and
test whether the newer measures to dilute data are effective.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Since the time is used as key in MySQL, this might help to solve key
race conditions where new_router_stats is entered at the same time.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This is a test patch to find out whether deadlocks can be
reduced by using smaller (but more) transactions.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Sometimes two queries want to insert the same entry into the
router stats table, although we check for that right before the
query is made. One can suppress this by using ON DUPLICATE KEY UPDATE
to ignore the second (redundant) entry.
This is no fix, but will work until this is examined more thoroughly.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Value set to only 7 days to reduce database size, since these
data seem to be of little relevance.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This provides lists of V2 routers to be used in DNS servers:
/api/dnslist - Plain tab-separated list to be used in custom scripts
/api/dnsentries - List of zone file entries without a header
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
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>
If we receive data from more than one gateway, there happens to
be a mix of older and newer data (since synchronization between
gateways seems to be not working).
To deal with that, we now only accept data where the router's
system time is newer than the value stored in the DB. To account
for time synchronization issues, we also accept data which is more
than one hour older.
This patch removes other checks for old data which are now obsolete.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Adds display support for BATMAN_V data.
This is step 1 of 2. It does change the background colors for
neighbors, but does NOT change the link colors in the map.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This only works for routers with updated nodewatcher.
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This only works for routers with updated nodewatcher.
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Like normal router events, the block/unblock events are deleted
if they become old enough.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Since old routers send defective gateway data, some routers got
values like "false6" for quality. This is now caught and false
removed.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Adrian Schmutzler