Re: AANVAL or MYSQL question

["Gierczak, Stan" <SGierczak () presencehealth org>]

So,  do I need to be concerned with:
[Description: cid:image001.png@01CF595C.E309FE60]

Also how can I see if the db is getting data into it?

Stanley Gierczak
Lead Network Engineer

Presence Health
1100 Elmhurst Rd. | Elkgrove Village, Il 60007
Office: 847.390.3874 | Fax: 847.390.1905
sgierczak () presencehealth org<mailto:sgierczak () presencehealth org>
www.presencehealth.org<http://www.presencehealth.org/>


Confidentiality notice: This email message, including any attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. All personal messages express views solely of the sender, 
which are not to be attributed to Presence Health. Unauthorized review, use, disclosure or distribution is prohibited. 
If you are not the intended recipient, please contact the sender by reply mail and destroy all copies of the original 
message.


From: Y M [mailto:snort () outlook com]
Sent: Wednesday, April 16, 2014 12:03 PM
To: Gierczak, Stan
Cc: snort-users
Subject: RE: [Snort-users] AANVAL or MYSQL question

> The only error I see is about WALDO.  Not sure if that is an issue or not.

This is a rather warning than error. Barnyard2 will check if the waldo file exists, if it does not, then Barnyard2 will 
warn you about it and create the waldo file for you.

> Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Waiting for new data

This means that Barnyard2 is up and running and waiting for u2 data to read.

YM

________________________________
From: SGierczak () presencehealth org
To: snort-users () lists sourceforge net
Date: Wed, 16 Apr 2014 15:19:25 +0000
Subject: [Snort-users] AANVAL or MYSQL question
I have just finished installing snort/barnyard/aanval.
I can see that snort is working.  I see messages queuing in the alert file in /var/log/snort/eth0.
Not sure if barnyard is not populating mysql or if aanval is not working.
I got this message in aanval under configuration/snort module settings:
[cid:image001.png@01CF5976.5BE8CC30]

I verified that the db is correct as is the user name and password.

I have this in the syslog for when barnyard loads:
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]: Running in Continuous mode
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]:
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]:         --== Initializing Barnyard2 ==--
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]: Initializing Input Plugins!
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]: Initializing Output Plugins!
Apr 16 09:36:01 rlicsnortids1 barnyard2[1456]: Parsing config file "/etc/snort/barnyard.conf"
Apr 16 09:36:04 rlicsnortids1 barnyard2[1456]: Log directory = /var/log/snort/eth0
Apr 16 09:36:04 rlicsnortids1 barnyard2[1456]: Initializing daemon mode
Apr 16 09:36:04 rlicsnortids1 barnyard2[1456]: Daemon parent exiting
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Daemon initialized, signaled parent pid: 1456
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: PID path stat checked out ok, PID path set to /var/run/
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Writing PID "1457" to file "/var/run//barnyard2_NULL.pid"
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database: compiled support for (mysql)
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database: configured to use mysql
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database: schema version = 107
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:           host = localhost
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:           user = snort_user
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:  database name = snortdb
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:    sensor name = rlicsnortids1:NULL
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:      sensor id = 1
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:     sensor cid = 1
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:  data encoding = hex
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:   detail level = full
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database:     ignore_bpf = no
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: database: using the "log" facility
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]:
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]:         --== Initialization Complete ==--
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Barnyard2 initialization completed successfully (pid=1457)
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: WARNING: Unable to open waldo file '/var/log/snort/eth0/barnyard2.waldo' 
(No such file or directory)
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Opened spool file '/var/log/snort/eth0/snort.log.1397656582'
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Closing spool file '/var/log/snort/eth0/snort.log.1397656582'. Read 0 
records
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Opened spool file '/var/log/snort/eth0/snort.log.1397658954'
Apr 16 09:36:04 rlicsnortids1 barnyard2[1457]: Waiting for new data

The only error I see is about WALDO.  Not sure if that is an issue or not.

Again thanks everyone for all the help.

------------------------------------------------------------------------------ Learn Graph Databases - Download FREE 
O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three 
acclaimed leaders in the field, this first edition is now available. Download your free book today! 
http://p.sf.net/sfu/NeoTech
_______________________________________________ Snort-users mailing list Snort-users () lists sourceforge 
net<mailto:Snort-users () lists sourceforge net> Go to this URL to change user options or unsubscribe: 
https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: 
http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users Please visit http://blog.snort.org to stay current 
on all the latest Snort news!

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users

Please visit http://blog.snort.org to stay current on all the latest Snort news!