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!

I’m loving all this. Works like a charm. Thank you.

If I may pass one comment? In the GUI I find the there needs to be more room to display the blocked domain text. It is overwriting other text.
49079EDC-3446-4052-A1EE-A110907A4B3B.png
 
pattiri said:
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.
Click to expand...
You say node...is this a router or AP?

After installing procps-ng-pkill the next stage is to download the taildns tar:
Code: 
Update_File "taildns.tar.gz"

I've just pushed a hotfix that adds extra verbosity to the upgrade process, so we can see where things are getting stuck. Running the below at the command line should work and get the updated version without getting stuck:
Code: 
uiDivStats update
 
Last edited:
JemTheWire said:
I’m loving all this. Works like a charm. Thank you.

If I may pass one comment? In the GUI I find the there needs to be more room to display the blocked domain text. It is overwriting other text.
View attachment 23934
Click to expand...
I'm not sure chartJS has an option to set a width for labels but I will take a look. I may remove the "Domain" label since its fairly obvious what the axis shows!
 
Jack Yaz said:
uiDivStats update
Click to expand...

after this all seems fine, waiting for database to be created. I meant router with node :) thanks :)

Code: 
admin@FaTiii:/tmp/home/root# uiDivStats update
uiDivStats: Stale lock file found (>600 seconds old) - purging lock

uiDivStats: MD5 hash of uiDivStats does not match - downloading updated v2.0.0

uiDivStats: uiDivStats successfully updated

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.
uiDivStats: Creating database table and enabling write-ahead logging...

uiDivStats: Creating database table indexes...
 
Jack Yaz said:
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)
Click to expand...
Still no stats :confused:
have 20+ active clients and before update there were a lot of stats.
Any ideas?
 
pattiri said:
after this all seems fine, waiting for database to be created. I meant router with node :) thanks :)

Code: 
admin@FaTiii:/tmp/home/root# uiDivStats update
uiDivStats: Stale lock file found (>600 seconds old) - purging lock

uiDivStats: MD5 hash of uiDivStats does not match - downloading updated v2.0.0

uiDivStats: uiDivStats successfully updated

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.
uiDivStats: Creating database table and enabling write-ahead logging...

uiDivStats: Creating database table indexes...
Click to expand...
The index creation should be near-instant on a new db. It may be easier to
Code: 
uiDivStats uninstall
rm /opt/share/uiDivStats.d/dnsqueries.db
and start a fresh install
 
Jack Yaz said:
Firstly check taildns is running
Code: 
/opt/etc/init.d/S90taildns check
ps | grep taildns
Check files exist correctly:
Code: 
ls -laR /jffs/addons/uiDivStats.d
ls -laR /opt/share/uiDivStats.d
Click to expand...

check taildns is running
Code: 
 Checking taildns...              alive.
dana@RT-AC2900-72D8:/tmp/home/root# ps | grep taildns
 2322 dana      3368 S    {taildns} /bin/sh /opt/bin/taildns
 2325 dana      3368 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
 2333 dana      3368 S    {dnsmasqtotal.aw} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotal.awk
 2334 dana      3368 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
11768 dana      5432 S    grep taildns
Check files exist correctly
Code: 
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 .
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 ..
-rwxr-xr-x    1 dana     root           885 May 13 00:45 dnsmasqtotal.awk
-rwxr-xr-x    1 dana     root           886 May 19 14:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 dana     root           540 Apr 24 11:15 taildns
-rwxr-xr-x    1 dana     root          1131 May 19 10:49 taildnstotal
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
 
Dan Ljungberg said:
check taildns is running
Code: 
 Checking taildns...              alive.
dana@RT-AC2900-72D8:/tmp/home/root# ps | grep taildns
 2322 dana      3368 S    {taildns} /bin/sh /opt/bin/taildns
 2325 dana      3368 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
 2333 dana      3368 S    {dnsmasqtotal.aw} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotal.awk
 2334 dana      3368 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
11768 dana      5432 S    grep taildns
Check files exist correctly
Code: 
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 .
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 ..
-rwxr-xr-x    1 dana     root           885 May 13 00:45 dnsmasqtotal.awk
-rwxr-xr-x    1 dana     root           886 May 19 14:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 dana     root           540 Apr 24 11:15 taildns
-rwxr-xr-x    1 dana     root          1131 May 19 10:49 taildnstotal
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
Click to expand...
taildns looks good, but the ls output seems to be missing - can you double check it copied out of your terminal app correctly please?
 
