first attempt reading mysql inside openwhisk using node.js (note: mysql is running in openshift; so is openwhisk)

index.js

function helloworld(params) {

    return new Promise(function (resolve, reject ) {
        // Default values set here
        let name = params.name || 'stranger';
        getGreeting(name, value => {
        resolve({message: value});
        })
    })
};

function getGreeting(name, callback) {
    const format = require('string-format');
    const mysql  = require('mysql');

    // Get special greeting from database here
    const dbconn = mysql.createConnection({
        host:     'mysql',
        user:     'myuser',
        password: 'myuser',
        database: 'mydb'
    });

    // Default greeting
    var greeting = "Hello";
    try {
        dbconn.connect((err) => {
            if (err) {
            }
        });
    } catch (error) {
    }

    try {
            var qry = format('SELECT custom_greeting FROM personal_greeting WHERE first_name = "{}";', name);
            dbconn.query(qry, (err,rows) => {
                if ( rows.length > 0 ) {
                    greeting = rows[0].custom_greeting;
                }
                return callback(format(greeting + ", {}", name));
            });
        } catch (error) {
        };
        dbconn.end;
    }

exports.main = helloworld;