Solved

Snort - sending messages to MySQL on another Snort machine

Posted on 2006-10-27
6
346 Views
Last Modified: 2010-04-11
I have W2K running Snort 2.4.5 and RHEL4 running Snort 2.6.0.2, both in IDS mode. The windows system is logging to syslog and the rhel system is logging to a mysql database. Both are working fine. . . I am running base on the rhel system.

I cant figure out how to have the alerts on the windows system go to the mysql data base on the linux system. I configured an output database command and the windows system is getting alerts (they show on the DOS console) but when I trace the connection between the two systems, no data ever leaves the windows system.

I am new to snort and relatively new to rhel . . . there must be a way to send data/alerts from multiple sensors. Any ideas?
0
Comment
Question by:SteveJ
  • 2
6 Comments
 
LVL 9

Accepted Solution

by:
crawfordits earned 100 total points
ID: 17824508
set the mysql output-logging in the snort.conf to get some debugging action.. then paste back output.. its possible it will output something like " Host 'x.x.x.x' is not allowed to connect to this MySQL server" then it it obvious what to do
0
 
LVL 9

Expert Comment

by:crawfordits
ID: 17824509
dont forget snort -T
0
 
LVL 16

Author Comment

by:SteveJ
ID: 17824656
Turns out that I didn't have a sensor_name variable on the sensor OR the main machine. When I added the sensor_name to the main machine it was visible in BASE and all's working fine now.

Thanks for responding crawfordits . . . the other problem is that I have Red Hat Advance Server 4 and it's got old PHP (4.0.x) and old MySQL (3.x) and I can't get pear to work . . . I'm a novice at red hat and I can't figure out how to upgrade all the stuff that it complains about when I try to upgrade the RPM and glibc and on and on . . .
0
 
LVL 38

Assisted Solution

by:Rich Rumble
Rich Rumble earned 100 total points
ID: 17828333
Try using Yum, aptget or uo2date:
as root
yum update php     or yum update mysql   or... yum update (then copy the packages you want to update to the command "yum update package1 package2 package3.."

iI think up2date is installed by default, yum might not be available
-rich
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Examines three attack vectors, specifically, the different types of malware used in malicious attacks, web application attacks, and finally, network based attacks.  Concludes by examining the means of securing and protecting critical systems and inf…
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question