mqtt - Read .db file in Mosquitto

Question

I'm using Mosquitto Project (http://mosquitto.org), this is my mosquitto.conf

persistence_file mosquitto.db

persistence_location C:/var/lib/mosquitto/

After running, I have got mosquitto.db, but I can't open it. I'm trying open with Microsoft Excel, sqlitebrowser_200_b1_win but it's not working. Please help me. Thanks in advance

Answer 1

I just answered this same question on the mosquitto answers tracker:

https://answers.launchpad.net/mosquitto/+question/217523

The mosquitto.db file holds internal persistence information on client subscriptions and retained messages. It isn't intended for use outside of mosquitto. There is no guarantee that it is up to date information.

Having said that, if you are interested in looking at the file then the source file to look at is src/persist.c. There is also a program to print the file contents in a more readable manner - you should compile src/db_dump/db_dump.c.

mosquitto.db is an internal file and has nothing to do with sql.