我正在嘗試將我的 express js 應用程式部署到應用程式引擎，我也想將此應用程式引擎鏈接到 mysql 資料庫，但在連接到資料庫時出現此錯誤：
Error: connect ENOENT /cloudsql/********3li at PipeConnectWrap.afterConnect [as oncomplete] (net.js:1145:16)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] --------------------
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at Protocol._enqueue (/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at Protocol.handshake (/app/node_modules/mysql/lib/protocol/Protocol.js:51:23)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at PoolConnection.connect (/app/node_modules/mysql/lib/Connection.js:116:18)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at Pool.getConnection (/app/node_modules/mysql/lib/Pool.js:48:16)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at Pool.query (/app/node_modules/mysql/lib/Pool.js:202:8)
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at /app/api/routes/users.js:48:22
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] at processTicksAndRejections (internal/process/task_queues.js:97:5) {
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] errno: 'ENOENT',
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] code: 'ENOENT',
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] syscall: 'connect',
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] address: '/cloudsql/********3li ',
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] fatal: true
2021-10-15 08:46:41 appengineedokanapi[20211015t103941] }
我也在使用帶有 express js 的 node-mysql 庫
const pool = mysql.createPool({
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_DATABASE,
socketPath: `/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}`,
})
app.yaml 包含：
env_variables:
INSTANCE_CONNECTION_NAME : ********3li
DB_DATABASE : databaseName
DB_USER : databaseUser
DB_PASSWORD : *******
uj5u.com熱心網友回復：
正如 'blacknamefornow' 在評論中指出并由 mohamed-ali 確認，問題出INSTANCE_CONNECTION_NAME在app.yaml檔案中的env 變數中。
從參考此答案，格式應為{project-id}:europe-west1:{database}。
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/322890.html