[Snort-users] Schema on MySQL

John Byrnes JohnByrnes at ...10108...
Thu Sep 18 07:33:09 EDT 2003

Hi Mike
have you recently truncated, deleted etc your mysql db? if you have that functionality scripted, it maybe clearing the schema table contents.

>>> "Mike Koponick" <mkoponick at ...7385...> 09/17/03 01:49PM >>>
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 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...

This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
Snort-users mailing list
Snort-users at lists.sourceforge.net 
Go to this URL to change user options or unsubscribe:
Snort-users list archive:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.snort.org/pipermail/snort-users/attachments/20030918/77d576ff/attachment.html>

More information about the Snort-users mailing list