Menu
What's new
By:
Filters Better Search

uiDivStats uiDivStats - WebUI for Diversion statistics

  • SNBForums Code of Conduct

    SNBForums is a community for everyone, no matter what their level of experience.

    Please be tolerant and patient of others, especially newcomers. We are all here to share and learn!

    The rules are simple: Be patient, be nice, be helpful or be gone!

tomsk said:
Hi Jack,
Updated to V2 and rebooted to make the tab show in LAN but to no avail. I went back into amtm and selected the j5 option. i got some Entware install and config activity but something is hanging and i'm not being returned to the menu
Code: 
Enter option  j5
Downloading http://bin.entware.net/armv7sf-k2.6/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Package grep (3.4-1) installed in root is up to date.
Package sqlite3-cli (3310100-1) installed in root is up to date.
Installing procps-ng-pkill (3.3.15-4) to root...
Downloading http://bin.entware.net/armv7sf-k2.6/procps-ng-pkill_3.3.15-4_armv7-2.6.ipk
Installing procps-ng (3.3.15-4) to root...
Downloading http://bin.entware.net/armv7sf-k2.6/procps-ng_3.3.15-4_armv7-2.6.ipk
Configuring procps-ng.
Configuring procps-ng-pkill.
uiDivStats: New version of taildns.tar.gz downloaded
Click to expand...
were you running v1 previously or did you hop on the beta train?
what do you see for
Code: 
ls -la /jffs/addons/uiDivStats.d
 
Dan Ljungberg said:
The update via amtm seemed to go well, but the web GUI shows no stats.
When updating in the uiDivStats> 1, the stats are regenerated with:
Code: 
awk: cmd. line:1: Division by zero
uiDivStats: Stats updated successfully

Any suggestions?
Click to expand...
do you still see this now? i'd expect this to happen if there are no queries logged whatsoever (which i will patch, but you shouldn't see it after things have been running for a few seconds, assuming you have active network clients)
 
Jack Yaz said:
were you running v1 previously or did you hop on the beta train?
what do you see for
Code: 
ls -la /jffs/addons/uiDivStats.d
Click to expand...
Hello
Some problem of tomsk ..
With your command I see:

ASUSWRT-Merlin RT-AC86U 384.18_alpha1-g5f6b535e1a Fri May 29 04:00:52 UTC 2020
admin@RT-AC86U-81D8:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx 3 admin root 0 Jun 6 11:00 .
drwxr-xr-x 11 admin root 0 Jun 2 10:13 ..
-rw-rw-rw- 1 admin root 0 Jun 6 10:39 .upgraded
-rw-rw-rw- 1 admin root 0 Jun 6 10:39 .upgraded2
-rw-rw-rw- 1 admin root 728 Jun 6 11:00 SQLData.js
-rw-rw-rw- 1 admin root 24 Jun 6 10:00 psstats.htm
drwxrwxrwx 2 admin root 0 Jun 6 10:39 taildns.d
-rw-rw-rw- 1 admin root 33 Jun 6 10:39 taildns.tar.gz.md5
-rw-rw-rw- 1 admin root 8334 Jun 6 10:00 uidivstats.js
-rw-rw-rw- 1 admin root 11598 Jun 6 10:00 uidivstats.txt
-rw-rw-rw- 1 admin root 28934 Jun 6 10:30 uidivstats_www.asp
-rw-rw-rw- 1 admin root 535 Jun 6 10:00 uidivstatsclients.js
-rw-rw-rw- 1 admin root 814 Jun 6 10:00 uidivstatstext.js
admin@RT-AC86U-81D8:/tmp/home/root#
 