Jack Yaz said:
taildns looks good, but the ls output seems to be missing - can you double check it copied out of your terminal app correctly please?
Click to expand...

My misstake :oops:
Code: 
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /jffs/addons/uiDivStats.d
/jffs/addons/uiDivStats.d:
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 .
drwxr-xr-x    8 dana     root             0 Jun  6 15:02 ..
-rw-rw-rw-    1 dana     root             0 Jun  6 15:11 .upgraded
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 .upgraded2
-rw-rw-rw-    1 dana     root          3268 Jun  6 15:29 SQLData.js
-rw-rw-rw-    1 dana     root          5059 Jun  6 10:00 psstats.htm
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 taildns.d
-rw-rw-rw-    1 dana     root            33 Jun  6 10:12 taildns.tar.gz.md5
-rw-rw-rw-    1 dana     root         12484 Jun  6 10:00 uidivstats.js
-rw-rw-rw-    1 dana     root         16182 Jun  6 10:00 uidivstats.txt
-rw-rw-rw-    1 dana     root         28934 Jun  6 10:05 uidivstats_www.asp
-rw-rw-rw-    1 dana     root           730 Jun  6 10:00 uidivstatsclients.js
-rw-rw-rw-    1 dana     root           813 Jun  6 10:00 uidivstatstext.js

/jffs/addons/uiDivStats.d/taildns.d:
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 .
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 ..
-rwxr-xr-x    1 dana     root           885 May 13 00:45 dnsmasqtotal.awk
-rwxr-xr-x    1 dana     root           886 May 19 14:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 dana     root           540 Apr 24 11:15 taildns
-rwxr-xr-x    1 dana     root          1131 May 19 10:49 taildnstotal
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
dana@RT-AC2900-72D8:/tmp/home/root#

Code: 
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
/opt/share/uiDivStats.d:
drwxrwxrwx    3 dana     root          4096 Jun  6 15:46 .
drwxr-xr-x    8 dana     root          4096 Jun  6 10:12 ..
drwxrwxrwx    2 dana     root          4096 Jun  6 15:29 csv
-rw-r--r--    1 dana     root         20480 Jun  6 15:29 dnsqueries.db

/opt/share/uiDivStats.d/csv:
drwxrwxrwx    2 dana     root          4096 Jun  6 15:29 .
drwxrwxrwx    3 dana     root          4096 Jun  6 15:46 ..
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddaily.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddailyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthlyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweekly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweeklyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweeklytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:46 SQLQueryLog.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 TotalBlockeddailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 TotalBlockedmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 TotalBlockedweeklytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldaily.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldailyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthlyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 Totalweekly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalweeklyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 Totalweeklytime.htm
dana@RT-AC2900-72D8:/tmp/home/root#
 
Dan Ljungberg said:
My misstake :oops:
Code: 
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /jffs/addons/uiDivStats.d
/jffs/addons/uiDivStats.d:
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 .
drwxr-xr-x    8 dana     root             0 Jun  6 15:02 ..
-rw-rw-rw-    1 dana     root             0 Jun  6 15:11 .upgraded
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 .upgraded2
-rw-rw-rw-    1 dana     root          3268 Jun  6 15:29 SQLData.js
-rw-rw-rw-    1 dana     root          5059 Jun  6 10:00 psstats.htm
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 taildns.d
-rw-rw-rw-    1 dana     root            33 Jun  6 10:12 taildns.tar.gz.md5
-rw-rw-rw-    1 dana     root         12484 Jun  6 10:00 uidivstats.js
-rw-rw-rw-    1 dana     root         16182 Jun  6 10:00 uidivstats.txt
-rw-rw-rw-    1 dana     root         28934 Jun  6 10:05 uidivstats_www.asp
-rw-rw-rw-    1 dana     root           730 Jun  6 10:00 uidivstatsclients.js
-rw-rw-rw-    1 dana     root           813 Jun  6 10:00 uidivstatstext.js

