hi me again, Now I'm looking at the MySQL table definition .. my questions is how I will be able to do the following (sorry for so much questions :") ):
1. Create troughput graphic like this : http://ntop-server:port/thptStats.html but for every address (range of addreses) i.e. separately not for all-total. What exactly is saved in IPtraffic table ? Is SQL-statement sent for every packet? Or is some accumulated value ? How TCP sesions should be handled ? I.e. should I summ ip-traffic with tcp-seessions or I should subtract them ? OR I should just use only IPtraffic info ? TCPsentX mean bytes-sent, isn't it ? Do I get only INSERT-queries or other too (as i looked at the perl script there is handling for DELETE, why ?) 2. As I understand session info I should get from TCPSession. Client and Server are not IP-addresses from what I see or they are ? Is there such info for UDP sessions ? 3. How is the info about the bytes passed i.e. accumulative or piece by piece ? What I mean : time/s | accumulated/bytes | pieced/bytes ------------------------------------------ 1 | 5 | 5 3 | 10 | 5 4 | 33 | 23 5 | 57 | 24 ------------------------------------------- total | 57 | 57 CREATE TABLE IPtraffic ( IPaddress CHAR(16) NOT NULL, TCPsentLoc INT, TCPsentRem INT, TCPrcvdLoc INT, TCPrcvdFromRem INT, UDPsentLoc INT, UDPsentRem INT, UDPrcvdLoc INT, UDPrcvdFromRem INT, ICMPsent INT, ICMPrcvd INT, OSPFsent INT, OSPFrcvd INT, IGMPsent INT, IGMPrcvd INT, ); CREATE TABLE TCPsessions ( Client CHAR(18), Server CHAR(18), ClientPort INT, ServerPort INT, DataSent CHAR(16), DataRcvd CHAR(16), FirstSeen DATETIME, LastSeen DATETIME, ID INT NOT NULL AUTO_INCREMENT, ...... ) _______________________________________________ Ntop mailing list [EMAIL PROTECTED] http://lists.ntop.org/mailman/listinfo/ntop
