Re: [Sguil-users] Upgrading to 0.9.0 sql issue

[Paul H. <pau...@gm...>]

Should be 14 entries there; 'comment' is missing. See:

https://github.com/bammv/sguil/blob/master/server/sql_scripts/update_sguildb_v13-v14.sql


On Tue, Jun 10, 2014 at 5:10 PM, James Lay <jl...@sl...> wrote:

> On 2014-06-10 12:43, Paul Halliday wrote:
> > James,
> >
> > Can you do a "mysql> DESC autocat;"
> >
> > On Tue, Jun 10, 2014 at 3:01 PM, James Lay <jl...@sl...
> > [4]> wrote:
> >
> >> Topic says it:
> >>
> >> 2014-06-10 17:53:37 pid(8392)  Loading access list:
> >> /opt/etc/snort/sguild/sguild.access
> >> 2014-06-10 17:53:37 pid(8392)  Sensor access list set to ALLOW
> >> ANY.
> >> 2014-06-10 17:53:37 pid(8392)  Client access list set to ALLOW
> >> ANY.
> >> 2014-06-10 17:53:37 pid(8392)  Email Configuration:
> >> 2014-06-10 17:53:37 pid(8392)    Config file:
> >> /etc/sguild/sguild.email
> >> 2014-06-10 17:53:37 pid(8392)    Enabled: No
> >> 2014-06-10 17:53:37 pid(8392)  Connecting to localhost on 3306 as
> >> sguil
> >> 2014-06-10 17:53:37 pid(8392)  MySQL Version: version
> >> 5.5.37-0ubuntu0.12.04.1
> >> 2014-06-10 17:53:37 pid(8392)  SguilDB Version: 0.14
> >> mysqlsel/db server: Unknown column comment in field list
> >>      while executing
> >> "mysqlsel $MAIN_DB_SOCKETID $query -list"
> >>      (procedure "MysqlSelect" line 8)
> >>      invoked from within
> >> "MysqlSelect $aquery list"
> >>      (procedure "LoadAutoCats" line 5)
> >>      invoked from within
> >> "LoadAutoCats"
> >>      (file "./sguild" line 588)
> >>
> >> This doing an upgrade from 0.8.0 to 0.9.0.  I first ran
> >> update_sguildb_v13-v14.sql then autocat2mysql.tcl.  Not sure where
> >> to go
> >> from here, but I did have success with running both of those.
> >>  Checked
> >> the FAQ but didn’t see this particular issue.  Thank you.
> >>
> >> James
> >>
>
> Thanks Paul...coming at you:
>
> mysql> DESC autocat;
>
> +------------+----------------------+------+-----+---------+----------------+
> | Field      | Type                 | Null | Key | Default | Extra
>     |
>
> +------------+----------------------+------+-----+---------+----------------+
> | autoid     | int(10) unsigned     | NO   | PRI | NULL    |
> auto_increment |
> | erase      | datetime             | YES  |     | NULL    |
>     |
> | sensorname | varchar(255)         | YES  |     | NULL    |
>     |
> | src_ip     | varchar(18)          | YES  |     | NULL    |
>     |
> | src_port   | int(10) unsigned     | YES  |     | NULL    |
>     |
> | dst_ip     | varchar(18)          | YES  |     | NULL    |
>     |
> | dst_port   | int(10) unsigned     | YES  |     | NULL    |
>     |
> | ip_proto   | tinyint(3) unsigned  | YES  |     | NULL    |
>     |
> | signature  | varchar(255)         | YES  |     | NULL    |
>     |
> | status     | smallint(5) unsigned | NO   |     | NULL    |
>     |
> | active     | enum('Y','N')        | YES  |     | Y       |
>     |
> | timestamp  | datetime             | NO   |     | NULL    |
>     |
> | uid        | int(10) unsigned     | NO   |     | NULL    |
>     |
>
> +------------+----------------------+------+-----+---------+----------------+
> 13 rows in set (0.00 sec)
>
> James
>
>
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> Sguil-users mailing list
> Sgu...@li...
> https://lists.sourceforge.net/lists/listinfo/sguil-users
>



-- 
Paul Halliday
http://www.pintumbler.org/