[Snort-users] HELP!

A.L.Lambert alambert at ...387...
Wed Sep 13 20:20:23 EDT 2000


	Got problems with the following:

Snort->MySQL database.  Problem exemplified by screendump below.

---- begin screen dump

Initializating Output Plugins!

+++++++++++++++++++++++++++++++++++++++++++++++++++
Initializing rule chains...
log_database: Database type is mysql
log_database: Database name is snort
log_database: User set to root
log_database: Host set to localhost
1526 Snort rules read...
1526 Option Chains linked into 216 Chain Headers
+++++++++++++++++++++++++++++++++++++++++++++++++++


-*> Snort! <*-
Version 1.6.3
By Martin Roesch (roesch at ...66..., www.snort.org)
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
Error: Unknown column 'th_sport' in 'field list'
<Lots more; different names of column's it don't like>

------- end cut

	And yes, I know I shouldn't run snort logging to the DB as root;
but I couldn't get anything else to work at all.

line from rules.base:

output log_database: mysql, dbname=snort user=root password=<YEAH RIGHT> host=localhost


	Anything else that might be of help; someone let me know.  I know
just enough about MySQL to be a moron in that department.  :)

	--A.L.Lambert - going home after a long day of php4, MySQL, and
other things that didn't even come close to working like the directions
said they would. :(




More information about the Snort-users mailing list