DROP TABLE IF EXISTS tmp;create table tmp like mytable; ALTER TABLE tmp ADD UNIQUE INDEX(text1, text2, text3, text4, text5, text6); insert IGNORE into tmp select * from mytable; delete from mytable where id not in ( select id from tmp); DROP TABLE IF EXISTS tmp;
Well I had some problems on my server with config files for Snort and Barnyard so I will write short explanation here. First in /etc/snort/snort.conf define output like output unified2: filename snort.u2, limit 128 Then in /usr/local/etc/barnyard2.conf define output to database with : output database: log, mysql, user=snort_user password=snort dbname=snortdb host=127.0.0.1 output database: alert, mysql, user=snort_user password=snort […]
while exeucting snort -c /usr/local/snort/etc/snort.conf –dump-dynamic-rules=/usr/local/snort/so_rules Ubuntu shows following error : error while loading shared libraries: libsfbpf.so.0: cannot open shared object file: No such file or directory The same error occurs while executing: snort -c /usr/local/snort/etc/snort.conf -T The way to solve this is to type ldconfig , after that try the snort -c command as […]