MQTT Data Tables Missing In Postgres #4062
-
|
MQTT_SUB AND MQTT_SESSION Both these tables are visible in webadmin and its never seen in postgre still i have given db_type as sql in mod_mqtt and mqtt_pub table is present in postgre schema but no data is getting stored there. any idea what to configure more |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
Did you configure the MQTT modules to use a relational database backend and not the default mnesia backend ? |
Beta Was this translation helpful? Give feedback.
-
|
Right, there are some tables that contain runtime information, only relevant while the server is running, and its content is irrelevant once the server stops. Such tables are not stored in SQL or in disk Mnesia. Those tables are kept in ETS or in RAM mnesia, for example: bosh, muc_online_room, route, s2s, session, session_counter, mqtt_session and mqtt_sub. |
Beta Was this translation helpful? Give feedback.
Right, there are some tables that contain runtime information, only relevant while the server is running, and its content is irrelevant once the server stops. Such tables are not stored in SQL or in disk Mnesia.
Those tables are kept in ETS or in RAM mnesia, for example: bosh, muc_online_room, route, s2s, session, session_counter, mqtt_session and mqtt_sub.