Unable to install additional nodes

General
1

I can't get any additional nodes to install. The one I'm trying to install is node-red-node-mysql.
I'm super new to Node-RED. I'm a PLC programmer and I'm trying to use the new C2-NRED module to allow my PLC to share information with the database that supports our website.
I've seen videos of how to add the mysql nodes but right now every installation fails. Here's the data log:

2025-03-13T20:06:01.877Z Install : node-red-node-mysql 2.0.0

2000-01-01T10:32:25.606Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-mysql@2.0.0
2000-01-01T10:32:51.182Z [err] npm
2000-01-01T10:32:51.186Z [err]  
2000-01-01T10:32:51.187Z [err] ERR!
2000-01-01T10:32:51.188Z [err]  
2000-01-01T10:32:51.189Z [err] code
2000-01-01T10:32:51.195Z [err]  EAI_AGAIN
2000-01-01T10:32:51.195Z [err] npm ERR! errno EAI_AGAIN
2000-01-01T10:32:51.381Z [err] npm
2000-01-01T10:32:51.383Z [err]  
2000-01-01T10:32:51.384Z [err] ERR!
2000-01-01T10:32:51.385Z [err]  request to https://registry.npmjs.org/node-red-node-mysql failed, reason: getaddrinfo EAI_AGAIN registry.npmjs.org
2000-01-01T10:32:51.451Z [err] 
2000-01-01T10:32:51.454Z [err] npm
2000-01-01T10:32:51.455Z [err]  
2000-01-01T10:32:51.456Z [err] ERR!
2000-01-01T10:32:51.457Z [err]  A complete log of this run can be found in:
2000-01-01T10:32:51.461Z [err] npm ERR!     /usr/local/nred/.npm/_logs/2000-01-01T10_32_51_396Z-debug.log
2000-01-01T10:32:51.513Z rc=1
2

EAI_AGAIN is a DNS lookup timeout error. It means a network connectivity error or proxy related error occurred.

Where is node-red installed? Does the server/device have internet access?

I assume since you mention PLCs this device is in a DMZ or segregated network without internet connectivity?

3

The PLC module/device came with node-red already installed. The PLC module is only connected to the PLC itself and my PC. I set the node-red PLC module DNS server to 1.1.1.1
It's connected to my PC via ethernet. Can it get internet access through my PC?

4

You'd be better off putting the device onto a network with internet access. However, I know windows has "Internet Connection Sharing" (ICS)" though I've not used it in many years.

5

Okay, So I've connected the device to the network and am accessing it via the network (which has internet. I'm still getting the same error though.

2025-03-13T21:02:35.324Z Install : node-red-node-mysql 2.0.0

2000-01-01T11:28:58.712Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-mysql@2.0.0
2000-01-01T11:29:24.761Z [err] npm
2000-01-01T11:29:24.765Z [err]  
2000-01-01T11:29:24.766Z [err] ERR!
2000-01-01T11:29:24.768Z [err]  
2000-01-01T11:29:24.770Z [err] code
2000-01-01T11:29:24.772Z [err]  EAI_AGAIN
2000-01-01T11:29:24.775Z [err] npm
2000-01-01T11:29:24.776Z [err]  
2000-01-01T11:29:24.777Z [err] ERR!
2000-01-01T11:29:24.778Z [err]  
2000-01-01T11:29:24.788Z [err] errno EAI_AGAIN
2000-01-01T11:29:24.996Z [err] npm
2000-01-01T11:29:24.997Z [err]  
2000-01-01T11:29:24.999Z [err] ERR!
2000-01-01T11:29:25.000Z [err]  request to https://registry.npmjs.org/node-red-node-mysql failed, reason: getaddrinfo EAI_AGAIN registry.npmjs.org
2000-01-01T11:29:25.035Z [err] 
2000-01-01T11:29:25.037Z [err] npm
2000-01-01T11:29:25.038Z [err]  
2000-01-01T11:29:25.040Z [err] ERR!
2000-01-01T11:29:25.042Z [err]  A complete log of this run can be found in:
2000-01-01T11:29:25.043Z [err] npm
2000-01-01T11:29:25.046Z [err]  ERR!     /usr/local/nred/.npm/_logs/2000-01-01T11_29_25_007Z-debug.log
2000-01-01T11:29:25.105Z rc=1
6