Jack Yaz said:
were you running v1 previously or did you hop on the beta train?
what do you see for
Code: 
ls -la /jffs/addons/uiDivStats.d
Click to expand...
I was previously running V1.... not brave enough to dabble in the beta for that one
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx    3 tOmsK root             0 Jun  6 13:30 .
drwxrwxrwx   10 tOmsK root             0 Jun  6 13:27 ..
-rw-rw-rw-    1 tOmsK root            28 Jun  6 13:30 SQLData.js
-rw-rw-rw-    1 tOmsK root          5060 May 18 17:00 psstats.htm
drwxrwxrwx    2 tOmsK root             0 Jun  6 13:30 taildns.d
-rw-rw-rw-    1 tOmsK root            33 Jun  6 13:30 taildns.tar.gz.md5
-rw-rw-rw-    1 tOmsK root         14169 Jun 23  2019 uiDivStats_cache.tar.gz
-rw-rw-rw-    1 tOmsK root          6249 May 18 17:00 uidivstats.js
-rw-rw-rw-    1 tOmsK root          8715 May 18 17:00 uidivstats.txt
-rw-rw-rw-    1 tOmsK root         28934 Jun  6 13:20 uidivstats_www.asp
-rw-rw-rw-    1 tOmsK root           591 May 18 17:00 uidivstatsclients.js
-rw-rw-rw-    1 tOmsK root           814 May 18 17:00 uidivstatstext.js
if i try the j5 option now i just get
Code: 
 Enter option  j5
Downloading http://bin.entware.net/armv7sf-k2.6/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Package grep (3.4-1) installed in root is up to date.
Package sqlite3-cli (3310100-1) installed in root is up to date.
Package procps-ng-pkill (3.3.15-4) installed in root is up to date.
 
StefanoN said:
Hello
Some problem of tomsk ..
With your command I see:

ASUSWRT-Merlin RT-AC86U 384.18_alpha1-g5f6b535e1a Fri May 29 04:00:52 UTC 2020
admin@RT-AC86U-81D8:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx 3 admin root 0 Jun 6 11:00 .
drwxr-xr-x 11 admin root 0 Jun 2 10:13 ..
-rw-rw-rw- 1 admin root 0 Jun 6 10:39 .upgraded
-rw-rw-rw- 1 admin root 0 Jun 6 10:39 .upgraded2
-rw-rw-rw- 1 admin root 728 Jun 6 11:00 SQLData.js
-rw-rw-rw- 1 admin root 24 Jun 6 10:00 psstats.htm
drwxrwxrwx 2 admin root 0 Jun 6 10:39 taildns.d
-rw-rw-rw- 1 admin root 33 Jun 6 10:39 taildns.tar.gz.md5
-rw-rw-rw- 1 admin root 8334 Jun 6 10:00 uidivstats.js
-rw-rw-rw- 1 admin root 11598 Jun 6 10:00 uidivstats.txt
-rw-rw-rw- 1 admin root 28934 Jun 6 10:30 uidivstats_www.asp
-rw-rw-rw- 1 admin root 535 Jun 6 10:00 uidivstatsclients.js
-rw-rw-rw- 1 admin root 814 Jun 6 10:00 uidivstatstext.js
admin@RT-AC86U-81D8:/tmp/home/root#
Click to expand...
OK so yours has completed the upgrade, so should load after finishing the stat generation (which with an empty db should take no time at all). If you Ctrl-C and re-launch, what happens?
 
tomsk said:
I was previously running V1.... not brave enough to dabble in the beta for that one
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx    3 tOmsK root             0 Jun  6 13:30 .
drwxrwxrwx   10 tOmsK root             0 Jun  6 13:27 ..
-rw-rw-rw-    1 tOmsK root            28 Jun  6 13:30 SQLData.js
-rw-rw-rw-    1 tOmsK root          5060 May 18 17:00 psstats.htm
drwxrwxrwx    2 tOmsK root             0 Jun  6 13:30 taildns.d
-rw-rw-rw-    1 tOmsK root            33 Jun  6 13:30 taildns.tar.gz.md5
-rw-rw-rw-    1 tOmsK root         14169 Jun 23  2019 uiDivStats_cache.tar.gz
-rw-rw-rw-    1 tOmsK root          6249 May 18 17:00 uidivstats.js
-rw-rw-rw-    1 tOmsK root          8715 May 18 17:00 uidivstats.txt
-rw-rw-rw-    1 tOmsK root         28934 Jun  6 13:20 uidivstats_www.asp
-rw-rw-rw-    1 tOmsK root           591 May 18 17:00 uidivstatsclients.js
-rw-rw-rw-    1 tOmsK root           814 May 18 17:00 uidivstatstext.js
if i try the j5 option now i just get
Code: 
 Enter option  j5
