rasqlinsert and InnoDB

[John Kennedy]

After some testing I found that using the -m none option gives the
erroneous data; however, if I enter the fields using the -s option
everything seems to be OK.

John

On Mon, Mar 19, 2012 at 12:54 PM, John Kennedy <wilson.amajohn at gmail.com>wrote:

> 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/ac18fcbb/attachment.html>