Snort mailing list archives
Re: view alerts in base
From: David Kingsly <davidkingsly () verizon net>
Date: Wed, 22 Apr 2009 19:55:57 -0400
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 () verizon net> 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
------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH, (continued)
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH Todd Wease (Apr 13)
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH Stephen Reese (Apr 13)
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH Jason Wallace (Apr 14)
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH Todd Wease (Apr 14)
- Re: R: v2.8.4 incorrect logging to MySQL: PATCH Jason Wallace (Apr 14)
- view alerts in base David Kingsly (Apr 19)
- Re: view alerts in base David Kingsly (Apr 19)
- Re: view alerts in base Lee Clemens (Apr 20)
- Re: view alerts in base David Kingsly (Apr 21)
- Re: view alerts in base Paul Schmehl (Apr 21)
- Re: view alerts in base David Kingsly (Apr 22)
- Re: view alerts in base Joel Esler (Apr 22)
- Message not available
- Re: view alerts in base John Gay (Apr 20)
- Re: view alerts in base David Kingsly (Apr 21)
- Re: view alerts in base Paul Schmehl (Apr 21)
- Re: view alerts in base Dominique Karg (Apr 22)
- Re: view alerts in base David Kingsly (Apr 22)
- Re: view alerts in base Joel Esler (Apr 22)
- Re: view alerts in base Leon Ward (Apr 22)
- Re: view alerts in base Randal T. Rioux (Apr 22)
- Re: view alerts in base Joel Esler (Apr 22)