rasqlinsert and InnoDB

[Carter Bullard]

Hey John,
If you don't mind, send the command line that you are using, any .rarc that maybe
involved, and if you could dump a description of the mysql table, that would be
great.  In mysql.1 its something like:
   mysql> use db;
   mysql> desc table;

Carter


On Mar 19, 2012, at 2:54 PM, John Kennedy 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/66e8edd9/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/66e8edd9/attachment.bin>