Snort Forums Archive

Archive Home » Windows » Invalid object name 'acid_event'.

Please note that the categories listed below represent an archived version of our forums pages. To view the current version and be able to post and reply to threads, please register and login here to go to the full forums pages.

[ Notice: Full Version of This Topic ]

Invalid object name 'acid_event'.

Posted by mmills1120 on August 10, 2006 10:05:15

I am new to Snort, and I followed instructions on setting up Snort on a Windows environment from Winsnort.com, however, when I try to load BASE console, I get the following error:

Database ERROR:Database ERROR:Invalid object name 'acid_event'.

I am running this on a WinXP with MS SQL 2000. As far as I can see, everything is set up correctly. Please help!

Posted by Dselmeyer on August 28, 2006 11:36:45

I am having this same problem. I found that in the base_conf.php you have the following settings it gives you the error:

/* Archive DB connection parameters */
$archive_exists = 1; # Set this to 1 if you have an archive DB
$archive_dbname = 'archive';
$archive_host = 'localhost';
$archive_port = '';
$archive_user = 'base';
$archive_password = '@n@l1st';

If you set it to 0, it works fine, but you dont' get archives. Anyone have a solution to this?

Posted by ncoleman on August 30, 2006 01:27:32

Only way I got round this was to use the MySQL Admin GUI and create the table entries that were missing based on main 'snort' database. I can now archive events OK and I dont seem to be getting any error messages.

Posted by Dselmeyer on August 30, 2006 04:30:45

I am using MS SQL though. Do the tables need bo be created in Archive or where do they need to be created?

I am guessing Archive, but why wouldn't they have been created from the start?

Posted by ncoleman on August 31, 2006 01:33:15

They need to be created in Archive - not sure why they aren't. After a DB creation and first time you run the BASE console and go through the setup process for your main DB, the extra tables get created, you could try configuring BASE to use the archive DB and create the tables this way.

Posted by Dselmeyer on August 31, 2006 07:23:50

The best way to get around this, use a different version of BASE. I was on 1.2.6, I went to 1.2.5 and it works fine....go figure?

Posted by JGonzo on October 27, 2006 11:12:57

Hi Dselmeyer,

I am also new to snort and I am having the same issue, how specificallyl did you go about solving this problem? Need Help.