Node-red-contrib-sql

#1

Hello everyone. I am having issues with the sql insert node, which is part of the sql package. I am unable to link it to the mysql database node. When I searched for a possible solution, it said that I have to modify the configuration node which is available near the deploy button in the dropdown. I tried but was unsuccessful. I will paste the ss here. Could anyone suggest a solution please?

0 Likes

#2

0 Likes

#3

What error are you seeing?
Also tell us what operating system you are running on and post here the startup log from node red. It should start with the Welcome to node red message.
Finally are you able to connect to the database using a command line SQL client?

0 Likes

#4

You've pasted the wrong config screen. The one you have shared is the one from the mysql node (the orange one in your flow), you need to configure the light blue one ( as it indicates with the red triangle). If you double click on that one, how have you got it configured?

Although as @Colin states you can create an INSERT statement in a function node or a template node.

0 Likes

#5

One other point, if the 'sql package' is node-red-contrib-sql, you should realize it hasn't been updated since May of 2017...

0 Likes

#6

I forgot to attach the other SS sorry

0 Likes

#7

I am using Windows 10. And there is no problem with my node red booting. Yes I am able to connect to the database using SQL client, that is part of another flow. I am able to manually run the sql query commands, using the function node that is not the issue here. I am unable to do so dynamically. I want the incoming data to populate automatically into the database without having to manually insert it each time.

0 Likes

#8

Here is the start up log

0 Likes

#9

0 Likes

#10

0 Likes

#11

SS8

0 Likes

#12

SS9

0 Likes

#13

As you can see, manual insertion is not an issue. I need help to configure the sql insert node to carry out the same process dynamically. I would be grateful if you can help me come up with some solution. Thanks in advance!

0 Likes

#14

So where is the data you want to insert coming from ? What does it look like, can you feed it into a debug node and show us ?

0 Likes

#15

If you can insert it using a function node as you have shown, why not just do it that way? Why do you need to use the sql insert node?
In the info panel for the sql insert node does it say that you can configure it dynamically? If not then you probably cannot.

0 Likes