[Snort-users] view alerts in base

Paul Schmehl pschmehl_lists at ...14358...
Tue Apr 21 22:48:02 EDT 2009


--On April 21, 2009 8:40:03 PM -0500 David Kingsly 
<davidkingsly at ...3147...> wrote:

>
> I can not do the query.  I see the table, but it does not work...
> mysql> show tables;

You misread his instructions.  It's not 'schema' (single quotes).  It's 
`shema` (backticks);

mysql> describe schema;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to use 
near 'schema' at line 1
mysql> describe `schema`;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| vseq  | int(10) unsigned | NO   | PRI | NULL    |       |
| ctime | datetime         | NO   |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

Paul Schmehl, If it isn't already
obvious, my opinions are my own
and not those of my employer.
******************************************
WARNING: Check the headers before replying





More information about the Snort-users mailing list