We help IT Professionals succeed at work.

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

Mbhushan
Mbhushan asked
on
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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

CERTIFIED EXPERT
Commented:
Oh, remember to change "YOURPASSWORD" in the second command to your own password for the snort user.

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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.