dimanche 9 août 2015

RDS mysql public database cannot connect from AWS Lambda

my RDS mysql public database instance can be connected from mysql clients. But when i trying the same in AWS Lambda it won't work. my code is given below.

console.log('Loading function');
var doc = require('dynamodb-doc');
var dynamo = new doc.DynamoDB();
var mysql = require('mysql');
exports.handler = function(event, context) {
//console.log('Received event:', JSON.stringify(event, null, 2));  
var operation = event.operation;
delete event.operation;
switch (operation) {
case 'create':
var conn = mysql.createConnection({
host      :  'lamdatest.********.rds.amazonaws.com' ,  // RDS endpoint 
user      :  'user' ,  // MySQL username 
password  :  'password' ,  // MySQL password 
database  :  'rdslamda' 
});
conn.connect();
console.log("connecting...");
conn.query ( 'INSERT INTO login (name,password) VALUES("use6","password6")' ,     function(err, info){
        console.log("insert: "+info.msg+" /err: "+err);
    });
console.log("insert values in to database");
break;
case 'read':
dynamo.getItem(event, context.done());
break;

default:
context.fail(new Error('Unrecognized operation "' + operation + '"'));

}
context.succeed();
};  




Aucun commentaire:

Enregistrer un commentaire