Yeoman Error: self signed certificate in certificate chain code: 'SELF_SIGNED_CERT_IN_CHAIN'

Question

I am creating Add-in to excel using Yeoman generation in Windows 10.
After installing Yeoman by npm install -g yo generator-office, and call the Yeoman with yo office > select Excel Custom Functions using a Shared Runtime > Choose script type as Javascrip > Input my add-in name

I got the error shows:

Unable to download project zip file for "https://github.com/OfficeDev/Excel-Custom-Functions-JS/archive/shared-runtime-yo-office.zip".
Error: self signed certificate in certificate chain

ApplicationInsights:CorrelationIdManager [
  Error: self signed certificate in certificate chain
      at TLSSocket.onConnectSecure (node:_tls_wrap:1535:34)
      at TLSSocket.emit (node:events:513:28)
      at TLSSocket.emit (node:domain:489:12)
      at TLSSocket._finishInit (node:_tls_wrap:949:8)
      at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:730:12)
      at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
    code: 'SELF_SIGNED_CERT_IN_CHAIN'
  }
]

I have tried to use the command: npm set strict-ssl false npm config set ca=""

these two commands didn't return any feedback

and I also tried: npm install npm -g --ca=null and got the error

npm ERR! code ERR_INVALID_ARG_TYPE
npm ERR! The "options.ca" property must be of type string or an instance of Buffer, TypedArray, or DataView. Received null

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\Hlin\AppData\Local\npm-cache\_logs\2022-10-10T15_23_25_509Z-debug-0.log

I tried to restart the command prompt, and recall the yo office, it would directly show the previous error, it would start from here:

? Choose a project type: (Use arrow keys)
> Office Add-in Task Pane project
  Office Add-in Task Pane project using React framework
  Office Add-in Task Pane project using Angular framework
  Excel Custom Functions using a Shared Runtime
  Excel Custom Functions using a JavaScript-only Runtime
  Office Add-in Task Pane project supporting single sign-on (localhost)
  Outlook Add-in with Teams Manifest (Developer preview)
(Move up and down to reveal more choices)ApplicationInsights:CorrelationIdManager [
  Error: self signed certificate in certificate chain
      at TLSSocket.onConnectSecure (node:_tls_wrap:1535:34)
      at TLSSocket.emit (node:events:513:28)
      at TLSSocket.emit (node:domain:489:12)
      at TLSSocket._finishInit (node:_tls_wrap:949:8)
      at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:730:12)
      at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
    code: 'SELF_SIGNED_CERT_IN_CHAIN'
  }
]

How can I solve this issue and continue to develop the add-in. Thanks a lot!

Yeoman Error: self signed certificate in certificate chain code: 'SELF_SIGNED_CERT_IN_CHAIN'

0 Answers0