| And this other error means you're missing one extra table inside the snort database: extra_data.
DROP TABLE IF EXISTS extra_data; CREATE TABLE extra_data ( sid INT8 NOT NULL, cid INT8 NOT NULL, filename varchar(255), username varchar(255), password varchar(255), userdata1 varchar(255), userdata2 varchar(255), userdata3 varchar(255), userdata4 varchar(255), userdata5 varchar(255), userdata6 varchar(255), userdata7 varchar(255), userdata8 varchar(255), userdata9 varchar(255), PRIMARY KEY (sid, cid) );
And if this is so you'll probably got an incomplete ossim_event table, although only incomplete in terms of 0.9.9rc4:
DROP TABLE IF EXISTS ossim_event; CREATE TABLE ossim_event ( sid INT NOT NULL, cid INT NOT NULL, type INT NOT NULL, priority INT DEFAULT 1, reliability INT DEFAULT 1, asset_src INT DEFAULT 1, asset_dst INT DEFAULT 1, risk_c INT DEFAULT 1, risk_a INT DEFAULT 1, plugin_id INTEGER NOT NULL, plugin_sid INTEGER NOT NULL, PRIMARY KEY (sid, cid), INDEX (type), INDEX (priority), INDEX (reliability), INDEX (asset_src), INDEX (asset_dst), INDEX (risk_c), INDEX (risk_a), INDEX (plugin_id), INDEX (plugin_sid) );
Greetings,
Dominique
Am 30.03.2007 um 11:44 schrieb Sébastien Thomelin:
OSSIM-Message: ERROR INSERT INTO extra_data (sid, cid, filename, username, passw
ord, userdata1, userdata2, userdata3, userdata4, userdata5, userdata6, userdata7
, userdata8, userdata9) VALUES (1, 93, '(null)', '(null)', '(null)', 'Windows XP
SP1, 2000 SP3', '(null)', '(null)', '(null)', '(null)', '(null)', '(null)', '(n
ull)', '(null)') 1146: Table 'snort.extra_data' doesn't exist
|