node2mysql

wss2mysql gateway

This is a simple secure webscoket to mysql gateway.

Use to run stored procedures from a secure weboskcet client on mysql.

For security reasons, only procedures are allowed.

See the source on index.js, the index.js has a complete example for a client and server implementation.

How to Test

Fist, set all ENV vars before runing the index.js Example:

#!/bin/bash 
export WEBSOCKET_CLIENT_HOST = 'localhost';
export WEBSOCKET_PROTOCOL = 'ws2mysql-protocol';
export WEBSOCKET_PORT = 3001;
export WEBSOCKET_CERT_FILE = '/etc/ssl/certs/ssl-cert-snakeoil.pem';
export WEBSOCKET_CERT_KEY = '/etc/ssl/private/ssl-cert-snakeoil.key';
export WEBSOCKET_CERT_CA = '';
export MYSQL_HOST = 'localhost';
export MYSQL_USER = 'root';
export MYSQL_PASSWORD = '';
export MYSQL_DB = 'test';
export MYSQL_PORT = '3306';
nodejs ./index.js

How to run from a websocket client:

Just send the following message via websocket to this server:

const message = '{"proc":"PROCEDURE_NAME","callback":"ON_MYSQL_DATA","args":["[e-mail]","PASS"]}';

The server will respond to websocket client with with:

const respons = '{"proc":"PROCEDURE_NAME","callback":"ON_MYSQL_DATA","args":[{"id":2,"name":"test","email":"[e-mail]","pass":"test"}]}';