Re: Vol 1 #1833 Msg#10

["Joe Pampel" <joe () ardsley com>]

I hope this isn't a dumb Q, but have you set the timeout in php.ini to something really long?
This fixed some issues for me. If you're dumping ok from mysql directly but not from ACID, that
would be my first guess.
 
If you followed the SD install schema, you want to go to
c:\winnt\php.ini

edit the line:
max_execution_time = 

(put in max # of seconds you think something might take.. use empirical process to determine.. I wound up with 4500. 
I'm running NT4 on a PIII 933 with 500MB RAM. Running 2 instances of Snort with full rulesets. Runs great. 

and also 

memory_limit   (I made ours like 32MB or 64MB or something crazy. 8 is the default.

Perhaps that could help; maybe the functions are timing out.

hth

Joe

----------------------------------original post-----------------------------------------------------
Message: 10
From: "Whaley, Mike" <mwhaley () rightnow com>
To: "Snort-Users (E-mail)" <snort-users () lists sourceforge net>
Date: Fri, 26 Apr 2002 10:49:35 -0600
Subject: [Snort-users] Archiving Snort--mysql questions

Hello,

I'm currently running snort 1.8.6b105 on a windows 2000 box.  My issue is
that when my database reaches, say more 2000 records, the archive, delete,
etc. functions no longer work properly.  This may be due to weak machine,
but I still need to move the records to an archive database.  So, I use
mysqldump command to dump the data to a file and then import it into the
archive db using mysql -f -u snort snort < *.dump.  I have two questions:

1)how do I append the data to the archive database so that I do not get all
of the "duplicate data" errors?

2)specifically what tables do I need to delete in the snort database so that
I do not get goofy results when using the acid interface?

Thank you very much for your help.

Mike


_______________________________________________
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