Snort mailing list archives
Snort 2.0.0 logging to MySQL, but nothing in ACID???
From: "Williams Jon" <WilliamsJonathan () JohnDeere com>
Date: Tue, 19 Oct 2004 15:29:15 -0500
I'm having a pretty bad brain fart. Some time this morning, one of our ACID consoles stopped working. We've confirmed that all of our sensors are seeing data and generating alerts, that the MySQL port is open between all of the sensors and the DB server, that MySQL is running and accepting connections on the port the sensors are connecting to, and that the sensors are writing data to the database. When I go into ACID, it shows no alerts and no sensors, but if I click on the "Application cache and status" link, the Alert Information Cache section shows the correct number of alerts under "Total Events". Clicking on "Repair Tables" and "Update Alert Cache" have no effect on the problem, nor did restarting the web server, MySQL server, and rebooting the box. Fortunately, we've got a second DB server. When we repointed the sensors to the second server, everything works fine there. While I was logged into the box around the time that the problem occurred, and there were no other users logged in at all since before the problem, I have no clear recollection of any actions that had anything to do with PHP, the web server, ACID, or MySQL. Any suggestions? Any idea how I shot myself in the foot? Thanks. Jon ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ 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://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Snort 2.0.0 logging to MySQL, but nothing in ACID??? Williams Jon (Oct 19)
- Re: Snort 2.0.0 logging to MySQL, but nothing in ACID??? Kevin Johnson (Oct 19)
- <Possible follow-ups>
- RE: Snort 2.0.0 logging to MySQL, but nothing in ACID??? Williams Jon (Oct 20)