When I open mosquitto.db with sqlite it gives an error 'File is encrypted or it is not a database'

Question

I know there are fixed like creating databases in php,android but in this case it is generated by mosquitto so how can I see it.

score 1 · Answer 1 · edited May 23 '17 at 11:44

1

It is not a sqllite db.

Why do you want to open the mosquitto db file? It doesn't hold anything of use to a end user.

Messages are only held in this DB while they are being delivered.

Please see the following answer for more detail

edited May 23 '17 at 11:44

Community

answered Oct 09 '15 at 16:30

hardillb

Where can see the retained messages by the broker to do analysis on data. – Yugandhar Chaudhari Oct 09 '15 at 19:09
You don't, if you really must then look at the mosquito source code and write your own tool to open the file. – hardillb Oct 10 '15 at 08:38
Thanks that will help too. I got another solution in mind I will log data into the database in callback in java.After subscribing to # and analyzing entries. – Yugandhar Chaudhari Oct 10 '15 at 10:26

1 Answers1