Snort - sending messages to MySQL on another Snort machine

I have W2K running Snort 2.4.5 and RHEL4 running Snort, 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?
LVL 16
Steve JenningsIT ManagerAsked:
Who is Participating?
crawforditsConnect With a Mentor Commented:
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
dont forget snort -T
Steve JenningsIT ManagerAuthor Commented:
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 . . .
Rich RumbleConnect With a Mentor Security SamuraiCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.