To answer my own Q, this functions can be used - http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Bigint_to_ip I tried it with a few IPs (PostgreSQL table ) and compared to the alert log generated by ossec. It works.
On Wednesday, September 11, 2013 2:02:23 PM UTC+5:30, Jayadevan M wrote: > > The column data types are INT8 for IPs in the table. How can we map it to > valid/real IPs in IPV4 format? > -- --- You received this message because you are subscribed to the Google Groups "ossec-list" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
