rasqlinsert and InnoDB

Carter Bullard carter at qosient.com
Mon Mar 19 16:42:25 EDT 2012


Hey John,
Good to see there is a work-around.
Not sure that I can replicate this with the info that you've sent so far.
If you could give a bit of a description of what you're doing and the 
erroneous data formats you're seeing, I can fix it.

Carter 

On Mar 19, 2012, at 4:34 PM, John Kennedy wrote:

> 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/5353ad8a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4367 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120319/5353ad8a/attachment.bin>


More information about the argus mailing list