asked on

Snort Error (Table 'snort.event' doesn't exist)

http://www.snort.org/assets/158/012-snortinstallguide291.pdf

Hi,
i have configured snort on ubuntu 10.0.4 according to this pdf http://www.snort.org/assets/158/012-snortinstallguide291.pdf. here is the eth details.

-----------------------------------------------------------------------------------------------

root@xss-240:~# ifconfig
eth0 Link encap:Ethernet HWaddr 00:1d:7d:22:2c:b3
UP BROADCAST MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
Interrupt:23 Base address:0x6000

eth1 Link encap:Ethernet HWaddr 00:03:47:df:bb:02
inet addr:10.5.0.171 Bcast:10.5.0.255 Mask:255.255.255.0
inet6 addr: fe80::203:47ff:fedf:bb02/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:6704 errors:0 dropped:0 overruns:0 frame:0
TX packets:4105 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:3985918 (3.9 MB) TX bytes:959947 (959.9 KB
----------------------------------------------------------------------------------------------------

i have done step by step as it is mentioned in pdf. while opening snort in browser i am getting this errorr

Table 'snort.event' doesn't exist

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| snort |
+--------------------+
3 rows in set (0.00 sec)

mysql> use snort;
Database changed

mysql> show tables;
Empty set (0.00 sec)

plz guide me.

snort-error.png

xterm

You have the database created, but somehow the step below must not have gotten executed. I recommend going back into the snort source directory and doing the following:

mysql -u root -p -D snort < ./schemas/create_mysql
echo "grant create, insert, select, delete, update on snort.* to snort@localhost identified by 'YOURPASSWORD'" | mysql -u root -p

Open in new window

ASKER CERTIFIED SOLUTION

xterm

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Mbhushan

ASKER

hi xtrem,

thanks for the reply, when i am giving this command this is the error i am getting.

root@xss-240:~# mysql -u root -p -D snort < ./schemas/create_mysql-bash: ./schemas/create_mysql: No such file or directory

xterm

You have to run that command in the directory that contains the snort schemas.

Please run "locate schemas/create_mysql" and find out where on your system it is.

Then cd to the directory that which contains the schemas folder, and then run the command again.