Reply To: Issue in connecting MQTTROUTE to MYSQL SERVER

Forums MQTT Broker Issue in connecting MQTTROUTE to MYSQL SERVER Reply To: Issue in connecting MQTTROUTE to MYSQL SERVER

Place to gain & share unique insights about MQTT Broker
#8702
Lakshmi Deepa S

Hello Abella. This issue can be solved by reinstalling and re-configuring the MYSQL server. Follow the beneath steps to beat this issue.
Open Terminal and go to./Bevywise/MQTTRoute/bin
Run the sh installer.sh, this file will install all dependence and Python MYSQL-connector (version 8.0.5).
Install MySQL 5.7 server or higher and afterward set MYSQL username and password in the data_store.conf file.
If you have installed MariaDB instead of MYSQL 5.7, please install MYSQL 5.7 or higher to connect. Since MariaDB will not support Bevywise MQTT Broker.
When the establishment is finished it shows the message like “Now you can connect the MQTT broker to MYSQL or MSSQL”.
At that point run the broker using sh runbroker.sh command in terminal.
Presently, your MQTT broker is connected with MYSQL and you can open the program and view your associated devices.
To know more information about interfacing MYSQL with MQTTBroker and how to connect MYSQL for Windows please refer help document.