pigsty-mysql

library0.1.6jsnpmunverified

A MySQL output plugin for Pigsty, a system for processing and storing security events. This package (v0.1.6) allows Pigsty to insert events into a MySQL database. It is part of a broader ecosystem but has known issues with reconnection and missing table insertions. The project appears to be abandoned with no updates since 2013.

storage

npm install pigsty-mysql

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · PIGSTY-MYSQL

pigsty-mysql

storagejavascriptv0.1.6

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

pigsty-mysql

✓ No import needed; plugin loaded via configuration

✗ const pigstyMysql = require('pigsty-mysql')

This is a Pigsty plugin, not a library. It is configured in pigsty.config.js under output.mysql.

Shows global installation and configuration for the MySQL output plugin.

// Install globally npm install pigsty-mysql -g // Configure in /etc/pigsty/pigsty.config.js output: { mysql: { user: 'root', password: 'password', host: '127.0.0.1', database: 'snorby' } }

Debug

Known issues

gotchaMySQL reconnection not handled; plugin may fail silently on connection loss.

fix

Implement custom reconnection logic or use a wrapper.

affects: >=0.0.0

gotchatcp options table not being inserted; incomplete data storage.

fix

Manually create the missing table or patch the plugin.

affects: >=0.0.0

gotchaInserts into UTC by default; localtime option must be explicitly set to true for local time.

fix

Set localtime: true in config if local timestamps are desired.

affects: >=0.0.0

breakingPackage is no longer maintained since 2013; no support for modern MySQL or Node.js versions.

fix

Consider using an alternative or updating the codebase.

affects: >=0.0.0

Errors

Common errors & fixes

Error: Cannot find module 'pigsty'

Pigsty core not installed or not in require path

fix

Install pigsty globally: npm install pigsty -g

Error: connect ECONNREFUSED 127.0.0.1:3306

MySQL server not running or host/port incorrect

fix

Start MySQL service or check connection settings.

Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'user'@'localhost'

Invalid MySQL credentials configured

fix

Verify user and password in pigsty.config.js.

Upgrade

Version history

0.1.6latest on npm

Audit

Dependencies

pigstyrequiredCore framework required for the plugin to function

mysqlrequiredMySQL driver for database connections

Agent activity

12 hits · last 30 days

node

Amazon

OpenAI (training)

Resources

githubhttps://github.com/threatstack/pigsty-plugin ↗

packagepigsty-mysql ↗

homepagehttps://github.com/threatstack/pigsty-plugin ↗