<?xml version="1.0"?>
<rss version="2.0"><channel><title>Discussing Manual Installation for Remote Node Logging to MySQL Latest Topics</title><link>https://www.winsnort.com/forum/34-discussing-manual-installation-for-remote-node-logging-to-mysql/</link><description>Discussing Manual Installation for Remote Node Logging to MySQL Latest Topics</description><language>en</language><item><title>Path issues</title><link>https://www.winsnort.com/topic/255-path-issues/</link><description><![CDATA[
<p>
	There are a couple of path adjustments in the procedure that seem to be not quite correct.
</p>

<p>
	#1: Original Line(s): var SO_RULE_PATH ../so_rules<br />
	Change to: # var SO_RULE_PATH ../so_rules
</p>

<p>
	This is not actually a change, since the two lines are identical. Presumably it's supposed to be 'd:\winids\Snort\so_rules'. Is that right?
</p>

<p>
	#2: Original Line(s): dynamicdetection directory /usr/local/lib/snort_dynamicrules<br />
	Change to: # dynamicdetection directory /usr/local/lib/snort_dynamicrules
</p>

<p>
	This is not actually a change, since the two lines are identical. And when I run the Snort test, I get this fatal error: 'ERROR: f:\winids\snort\etc\snort.conf(258) Could not stat dynamic module path "/usr/local/lib/snort_dynamicrules": No such file or directory.'
</p>

<p>
	I was going to change the path to 'f:\winids\snort\lib\snort_dynamicrules', bu that directory doesn't exist. Any ideas?<br />
	 
</p>
]]></description><guid isPermaLink="false">255</guid><pubDate>Sat, 28 Jan 2017 14:17:24 +0000</pubDate></item><item><title>Wrong file names?</title><link>https://www.winsnort.com/topic/254-wrong-file-names/</link><description><![CDATA[
<p>
	I'm at this step: 'Configuring Snort, the Heart of the Windows Intrusion Detection System (WinIDS)'.
</p>

<p>
	At this point there are two commands, the point of which seems to be to clear the blacklist and whitelist files that are included with Snort. Here's the first one:
</p>

<p>
	'type NUL &gt; d:\winids\snort\rules\black_list.rules'
</p>

<p>
	This actually creates a *new* file called 'black_list.rules', with no content (size zero).
</p>

<p>
	I think perhaps the intention was to clear the contents of the existing file, which is actually named 'blacklist.rules'.
</p>

<p>
	I don't see 'white_list.rules' or 'whitelist.rules', so the other command just creates an empty 'white_list.rules'.
</p>
]]></description><guid isPermaLink="false">254</guid><pubDate>Sat, 28 Jan 2017 13:50:53 +0000</pubDate></item><item><title>Missing steps related to MySQL?</title><link>https://www.winsnort.com/topic/252-missing-steps-related-to-mysql/</link><description><![CDATA[<p>
	I'm working through this tutorial and have hit a bit of a roadblock. Starting at 'Prepping the Windows Intrusion Detection System (WinIDS) Master Sensor', there seems to be an assumption that I already have mySQL installed, and that there's already a database called 'snort'. But I can't find anything in the tutorial about installing MySQL or creating that database or its tables. I checked the various scripts in the WinIDS package (winids-cssp-x64.zip), and didn't find anything there either. What am I missing?
</p>]]></description><guid isPermaLink="false">252</guid><pubDate>Wed, 25 Jan 2017 11:23:53 +0000</pubDate></item><item><title>Portqry missing from Winids downloads</title><link>https://www.winsnort.com/topic/253-portqry-missing-from-winids-downloads/</link><description><![CDATA[<p>
	I'm at the point in the tutorial where access to the master's MySQL server is tested. But the tool used (portqry) is nowhere to be found in the downloaded files (winids-cssp-x64.zip).
