LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Security
User Name
Password
Linux - Security This forum is for all security related questions.
Questions, tips, system compromises, firewalls, etc. are all included here.

Notices


Reply
  Search this Thread
Old 04-21-2006, 04:53 PM   #1
ziegen
Member
 
Registered: May 2003
Posts: 32

Rep: Reputation: 15
SnortCenter Database Error


I have been searching google for the following error on snortcenter and cant fix this problem. I have mysql installed with a database called snort and one called snortcenter. I have created the tables via create_mysql for the snort database and crated the tables for the snortcenter via snortcenter_db.mysql. I have looked and they are there. I have snort running and the snort.conf file is changed to log to the database called snort. I have changed the config.php to read the DBtype = "mysql"
DB_dbname = "snort"
DB_host = "localhost"
When I launch a browser to localhost/snortcenter I get Database ERROR: Database ERROR: Unknown column 'id' in 'field list'

I have searched google and the only thing I see is to create a database called snortcenter and run the snortcenter_db.mysql. I have already done that and I still have errors.
 
Old 04-21-2006, 05:13 PM   #2
ziegen
Member
 
Registered: May 2003
Posts: 32

Original Poster
Rep: Reputation: 15
I just changed the database in the config.php file to snortcenter and now I am prompted with a username and password. But the username and password that I have in the config.php file does not work...
 
Old 04-21-2006, 05:44 PM   #3
ziegen
Member
 
Registered: May 2003
Posts: 32

Original Poster
Rep: Reputation: 15
I was able to log into using admin. Turns out that this version of snortcenter installed from rpmdrake on Mandriva is not what I expected or maybe I am using it wrong. Once logged in I cant view any alerts. I am using the bruce perens open source series intrusion detection with snort as ref. This book covers ACID and not the new snortcenter. I wonder if the database in the snort.conf file should be the snortcenter insead of the snort database. Anyone useing a better snort interface please give me a shout out.

thanks
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error in liking the database with the vb baqer Programming 0 08-13-2005 12:06 PM
Error with database? Canam97 Mandriva 1 03-08-2005 08:23 PM
mysql database error Tredo Linux - Security 7 11-26-2004 03:12 PM
Tripwire Database Error OutKaster Linux - Software 0 09-07-2004 10:14 PM
Problems with Snortcenter agent!!! Olusegun Linux - Software 1 12-05-2002 12:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Security

All times are GMT -5. The time now is 09:16 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration