How Can I inert mac with rasqlinsert?

[modversion]

Hi Carter, it works fine , thank you very mych!

 

From: Carter Bullard [mailto:carter at qosient.com] 
Sent: Sunday, August 01, 2010 10:50 PM
To: modversion
Cc: argus-info at lists.andrew.cmu.edu
Subject: Re: [ARGUS] How Can I inert mac with rasqlinsert?

 

Whenever you insert data using rasqlinsert() the whole argus record is
inserted as binary data in each row.

So the mac's are there, and you can print them using rasql().

 

   rasql -r mysql://argus@localhost/argusData/argusTable_2010_08_01 -s +smac
+dmac

 

but to have them as mysql table attributes, you just need to indicate you
want it as a printed field.

In your example, you aren't specifying any fields using the "-s field ..."
option, so you are using the defaults,

or the fields defined in your ~/.rarc.  Try this

 

   rasqlinsert -S localhost:561 -m none -d -M time 1s -w
mysql://user@host/db/table -s +smac +dmac

 

or add "smac dmac"  to your RA_FIELD_SPECIFIER in your ~/.rarc

 

This will add smac and dmac to your database schema, which you can verify
using the mysql

command, 'desc table'.

 

   % mysql

   mysql> use argusData;

   mysql> desc argusTable_2010_08_01;

 

Adding this and running it may cause rasqlinsert() to try to insert the
fields into an existing table that

doesn't have these fields in it, and it will fail, so be sure and drop any
tables that cause problems.

mysql() will allow you to add attributes to existing tables, so if its
really important, you can make

a legacy table usable.

 

Remember the more fields you "expose" in mysql() the more cycles it will
take to insert a record,

so expose them in mysql if you will have queries that use the fields.  If
not, use rasql() to grab

the fields when you need them.

 

Carter

 

 

 

On Aug 1, 2010, at 8:00 AM, modversion wrote:





Hi list:

How Can I inert mac with rasqlinsert? I've set ARGUS_GENERATE_MAC_DATA=yes
to collect the mac address,but I can not store the smac and dmac in the
mysql database via the command "/usr/local/bin/rasqlinsert -S localhost:561
-m none -d -M time 1d -w
mysql://argus@localhost/argusData/argusTable_%Y_%m_%d".

 

Anybody could be kind enough to do me a favor and tell me how can I get the
mac into mysql database,thank you very much!

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20100802/b92f2b58/attachment.html>