</p>]]></description><guid isPermaLink="false">253</guid><pubDate>Wed, 25 Jan 2017 11:49:38 +0000</pubDate></item><item><title>Snort behaviour when -p promiscuous mode is disabled</title><link>https://www.winsnort.com/topic/247-snort-behaviour-when-p-promiscuous-mode-is-disabled/</link><description><![CDATA[<div style="table-layout:fixed;width:1190px;line-height:1.6;color:rgb(39,42,52);font-size:14px;margin-bottom:20px;margin-top:0px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);">
	<p style="margin-top:0px;">
		Hello WinIDS community - again,
	</p>

	<p>
		Went through the <span> </span><a href="https://www.winsnort.com/tutorials/article/6-installing-a-slave-client-logging-events-to-a-remote-mysql-database/" rel="" style="color:rgb(173,20,87);text-decoration:none;background-color:rgb(249,249,249);font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:14px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;">Installing a slave client logging events to a remote MySQL Database</a><span> </span>tutorial. My remote WinIDS is running on server 2008 R2 and I have verified connectivity to Ubuntu server MySQL running 5.7.16 listening on port 3306. My hope is to use Snorby frontend running on the ubuntu 16.04 to read the mysql after Barnyard2 dumps the pcaps from snort into the DB.
	</p>

	<p>
		This is a change from the previous issues I was having to get the WINIDS / snort install working - As a general FYI I have validated that the referenced tutorial has been completed with the necessary modifications to my environment - i.e. Linux database / snorby  instead of Windows MySQL / Base. the Snort and Barnyard2 applications are configured to run as services from startup per instructions and Barnyard2 is able to communicate with the MySQL database Snorby on the Ubuntu server. The snorby front end is also functional from the perspective that one can login to the website and browse the settings and menu options.
	</p>

	<p>
		Issue: I'm running this configuration in a set of Amazon AWS EC2 instances. AWS does not allow networks connecting EC2 instances to run packet sniffing functions - i.e. promiscuous mode NIDS type of functions - to this end I'm ok if I can just capture traffic going to/from the box where snort is installed and pass that data via barnyard to the mysql db. 
	</p>

	<p>
		** First configuration - Snort cmd - this was before running with -p to disable promiscuous mode
	</p>

	<p>
		c:\IDS\Snort\bin\snort -c c:\IDS\Snort\etc\snort.conf -l c:\IDS\Snort\log -i1
	</p>

	<p>
		result - snort was listening but nothing was being dumped to the log files - merged,log-[timestamp] = 0 kb
	</p>

	<p>
		Barnyard2 is not reading or getting any of this data and is not sending the data to mysql db
	</p>

	<div style="table-layout:fixed;width:1190px;line-height:1.6;color:rgb(39,42,52);font-size:14px;margin-bottom:20px;margin-top:0px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);">
		<p>
			** 2nd configuration - Snort cmd - this was first attempt to disable promiscuous mode
		</p>

		<p>
			c:\IDS\Snort\bin\snort -dev -b -l c:\IDS\Snort\log -i 1 -E -U -p -c c:\IDS\Snort\etc\snort.conf
		</p>

		<p>
			result - snort was listening but little was being dumped to the log files - merged.log-[timestamp] = 1 kb CMD window screen goes crazy cause there is lots of network traffic data being posted to the stdout Windows instance becomes slow to respond to anything other than snort window. barnyard was tracking merged.log file but no data was transferred.
		</p>

		<p>
			Test rules were inserted in local.rules file:
		</p>

		<p>
			alert icmp -&gt; any any -&gt; any any (msg:"ICMP Testing Rule"; sid:1000001; rev:1;)
		</p>

		<p>
			alert tcp -&gt; any any -&gt; any 80 (msg:"TCP Testing Rule"; sid:1000002; rev:1;)
		</p>

		<p>
			alert udp -&gt; any any -&gt; any any (msg:"UDP Testing Rule"; sid:1000003; rev:1;)
		</p>

		<p>
			I added google's ip address to the black_list.rules file
		</p>

		<p>
			Barnyard2 seemed more responsive - its stdout was tracking the merged.log file but not reading or getting any of this data and is not sending the data to mysql db
		</p>

		<p>
			** 3rd configuration - Snort cmd - this was 2nd attempt to disable promiscuous mode
		</p>

		<p>
			c:\IDS\Snort\bin\snort -dev -b -l c:\IDS\Snort\log -i 1 -E -U -p
		</p>

		<p>
			note: removed '-c c:\IDS\Snort\etc\snort.conf' from CMD line
		</p>

		<p>
			result - snort was listening the log files began growing fast - merged.log-[timestamp] = 3,072 kb CMD window screen is not posting network traffic data - warning is posted to the stdout.  "No preprocessors configured for policy 0" Windows instance is not slow to respond at this time. barnyard2 was not able to find or create a new barnyard2.waldo file (i deleted all files in directory before running 3rd configuration) another error from stdout - "(snort_decoder) WARNING: IP dgm len &lt; IP Hdr len"
		</p>

		<p>
			Test rules were inserted in local.rules file:
		</p>

		<p>
			alert icmp -&gt; any any -&gt; any any (msg:"ICMP Testing Rule"; sid:1000001; rev:1;)
		</p>

		<p>
			alert tcp -&gt; any any -&gt; any 80 (msg:"TCP Testing Rule"; sid:1000002; rev:1;)
		</p>

		<p>
			alert udp -&gt; any any -&gt; any any (msg:"UDP Testing Rule"; sid:1000003; rev:1;)
		</p>

		<p>
			I added google's ip address to the black_list.rules file
		</p>

		<p>
			Barnyard2 is not reading or getting any of this data and is not sending the data to mysql db
		</p>

		<p>
			At this point I don't know what to expect from the application based on the limitations I have in this environment. I'm not sure if I should change the CMD switches I have set or if my logs are even being output to unified2 (due to the exclusion of the conf file I'm not sure) current merged.log opened in notepad++ reads NUL about a gazillion times a a bunch of non-standard characters.
		</p>

		<p>
			Thoughts and input are welcome and greatly appreciated.
		</p>

		<p>
			Thanks,
		</p>

		<p>
			JVinson
		</p>
	</div>
</div>]]></description><guid isPermaLink="false">247</guid><pubDate>Tue, 27 Dec 2016 22:06:52 +0000</pubDate></item><item><title>Barnyard2 / snort merged.log file misconfig</title><link>https://www.winsnort.com/topic/243-barnyard2-snort-mergedlog-file-misconfig/</link><description><![CDATA[
<p>
	Hello WinIDS community,
