Resolved app fails after upgrade to node.js 18.8.0

[basdebruin]

Server operating system version

Ubuntu 20.04.5 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.45 Update #2

Hi All

When I upgrade to Node.js 18.8.0 (selecting this version in "Websites & Domains" > my domain > Node.js > Node.js Version) my app fails with:

Error: connect ECONNREFUSED ::1:3306 at PromisePool.query (/var/www/vhosts/excellent-team.nl/mondaydev.excellent-team.nl/excellent-monday/node_modules/mysql2/promise.js:341:22)

The app is unable to connect to MariaDB. When selecting Node.js Version 16.17.0 everything is working fine again.

Any steps I am missing for this upgrade?

 

[basdebruin]

Oops...solved it. With node 16.17 MariaDB accepts connections from "localhost". After upgrading to node 18.8 MariaDB doesn't allow connections from "localhost", need to use "127.0.0.1" instead.