/jffs/addons/uiDivStats.d/taildns.d:
drwxrwxrwx    2 dana     root             0 Jun  6 10:12 .
drwxrwxrwx    3 dana     root             0 Jun  6 15:29 ..
-rwxr-xr-x    1 dana     root           885 May 13 00:45 dnsmasqtotal.awk
-rwxr-xr-x    1 dana     root           886 May 19 14:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 dana     root           540 Apr 24 11:15 taildns
-rwxr-xr-x    1 dana     root          1131 May 19 10:49 taildnstotal
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
dana@RT-AC2900-72D8:/tmp/home/root#

Code: 
dana@RT-AC2900-72D8:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
/opt/share/uiDivStats.d:
drwxrwxrwx    3 dana     root          4096 Jun  6 15:46 .
drwxr-xr-x    8 dana     root          4096 Jun  6 10:12 ..
drwxrwxrwx    2 dana     root          4096 Jun  6 15:29 csv
-rw-r--r--    1 dana     root         20480 Jun  6 15:29 dnsqueries.db

/opt/share/uiDivStats.d/csv:
drwxrwxrwx    2 dana     root          4096 Jun  6 15:29 .
drwxrwxrwx    3 dana     root          4096 Jun  6 15:46 ..
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddaily.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddailyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Blockeddailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthlyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweekly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweeklyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Blockedweeklytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:46 SQLQueryLog.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 TotalBlockeddailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 TotalBlockedmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 TotalBlockedweeklytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldaily.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldailyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:29 Totaldailytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthlyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalmonthlytime.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 Totalweekly.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:13 Totalweeklyclients.htm
-rw-rw-rw-    1 dana     root             0 Jun  6 15:12 Totalweeklytime.htm
dana@RT-AC2900-72D8:/tmp/home/root#
Click to expand...
Hm so the database isn't actually being updated by the looks of it. Can you run the below and check if you get any output when visiting websites etc.?
Code: 
tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3
 
I also don't have any graphs after fresh install for about 30 minutes.

Code: 
admin@FaTiii:/tmp/home/root# /opt/etc/init.d/S90taildns check
 Checking taildns...              alive.
admin@FaTiii:/tmp/home/root# ps | grep taildns
13087 admin     1420 S    {taildns} /bin/sh /opt/bin/taildns
13090 admin     1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
13094 admin     1432 S    {dnsmasqtotalext} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotalextra.awk
13095 admin     1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
20149 admin     4656 S    grep taildns
admin@FaTiii:/tmp/home/root# ls -laR /jffs/addons/uiDivStats.d
/jffs/addons/uiDivStats.d:
drwxrwxrwx    3 admin    root             0 Jun  6 17:03 .
drwxr-xr-x    7 admin    root             0 Jun  6 16:34 ..
-rw-rw-rw-    1 admin    root             0 Jun  6 16:34 .upgraded
-rw-rw-rw-    1 admin    root             0 Jun  6 16:34 .upgraded2
-rw-rw-rw-    1 admin    root           704 Jun  6 17:03 SQLData.js
drwxrwxrwx    2 admin    root             0 Jun  6 16:34 taildns.d
-rw-rw-rw-    1 admin    root            33 Jun  6 16:34 taildns.tar.gz.md5
-rw-rw-rw-    1 admin    root         28934 Jun  6 16:34 uidivstats_www.asp

/jffs/addons/uiDivStats.d/taildns.d:
drwxrwxrwx    2 admin    root             0 Jun  6 16:34 .
drwxrwxrwx    3 admin    root             0 Jun  6 17:03 ..
-rwxr-xr-x    1 admin    root           885 May 13 01:45 dnsmasqtotal.awk
-rwxr-xr-x    1 admin    root           886 May 19 15:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 admin    root           540 Apr 24 12:15 taildns
-rwxr-xr-x    1 admin    root          1131 May 19 11:49 taildnstotal
admin@FaTiii:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
/opt/share/uiDivStats.d:
drwxrwxrwx    3 admin    root          4096 Jun  6 17:04 .
drwxr-xr-x   10 admin    root          4096 Jun  6 14:27 ..
drwxrwxrwx    2 admin    root          4096 Jun  6 17:03 csv
-rw-r--r--    1 admin    root         20480 Jun  6 17:03 dnsqueries.db

/opt/share/uiDivStats.d/csv:
drwxrwxrwx    2 admin    root          4096 Jun  6 17:03 .
drwxrwxrwx    3 admin    root          4096 Jun  6 17:04 ..
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddaily.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddailyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthlyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweekly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweeklyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweeklytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:04 SQLQueryLog.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockeddailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockedmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockedweeklytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldaily.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldailyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthlyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweekly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweeklyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweeklytime.htm
admin@FaTiii:/tmp/home/root#

