[Snort-users] Schema on MySQL

Mike Koponick mkoponick at ...7385...
Thu Sep 18 07:12:21 EDT 2003


I haven't seen this on the list and I apologize in advance if it has
been talked about previously.

I recently had a problem with SNORT dieing after a few minutes of
startup. After running the snort test mode, I found that the MySQL
database was *missing* the schema in the table. 
I simply added it with the following command and all is well now.

INSERT INTO schema  (vseq, ctime) VALUES ('106', now());

I have had this problem in the past, but I thought I might have deleted
it by accident. I haven't been into this system with the exception of
checking logs etc. So, I'm thinking it's something else.

Has anyone seen this issue in the past? There were no clues in the logs
that I could see.

Thanks in advance,

Mike



Mike Koponick
RedHawk. - Network Engineering
mike at ...7385...

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify
 security at ...9202...
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





More information about the Snort-users mailing list