MQTT Broker - Mosquitto Message Logging

[kavidriod]

Is it possible to log MQTT Broker Mosquitto events such as messages published to all channels, subscriptions, client connections/disconnections and errors to a log file with a time stamp and then have program insert this into a database either SQL in encrypted form?

If so, how could this be achieved?

What I have tried?

I have subscribed to the topic $SYS/broker/# ,able to get only connection logs,My query here is how can i get what message is sent and received from broker?

Reference Link : http:https://www.steves-internet-guide.com/mosquitto-logging/

[john2exonets]

Add to your mosquitto.conf:

log_type payload

This will add the contents of the packet payload to the log file. Works for non-binary data....not sure what happens with binary data.