aws lam nodejs mysql_mysql - 在笔记本电脑上运行时，nodeJS脚本可以连接到AWS MySQL Server，但在Amazon EC2实例上运行时，不能连接到AWS My...

我有以下脚本：const pug = require('pug');

var cloudinary = require('cloudinary');

var express = require('express');

var multer = require('multer');

var upload = multer({ dest: 'uploads/' });

var request = require('request');

var https = require('https');

var fs = require('fs');

var morgan = require('morgan');

var bodyParser = require('body-parser');

var mysql = require('mysql');

var JSON = require('JSON');

var bluebird = require('bluebird');

var databaseConnection = mysql.createConnection({

host : 'assignment3cloud.cfavdkskfrrc.us-west-2.rds.amazonaws.com',

port: 3306,

user : '<>',

password : '<>',

database : 'assign3'

});

databaseConnection .connect(function(err){

if(!err) {

console.log("Database is connected ... \n\n");

} else {

console.log(err);

console.log("Error connecting database ... \n\n");

}

});

当我在笔记本电脑上运行此脚本时，它运行正常。

在Amazon EC2 Ubuntu实例上运行它时，出现以下错误：

{ [Error: connect ETIMEDOUT]

errorno: 'ETIMEDOUT',

code: 'ETIMEDOUT',

syscall: 'connect',

fatal: true }

Error connecting database ...

/home/ubuntu/home/skrpt.js:38

if (error) throw error;

^

Error: connect ETIMEDOUT

at Connection._handleConnectTimeout (/home/ubuntu/home/node_modules/mysql/lib/Connection.js:419:13)

at Socket.g (events.js:260:16)

at emitNone (events.js:67:13)

at Socket.emit (events.js:166:7)

at Socket._onTimeout (net.js:318:8)

at _runOnTimeout (timers.js:524:11)

at _makeTimerTimeout (timers.js:515:3)

at Timer.unrefTimeout (timers.js:584:5)

--------------------

at Protocol._enqueue (/home/ubuntu/home/node_modules/mysql/lib/protocol/Protocol.js:141:48)

at Protocol.handshake (/home/ubuntu/home/node_modules/mysql/lib/protocol/Protocol.js:52:41)

at Connection.connect (/home/ubuntu/home/node_modules/mysql/lib/Connection.js:130:18)

at Object. (/home/ubuntu/home/skrpt.js:27:22)

at Module._compile (module.js:410:26)

at Object.Module._extensions..js (module.js:417:10)

at Module.load (module.js:344:32)

at Function.Module._load (module.js:301:12)

at Function.Module.runMain (module.js:442:10)

at startup (node.js:136:18)

at node.js:966:3

我的猜测是，为了使数据库与EC2服务器对话，还有一些其他的安全要求。我能做什么？

最佳答案

您可能必须在实例的入站安全规则中添加MYSQL端口(当您在带有aws实例的页面上时，向右水平滚动)。