[-] Pigsty is starting up... [-] Starting monitoring: /var/log/snort/snort.unified2.1378453396 { timestamp: 1378453396000, filename: 'snort.unified2.1378453396', position: 0 } dex: 0, state: 'start', stmt: '', params: [], start: [Function], execute_ok: [Function], fields: [Function], binrow: [Function], command_name: 'execute_prepared', args: [ 'select sid from sensor where hostname = ? and interface = COALESCE(?, interface) and COALESCE(filter, -1) = COALESCE(?, filter, -1) and COALESCE(encoding, -1) = COALESCE(?, encoding, -1) and COALESCE(detail, -1) = COALESCE(?, detail, -1) LIMIT 1', [ 'Sagan 192.168.1.18', 'eth0', null, null, null ] ], client: { queued_cmds: { begin: [Object], end: [Object], length: 3 }, connection: { _connecting: false, _handle: null, _readableState: [Object], readable: false, domain: null, _events: [Object], _maxListeners: 10, _writableState: [Object], writable: false, allowHalfOpen: false, onend: null, destroyed: true, errorEmitted: true, bytesRead: 0, _bytesDispatched: 0, _pendingData: null, _pendingEncoding: '', buffer: '', pscache: {}, _idleNext: null, _idlePrev: null, _idleTimeout: -1, pipe: [Function], addListener: [Function], on: [Function], pause: [Function], resume: [Function], read: [Function], _consuming: true }, settings: { row_as_hash: true, auto_prepare: true }, auth: [Function], close: [Function], end: [Function], query: [Function], prepare: [Function], execute: [Function], debug: [Function], ping: [Function], auto_prepare: true, test: [Function], _pool_id: 'pool_id_8', exec: [Function], _active_query: [Circular] }, connection: { _connecting: false, _handle: null, _readableState: { highWaterMark: 16384, buffer: [], length: 0, pipes: null, pipesCount: 0, flowing: false, ended: false, endEmitted: false, reading: true, calledRead: true, sync: false, needReadable: true, emittedReadable: false, readableListening: false, objectMode: false, defaultEncoding: 'utf8', ranOut: false, awaitDrain: 0, readingMore: false, decoder: [Object], encoding: 'binary' }, readable: false, domain: null, _events: { end: [Object], finish: [Function: onSocketFinish], _socketEnd: [Function: onSocketEnd], data: [Function], readable: [Function], connect: [Object], authorized: [Function], error: [Function] }, _maxListeners: 10, _writableState: { highWaterMark: 16384, objectMode: false, needDrain: false, ending: false, ended: false, finished: false, decodeStrings: false, defaultEncoding: 'utf8', length: 0, writing: false, sync: true, bufferProcessing: false, onwrite: [Function], writecb: null, writelen: 0, buffer: [] }, writable: false, allowHalfOpen: false, onend: null, destroyed: true, errorEmitted: true, bytesRead: 0, _bytesDispatched: 0, _pendingData: null, _pendingEncoding: '', buffer: '', pscache: {}, _idleNext: null, _idlePrev: null, _idleTimeout: -1, pipe: [Function], addListener: [Function], on: [Function], pause: [Function], resume: [Function], read: [Function], _consuming: true }, _events: { error: [Function], row: [Function], end: [Function] } } Unable to execute: select sid from sensor where hostname = ? and interface = COALESCE(?, interface) and COALESCE(filter, -1) = COALESCE(?, filter, -1) and COALESCE(encoding, -1) = COALESCE(?, encoding, -1) and COALESCE(detail, -1) = COALESCE(?, detail, -1) LIMIT 1 retrying: 3 connection error: pool_id_0 { [Error: connect ECONNREFUSED] code: 'ECONNREFUSED', errno: 'ECONNREFUSED', syscall: 'connect' } undefined { fieldindex: 0, state: 'start', stmt: '', params: [], start: [Function], execute_ok: [Function], fields: [Function], binrow: [Function], command_name: 'execute_prepared', args: [ 'select sig_id, sig_sid, sig_name, sig_gid, sig_rev from signature', [] ], client: { queued_cmds: { begin: [Object], end: [Object], length: 3 }, connection: { _connecting: false, _handle: null, _readableState: [Object], readable: false, domain: null, _events: [Object], _maxListeners: 10, _writableState: [Object], writable: false, allowHalfOpen: false, onend: null, destroyed: true, errorEmitted: true, bytesRead: 0, _bytesDispatched: 0, _pendingData: null, _pendingEncoding: '', buffer: '', pscache: {}, _idleNext: null, _idlePrev: null, _idleTimeout: -1, pipe: [Function], addListener: [Function], on: [Function], pause: [Function], resume: [Function], read: [Function], _consuming: true }, settings: { row_as_hash: true, auto_prepare: true }, auth: [Function], close: [Function], end: [Function], query: [Function], prepare: [Function], execute: [Function], debug: [Function], ping: [Function], auto_prepare: true, test: [Function], _pool_id: 'pool_id_0', exec: [Function], _active_query: [Circular] }, connection: { _connecting: false, _handle: null, _readableState: { highWaterMark: 16384, buffer: [], length: 0, pipes: null, pipesCount: 0, flowing: false, ended: false, endEmitted: false, reading: true, calledRead: true, sync: false, needReadable: true, emittedReadable: false, readableListening: false, objectMode: false, defaultEncoding: 'utf8', ranOut: false, awaitDrain: 0, readingMore: false, decoder: [Object], encoding: 'binary' }, readable: false, domain: null, _events: { end: [Object], finish: [Function: onSocketFinish], _socketEnd: [Function: onSocketEnd], data: [Function], readable: [Function], connect: [Object], authorized: [Function], error: [Function] }, _maxListeners: 10, _writableState: { highWaterMark: 16384, objectMode: false, needDrain: false, ending: false, ended: false, finished: false, decodeStrings: false, defaultEncoding: 'utf8', length: 0, writing: false, sync: true, bufferProcessing: false, onwrite: [Function], writecb: null, writelen: 0, buffer: [] }, writable: false, allowHalfOpen: false, onend: null, destroyed: true, errorEmitted: true, bytesRead: 0, _bytesDispatched: 0, _pendingData: null, _pendingEncoding: '', buffer: '', pscache: {}, _idleNext: null, _idlePrev: null, _idleTimeout: -1, pipe: [Function], addListener: [Function], on: [Function], pause: [Function], resume: [Function], read: [Function], _consuming: true }, _events: { error: [Function], row: [Function], end: [Function] } } Unable to execute: select sig_id, sig_sid, sig_name, sig_gid, sig_rev from signature retrying: 1 /usr/local/lib/node_modules/pigsty-mysql/lib/pigsty-mysql/signatures.js:120 event.classification.severity, ^ TypeError: Cannot read property 'severity' of undefined at /usr/local/lib/node_modules/pigsty-mysql/lib/pigsty-mysql/signatures.js:120:29 at /usr/local/lib/node_modules/pigsty-mysql/lib/pigsty-mysql/query.js:215:16 at cmd. (/usr/local/lib/node_modules/pigsty-mysql/lib/pigsty-mysql/query.js:255:16) at cmd.EventEmitter.emit (events.js:95:17) at cmd.process_packet (/usr/local/lib/node_modules/pigsty-mysql/node_modules/mysql-native/lib/mysql-native/command.js:51:11) at SocketClient.dispatch_packet (/usr/local/lib/node_modules/pigsty-mysql/node_modules/mysql-native/lib/mysql-native/socketclient.js:104:32) at Socket. (/usr/local/lib/node_modules/pigsty-mysql/node_modules/mysql-native/lib/mysql-native/socketclient.js:58:18) at Socket.EventEmitter.emit (events.js:95:17) at Socket. (_stream_readable.js:736:14) at Socket.EventEmitter.emit (events.js:92:17)