RE: Snort, Acid, Mysql Database error

["Hutchinson, Andrew" <andrew.hutchinson () Vanderbilt Edu>]

Chip:

There have been a couple of these types of problems from the last couple
of weeks.  Basically, a MyISAM table in your MySQL database has been
hammered and has some consistency issues.  Here is a clip from one of my
earlier responses:

*>>>>>>>>>>
The table you mention is a MyISAM table (identifiable by the .MYI
extention).  There is a MySQL utility called 'myisamchk' that you will
soon become intimately familiar with.

First, make a copy of the table iphdr.MYI and put it somewhere safe in
case things get ugly.

Second, you'll want to run 'myisamchk iphdr.MYI' to see what it reports
as the problem.  This will let you know basically where you stand.  If
it looks like the index file is in good shape, then...

- you'll want to run 'myisamchk --recover --quick iphdr.MYI'

If it looks like the index is hosed, then...

- you'll want to run 'myisamchk --recover iphdr.MYI'

If that doesn't work, try...

- 'myisamchk --safe-recover iphdr.MYI'

*<<<<<<<<<<

HTH,

Andrew

Andrew Hutchinson - Network Security
Vanderbilt University Medical Center
(615) 936-2856


> -----Original Message-----
> From: Chip Upsal [mailto:cupsal () cyberwolf com] 
> Sent: Tuesday, August 26, 2003 9:40 AM
> To: snort-users () lists sourceforge net
> Subject: [Snort-users] Snort, Acid, Mysql Database error
>
>
> Acid is showing the error:
>  
> Database ERROR:Database ERROR:Can't open file: 
> 'acid_event.MYI'. (errno:
> 145)
>
> Has anyone seen this?
>
> Chip
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a 
> single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
> at the same time. Free trial click 
> here:http://www.vmware.com/wl/offer/358/0
> _______________________________________________
> 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


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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