rasqlinsert user data

[CS Lee]

hi carter,

I get this error from rasqlinsert -

rasqlinsert[1638]: 1326939805.819339 mysql_real_query error You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near
'.O.r..ov......T.^.7...D;.....n.....$.z.1%%N{V!&=.Z..\...../+.x..2...=..r).|3<....'
at line 1
rasqlinsert[1638]: 1326939808.743096 mysql_real_query error You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '....*=.z....=o...s......4&
.V..h.....vn.....=..Q..h..a....{......{).1..mj.NS..\.' at line 1

To reproduce it -

argus -mAJZRU 512 -i eth0 -B 127.0.0.1 -P 561 -d
rasqlinsert -u -n -S localhost:561 -w
mysql://root@localhost/argusdb/argusdb_test
-M cache -m srcid proto saddr sport daddr dport -s stime ltime dur srcid
flgs proto saddr sport dir daddr dport pkts bytes appbytes state spkts
dpkts sbytes dbytes sappbytes dappbytes smac dmac suser duser - ip

However if i set the user data byte with -U 64 instead of -U 512 in argus,
and using same rasqlinsert command, the error doesn't appear, I haven't
checked through if this has anything to do with sql strict mode and
varbinary max length for suser and duser in mysql yet. By the way I'm using
Mysql 5.1


-- 
Best Regards,

CS Lee<geek00L[at]gmail.com>

http://geek00l.blogspot.com
http://defcraft.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120119/631e18a6/attachment.html>