Community discussions

MikroTik App
 
jack2k
just joined
Topic Author
Posts: 4
Joined: Fri Oct 20, 2017 5:01 pm

SQLITE Dude 6 database and objects

Tue Mar 13, 2018 8:18 pm

Hello, I need to access to the objects colletion inside the dude database, for example I need to be able to read names and IPs of devices.
I already exported the dude.db file sucefully and opened ti with sqlite3, I can view some tables:

sqlite> .tables
chart_values_10min chart_values_2hour objs
chart_values_1day chart_values_raw outages

At this time seeing the table names I think the table called objs is my boy, but after doing some select in the table I see only data like this:

sqlite> select * from objs limit 0,10;
10004|M2
10005|M2
10006|M2
10009|M2
10010|M2
10011|M2
10012|M2
10013|M2
10014|M2
10015|M2

This is only a top 10, but all rows are similar.

The other tables has no relevant information.

Any idea ?

Regards,
RDA.-
 
sid5632
Long time Member
Long time Member
Posts: 554
Joined: Fri Feb 17, 2017 6:05 pm

Re: SQLITE Dude 6 database and objects

Tue Mar 13, 2018 8:25 pm

Yes, I wish it was human readable too, rather than some sort of binary blob.
I've half considered having a go at reverse engineering some of the fields (I kinda guess M won't tell us the structure), but it seems like a lot of work.
Be nice if they finished the command line support in RouterOS as well, which might help.
At the moment, the Dude is an unreliable mess.

Who is online

Users browsing this forum: No registered users and 33 guests