Open-AudIT
https://www.open-audit.org/phpBB3/

Why Open-Audit padding "0" to IP V4 address on "IP" table?
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6567
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.
Regards,
Satoru Funai

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.
Code:
INET_NTOA(INET_ATON(ip))

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/