This may work: Use your Windows device as a mobile hotspot - Microsoft Support.

But you need to know a few things.

  • I think it depends on what version of Windows you have. You may need to do some fiddling if using Windows Home Edition
  • If you are on a work or Uni/collage network, it may well be that such sharing would be against their acceptable use policy so make sure you check that out.
  • You may hit some Windows firewall issues that you would need to deal with.

As you are still getting the issue, the implication is that you don't have the correct network settings. Who owns the network?

7

It's on the network now. But yes, I'm still getting the same issue. The company owns the network. Not sure how everything is setup but it works with everything else we have including machines and servers.

8

Have you checked with your IT people that it is OK to attach the device? They should be able to give you the right settings. There are all sorts of security things on a corporate network that might prevent access to the Internet from an unapproved device.

9

I can check.

11

Okay, I think I might have solved the network issues. Now I'm getting this error. Looks like my device doesn't support the mysql node??

2025-03-13T21:27:19.947Z Install : node-red-node-mysql 2.0.0

2025-03-13T21:27:18.891Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-mysql@2.0.0
2025-03-13T21:27:54.963Z [err] npm
2025-03-13T21:27:54.968Z [err]  ERR! 
2025-03-13T21:27:54.984Z [err] code ENOTSUP
2025-03-13T21:27:55.367Z [err] npm
2025-03-13T21:27:55.369Z [err]  
2025-03-13T21:27:55.372Z [err] ERR! notsup
2025-03-13T21:27:55.377Z [err]  Unsupported engine for node-red-node-mysql@2.0.0: wanted: {"node":">=16"} (current: {"node":"14.18.1","npm":"6.14.15"})
2025-03-13T21:27:55.381Z [err] npm ERR! notsup Not compatible with your version of node/npm: node-red-node-mysql@2.0.0
2025-03-13T21:27:55.385Z [err] npm ERR! notsup Not compatible with your version of node/npm: node-red-node-mysql@2.0.0
2025-03-13T21:27:55.385Z [err] npm ERR! notsup Required: {"node":">=16"}
2025-03-13T21:27:55.388Z [err] npm ERR! notsup Actual:   {"npm":"6.14.15","node":"14.18.1"}
2025-03-13T21:27:55.437Z [err] 
2025-03-13T21:27:55.445Z [err] npm
2025-03-13T21:27:55.449Z [err]  
2025-03-13T21:27:55.451Z [err] ERR!
2025-03-13T21:27:55.454Z [err]  A complete log of this run can be found in:
2025-03-13T21:27:55.460Z [err] npm ERR!     /usr/local/nred/.npm/_logs/2025-03-13T21_27_55_400Z-debug.log
2025-03-13T21:27:55.631Z rc=1
12

It's not your device, it's the old (end of life) version of nodejs installed on it)

What device is it (make and model)? Have you checked to see if there is a firmware update? Perhaps nodejs version can be updated?

13

It is a CLICK PLUS module. The model number is C2-NRED. It just came out and I already installed the latest updates. Maybe they will release an update with new node.js version. I found a different mysql module that was supported on the older software so hopefully this will work. :crossed_fingers:

14

Thanks for all the help!

15

Oh my, not great!

https://www.automationdirect.com/adc/shopping/catalog/programmable_controllers/click_plus_plcs_(stackable_micro_modular)/cpu_option_slot_modules/c2-nred

You'd be better off with a raspberry pi or an industrial one like the revolution pi which happily runs latest everything.

16

The C2-NRED module uses Node-RED version 3.0.
To use MySQL, take a look at the applications guide.

Regards,
Garry