[Snort-users] Database ERROR:Database ERROR:Duplicate entry

Jason snort-users at ...2977...
Wed Jul 16 11:06:09 EDT 2003


I have searched through the archive, so far nothing has really resolved
the issue.
Below are the tables referenced in a previous post.
Any clues to resolve the issue would be greatly appreciated.
Current setup.

mysql  Ver 12.20 Distrib 4.0.13, for portbld-freebsd4.8 (i386)
apache+mod_ssl-1.3.27+2.8.14
mod_php4-4.3.3.r1_1,1

mysql> select * from schema
    -> ;
+------+---------------------+
| vseq | ctime               |
+------+---------------------+
|  106 | 2003-07-16 10:44:30 |
+------+---------------------+
1 row in set (0.00 sec)

mysql> desc sensor
    -> ;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| sid       | int(10) unsigned |      | PRI | NULL    | auto_increment |
| hostname  | text             | YES  |     | NULL    |                |
| interface | text             | YES  |     | NULL    |                |
| filter    | text             | YES  |     | NULL    |                |
| detail    | tinyint(4)       | YES  |     | NULL    |                |
| encoding  | tinyint(4)       | YES  |     | NULL    |                |
| last_cid  | int(10) unsigned |      |     | 0       |                |
+-----------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)





More information about the Snort-users mailing list