当我尝试连接到google cloud的mysql数据库时,它显示此错误connect ETIMEDOUT加上undefined消息。这个错误花了很多天,我想不出解决这个问题的办法是什么。我过去没有这种语言的经验。
当我详细打开此错误时,它显示以下内容:
{ Error: connect ETIMEDOUT
at Connection._handleConnectTimeout (/srv/node_modules/mysql/lib/Connection.js:409:13)
at Object.onceWrapper (events.js:313:30)
at emitNone (events.js:106:13)
at Socket.emit (events.js:208:7)
at Socket._onTimeout (net.js:422:8)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (/srv/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Protocol.handshake (/srv/node_modules/mysql/lib/protocol/Protocol.js:51:23)
at Connection.connect (/srv/node_modules/mysql/lib/Connection.js:116:18)
at Promise (/srv/index.js:34:19)
at new Promise (<anonymous>)
at connectToDatabase (/srv/index.js:33:12)
at handleReadFromMySQL (/srv/index.js:52:12)
at WebhookClient.handleRequest (/srv/node_modules/dialogflow-fulfillment/src/dialogflow-fulfillment.js:303:44)
at exports.dialogflowFirebaseFulfillment.functions.https.onRequest (/srv/index.js:104:9)
at cloudFunction (/srv/node_modules/firebase-functions/lib/providers/https.js:57:9)
errorno: 'ETIMEDOUT',
code: 'ETIMEDOUT',
syscall: 'connect',
fatal: true }
请帮我从数据库中检索数据。我提到了这个教程https://www.youtube.com/watch?v=v7k5vckSzNo&t=892s,我也在评论区问了我的问题,但没有得到他们的回复。
这是我的index.js文件
// See https://github.com/dialogflow/dialogflow-fulfillment-nodejs
// for Dialogflow fulfillment library docs, samples, and to report issues
'use strict';
const functions = require('firebase-functions');
const {WebhookClient} = require('dialogflow-fulfillment');
const {Card, Suggestion} = require('dialogflow-fulfillment');
const mysql = require('mysql');
process.env.DEBUG = 'dialogflow:debug'; // enables lib debugging statements
exports.dialogflowFirebaseFulfillment = functions.https.onRequest((request, response) => {
const agent = new WebhookClient({ request, response });
console.log('Dialogflow Request headers: ' + JSON.stringify(request.headers));
console.log('Dialogflow Request body: ' + JSON.stringify(request.body));
function welcome(agent) {
agent.add(`Welcome to my agent!`);
}
function fallback(agent) {
agent.add(`I didn't understand`);
agent.add(`I'm sorry, can you try again?`);
}
function connectToDatabase(){
const connection = mysql.createConnection({
host : '34.93.236.175',
user : 'root',
password : '',
database : 'django_db',
});
return new Promise((resolve,reject) => {
connection.connect();
resolve(connection);
});
}
function queryDatabase(connection) {
return new Promise((resolve,reject) => {
connection.query('SELECT * from web_user',(error, results, fields) => {
console.log("result console");
console.log(results);
console.log(fields);
console.log(error);
resolve(results);
});
});
}
function handleReadFromMySQL(agent){
return connectToDatabase()
.then(connection => {
return queryDatabase(connection)
.then(result => {
console.log(result);
connection.end();
}).catch(error => {
console.log("error");
console.log(error);
connection.end();
});
}).catch(error=>{
console.log(error);
});
}
// // Uncomment and edit to make your own intent handler
// // uncomment `intentMap.set('your intent name here', yourFunctionHandler);`
// // below to get this function to be run when a Dialogflow intent is matched
// function yourFunctionHandler(agent) {
// agent.add(`This message is from Dialogflow's Cloud Functions for Firebase editor!`);
// agent.add(new Card({
// title: `Title: this is a card title`,
// imageUrl: 'https://developers.google.com/actions/images/badges/XPM_BADGING_GoogleAssistant_VER.png',
// text: `This is the body text of a card. You can even use line\n breaks and emoji! `,
// buttonText: 'This is a button',
// buttonUrl: 'https://assistant.google.com/'
// })
// );
// agent.add(new Suggestion(`Quick Reply`));
// agent.add(new Suggestion(`Suggestion`));
// agent.setContext({ name: 'weather', lifespan: 2, parameters: { city: 'Rome' }});
// }
// // Uncomment and edit to make your own Google Assistant intent handler
// // uncomment `intentMap.set('your intent name here', googleAssistantHandler);`
// // below to get this function to be run when a Dialogflow intent is matched
// function googleAssistantHandler(agent) {
// let conv = agent.conv(); // Get Actions on Google library conv instance
// conv.ask('Hello from the Actions on Google client library!') // Use Actions on Google library
// agent.add(conv); // Add Actions on Google library responses to your agent's response
// }
// // See https://github.com/dialogflow/fulfillment-actions-library-nodejs
// // for a complete Dialogflow fulfillment library Actions on Google client library v2 integration sample
// Run the proper function handler based on the matched Dialogflow intent name
let intentMap = new Map();
intentMap.set('Default Welcome Intent', welcome);
intentMap.set('Default Fallback Intent', fallback);
intentMap.set('getDataFromMySQL', handleReadFromMySQL);
// intentMap.set('your intent name here', yourFunctionHandler);
// intentMap.set('your intent name here', googleAssistantHandler);
agent.handleRequest(intentMap);
});
package.json文件
{
"name": "dialogflowFirebaseFulfillment",
"description": "This is the default fulfillment for a Dialogflow agents using Cloud Functions for Firebase",
"version": "0.0.1",
"private": true,
"license": "Apache Version 2.0",
"author": "Google Inc.",
"engines": {
"node": "8"
},
"scripts": {
"start": "firebase serve --only functions:dialogflowFirebaseFulfillment",
"deploy": "firebase deploy --only functions:dialogflowFirebaseFulfillment"
},
"dependencies": {
"actions-on-google": "^2.2.0",
"firebase-admin": "^5.13.1",
"firebase-functions": "^2.0.2",
"dialogflow": "^0.6.0",
"dialogflow-fulfillment": "^0.5.0",
"mysql": "2.18.1",
"firebase-tools" : "7.16.1"
}
}
非常感谢您的帮助,这是我最后一年项目的一部分。此外,我还必须在数据库上执行插入、更新和删除操作。
发布于 2020-04-02 03:24:36
在createConnection方法中,而不是主机
host : '34.93.236.175',
user : 'root',
password : '',
database : 'django_db'
像这样使用socketpath
/cloudsql/isntance connection-name,它将连接到我的数据库
socketPath: '/cloudsql/charbot2-ivjagp:asia-south1:auction-instance',
user : 'root',
password : '',
database : 'django_db'
很抱歉给您带来不便,囚犯先生,我的朋友分享了这个解决方案,所以我在这里分享,这样其他人就不会在这些错误上花费时间
发布于 2020-03-31 19:01:02
诊断确切的问题有点困难,因为我们不知道您的MySQL服务器的配置,但从广义上讲,这个错误是因为网络中有一些配置阻止了连接。
即刻,我可以想到几个可能的地方去寻找:
https://stackoverflow.com/questions/60933582
复制相似问题