RE: Access Denied

["L. Christopher Luther" <CLuther () Xybernaut com>]

James, 

You mentioned "upgrading".  Are you upgrading Snort from a pre-1.9.0
version?  If so, then you should know that the DB schema changed between
Snort versions 1.8.7 and 1.9.0.  

I ran WinDiff against the contrib/create_mysql scripts for 1.8.7 and 1.9.0,
and there appear to only be two changes:  

  1.8.7 - INSERT INTO schema  (vseq, ctime) VALUES ('105', now());
  1.9.0 - INSERT INTO schema  (vseq, ctime) VALUES ('106', now());

  1.9.0 - In the create DDL statement for the sensor table, there is an
additional column defined: 

            last_cid    INT      UNSIGNED NOT NULL

Unless someone on this list has an "upgrade" SQL script that can be used to
modify a Snort 1.8.7 DB to a Snort 1.9.0 DB, you may have to make these
changes yourself.  

Cheers!
- Christopher  


-----Original Message-----
From: "Lucretia Enterprises" <lucretia () telusplanet net>
To: "Snort-Users List" <snort-users () lists sourceforge net>
Date: Thu, 6 Feb 2003 07:43:28 -0700
Subject: [Snort-users] Access Denied

Hi,

I'm using Snort 1.9.0 configured with IDSCenter 1.1RC1 on two Windows2000sp3
machines, logging to a mysql 3.23.54 also on a Windows 2000sp3 box.

I'm in the process of upgrading one snort sensor and adding another sensor.
I got both upgraded and ready to run (no errors), but when they attempt to
access the Mysql database, they get
"Access Denied"

I'm lost as to why after an upgrade this would occur.  Yes, the password and
user ID are set up correctly. user=snort password=""
But I wonder, is there any way I can see who has access to the snort
database and confirm the settings?  I'm no Mysql guru...

Thanks for your assistance,

James.