No "on" method for pool object

[shaalin]

I am seeing this issue using "2.0.0-alpha8".

Code Snippet :

var config = app.get('config');
this.pool = mysql.createPool(config.database.options);
this.pool.on('connection', function(err, connection){
    connection.query('some session related query');
})
var self = this;
this.pool.getConnection(function(err, connection) {
    if (!err) {
        callback(null);
    } else {
        callback(err);
    }
});

[apparatusdeus]

Pool.on is inherited from EventEmitter part of node.js standard library 'events' and is inherited using 'inherit' from the node.js standard library 'util'. I would hazard a guess that you need to update your version of Node.js

[euglv]

I installed the latest node.js recently (0.10.17) and have the same issue.

[euglv]

There is no "on" method in the documentation for 2.0.0-alpha8 version:
https://github.com/felixge/node-mysql/tree/v2.0.0-alpha8

So to use this method you need to download master branch of node-mysql.

[dougwilson]

This issue can be closed. The reason you are getting the error is because you are not using at least v2.0.0-alpha9 as before then, the pool object was not an event emitter, so it had no on method.

[kai-koch]

Feel free to reopen, if your problem still exists.