search

firnsy / barnyard2

Barnyard2 is a dedicated spooler for Snort's unified2 binary output format.
GNU General Public License v2.0
344 stars 189 forks source link

Barnyard2 2.1.13 MySQL not connecting #242

Open jdpadro opened 5 years ago

jdpadro commented 5 years ago

I added the following line for sending alerts to a remote SQL server.

output database: log, mysql, user=snort dbname=nwsnort sensor_name=lrc-eno2 password=xxxxxxxxx host=x.x.x.43

output database: alert, mysql, user=snort dbname=nwsnort sensor_name=lrc-eno2 password=xxxxxxxxx host=x.x.x.43

Once I restart the service, I look a the log file and I see the following.

Here is what I see within the barnyard2.log file. INFO database: Defaulting Reconnect/Transaction Error limit to 10 INFO database: Defaulting Reconnect sleep time to 5 second INFO database: Defaulting Reconnect/Transaction Error limit to 10 INFO database: Defaulting Reconnect sleep time to 5 second

What may be the problem. I can connect to the remote MySQL server via the CLI and am able to connect. I can connect to the database and am able to sho w tables.

Any ideas???

Thank you