</p>

<p>
	Went through the  <a href="https://www.winsnort.com/tutorials/article/6-installing-a-slave-client-logging-events-to-a-remote-mysql-database/" style="color:rgb(173,20,87);text-decoration:none;background-color:rgb(249,249,249);font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:14px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;" rel="">Installing a slave client logging events to a remote MySQL Database</a> tutorial. My remote WinIDS is running on server 2008 R2 and I have verified connectivity to Ubuntu server MySQL running 5.7.16 listening on port 3306. My hope is to use Snorby frontend running on the ubuntu 16.04 to read the mysql after Barnyard2 dumps the pcaps from snort into the DB.
</p>

<p>
	I run the snort validation cmd: c:\IDS\Snort\bin\snort -c c:\IDS\Snort\etc\snort.conf -l c:\IDS\snort\log -i1 -T
</p>

<p>
	Output says it can't find the whitelist / blacklist entries Reputation Preprocessor disabled.
</p>

<p>
	312 out of 1024 flowbits in use. 
</p>

<p>
	Snort successfully validated the configuration!
</p>

<p>
	Snort Exiting.
</p>

<p>
	Snort is running as a service (delayed auto-start)
</p>

<p>
	Next applied the Reg file "auto-remote-barnyard2.reg" no files have been installed to the c:\IDS\Snort\log directory
</p>

<p>
	Run as administrator - "c:\IDS\activators\by2-test.bat"
</p>

<p>
	Warning invalid reference spec 'url,'. Ignored x9
</p>

<p>
	INFO database: Defaulting Reconnect sleep time to 5 second..... (3 mins later)
</p>

<p>
	Unable to open waldo file C:\IDS\Snort\log\barnyard.waldo (no such file or directory)
</p>

<p>
	Waiting for new spool file.......(&amp; waiting &amp; waiting....)
</p>

<p>
	Process terminated by user because he screwed up somewhere.
</p>

<p>
	I'm assuming I have been careful about keeping the path reference changes adjusted for the modder.vbs and the Reg file 
</p>

<p>
	my SQL DB has a slightly different config: grant all on snorby.* to 'snorby'@'10.0.0.44'IDENTIFIED BY '**************';
</p>

<p>
	MySQL config has bind-address set to Master IDS server IP. Both master and slave have 1 NIC each.
</p>

<p>
	Based on a configuration I saw from a linux tutorial for running Snort I disabled the TCP Large Receive Offload on the Remote NIC.
</p>

<p>
	I really hope this doesn't matter, but they are EC2 instances on Amazon AWS.
</p>

<p>
	Not sure what to try next except throw away the VMs and start again.
</p>

<p>
	Any thoughts to help get me in the right direction would be awesome. Thanks &amp; take care.
</p>

