Home / Browse / Sguil / Mail / Archive

Sguil

Email Archive: sguil-users (read-only)

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:07

> Try starting sguild in the foreground with -d 2. Usually something
> like this happens b/c you've met the limit on open files, but you need
> to verify that you are getting an error 24 from MySQL.
>
> 
http://www.vorant.com/nsmwiki/index.php?title=Sguil_FAQ#I.27m_seeing_error_code_24_from_MySQL._
> _How_do_I_fix_that.3F

 	Thanks for the respone, Bamm!
 	I'm afraid I already have a "open_files_limit = 4096" like in my 
/etc/my.conf file, but here's the debug output from starting sguild in the 
foreground:


[root@... ~]# /usr/local/sguil/server/sguild -d 2
pid(9108)  Loading access list: /etc/sguild/sguild.access
pid(9108)  Sensor access list set to ALLOW ANY.
pid(9108)  Client access list set to ALLOW ANY.
pid(9108)  Email Configuration:
pid(9108)    Config file: /etc/sguild/sguild.email
pid(9108)    Enabled: No
pid(9108)  Creating event MERGE table.
pid(9108)  Creating tcphdr MERGE table.
pid(9108)  Creating udphdr MERGE table.
pid(9108)  Creating icmphdr MERGE table.
pid(9108)  Creating data MERGE table.
pid(9111)  Loaderd Forked
pid(9112)  Queryd Forked
pid(9108)  Retrieving DB info...
mysqlsel/db server: Lost connection to MySQL server during query
     while executing
"mysqlsel $MAIN_DB_SOCKETID $query -flatlist"
     (procedure "FlatDBQuery" line 5)
     invoked from within
"FlatDBQuery $tmpQuery"
     ("foreach" body line 12)
     invoked from within
"foreach sensorName $sensorList {

     set tmpQuery "SELECT sid FROM sensor WHERE hostname='$sensorName'"
     set sensorSid [FlatDBQuery $tmpQuery]

   ..."
     (file "/usr/local/sguil/server/sguild" line 508)
pid(9111)  loaderd: Received:
[root@... ~]# pid(9111)  Unknown command received from sguild:


-- 
********************************************************************
Brett Charbeneau
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************

Thread View

Thread	Author	Date
Re: [Sguil-users] Lost connection to MySQL server errors on restart	Brett Charbeneau <brett@wr...>

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Bamm Visscher <bamm.visscher@gm...> - 2007-02-16 18:12

>From a msyql prompt:

SELECT sid FROM sensor WHERE hostname='$sensorName'"


