How to read data from mysql in ntop



  • hey ,
    I read the post about collection of historical flow data in ntop of pfsense.
    https://forum.netgate.com/post/644553
    I followed the somewhat same thing and able to collect the data in mysql.
    I got the two tabels by name of flowV4 and FlowV6
    The problem is that how I can read those tables and can display in human readable format, please help!!



  • @zaber01 said in How to read data from mysql in ntop:

    The problem is that how I can read those tables and can display in human readable format, please help!!

    Bad news and good news.
    90 % ++ of all Internet sites do just that : extract info from MYSQL databases (tables etc) and convert it into html - using some other language - so browser and thus humans have a nice thing to look at.
    With other words : the reply will be huge ...

    How to build a "web site", or the basics of it, is of course not really what you will find on this forum. The good news is : many examples exists on net already.
    Be aware that this needs some basic SQL knowledge, some html knowledge and probably more some PHP knowledge (or whatever you choose to handle the data).
    The basics ... ;)



  • means I have to perform a development task and have to make my own software or website to read that right??



  • Yes.

    Be ware : it might exists already. ntopng is a known tool.
    Fire up your web search tool ?!

    edit : the access to the GeoIP data will be invalid - their usage isn't free any more (see other forum posts).


Log in to reply