rasqlinsert asn number

[CS Lee]

hi Carter,

For the asn issue, once I change the data type from tinyint to int, it works
alright -

mysql>ALTER table ralabel MODIFY sas int(10) unsigned;
mysql>ALTER table ralabel MODIFY das int(10) unsigned;

ralabel -S localhost -f ralabel.conf -w - | rasqlinsert -r - -w
mysql://root@localhost/argusdb/ralabel -m none -s +sas +das +label

mysql> select saddr,daddr,sas,das from ralabel limit 10;
+---------------+---------------+-------+-------+
| saddr         | daddr         | sas   | das   |
+---------------+---------------+-------+-------+
| 192.168.1.193 | 174.129.1.114 |     0 | 14618 |
| 192.168.1.193 | 174.129.1.114 |     0 | 14618 |
| 174.129.1.114 | 192.168.1.193 | 14618 |     0 |
| 192.168.1.153 | 64.233.189.18 |     0 | 15169 |
| 192.168.1.193 | 60.53.224.5   |     0 |  4788 |
| 192.168.1.193 | 58.27.186.121 |     0 | 38264 |
| 192.168.1.193 | 174.129.1.114 |     0 | 14618 |
| 192.168.1.193 | 174.129.1.114 |     0 | 14618 |
| 192.168.1.193 | 174.129.1.114 |     0 | 14618 |
| 192.168.1.153 | 76.13.15.45   |     0 | 14778 |
+---------------+---------------+-------+-------+
10 rows in set (0.07 sec)

Thanks ;)

-- 
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/20090913/4bb339e1/attachment.html>