Forum Discussion

Rodolphe_AUBINE's avatar
Rodolphe_AUBINE
Icon for Nimbostratus rankNimbostratus
Jan 02, 2014

Embeded Mysql ASM database - how to display src_ip datas from PRX.PROXY_LOG

Hello,

 

The reporting tool built into the GUI ASM can not meet my specific needs analysis. Therefore, to meet these needs I perform some SQL queries directly in the internal MySQL database.

 

The only thing I miss: How to get the IP addresses in a viewable format (as stored in varbinary (16)? Outside a CAST or CONVERT, the data is encrypted it?

 

management
mysql
security
storage
TMSH
  • Bernardo_Gui's avatar
    Bernardo_Gui
    Icon for Nimbostratus rankNimbostratus
    Dec 04, 2014

    Hello, I think that you are searching for this:

    concat(conv(substring(hex(src_ip),25,2),16,10),'.',concat(conv(substring(hex(src_ip),27,2),16,10).

    Or you can create a Procedure in Mysql.

    In Mysql recent version there is a INET6_ATON(expr) function.

    Bye!