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

[Bamm V. <bam...@gm...>]

USE sguildb;

On 2/16/07, Brett Charbeneau <br...@wr...> 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 <br...@wr...> 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@resolute ~]# 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          www.wrl.org
> BV> > (757)259-4079 (fax)    br...@wr...
> 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> > Sgu...@li...
> 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          www.wrl.org
> (757)259-4079 (fax)    br...@wr...
> ********************************************************************
>
>
> -------------------------------------------------------------------------
> 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
> Sgu...@li...
> https://lists.sourceforge.net/lists/listinfo/sguil-users
>


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