Change $sensorName to your sensor name (do it once for each sensor if
you have more than one. Do you get an error?

Bammkkkk

On 2/16/07, Brett Charbeneau <brett@...> wrote:
> > Try starting sguild in the foreground with -d 2. Usually something
> > like this happens b/c you've met the limit on open files, but you need
> > to verify that you are getting an error 24 from MySQL.
> >
> >
> http://www.vorant.com/nsmwiki/index.php?title=Sguil_FAQ#I.27m_seeing_error_code_24_from_MySQL._
> > _How_do_I_fix_that.3F
>
>         Thanks for the respone, Bamm!
>         I'm afraid I already have a "open_files_limit = 4096" like in my
> /etc/my.conf file, but here's the debug output from starting sguild in the
> foreground:
>
>
> [root@... ~]# /usr/local/sguil/server/sguild -d 2
> pid(9108)  Loading access list: /etc/sguild/sguild.access
> pid(9108)  Sensor access list set to ALLOW ANY.
> pid(9108)  Client access list set to ALLOW ANY.
> pid(9108)  Email Configuration:
> pid(9108)    Config file: /etc/sguild/sguild.email
> pid(9108)    Enabled: No
> pid(9108)  Creating event MERGE table.
> pid(9108)  Creating tcphdr MERGE table.
> pid(9108)  Creating udphdr MERGE table.
> pid(9108)  Creating icmphdr MERGE table.
> pid(9108)  Creating data MERGE table.
> pid(9111)  Loaderd Forked
> pid(9112)  Queryd Forked
> pid(9108)  Retrieving DB info...
> mysqlsel/db server: Lost connection to MySQL server during query
>      while executing
> "mysqlsel $MAIN_DB_SOCKETID $query -flatlist"
>      (procedure "FlatDBQuery" line 5)
>      invoked from within
> "FlatDBQuery $tmpQuery"
>      ("foreach" body line 12)
>      invoked from within
> "foreach sensorName $sensorList {
>
>      set tmpQuery "SELECT sid FROM sensor WHERE hostname='$sensorName'"
>      set sensorSid [FlatDBQuery $tmpQuery]
>
>    ..."
>      (file "/usr/local/sguil/server/sguild" line 508)
> pid(9111)  loaderd: Received:
> [root@... ~]# pid(9111)  Unknown command received from sguild:
>
>
> --
> ********************************************************************
> Brett Charbeneau
> Network Administrator
> Williamsburg Regional Library
> 7770 Croaker Road
> Williamsburg, VA 23188-7064
> (757)259-4044          http://www.wrl.org
> (757)259-4079 (fax)    brett@...
> ********************************************************************
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sguil-users mailing list
> Sguil-users@...
> https://lists.sourceforge.net/lists/listinfo/sguil-users
>


-- 
sguil - The Analyst Console for NSM
http://sguil.sf.net

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:29

> >From a msyql prompt:
>
> SELECT sid FROM sensor WHERE hostname='$sensorName'"
>
> Change $sensorName to your sensor name (do it once for each sensor if
> you have more than one. Do you get an error?

 	No error (tried it two ways becuase I thought there might be an 
unbalanced quotation mark):


Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.17-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'"
     "> 
[root@... ~]# mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.17-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'
     ->




-- 
********************************************************************
Brett Charbeneau
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Bamm Visscher <bamm.visscher@gm...> - 2007-02-16 18:32

Sorry, you need to end the statement with a semi colon to be processed.

So

SELECT sid FROM sensor WHERE hostname='ciscoE1';


Bammkkkk


On 2/16/07, Brett Charbeneau <brett@...> wrote:
> > >From a msyql prompt:
> >
> > SELECT sid FROM sensor WHERE hostname='$sensorName'"
> >
> > Change $sensorName to your sensor name (do it once for each sensor if
> > you have more than one. Do you get an error?
>
>         No error (tried it two ways becuase I thought there might be an
> unbalanced quotation mark):
>
>
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 6 to server version: 5.0.17-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'"
>      ">
> [root@... ~]# mysql -h localhost -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 7 to server version: 5.0.17-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'
>      ->
>
>
>
>
> --
> ********************************************************************
> Brett Charbeneau
> Network Administrator
> Williamsburg Regional Library
> 7770 Croaker Road
> Williamsburg, VA 23188-7064
> (757)259-4044          http://www.wrl.org
> (757)259-4079 (fax)    brett@...
> ********************************************************************
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sguil-users mailing list
> Sguil-users@...
> https://lists.sourceforge.net/lists/listinfo/sguil-users
>


-- 
sguil - The Analyst Console for NSM
http://sguil.sf.net

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:40

On Fri, 16 Feb 2007, Bamm Visscher wrote:

BV> Sorry, you need to end the statement with a semi colon to be processed.
BV> 
BV> So
BV> 
BV> SELECT sid FROM sensor WHERE hostname='ciscoE1';

	I'm probably screwing up a basic MySql command - I appreciate your 
patience with me!
	Ah, so. I don't play with MySql once I get it working - as you can tell. 
=8^)
	I *do* get an error:

mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
ERROR 1046 (3D000): No database selected

mysql> use ciscoE1
ERROR 1049 (42000): Unknown database 'ciscoE1'	

	That *is* the correct name of the sensor. From the NSM startup script:

The following sensors are installed on this system:
        ciscoE1



BV> On 2/16/07, Brett Charbeneau <brett@...> wrote:
BV> > > >From a msyql prompt:
BV> > >
BV> > > SELECT sid FROM sensor WHERE hostname='$sensorName'"
BV> > >
BV> > > Change $sensorName to your sensor name (do it once for each sensor if
BV> > > you have more than one. Do you get an error?
BV> >
BV> >         No error (tried it two ways becuase I thought there might be an
BV> > unbalanced quotation mark):
BV> >
BV> >
BV> > Enter password:
BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
BV> > Your MySQL connection id is 6 to server version: 5.0.17-log
BV> >
BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
BV> >
BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'"
BV> >      ">
BV> > [root@... ~]# mysql -h localhost -u root -p
BV> > Enter password:
BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
BV> > Your MySQL connection id is 7 to server version: 5.0.17-log
BV> >
BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
BV> >
BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'
BV> >      ->
BV> >
BV> >
BV> >
BV> >
BV> > --
BV> > ********************************************************************
BV> > Brett Charbeneau
BV> > Network Administrator
BV> > Williamsburg Regional Library
BV> > 7770 Croaker Road
BV> > Williamsburg, VA 23188-7064
BV> > (757)259-4044          http://www.wrl.org
BV> > (757)259-4079 (fax)    brett@...
BV> > ********************************************************************
BV> >
BV> >
BV> > -------------------------------------------------------------------------
BV> > Take Surveys. Earn Cash. Influence the Future of IT
BV> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
BV> > opinions on IT & business topics through brief surveys-and earn cash
BV> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
BV> > _______________________________________________
BV> > Sguil-users mailing list
BV> > Sguil-users@...
BV> > https://lists.sourceforge.net/lists/listinfo/sguil-users
BV> >
BV> 
BV> 
BV> 

-- 
********************************************************************
Brett Charbeneau, GSEC Gold, GCIH Gold
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:43

On Fri, 16 Feb 2007, Brett Charbeneau wrote:

BC> mysql> use ciscoE1
BC> ERROR 1049 (42000): Unknown database 'ciscoE1'	
BC> 
BC> 	That *is* the correct name of the sensor. From the NSM startup script:
BC> 
BC> The following sensors are installed on this system:
BC>         ciscoE1

	Hmm, this is disturbing, looks like no database with the sensor's name:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| sguildb            |
| test               |
+--------------------+
4 rows in set (0.24 sec)

	



-- 
********************************************************************
Brett Charbeneau, GSEC Gold, GCIH Gold
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Bamm Visscher <bamm.visscher@gm...> - 2007-02-16 18:47

USE sguildb;

On 2/16/07, Brett Charbeneau <brett@...> wrote:
> On Fri, 16 Feb 2007, Bamm Visscher wrote:
>
> BV> Sorry, you need to end the statement with a semi colon to be processed.
> BV>
> BV> So
> BV>
> BV> SELECT sid FROM sensor WHERE hostname='ciscoE1';
>
> 	I'm probably screwing up a basic MySql command - I appreciate your
> patience with me!
> 	Ah, so. I don't play with MySql once I get it working - as you can tell.
> =8^)
> 	I *do* get an error:
>
> mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
> ERROR 1046 (3D000): No database selected
>
> mysql> use ciscoE1
> ERROR 1049 (42000): Unknown database 'ciscoE1'	
>
> 	That *is* the correct name of the sensor. From the NSM startup script:
>
> The following sensors are installed on this system:
>         ciscoE1
>
>
>
> BV> On 2/16/07, Brett Charbeneau <brett@...> wrote:
> BV> > > >From a msyql prompt:
> BV> > >
> BV> > > SELECT sid FROM sensor WHERE hostname='$sensorName'"
> BV> > >
> BV> > > Change $sensorName to your sensor name (do it once for each sensor
> if
> BV> > > you have more than one. Do you get an error?
> BV> >
> BV> >         No error (tried it two ways becuase I thought there might be
> an
> BV> > unbalanced quotation mark):
> BV> >
> BV> >
> BV> > Enter password:
> BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> BV> > Your MySQL connection id is 6 to server version: 5.0.17-log
> BV> >
> BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> BV> >
> BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'"
> BV> >      ">
> BV> > [root@... ~]# mysql -h localhost -u root -p
> BV> > Enter password:
> BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> BV> > Your MySQL connection id is 7 to server version: 5.0.17-log
> BV> >
> BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> BV> >
> BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'
> BV> >      ->
> BV> >
> BV> >
> BV> >
> BV> >
> BV> > --
> BV> > ********************************************************************
> BV> > Brett Charbeneau
> BV> > Network Administrator
> BV> > Williamsburg Regional Library
> BV> > 7770 Croaker Road
> BV> > Williamsburg, VA 23188-7064
> BV> > (757)259-4044          http://www.wrl.org
> BV> > (757)259-4079 (fax)    brett@...
> BV> > ********************************************************************
> BV> >
> BV> >
> BV> >
> -------------------------------------------------------------------------
> BV> > Take Surveys. Earn Cash. Influence the Future of IT
> BV> > Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> BV> > opinions on IT & business topics through brief surveys-and earn cash
> BV> >
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> BV> > _______________________________________________
> BV> > Sguil-users mailing list
> BV> > Sguil-users@...
> BV> > https://lists.sourceforge.net/lists/listinfo/sguil-users
> BV> >
> BV>
> BV>
> BV>
>
> --
> ********************************************************************
> Brett Charbeneau, GSEC Gold, GCIH Gold
> Network Administrator
> Williamsburg Regional Library
> 7770 Croaker Road
> Williamsburg, VA 23188-7064
> (757)259-4044          http://www.wrl.org
> (757)259-4079 (fax)    brett@...
> ********************************************************************
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sguil-users mailing list
> Sguil-users@...
> https://lists.sourceforge.net/lists/listinfo/sguil-users
>


-- 
sguil - The Analyst Console for NSM
http://sguil.sf.net

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:49

On Fri, 16 Feb 2007, Bamm Visscher wrote:

BV> USE sguildb;

	Right.
	Here ya go:

mysql> use sguildb;
Database changed
mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
+-----+
| sid |
+-----+
|   1 |
+-----+
1 row in set (0.19 sec)

mysql> 











BV> 
BV> On 2/16/07, Brett Charbeneau <brett@...> wrote:
BV> > On Fri, 16 Feb 2007, Bamm Visscher wrote:
BV> >
BV> > BV> Sorry, you need to end the statement with a semi colon to be processed.
BV> > BV>
BV> > BV> So
BV> > BV>
BV> > BV> SELECT sid FROM sensor WHERE hostname='ciscoE1';
BV> >
BV> > 	I'm probably screwing up a basic MySql command - I appreciate your
BV> > patience with me!
BV> > 	Ah, so. I don't play with MySql once I get it working - as you can tell.
BV> > =8^)
BV> > 	I *do* get an error:
BV> >
BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
BV> > ERROR 1046 (3D000): No database selected
BV> >
BV> > mysql> use ciscoE1
BV> > ERROR 1049 (42000): Unknown database 'ciscoE1'	
BV> >
BV> > 	That *is* the correct name of the sensor. From the NSM startup script:
BV> >
BV> > The following sensors are installed on this system:
BV> >         ciscoE1
BV> >
BV> >
BV> >
BV> > BV> On 2/16/07, Brett Charbeneau <brett@...> wrote:
BV> > BV> > > >From a msyql prompt:
BV> > BV> > >
BV> > BV> > > SELECT sid FROM sensor WHERE hostname='$sensorName'"
BV> > BV> > >
BV> > BV> > > Change $sensorName to your sensor name (do it once for each sensor
BV> > if
BV> > BV> > > you have more than one. Do you get an error?
BV> > BV> >
BV> > BV> >         No error (tried it two ways becuase I thought there might be
BV> > an
BV> > BV> > unbalanced quotation mark):
BV> > BV> >
BV> > BV> >
BV> > BV> > Enter password:
BV> > BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
BV> > BV> > Your MySQL connection id is 6 to server version: 5.0.17-log
BV> > BV> >
BV> > BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
BV> > BV> >
BV> > BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'"
BV> > BV> >      ">
BV> > BV> > [root@... ~]# mysql -h localhost -u root -p
BV> > BV> > Enter password:
BV> > BV> > Welcome to the MySQL monitor.  Commands end with ; or \g.
BV> > BV> > Your MySQL connection id is 7 to server version: 5.0.17-log
BV> > BV> >
BV> > BV> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
BV> > BV> >
BV> > BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1'
BV> > BV> >      ->
BV> > BV> >
BV> > BV> >
BV> > BV> >
BV> > BV> >
BV> > BV> > --
BV> > BV> > ********************************************************************
BV> > BV> > Brett Charbeneau
BV> > BV> > Network Administrator
BV> > BV> > Williamsburg Regional Library
BV> > BV> > 7770 Croaker Road
BV> > BV> > Williamsburg, VA 23188-7064
BV> > BV> > (757)259-4044          http://www.wrl.org
BV> > BV> > (757)259-4079 (fax)    brett@...
BV> > BV> > ********************************************************************
BV> > BV> >
BV> > BV> >
BV> > BV> >
BV> > -------------------------------------------------------------------------
BV> > BV> > Take Surveys. Earn Cash. Influence the Future of IT
BV> > BV> > Join SourceForge.net's Techsay panel and you'll get the chance to
BV> > share your
BV> > BV> > opinions on IT & business topics through brief surveys-and earn cash
BV> > BV> >
BV> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
BV> > BV> > _______________________________________________
BV> > BV> > Sguil-users mailing list
BV> > BV> > Sguil-users@...
BV> > BV> > https://lists.sourceforge.net/lists/listinfo/sguil-users
BV> > BV> >
BV> > BV>
BV> > BV>
BV> > BV>
BV> >
BV> > --
BV> > ********************************************************************
BV> > Brett Charbeneau, GSEC Gold, GCIH Gold
BV> > Network Administrator
BV> > Williamsburg Regional Library
BV> > 7770 Croaker Road
BV> > Williamsburg, VA 23188-7064
BV> > (757)259-4044          http://www.wrl.org
BV> > (757)259-4079 (fax)    brett@...
BV> > ********************************************************************
BV> >
BV> >
BV> > -------------------------------------------------------------------------
BV> > Take Surveys. Earn Cash. Influence the Future of IT
BV> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
BV> > opinions on IT & business topics through brief surveys-and earn cash
BV> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
BV> > _______________________________________________
BV> > Sguil-users mailing list
BV> > Sguil-users@...
BV> > https://lists.sourceforge.net/lists/listinfo/sguil-users
BV> >
BV> 
BV> 
BV> 

-- 
********************************************************************
Brett Charbeneau, GSEC Gold, GCIH Gold
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Bamm Visscher <bamm.visscher@gm...> - 2007-02-16 18:51

Okay, now:

mysql> USE sguildb;
mysql> SELECT * FROM sensor;

Any chance you can IRC to irc.freenode.net and join #snort-gui?

Bammkkkk


On 2/16/07, Brett Charbeneau <brett@...> wrote:
> On Fri, 16 Feb 2007, Bamm Visscher wrote:
>
> BV> USE sguildb;
>
>         Right.
>         Here ya go:
>
> mysql> use sguildb;
> Database changed
> mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
> +-----+
> | sid |
> +-----+
> |   1 |
> +-----+
> 1 row in set (0.19 sec)
>
> mysql>
>
>

Re: [Sguil-users] Lost connection to MySQL server errors on restart

From: Brett Charbeneau <brett@wr...> - 2007-02-16 18:56

On Fri, 16 Feb 2007, Bamm Visscher wrote:

BV> Okay, now:
BV> 
BV> mysql> USE sguildb;
BV> mysql> SELECT * FROM sensor;
BV> 
BV> Any chance you can IRC to irc.freenode.net and join #snort-gui?

	Sure can, I'll head over there now!



BV> On 2/16/07, Brett Charbeneau <brett@...> wrote:
BV> > On Fri, 16 Feb 2007, Bamm Visscher wrote:
BV> >
BV> > BV> USE sguildb;
BV> >
BV> >         Right.
BV> >         Here ya go:
BV> >
BV> > mysql> use sguildb;
BV> > Database changed
BV> > mysql> SELECT sid FROM sensor WHERE hostname='ciscoE1';
BV> > +-----+
BV> > | sid |
BV> > +-----+
BV> > |   1 |
BV> > +-----+
BV> > 1 row in set (0.19 sec)
BV> >
BV> > mysql>
BV> >
BV> >
BV> 
BV> -------------------------------------------------------------------------
BV> Take Surveys. Earn Cash. Influence the Future of IT
BV> Join SourceForge.net's Techsay panel and you'll get the chance to share your
BV> opinions on IT & business topics through brief surveys-and earn cash
BV> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
BV> _______________________________________________
BV> Sguil-users mailing list
BV> Sguil-users@...
BV> https://lists.sourceforge.net/lists/listinfo/sguil-users
BV> 
BV> 

-- 
********************************************************************
Brett Charbeneau, GSEC Gold, GCIH Gold
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          http://www.wrl.org
(757)259-4079 (fax)    brett@...
********************************************************************