RE: snort v2.0 logging to mysql database

["Semerjian, Ohanes" <ohanes.semerjian () au mci com>]

Thanx very much Erek for the tip much appreciated. I'll do that

Best Regards

Ohanes Semerjian
Security Engineer, AsiaPac
International Security Group  (Central Services)
MCI International

Ph:(02) 9434 5636
Mob: 0410 657 249

PGP kEY 
75DF 2980 5663 2DC1 12CD  E43E 94D6 7A9A 222D 3449


-----Original Message-----
From: Erek Adams [mailto:erek () snort org]
Sent: Tuesday, 6 May 2003 12:06 AM
To: Semerjian, Ohanes
Cc: 'snort-users () lists sourceforge net'
Subject: Re: [Snort-users] snort v2.0 logging to mysql database


On Mon, 5 May 2003, Semerjian, Ohanes wrote:

> I'm testing snort v2.0 on solaris v8 (sparc). I had snort starting but
then
> it quite with error below. On the databse side I had granted permission to
> the user on the sensor to log alerts to mysql (I had 8 other sensors doing
> so running v 1.7). On the mysql I use the following command to grant the
> permission

[...snip...]

If you're upgrading from 1.7 and using MySQL, I'm almost 100% certain that
you have an old version of the DB schema.  Due to the large number of
changes from 1.7 to 2.0 I'd suggest either building a new DB for testing
with 2.0 and then slowly migrate the 1.7 sensors to 2.0 and use the newdb
or drop the tables and rereate it using the new schema.

Cheers!

-----
Erek Adams

   "When things get weird, the weird turn pro."   H.S. Thompson


-------------------------------------------------------
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