|Why Open-Audit padding "0" to IP V4 address on "IP" table?
|Page 1 of 1|
|Author:||satoru [ Thu Nov 24, 2016 3:33 pm ]|
|Post subject:||Why Open-Audit padding "0" to IP V4 address on "IP" table?|
I need to retrieve ip address v4 of all interfaces, but "ip" culomn data on "IP" table is padding with "0".
eg. 10.0.0.1 -> 010.000.000.001
I checked audit_linux.sh and it create normal (eg. 10.0.0.1) output in xml.
"010.000.000.001" format is hard to handle in SQL for us.
Are there any way to convert or store with normal format in Open-Audit database?
Any suggestions would be appreciated.
|Author:||jpa [ Tue Nov 29, 2016 2:26 am ]|
|Post subject:||Re: Why Open-Audit padding "0" to IP V4 address on "IP" tabl|
Probably to make IP range calculation easy. May be a historical artifact but I'm not sure.
This should unpad in a SQL query. There may be better ways.
|Page 1 of 1||All times are UTC + 10 hours|
|Powered by phpBB® Forum Software © phpBB Group