node-red mssql and mysql node
I’ve tried the most symplistic flows like this:
[{“id”:”57f6617f.a809a”,”type”:”MySQLdatabase”,”z”:”f7155196.08eab”,”host”:”127.0.0.1″,”port”:”3306″,”db”:”world”,”tz”:””},{“id”:”fc76f77e.038908″,”type”:”inject”,”z”:”f7155196.08eab”,”name”:””,”topic”:”\”SELECT * FROM world.city\””,”payload”:”\”SELECT * FROM world.city\””,”payloadType”:”string”,”repeat”:””,”crontab”:””,”once”:false,”x”:245,”y”:111,”wires”:[[“2ad90b3.fd526f4”]]},{“id”:”2ad90b3.fd526f4″,”type”:”mysql”,”z”:”f7155196.08eab”,”mydb”:”57f6617f.a809a”,”name”:””,”x”:483,”y”:174,”wires”:[[“b9cb9507.463468”]]},{“id”:”b9cb9507.463468″,”type”:”debug”,”z”:”f7155196.08eab”,”name”:””,”active”:true,”console”:”false”,”complete”:”false”,”x”:679,”y”:178,”wires”:[]}]
my servers are up and running and the configuration in the mysql node looks ok to me ( I do use auth but took it out for the sake of posting).
Can anyone help me or point me to some guide/howto?
Thanks
E
Read more here: Source link
