rasqlinsert and InnoDB

[John Kennedy]

I have things working; however, the saddr and daddr are formated in a way I
am not familiar with. The data in the cell appears to be hex with ascii
representation that looks like %T.00000000.  I am not sure how to convert
this.  Any assistance would be appreciated.

John

On Mon, Mar 19, 2012 at 8:42 AM, Carter Bullard <carter at qosient.com> wrote:

> Hey John,
> In argus-clients-3.0.5.x  (I just uploaded 36), we have two ways to change
> the database table type.  On the command line for rasqlinsert.1, the option
> is:
>   rasqlinsert -M mysql_engine="whatever" ……..
>
> In the .rarc file, there is the variable:
>
>   MYSQL_DB_ENGINE="MyISAM"
>
> You can change that to any of the supported values (InnoDB, Merge,
> Memory, Archive, NDB, Federated, CSV, ….) and any new tables that
> a rasql* program will create will get the new type.
>
> As I mentioned before, we aren't doing a lot of error checking on table
> types,
> schema definitions, etc… to ensure that any existing tables that would
> be written to are "OK to go" so to speak.  We do have the "-M drop" option
> so that if a database table exists, you will drop it and recreate it.
>
> So I would recommend while testing, that on the command-line you use:
>
>   rasqlinsert -M drop mysql_engine="whatever" ……..
>
> To get started, and when happy, you can modify the .rarc file to get the
> behavior you want.
>
> Hope this helps, and if you have any problems, holler !!!!!
>
> Carter
>
>
> On Mar 15, 2012, at 7:26 PM, John Kennedy wrote:
>
> > Hi Carter,
> >
> > I am just curious what mysql engine is supported for rasqlinsert?
>  rasqlinsert works great on a mysql instance using a MyISAM engine;
> however, I get errors when using InnoDB.
> >
> > Thanks
> >
> > John
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120319/de8d4790/attachment.html>