Downloading http://bin.entware.net/armv7sf-k2.6/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Package grep (3.4-1) installed in root is up to date.
Package sqlite3-cli (3310100-1) installed in root is up to date.
Package procps-ng-pkill (3.3.15-4) installed in root is up to date.
Click to expand...
It seems like your database hasn't been through the upgrade/creation yet. Can you run the below?
Code: 
sqlite3 /opt/share/uiDivStats.d/dnsqueries.db
.tables
.index
.exit
 
Jack Yaz said:
OK so yours has completed the upgrade, so should load after finishing the stat generation (which with an empty db should take no time at all). If you Ctrl-C and re-launch, what happens?
Click to expand...
With ctrl-C I cannot stop the process. I had to get out of the shell.
After the start generation (point 2 of the menu) seem all ok.

Thanks
 
Jack Yaz said:
It seems like your database hasn't been through the upgrade/creation yet. Can you run the below?
Code: 
sqlite3 /opt/share/uiDivStats.d/dnsqueries.db
.tables
.index
.exit
Click to expand...
Ok Done
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx    3 tOmsK root             0 Jun  6 13:30 .
drwxrwxrwx   10 tOmsK root             0 Jun  6 13:27 ..
-rw-rw-rw-    1 tOmsK root            28 Jun  6 13:30 SQLData.js
-rw-rw-rw-    1 tOmsK root          5060 May 18 17:00 psstats.htm
drwxrwxrwx    2 tOmsK root             0 Jun  6 13:30 taildns.d
-rw-rw-rw-    1 tOmsK root            33 Jun  6 13:30 taildns.tar.gz.md5
-rw-rw-rw-    1 tOmsK root         14169 Jun 23  2019 uiDivStats_cache.tar.gz
-rw-rw-rw-    1 tOmsK root          6249 May 18 17:00 uidivstats.js
-rw-rw-rw-    1 tOmsK root          8715 May 18 17:00 uidivstats.txt
-rw-rw-rw-    1 tOmsK root         28934 Jun  6 13:20 uidivstats_www.asp
-rw-rw-rw-    1 tOmsK root           591 May 18 17:00 uidivstatsclients.js
-rw-rw-rw-    1 tOmsK root           814 May 18 17:00 uidivstatstext.js
 
tomsk said:
Ok Done
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# ls -la /jffs/addons/uiDivStats.d
drwxrwxrwx    3 tOmsK root             0 Jun  6 13:30 .
drwxrwxrwx   10 tOmsK root             0 Jun  6 13:27 ..
-rw-rw-rw-    1 tOmsK root            28 Jun  6 13:30 SQLData.js
-rw-rw-rw-    1 tOmsK root          5060 May 18 17:00 psstats.htm
drwxrwxrwx    2 tOmsK root             0 Jun  6 13:30 taildns.d
-rw-rw-rw-    1 tOmsK root            33 Jun  6 13:30 taildns.tar.gz.md5
-rw-rw-rw-    1 tOmsK root         14169 Jun 23  2019 uiDivStats_cache.tar.gz
-rw-rw-rw-    1 tOmsK root          6249 May 18 17:00 uidivstats.js
-rw-rw-rw-    1 tOmsK root          8715 May 18 17:00 uidivstats.txt
-rw-rw-rw-    1 tOmsK root         28934 Jun  6 13:20 uidivstats_www.asp
-rw-rw-rw-    1 tOmsK root           591 May 18 17:00 uidivstatsclients.js
-rw-rw-rw-    1 tOmsK root           814 May 18 17:00 uidivstatstext.js
Click to expand...
What did the . commands show please?
 
Jack Yaz said:
What did the . commands show please?
Click to expand...
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# sqlite3 /opt/share/uiDivStats.d/dnsqueries.db
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> .tables
dnsqueries         dnsqueriesdaily    dnsqueriesmonthly  dnsqueriesweekly
sqlite> .index
idx_dns_clients  idx_dns_domains  idx_dns_time   
sqlite> .exit
tOmsK@RT-AC68U-4690:/tmp/home/root#
 
