首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >{错误: connect ETIMEDOUT at Connection._handleConnectTimeout and wierd undefined message

{错误: connect ETIMEDOUT at Connection._handleConnectTimeout and wierd undefined message
EN

Stack Overflow用户
提问于 2020-03-30 23:09:20
回答 2查看 3.2K关注 0票数 0

当我尝试连接到google cloud的mysql数据库时,它显示此错误connect ETIMEDOUT加上undefined消息。这个错误花了很多天,我想不出解决这个问题的办法是什么。我过去没有这种语言的经验。

当我详细打开此错误时,它显示以下内容:

代码语言:javascript
运行
复制
{ 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文件

代码语言:javascript
运行
复制
// 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文件

代码语言:javascript
运行
复制
{
  "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"
  }
}

非常感谢您的帮助,这是我最后一年项目的一部分。此外,我还必须在数据库上执行插入、更新和删除操作。

EN

回答 2

Stack Overflow用户

发布于 2020-04-02 03:24:36

在createConnection方法中,而不是主机

代码语言:javascript
运行
复制
      host     : '34.93.236.175',
      user     : 'root',
      password : '',
      database : 'django_db'

像这样使用socketpath

/cloudsql/isntance connection-name,它将连接到我的数据库

代码语言:javascript
运行
复制
      socketPath: '/cloudsql/charbot2-ivjagp:asia-south1:auction-instance',
      user     : 'root',
      password : '',
      database : 'django_db'

很抱歉给您带来不便,囚犯先生,我的朋友分享了这个解决方案,所以我在这里分享,这样其他人就不会在这些错误上花费时间

票数 2
EN

Stack Overflow用户

发布于 2020-03-31 19:01:02

诊断确切的问题有点困难,因为我们不知道您的MySQL服务器的配置,但从广义上讲,这个错误是因为网络中有一些配置阻止了连接。

即刻,我可以想到几个可能的地方去寻找:

  • 听起来您的实现是使用行内编辑器运行的。这使用Google Cloud Functions,因此函数中可能存在阻止网络连接的配置。
    • 注意到以前版本的内联编辑器使用Firebase Cloud Functions,这会阻止网络连接,除非您是付费套餐(即使您使用免费套餐)。我不认为Google Cloud Functions有同样的限制,但它may.

  • 您的MySQL/cpanel配置可能会限制您可以连接的位置。
  • 您可能安装了防火墙,不允许在mysql cpanel上进行连接您的MySQL配置可能正在监听不同于标准端口的端口。在这种情况下,您需要确保计算机上的端口已打开,防火墙将允许该端口通过,并且您的代码已配置为在该端口上进行连接。
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/60933582

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档