[Snort-users] view alerts in base

David Kingsly davidkingsly at ...3147...
Wed Apr 22 19:55:57 EDT 2009


Thanks.  Here is what I get:
mysql> select * from `schema`;
+------+---------------------+
| vseq | ctime               |
+------+---------------------+
|  107 | 2009-04-01 06:03:14 | 
+------+---------------------+
1 row in set (0.00 sec)


On Tue, 2009-04-21 at 21:48 -0500, Paul Schmehl wrote:
> --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