tomsk said:
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# sqlite3 /opt/share/uiDivStats.d/dnsqueries.db
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> .tables
dnsqueries         dnsqueriesdaily    dnsqueriesmonthly  dnsqueriesweekly
sqlite> .index
idx_dns_clients  idx_dns_domains  idx_dns_time  
sqlite> .exit
tOmsK@RT-AC68U-4690:/tmp/home/root#
Click to expand...
Weird...it looks like a stat update started since the views exist as does the indexes.
Try running
Code: 
touch /jffs/addons/uiDivStats.d/.upgraded
touch /jffs/addons/uiDivStats.d/.upgraded2

Then option 2 again. If no dice, try a reboot and then option 2 please
 
Jack Yaz said:
Weird...it looks like a stat update started since the views exist as does the indexes.
Try running
Code: 
touch /jffs/addons/uiDivStats.d/.upgraded
touch /jffs/addons/uiDivStats.d/.upgraded2

Then option 2 again. If no dice, try a reboot and then option 2 please
Click to expand...
After creating the files i was able to enter the menu again instead of going straight to the entware process.

On entering option 2 i got
Code: 
Choose an option:    2

uiDivStats: Stale lock file found (>600 seconds old) - purging lock

awk: cmd. line:1: Division by zero
awk: cmd. line:1: Division by zero
awk: cmd. line:1: Division by zero
uiDivStats: Stats updated successfully

Still no Tab so i rebooted...... selected option 2 now and some churning going on somewhere i guess... will give it a few minutes and see if it recovers
 
tomsk said:
After creating the files i was able to enter the menu again instead of going straight to the entware process.

On entering option 2 i got
Code: 
Choose an option:    2

uiDivStats: Stale lock file found (>600 seconds old) - purging lock

awk: cmd. line:1: Division by zero
awk: cmd. line:1: Division by zero
awk: cmd. line:1: Division by zero
uiDivStats: Stats updated successfully

Still no Tab so i rebooted...... selected option 2 now and some churning going on somewhere i guess... will give it a few minutes and see if it recovers
Click to expand...
I assume you do have dnsmasq enabled? I recall seeing you active in the unbound thread a lot
 
Jack Yaz said:
I assume you do have dnsmasq enabled? I recall seeing you active in the unbound thread a lot
Click to expand...
Yes i made sure dnsmasq is primary DNS before i started the upgrade .. i can't see any unbound manager code that would potentially interfere.. but its hard to tell when you're not entirely sure what you are looking for :oops:
 
tomsk said:
Yes i made sure dnsmasq is primary DNS before i started the upgrade .. i can't see any unbound manager code that would potentially interfere.. but its hard to tell when you're not entirely sure what you are looking for :oops:
Click to expand...
Can you check taildns is running?
Code: 
/opt/etc/init.d/S90taildns check
ps | grep taildns
 
Jack Yaz said:
Can you check taildns is running?
Code: 
/opt/etc/init.d/S90taildns check
ps | grep taildns
Click to expand...
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# /opt/etc/init.d/S90taildns check
 Checking taildns...              alive.
tOmsK@RT-AC68U-4690:/tmp/home/root# ps | grep taildns
 3349 tOmsK  1420 S    {taildns} /bin/sh /opt/bin/taildns
 3357 tOmsK  1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
 3370 tOmsK  1456 S    {dnsmasqtotal.aw} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotal.awk
 3371 tOmsK  1424 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
20234 tOmsK  4656 D    grep taildns

The uiDivStats tab has appeared! (as has the Diversion tab which went missing during the t/shoot)
Everything seems to be hackling now.
What do you think went wrong during the update?
 
tomsk said:
Code: 
tOmsK@RT-AC68U-4690:/tmp/home/root# /opt/etc/init.d/S90taildns check
 Checking taildns...              alive.
tOmsK@RT-AC68U-4690:/tmp/home/root# ps | grep taildns
 3349 tOmsK  1420 S    {taildns} /bin/sh /opt/bin/taildns
 3357 tOmsK  1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
 3370 tOmsK  1456 S    {dnsmasqtotal.aw} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotal.awk
 3371 tOmsK  1424 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
20234 tOmsK  4656 D    grep taildns