<p><a class="ipsAttachLink" href="//www.winsnort.com/applications/core/interface/file/attachment.php?id=143">snort.conf</a></p>
<p><a class="ipsAttachLink" href="//www.winsnort.com/applications/core/interface/file/attachment.php?id=144">barnyard2.conf</a></p>]]></description><guid isPermaLink="false">243</guid><pubDate>Thu, 22 Dec 2016 03:35:15 +0000</pubDate></item><item><title>Barnyard2 service doesn't start after successful installation</title><link>https://www.winsnort.com/topic/126-barnyard2-service-doesnt-start-after-successful-installation/</link><description><![CDATA[<blockquote data-ipsquote="" class="ipsQuote"><div>
<p>I followed the guide posted on this forum, but Barnyard2 service doesn't start after computer restart. If I try to start it manually from Windows Services, then Barnyard2 crashes. I did not get any errors while installing Barnyard2. This is output from the command "c<span style="color:rgb(40,40,40);font-family:Helvetica, arial, sans-serif;">:winidsactivatorsby2-test</span>" (I have replaced all paths where drive d is referenced, because I use c drive):</p>
<p> </p>
<div>C:Windowssystem32&gt;c:winidsbarnyard2barnyard2.exe -c c:winidsbarnyard2etc</div>
<div>barnyard2.conf -d c:winidssnortlog -f merged.log -l c:winidsbarnyard2 -w c</div>
<div>:winidssnortlogbarnyard.waldo -T</div>
<div>Running in Test mode</div>
<div> </div>
<div>        --== Initializing Barnyard2 ==--</div>
<div>Initializing Input Plugins!</div>
<div>Initializing Output Plugins!</div>
<div>Parsing config file "c:winidsbarnyard2etcbarnyard2.conf"</div>
<div> </div>
<div> </div>
<div>+[ Signature Suppress list ]+</div>
<div>----------------------------</div>
<div>+[No entry in Signature Suppress List]+</div>
<div>----------------------------</div>
<div>+[ Signature Suppress list ]+</div>
<div> </div>
<div>WARNING: invalid Reference spec 'url,'. Ignored</div>
<div>WARNING: invalid Reference spec 'url,'. Ignored</div>
<div>Barnyard2 spooler: Event cache size set to [32768]</div>
<div>INFO database: Defaulting Reconnect/Transaction Error limit to 10</div>
<div>INFO database: Defaulting Reconnect sleep time to 5 second</div>
<div>database: compiled support for (postgresql)</div>
<div>database: configured to use mysql</div>
<div>database: schema version = 107</div>
<div>database:           host = 10.165.17.82</div>
<div>database:           port = 3306</div>
<div>database:           user = snort</div>
<div>database:  database name = snort</div>
<div>database:    sensor name = SNMP-agent3-win</div>
<div>database:      sensor id = 3</div>
<div>database:     sensor cid = 1</div>
<div>database:  data encoding = hex</div>
<div>database:   detail level = full</div>
<div>database:     ignore_bpf = no</div>
<div>database: using the "log" facility</div>
<div> </div>
<div>        --== Initialization Complete ==--</div>
<div> </div>
<div>  ______   -*&gt; Barnyard2 &lt;*-</div>
<div> / ,,_    Version 2.1.13 (Build 333)</div>
<div> |o"  )~|  By Ian Firns (SecurixLive): <a href="http://www.securixlive.com/" rel="external nofollow">http://www.securixlive.com/</a></div>
<div> + '''' +  © Copyright 2008-2013 Ian Firns &lt;firnsy@securixlive.com&gt;</div>
<div> </div>
<div> </div>
<div>Barnyard2 successfully loaded configuration file!</div>
<div>Barnyard2 exiting</div>
<div>database: Closing connection to database "snort"</div>
</div></blockquote>
<div>EDIT: I have found what the problem was. The VB script tried to open Barnyard2 from drive D.</div>
]]></description><guid isPermaLink="false">126</guid><pubDate>Thu, 12 Mar 2015 12:43:18 +0000</pubDate></item><item><title>unable to connect to Master DB</title><link>https://www.winsnort.com/topic/120-unable-to-connect-to-master-db/</link><description><![CDATA[<p>I am not sure what the listening port is on MySQL.  I tried what I think is the default of 3306 and still I am getting the following error:</p>
<p> </p>
<p>database mysql_error: Can't connect to MySQL server on '10.250.254.253' (111)<br>
Barnyard2 exiting<br>
database: Closing connection to database "snort"</p>
<p> </p>
<p>My barnyard.conf file looks like this:</p>
<p> </p>
<p>output database: log, mysql, user=snort password=l0gg3r dbname=snort host=10.250.254.253 port=3306 sensor_name=WinIDS-Madrid</p>
<p> </p>
<p>My remote sensor ip address is 10.250.253.253</p>
<p> </p>
<p>I have read where remote access to MYSQL is off by default,  could this be the reason for the error and if so,  how might I enable remote access??</p>
<p> </p>
<p><br>
 </p>
]]></description><guid isPermaLink="false">120</guid><pubDate>Thu, 08 Jan 2015 20:40:45 +0000</pubDate></item></channel></rss>
