Hi there !
When I try to save (using UDP connection) from NTOP to an ODBC database, some
errors happened and I've found that some fields in the IPTraffic are
incorrect (I mean : what was defined in the /database dir in the
MySQLdefs.txt file) .
As soon as I fixed it, I was able to save to my database.
I am sending the correct tables below. I hope this help.
Thank you all for this incredible tool.
Ricardo Jorge
P.S. I also developed a small module using Tcl to receive the UDP connection
and save SQL statements into an ODBC database. If someone think this could
help, I can send it to the list.
--------------------------------------------------------------------------------
# phpMyAdmin MySQL-Dump
# version 2.2.5
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# M�quina: 127.0.0.1
# Data de Cria��o: 22-Mai-2002 �s 10:12
# Vers�o do servidor: 3.23.46
# vers�o do PHP: 4.1.1
# Base de Dados : `NTOP`
# --------------------------------------------------------
#
# Estrutura da tabela `Hosts`
#
DROP TABLE IF EXISTS Hosts;
CREATE TABLE Hosts (
ID int(11) NOT NULL auto_increment,
IPaddress char(16) NOT NULL default '',
MACaddress char(50) default NULL,
NICvendor char(32) default NULL,
OsName char(50) default NULL,
PktRcvd int(11) default NULL,
PktSent int(11) default NULL,
PktMulticastSent int(11) default NULL,
PktBroadcastSent int(11) default NULL,
DataSent int(11) default NULL,
DataRcvd int(11) default NULL,
FirstSeen datetime default NULL,
LastSeen datetime default NULL,
DataMulticastSent int(11) default NULL,
DataBroadcastSent int(11) default NULL,
PRIMARY KEY (ID),
KEY ID (ID)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Estrutura da tabela `IPtraffic`
#
DROP TABLE IF EXISTS IPtraffic;
CREATE TABLE IPtraffic (
IPaddress char(16) NOT NULL default '',
TCPSentLoc int(11) default NULL,
TCPSentRem int(11) default NULL,
TCPrcvdLoc int(11) default NULL,
TCPrcvdFromRem int(11) default NULL,
UDPSentLoc int(11) default NULL,
UDPSentRem int(11) default NULL,
UDPrcvdLoc int(11) default NULL,
UDPrcvdFromRem int(11) default NULL,
ICMPsent int(11) default NULL,
ICMPrcvd int(11) default NULL,
OSPFsent int(11) default NULL,
OSPFrcvd int(11) default NULL,
IGMPsent int(11) default NULL,
IGMPrcvd int(11) default NULL,
PRIMARY KEY (IPaddress)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Estrutura da tabela `NameMapper`
#
DROP TABLE IF EXISTS NameMapper;
CREATE TABLE NameMapper (
IPaddress char(16) NOT NULL default '',
Name char(50) default NULL,
PRIMARY KEY (IPaddress)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Estrutura da tabela `NonIPTraffic`
#
DROP TABLE IF EXISTS NonIPTraffic;
CREATE TABLE NonIPTraffic (
IPaddress char(16) NOT NULL default '',
IPXsent int(11) default NULL,
IPXrcvd int(11) default NULL,
OSIsent int(11) default NULL,
OSIrcvd int(11) default NULL,
DLCsent int(11) default NULL,
DLCrcvd int(11) default NULL,
ARPsent int(11) default NULL,
ARPrcvd int(11) default NULL,
DECNETsent int(11) default NULL,
DECNETrcvd int(11) default NULL,
ATALKsent int(11) default NULL,
ATALKrcvd int(11) default NULL,
NBIOSsent int(11) default NULL,
NBIOSrcvd int(11) default NULL,
OtherSent int(11) default NULL,
OtherRcvd int(11) default NULL,
PRIMARY KEY (IPaddress)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Estrutura da tabela `TCPsessions`
#
DROP TABLE IF EXISTS TCPsessions;
CREATE TABLE TCPsessions (
Client char(18) default NULL,
Server char(18) default NULL,
ClientPort int(11) default NULL,
ServerPort int(11) default NULL,
DataSent char(16) default NULL,
DataRcvd char(16) default NULL,
FirstSeen datetime default NULL,
LastSeen datetime default NULL,
ID int(11) NOT NULL auto_increment,
PRIMARY KEY (ID),
KEY ID (ID)
) TYPE=MyISAM;
_______________________________________________
Ntop-dev mailing list
[EMAIL PROTECTED]
http://listgateway.unipi.it/mailman/listinfo/ntop-dev
