Issue with Load Balancer - HAProxy, PorxySQL

[mineexchange89]

Hello Team,

I am trying to connect MariaDB database via load balancer but getting below error.

node -v
v8.11.3
node mariasql_demo.js
events.js:183
      throw er; // Unhandled 'error' event
     ^
Error: Host '192.168.5.13' is not allowed to connect to this MariaDB server

Code :

var Client = require('mariasql');
var c = new Client({
  host: "xxx.xxx.xxx.xxx",
  port: "3307",
  database: "test_db",
  user: "test_usr",
  password: "******"
});
c.query('SHOW DATABASES', function(err, rows) {
  if (err)
    throw err;
  console.dir(rows);
});
c.end();

And when i am trying with mysql its working fine with load balncer.