[Snort-users] Problems with creating MySQL tables under 1.7beta0

Ian Jones ian at ...686...
Tue Oct 24 13:30:58 EDT 2000

Upgrade your MySql to a newer version. I believe the syntax has changed. I
had the same problem and upgrading mysql seemed to fix it.

You will like ACID, it is a very nice front-end.

----- Original Message -----
From: "Ben Lovett" <blovett at ...682...>
Hash: SHA1

snort-users at lists.sourceforge.net

Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
Comment: Making the world safe for geeks.

Sent: Tuesday, October 24, 2000 5:59 AM
Subject: [Snort-users] Problems with creating MySQL tables under 1.7beta0

> Hello,
> I am trying to run snort 1.7beta0 because I am attempting to implement
> ACID on my host.  When i compile snort, everything works all fine and
> dandy, but then I try to create the tables.. That always seems to fail
> with:
> ERROR 1064 at line 116: You have an error in your SQL syntax near 'data
> ( sid           INT      UNSIGNED NOT NULL,
>          ' at line 1
> Now, I've also tried creating the tables with an older version (from
> 1.6.3), it works, and i attempt to run snort (1.7beta0) and get this:
> log_database: compiled support for ( mysql )
> log_database: configured to use mysql
> log_database:          user = root
> log_database: database name = snortdb
> log_database:          host = localhost
> log_database: password is set
> log_database:   sensor name = <myip>
> log_database: mysql error: Unknown column 'detail' in 'where clause'
> log_database: mysql_error: Unknown column 'detail' in 'field list'
> log_database: mysql error: Unknown column 'detail' in 'where clause'
> log_database: Problem obtaining SENSOR ID (sid) from
> It then states that I may not have the proper permissions to use INSERT
> or SELECT, but since I am trying to log as root, there should not be
> those permission problems.
> Could someone please give me some insight into this?  Thanks
> -ben
> _______________________________________________
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> http://lists.sourceforge.net/mailman/listinfo/snort-users

More information about the Snort-users mailing list