Recent content by lamentary

XD Sorry for the late response, I haven't been tracking this thread as of late figuring that the issues I was having have been satisfactorily (however temporarily) resolved until a more permanent/official solution was released. In terms of ASUS, even at the time of people posting scripts in...

Great work, @Martinski!

Looks like you're in the same boat as @mmacedo in that you don't have the stainfo.db file, @JimbobJay. To be clear, the script will show those errors and then just keep running, so it shouldn't cause any real issues, but I've gone ahead and added a conditional check to it to verify the file...

@jata - when I initially wrote the script, it was with the intent that it would be a one-off. When I found that the shell on the router didn't work with the array() object, I just copied/pasted instead of dealing with the research for arrays. Since it looks like others may use this, I've...

You could probably add the VACUUM command to the script to shrink the file sizes when you run it, but that's outside of my use case. You'd add something like /usr/sbin/sqlite3 <database file> 'vacuum;' after each of the DELETE commands to the script

No problem. If you're just planning on running it on demand from the console, though, as opposed to scheduling it via cron job, it might be just as easy to kill the conn_diag process and delete the contents of the /tmp/.diag directory and then optionally restart the conn_diag process, unless...

Sure, @jata, here is the original post. I am not strong with the Bourne shell, and there are probably a million ways to write this script better. I've modified the clean-dbs.sh script slightly since then to generate the output, provide some additional metrics, and cleaned up the cron...

FWIW, here's the output of my scripts from ~ 9:00 AM PST this morning: ******************************************************************************** ***** Running Clean Dbs *****...

They may still be unrelated, it's entirely possible that there are multiple memory leaks, and that fixing one may just delay the symptoms of the other from revealing themselves, but mitigating/fixing any (or, dare I say all?) of them will be helpful. I have yet to add the networkmap and...

I have had the issue multiple times - in fact, it's what drove me to this thread. Whether these are multiple issues or a single one, I cannot say, but I'm looking at anywhere that might have a memory leak and attempting to mitigate. I'm glad to see that at least one front of this is being...

I am also using an RT-AX68U running Merlin 388.1. I also have 2 RT-AC68U nodes, each running Merlin 386.9

Also worth noting: I've been up since yesterday morning and do not have any cron jobs aside from the one that runs the scripts to delete the .db file contents. I did manually restart the httpd and conn_diag at one point last night (no reboot) due to some issues that ended up having nothing to...

I suspect stainfo.db it might have something to do with AiMesh? Schema: CREATE TABLE DATA_INFO (data_id INTEGER PRIMARY KEY AUTOINCREMENT, node_type TEXT DEFAULT '' NOT NULL,node_ip TEXT DEFAULT '' NOT NULL,node_mac TEXT DEFAULT '' NOT NULL,sta_mac TEXT DEFAULT '' NOT NULL,sta_band TEXT...

FWIW, here is a snapshot of my scripts output last night at around 11:15 last night on my AX68U (I left my scripts running to keep the dbs trimmed): ******************************************************************************** ***** Running Clean Dbs...

For the sake of knowing what it's doing and comparison, I pushed the echos to a file in my jffs folder (not a good idea long term, bc it's going to eventually cause its own issues, but I'll sed the logging out after. Here's the first output...