I can see new logs when I tail "tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3"
 
pattiri said:
I also don't have any graphs after fresh install for about 30 minutes.

Code: 
admin@FaTiii:/tmp/home/root# /opt/etc/init.d/S90taildns check
 Checking taildns...              alive.
admin@FaTiii:/tmp/home/root# ps | grep taildns
13087 admin     1420 S    {taildns} /bin/sh /opt/bin/taildns
13090 admin     1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
13094 admin     1432 S    {dnsmasqtotalext} /usr/bin/awk -f /jffs/addons/uiDivStats.d/taildns.d/dnsmasqtotalextra.awk
13095 admin     1420 S    {taildnstotal} /bin/sh /jffs/addons/uiDivStats.d/taildns.d/taildnstotal
20149 admin     4656 S    grep taildns
admin@FaTiii:/tmp/home/root# ls -laR /jffs/addons/uiDivStats.d
/jffs/addons/uiDivStats.d:
drwxrwxrwx    3 admin    root             0 Jun  6 17:03 .
drwxr-xr-x    7 admin    root             0 Jun  6 16:34 ..
-rw-rw-rw-    1 admin    root             0 Jun  6 16:34 .upgraded
-rw-rw-rw-    1 admin    root             0 Jun  6 16:34 .upgraded2
-rw-rw-rw-    1 admin    root           704 Jun  6 17:03 SQLData.js
drwxrwxrwx    2 admin    root             0 Jun  6 16:34 taildns.d
-rw-rw-rw-    1 admin    root            33 Jun  6 16:34 taildns.tar.gz.md5
-rw-rw-rw-    1 admin    root         28934 Jun  6 16:34 uidivstats_www.asp

/jffs/addons/uiDivStats.d/taildns.d:
drwxrwxrwx    2 admin    root             0 Jun  6 16:34 .
drwxrwxrwx    3 admin    root             0 Jun  6 17:03 ..
-rwxr-xr-x    1 admin    root           885 May 13 01:45 dnsmasqtotal.awk
-rwxr-xr-x    1 admin    root           886 May 19 15:51 dnsmasqtotalextra.awk
-rwxr-xr-x    1 admin    root           540 Apr 24 12:15 taildns
-rwxr-xr-x    1 admin    root          1131 May 19 11:49 taildnstotal
admin@FaTiii:/tmp/home/root# ls -laR /opt/share/uiDivStats.d
/opt/share/uiDivStats.d:
drwxrwxrwx    3 admin    root          4096 Jun  6 17:04 .
drwxr-xr-x   10 admin    root          4096 Jun  6 14:27 ..
drwxrwxrwx    2 admin    root          4096 Jun  6 17:03 csv
-rw-r--r--    1 admin    root         20480 Jun  6 17:03 dnsqueries.db

/opt/share/uiDivStats.d/csv:
drwxrwxrwx    2 admin    root          4096 Jun  6 17:03 .
drwxrwxrwx    3 admin    root          4096 Jun  6 17:04 ..
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddaily.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddailyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockeddailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthlyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweekly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweeklyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Blockedweeklytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:04 SQLQueryLog.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockeddailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockedmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 TotalBlockedweeklytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldaily.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldailyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totaldailytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthlyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalmonthlytime.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweekly.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweeklyclients.htm
-rw-rw-rw-    1 admin    root             0 Jun  6 17:03 Totalweeklytime.htm
admin@FaTiii:/tmp/home/root#

I can see new logs when I tail "tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3"
Click to expand...
Do you get any errors if you use option 2 in uiDivStats?
 
Jack Yaz said:
Hm so the database isn't actually being updated by the looks of it. Can you run the below and check if you get any output when visiting websites etc.?
Code: 
tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3
Click to expand...

