By default, position popup is off again until you select the layer:
With the layer enabled, behavior is as before.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
The data for each netif is only loaded when the respective row
is clicked.
Correspondingly, br-mesh is loaded initially.
So far, it is unclear how big the impact of the netif filter in
MySQL transactions is, as those have no key of their own.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
With this patch, only the neighbor stats for the last day are
loaded by default. If you want more, a hyperlink is implemented
for this purpose.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
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>
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 patch uses smaller (but more) transactions to delete router
data. This makes lock more specific and thus prevents deadlocks
quite effectively.
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>
Increases visibility of links.
Same color change has already been performed earlier for the
neighbors in router.html.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This patch uses the absolute value for plotting and removes the
graph maximum. A dynamic upper margin is introduced to prevent
overlap of data and legend.
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>
This affects only whether the status indication is SHOWN. It does
not affect the storage of this tag.
One can still en- or disable the blocked status of a V2 router via
the options menu.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
If a router sends his hood, it is considered to be V2.
V2 hoods are highlighted on the statistics page.
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>
Adrian Schmutzler