RE: Snort database problem

["Hutchinson, Andrew" <andrew.hutchinson () Vanderbilt Edu>]

You must first create the database.  The 'create_mysql' script will
create the tables, but the db must already exist.

Do this:

echo "CREATE DATABASE snort" | /usr/local/mysql/bin/mysql -u root -p

Then run the command below, and all should be well.  Be sure to run the
appropriate GRANTs for the user/sensor that is sending the alerts.

Andrew Hutchinson
Infomatics/NCS/Network Security
Vanderbilt University Medical Center



-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Laura
Sent: Tuesday, April 06, 2004 1:01 PM
Cc: snort-users () lists sourceforge net
Subject: [Snort-users] Snort database problem


Hello people, i had snort running fine until yesterday when i decided to
clear all the tables rows ... whenever i wanted to start snort some
error message came up so ... i decided to delete the snort database ...

now i want to create again that database with the following command (the
same command i've used before): 

 < ./contrib/create_mysql snort But i get this error:

ERROR 1049: Unknown database "snort"

Can anyone give me a clue of what is going on?

TIA

laura



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
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


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
_______________________________________________
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