Re: Problems with MySQL and SNORT after Reboot

2004-12-31 Thread Mattias Björk
Hi, Thanks for the fast response. I did run "REPAIR TABLE event" from phpmyadmin and there where no problems with that. No Error here. But when I point my browser to my snort page and select the timeframe for the alerts to all I get the error message after a few seconds: Warning: mysql_query():

Re: Problems with MySQL and SNORT after Reboot

2004-12-30 Thread Scott Kupferschmidt
Hello, You need to login to mysql command prompt and do a REPAIR TABLE event; in that database, and it will clear it right up. Sincerely, Scott Kupferschmidt ISPrime, Inc. 866.502.4678 ext. 3 AIM: Scott ISPrime - ICQ: 174337249 On Fri, 31 Dec 2004, [ISO-8859-1] Mattias Björk wrote: > Dear list

Problems with MySQL and SNORT after Reboot

2004-12-30 Thread Mattias Björk
Dear list, After a power failure and my computers went down, I have been starting to get error messages in sys log and on the console: Dec 28 19:50:52 setiathome snort: database: mysql_error: Can't open file: 'event.MYI'. (errno: 145) SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES (