node-red mssql and mysql node

Hi all, I’m new to this so please bear with me. I have been fiddling around with node-red cause I am wow-ed by this exciting tech… I am trying to do a client webpage sending POST to a server side node and then run a query or stored procedure( not quite there yet) , but my problem is that I always get an error message regardless of which db node mysql or mssql I use (it’s the same message, not in debug but in the dev console (chrome)) which is :

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