Code: 
dana@RT-AC2900-72D8:/tmp/home/root# tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3
tail: can't open '/opt/var/log/dnsmasq.log3': No such file or directory
==> /opt/var/log/dnsmasq.log <==
Jun  6 16:08:46 dnsmasq[2719]: 867 192.168.123.36/59135 cached connectivitycheck.gstatic.com is 172.217.21.163
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 query[A] ps-125.pubnub.com from 192.168.123.84
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.20
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.18
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.19
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply ps-125.pubnub.com is <CNAME>
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply pubsub.pubnub.com is 54.93.254.233
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply pubsub.pubnub.com is 54.93.254.234
Jun  6 16:09:20 dnsmasq[2719]: 869 192.168.123.151/38153 query[A] connectivitycheck.gstatic.com from 192.168.123.151
Jun  6 16:09:20 dnsmasq[2719]: 869 192.168.123.151/38153 cached connectivitycheck.gstatic.com is 172.217.21.163
^C
dana@RT-AC2900-72D8:/tmp/home/root#
 
Dan Ljungberg said:
Code: 
dana@RT-AC2900-72D8:/tmp/home/root# tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3
tail: can't open '/opt/var/log/dnsmasq.log3': No such file or directory
==> /opt/var/log/dnsmasq.log <==
Jun  6 16:08:46 dnsmasq[2719]: 867 192.168.123.36/59135 cached connectivitycheck.gstatic.com is 172.217.21.163
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 query[A] ps-125.pubnub.com from 192.168.123.84
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.20
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.18
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 forwarded ps-125.pubnub.com to 195.67.199.19
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply ps-125.pubnub.com is <CNAME>
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply pubsub.pubnub.com is 54.93.254.233
Jun  6 16:09:07 dnsmasq[2719]: 868 192.168.123.84/38969 reply pubsub.pubnub.com is 54.93.254.234
Jun  6 16:09:20 dnsmasq[2719]: 869 192.168.123.151/38153 query[A] connectivitycheck.gstatic.com from 192.168.123.151
Jun  6 16:09:20 dnsmasq[2719]: 869 192.168.123.151/38153 cached connectivitycheck.gstatic.com is 172.217.21.163
^C
dana@RT-AC2900-72D8:/tmp/home/root#
Click to expand...
OK so it looks like you have extra query logging for dnsmasq enabled, but taildns is using the standard awk script. Can you send the output of:
Code: 
cat /etc/dnsmasq.conf | grep log
please?
 
Jack Yaz said:
Do you get any errors if you use option 2 in uiDivStats?
Click to expand...


Code: 
Choose an option:    2

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

Press enter to continue...

I've just disabled extra query logging for dnsmasq and here is my current dnsmasq settings if it helps;


Code: 
Dnsmasq settings:

 See the Dnsmasq man page what these options do:
 http://www.thekelleys.org.uk/dnsmasq/docs/dnsmasq-man.html

 1. Disable Dnsmasq settings
 2. log-async         20
 3. cache-size        2500
 4. bogus-priv        on
 5. domain-needed     on
 6. log-queries=extra
 
Can this be the reason?

Code: 
admin@FaTiii:/tmp/home/root# tail -F /opt/var/log/dnsmasq.log /opt/var/log/dnsmasq.log3
tail: can't open '/opt/var/log/dnsmasq.log3': No such file or directory
==> /opt/var/log/dnsmasq.log <==
 
Jack Yaz said:
OK so it looks like you have extra query logging for dnsmasq enabled, but taildns is using the standard awk script. Can you send the output of:
Code: 
cat /etc/dnsmasq.conf | grep log
please?
Click to expand...

Code: 
dana@RT-AC2900-72D8:/tmp/home/root# cat /etc/dnsmasq.conf | grep log
log-async
log-queries=extra
log-facility=/opt/var/log/dnsmasq.log
dana@RT-AC2900-72D8:/tmp/home/root#
thanks!
 
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
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
Viktor Jaep
BACKUPMON BACKUPMON v1.8.20 -Oct 12, 2024- Backup/Restore your Router: JFFS + NVRAM + External USB Drive! CIFS/SMB/NFS! (Now available in AMTM!)
23 24 25
Replies
495
Views
61K
Viktor Jaep
Viktor Jaep
Similar threads
Thread starter Title Forum Replies Date
thelonelycoder uiDivStats uiDivstats 4.0.3 - WebUI Stats for Diversion, November 19, 2024 Asuswrt-Merlin AddOns 42
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
Mogsy Skynet Skynet WebUI as scMerlin sitemap Asuswrt-Merlin AddOns 7
kstamand Diversion [SOLVED] Exclude subnet from Diversion blocking 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!

Staff online

Members online

Total: 884 (members: 28, guests: 856)
Top