The uiDivStats tab has appeared! (as has the Diversion tab which went missing during the t/shoot)
Everything seems to be hackling now.
What do you think went wrong during the update?
Click to expand...
No idea - maybe rebooting too soon after updating?
 
Jack Yaz said:
No idea - maybe rebooting too soon after updating?
Click to expand...
It shall remain a mystery then... anyway thanks for your help ... and great work....now to update the YazFi;)
 
I have the same problem that tomsk had. I've seen the same things and just rebooted the node. Currently; it stucks here.

Code: 
admin@FaTiii:/tmp/home/root# uiDivStats
Downloading http://bin.entware.net/armv7sf-k2.6/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Package grep (3.4-1) installed in root is up to date.
Package sqlite3-cli (3310100-1) installed in root is up to date.
Package procps-ng-pkill (3.3.15-4) installed in root is up to date.
There is uiDivStats tab but it has no info.

Additionally I've removed procps-ng-pkill manually and tried again. it seems it's stucked when configuring procps-ng-pkill.

Code: 
admin@FaTiii:/tmp/home/root# uiDivStats
Downloading http://bin.entware.net/armv7sf-k2.6/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Package grep (3.4-1) installed in root is up to date.
Package sqlite3-cli (3310100-1) installed in root is up to date.
Installing procps-ng-pkill (3.3.15-4) to root...
Downloading http://bin.entware.net/armv7sf-k2.6/procps-ng-pkill_3.3.15-4_armv7-2.6.ipk
Configuring procps-ng-pkill.
 
Last edited:
You must log in or register to reply here.

Similar threads

314eter
uiDivStats uiDivStats development version compatible with Diversion 5.0
2 3 4
Replies
66
Views
10K
martinr
M
Jack Yaz
uiDivStats uiDivStats 3.x
2 3 4
Replies
64
Views
17K
SomeWhereOverTheRainBow
SomeWhereOverTheRainBow
Viktor Jaep
BACKUPMON BACKUPMON v1.8.22 -Nov 28, 2024- Backup/Restore your Router: JFFS + NVRAM + External USB Drive! CIFS/SMB/NFS! (Now available in AMTM!)
2
Replies
22
Views
831
Viktor Jaep
Viktor Jaep
Jack Yaz
YazFi YazFi v4.x - continued
6 7 8
Replies
147
Views
25K
fotingo
F
Jack Yaz
uiDivStats - WebUI for Diversion statistics
Replies
3
Views
3K
Jack Yaz
Jack Yaz
Similar threads
Thread starter Title Forum Replies Date
thelonelycoder uiDivStats uiDivstats 4.0.5 - WebUI Stats for Diversion, December 15, 2024 Asuswrt-Merlin AddOns 72
C uiDivStats Web browsing completely impacted nightly apparently by uiDivStats record trimming? Asuswrt-Merlin AddOns 5
Ripshod uiDivStats Updated Asuswrt-Merlin AddOns 12
314eter uiDivStats uiDivStats development version compatible with Diversion 5.0 Asuswrt-Merlin AddOns 66
RMerlin Incoming webui changes in 3006 Asuswrt-Merlin AddOns 3
A Addon tabs not propagating correctly in WebUI of GT-BE98_Pro on F/W v3006.102.1 Asuswrt-Merlin AddOns 2
kernol Diversion AC Merlinware 386.14 introduces screen scrolling problem on MANY [but not all] webui add-ons! Asuswrt-Merlin AddOns 36
HUNited vnStat WebUI page not found vnStat & connmon Asuswrt-Merlin AddOns 3
Zakalwe Diversion(?) blocking 4OD (well I mean it detects the adblocker and won't work) Asuswrt-Merlin AddOns 3
M Diversion Diversion failed to update. Check the Diversion-web-update.log with sf in the SSH UI. Asuswrt-Merlin AddOns 4

Similar threads

Latest threads

Support SNBForums w/ Amazon

If you'd like to support SNBForums, just use this link and buy anything on Amazon. Thanks!

Sign Up For SNBForums Daily Digest

Get an update of what's new every day delivered to your mailbox. Sign up here!

Members online

Total: 683 (members: 14, guests: 669)
Top