Database Table for Host Header Logging

You must manually create the table in the database before TrafMeter records the hosts. A minimal set of the fields for the table is:
 

N	Name	Type	Description
1.	rtime	datetime	Time when this HTTP request was completed
2.	filterid	smallint	Filter Id
3.	rtype	smallint	Type of the HTTP request
4.	method	smallint	Method of the HTTP request
5.	reason	smallint	Exit code of the HTTP request
6.	clt_ip	char(16)	IP address of a client (in decimal-dotted notation, e.g. 192.168.3.250)
7.	clt_port	int	TCP port number of the client (the range is 0-65535)
8.	srv_ip	char(16)	IP address of a server (in decimal-dotted notation, e.g. 192.168.3.1)
9.	srv_port	int	TCP port number of the server (the range is 0-65535)
10.	clt_bytes	int	Number of bytes transferred from the client to the server
11.	srv_bytes	int	Number of bytes transferred from the server to the client
12.	host	char(250)	Host name

 
See also:

• Microsoft SQL Server Syntax to create the table for Host Header Logging
• MySQL Syntax to create the table for Host Header Logging
• Microsoft Access Syntax to create the table for Host Header Logging