René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error when trying to pool socks stream connections ","articleBody":"I'm trying to pool socks stream connections.\n\nSample code here:\n\n``` javascript\nvar mysql2 = require('mysql2');\nvar SocksConnection = require('socksjs');\n\nvar mysql_server_options = {\n  host: 'database.ho.st',\n  port: 3306\n};\n\nvar socks_options = {\n  host: 'proxy.ho.st',\n  port: 1080,\n  user: 'proxy_username',\n  pass: 'proxy_password'\n};\n\nvar socksConn = new SocksConnection(mysql_server_options, socks_options);\n\nvar mysql_options =  {\n  database: 'db_name',\n  user: 'db_username',\n  password: 'secret',\n  stream: socksConn\n}\n\nvar mysqlConnPool = mysql2.createPool(mysql_options);\n\nmysqlConnPool.getConnection(function (err, connection) {\n\n  if (err) {\n    return callback(err);\n  }\n  // Use the connection\n  connection.query('SELECT 1+1 as test1;', function (err, rows, fields) {\n\n  // And done with the connection.\n  if (err) throw err;\n\n  console.log('Result: ', rows);\n\n  connection.release();\n  socksConn.dispose();\n  mysqlConnPool.end();\n  });\n});\n```\n\nBut I'm getting this error log:\n\n```\n09:40:00 web.1  | TypeError: Cannot call method 'execute' of null\n09:40:00 web.1  |     at PoolConnection.Connection.handlePacket (/Users/me/project/node_modules/mysql2/lib/connection.js:262:28)\n09:40:00 web.1  |     at PacketParser.execute (/Users/me/project/node_modules/mysql2/lib/packet_parser.js:40:21)\n09:40:00 web.1  |     at null.\u003canonymous\u003e (/Users/me/project/node_modules/mysql2/lib/connection.js:82:31)\n09:40:00 web.1  |     at EventEmitter.emit (events.js:95:17)\n09:40:00 web.1  |     at null.\u003canonymous\u003e (_stream_readable.js:746:14)\n09:40:00 web.1  |     at EventEmitter.emit (events.js:92:17)\n09:40:00 web.1  |     at emitDataEvents (_stream_readable.js:771:10)\n09:40:00 web.1  |     at Readable.on (_stream_readable.js:692:5)\n09:40:00 web.1  |     at PoolConnection.Connection (/Users/me/project/node_modules/mysql2/lib/connection.js:81:17)\n09:40:00 web.1  |     at new PoolConnection (/Users/me/project/node_modules/mysql2/lib/pool_connection.js:10:14)\n09:40:00 web.1  |     at Pool.getConnection (/Users/me/project/node_modules/mysql2/lib/pool.js:40:18)\n```\n\nIs my code is incorrect? More generally, are pooled custom stream connections normally supported? or is it specific to socks stream (my case)?\n\nThanks for your help.\n","author":{"url":"https://github.com/pierrickchabi","@type":"Person","name":"pierrickchabi"},"datePublished":"2014-02-05T08:51:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":10},"url":"https://github.com/80/node-mysql2/issues/80"}