connmon connmon - Internet connection monitoring

[sentinelvdx]

can you send me a copy of your database? if its large I can send a dropbox link
non-unix exports fine here, seems like your data is using the wrong timestamp for some reason
over ssh what do you get for

date

How do I obtain a copy of my db? you mean the csv file?
I can upload it to my mega account if necesary

date:

ASUSWRT-Merlin RT-AC88U 386.1_2 Fri Feb 12 22:47:24 UTC 2021
sentinelvdx@RT-AC88U:/tmp/home/root# date
Fri Feb 26 20:41:54 GMT 2021
sentinelvdx@RT-AC88U:/tmp/home/root#

I didn't try uninstall/reinstall

 

[Jack Yaz]

How do I obtain a copy of my db? you mean the csv file?
I can upload it to my mega account if necesary

date:

ASUSWRT-Merlin RT-AC88U 386.1_2 Fri Feb 12 22:47:24 UTC 2021
sentinelvdx@RT-AC88U:/tmp/home/root# date
Fri Feb 26 20:41:54 GMT 2021
sentinelvdx@RT-AC88U:/tmp/home/root#

I didn't try uninstall/reinstall

the .db file itself please, it'll be either /jffs/addons/connmon.d or /opt/share/connmon.d depending on what storage location you set

 

[sentinelvdx]

can you send me a copy of your database? if its large I can send a dropbox link
non-unix exports fine here, seems like your data is using the wrong timestamp for some reason
over ssh what do you get for

date

the .db file itself please, it'll be either /jffs/addons/connmon.d or /opt/share/connmon.d depending on what storage location you set

Here is it " conmon.d " better if you have everything
Also I've noticed today the 26th was not logged, graphs shows up to half day of 26th

 

[Jack Yaz]

Here is it " conmon.d " better if you have everything
Also I've noticed today the 26th was not logged, graphs shows up to half day of 26th

the good news is the data in the sqlite db is fine, the timestamps are correct. the bad news is, the last epoch in the db is 1614242943 which converts to GMT: Thursday, 25 February 2021 08:49:03 (https://www.epochconverter.com/)

is connmon listed in

cru l

if you run a ping (option 1 CLI) do you get any error messages?

Regarding the time conversion, that is weird. Can you run

which awk
cat /etc/TZ

 

[sentinelvdx]

the good news is the data in the sqlite db is fine, the timestamps are correct. the bad news is, the last epoch in the db is 1614242943 which converts to GMT: Thursday, 25 February 2021 08:49:03 (https://www.epochconverter.com/)

is connmon listed in

cru l

if you run a ping (option 1 CLI) do you get any error messages?

Regarding the time conversion, that is weird. Can you run

which awk
cat /etc/TZ

I'm attaching screenshots.
Conmon is listed, running manual ping it runs perfect, no errors...

And time I see it says GMT3 (System is set to GMT-3)

 

[Jack Yaz]

I'm attaching screenshots.
Conmon is listed, running manual ping it runs perfect, no errors...

And time I see it says GMT3 (System is set to GMT-3)

thanks. did you try a command line ping test from connmon?

 

[sentinelvdx]

thanks. did you try a command line ping test from connmon?

Ok, see attached. Here I'm getting errors...

 

[Jack Yaz]

Ok, see attached. Here I'm getting errors...

try

opkg update
opkg remove --autoremove sqlite3-cli
opkg install sqlite3-cli

segmentation fault may mean failing USB drive

 

[sentinelvdx]

try

opkg update
opkg remove --autoremove sqlite3-cli
opkg install sqlite3-cli

segmentation fault may mean failing USB drive

It working back!!!!!!! Even csv report is now correct. thanks for all the help!!!!
I'll be checking it to ensure it doesn't happen anymore.

Question, let say I want to reset logged data, how do I clear old records?

I'll buy you a coffeee next week, promise!

 

[Jack Yaz]

It working back!!!!!!! Even csv report is now correct. thanks for all the help!!!!
I'll be checking it to ensure it doesn't happen anymore.

Question, let say I want to reset logged data, how do I clear old records?

I'll buy you a coffeee next week, promise!

I'll check on best way to reset. I would say delete the database but I think i create hidden files for upgrading the db over time, I'll get back to you

 

[TicoMan]

Sorry if this is a stupid question, but if the ping is running, will it affect an online gaming session?

 

[Jack Yaz]

Sorry if this is a stupid question, but if the ping is running, will it affect an online gaming session?

no, it should have no effect on usage of your connection

 

[Jack Yaz]

It working back!!!!!!! Even csv report is now correct. thanks for all the help!!!!
I'll be checking it to ensure it doesn't happen anymore.

Question, let say I want to reset logged data, how do I clear old records?

I'll buy you a coffeee next week, promise!

i've added an option on the develop branch to reset the database, run

connmon develop

and then use option r

 

[maghuro]

Just for the record, my sqlite also had some kind of problem. It started today, 5AM for no reason, while I was asleep

Every data disappeared. Solution was removing and installing sq-lite again from opkg.

 

[MatteoPV]

I installed connmon on GNUton 386 beta 3 firmware but then I can't find it in the menu, why?

 

[QuikSilver]

I installed connmon on GNUton 386 beta 3 firmware but then I can't find it in the menu, why?

Check the syslog and see if it was unable to mount the page.

 

[MatteoPV]

Check the syslog and see if it was unable to mount the page.

I tried to force the update and in the system log of the router it puts that connmon is correctly updated and installed. I couldn't find anything about the page mount

 

[QuikSilver]

I tried to force the update and in the system log of the router it puts that connmon is correctly updated and installed. I couldn't find anything about the page mount

Nothing under the addons tab? Try rebooting the router.

 

[MatteoPV]

Nothing under the addons tab? Try rebooting the router.

I uninstalled or then reinstalled connmon, now everything works.
Thanks so much

 

[andresmorago]

hi
im just curious about this peaks that i see on the graphs. they are showed exactly every 30 minutes. Is it the ip address that im pinging?

My setup