TCPDB - Downloads

Recommendation.
Apache or IIS, PHP and MySql.
Pentium II 400
256 MB Memory

200 MB Free disk space.

Install on Linux/Unix.

Logon as root.
Unpack the software into web directory.

Create the mysql database.
mysqladmin create tcpdb
mysql tcpdb < tcpdb.sql

Logon.
Goto your http://yourdomain.com/tcpdb
Username: admin
Password: admin
Remember to change the administrator username and password in config.php file.

Install on Windows.

Download EasyPHP from http://www.easyphp.org/
Install EasyPHP
Unpack the TCPDB software into web directory C:Program FilesEasyPHP1-7www.

Create the mysql database.
C:Program FilesEasyPHP1-7mysqlbinmysqladmin create tcpdb
C:Program FilesEasyPHP1-7mysqlbinmysql tcpdb < C:Program FilesEasyPHP1-7wwwtcpdb.sql

Logon.
Goto your http://yourdomain.com/tcpdb
Username: admin
Password: admin

Change log

TCPDB 1.0
First release.

TCPDB 1.1
Code Cleanup.

TCPDB 1.2
Code Cleanup and some look and feel.

TCPDB 1.3
Event logging and global font and colors.
Upgrade from ver 1.2 to 1.3 you must add this table into MySql database

CREATE TABLE log (
  log varchar(250) default NULL,
  createdate timestamp(14) NOT NULL,
  subnet_id int(11) NOT NULL auto_increment,
  PRIMARY KEY  (subnet_id)
) TYPE=MyISAM;

TCPDB 1.4
Fix in Event logg and global font and colors.

TCPDB 1.5
Compatibility for Windows.
Major code improvements.

TCPDB 2.0
New Look.
Database Status.
Code Cleanup.

Upgrade from ver 1.x to 2.0 you must change TIMESTAMP lenght in MySql database.

ALTER TABLE `dhcp` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;
ALTER TABLE `location` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;
ALTER TABLE `machine_type` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;
ALTER TABLE `os` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;
ALTER TABLE `tcpip` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;
ALTER TABLE `user` CHANGE `createdate` `createdate` TIMESTAMP( 14 ) DEFAULT NULL;

TCPDB 2.1
Sort order on every table view.
More log data.
Security on deleting.

TCPDB 2.2
Bug in sort order.
Windows install documents.
Some new Look.
Code Cleanup.
NsLookup functions.
Ping functions (Linux/Unix only).

TCPDB 2.3
Check if hostname already exist when adding or updating a new host.
Global error handling for PHP in config.php.
PayPal for license.
Bug in NsLookup is fixed.
Some new looks.

TCPDB 2.4
Code Cleanup in Event log.
Prompt when deleting OS.
Prompt when deleting Machine Type.
Prompt when deleting DHCP.
Prompt when deleting User and some changes on edit User.
Export subnet to csv file.

TCPDB 2.5
Bug in license is fixed.
Field selection on export.
Auto refresh of margin when adding or deleting locations.
Hide Username and Password in IE adress bar.

TCPDB 3.0
Major upgrade.
TCPDB now support up to one A Class or 16777216 addresses.
Code Cleanup.
Prompt when deleting Subnet.
Prompt when deleting Subnetmask.
DHCP is fixed for large networks.
Select limited view on subnets.
Export now supports large networks and subnetmask.
Limit on search result.
Important to delete all old web files before upgrade to 3.0 also config.php.

Upgrade from ver 2.x to 3.0 you must make some changes in MySql database.

CREATE TABLE subnetmask (
  hosts int(10) default NULL,
  subnetmask1 varchar(15) default NULL,
  subnetmask2 int(2) default NULL,
  class varchar(1) default NULL,
  createdate timestamp(14) NOT NULL,
  subnetmask_id int(11) NOT NULL auto_increment,
  PRIMARY KEY  (subnetmask_id)
) TYPE=MyISAM;

INSERT INTO subnetmask VALUES (1,'255.255.255.255',32,'D',20040902232413,2);
INSERT INTO subnetmask VALUES (4,'255.255.255.252',30,'D',20040902232614,4);
INSERT INTO subnetmask VALUES (8,'255.255.255.248',29,'D',20040902232705,5);
INSERT INTO subnetmask VALUES (16,'255.255.255.240',28,'D',20040902232753,6);
INSERT INTO subnetmask VALUES (32,'255.255.255.224',27,'D',20040902232943,7);
INSERT INTO subnetmask VALUES (64,'255.255.255.192',26,'D',20040902233039,8);
INSERT INTO subnetmask VALUES (128,'255.255.255.128',25,'D',20040902233136,9);
INSERT INTO subnetmask VALUES (256,'255.255.255.0',24,'C',20040902233234,10);
INSERT INTO subnetmask VALUES (512,'255.255.254.0',23,'C',20040902233332,11);
INSERT INTO subnetmask VALUES (1024,'255.255.252.0',22,'C',20040902233416,12);
INSERT INTO subnetmask VALUES (2048,'255.255.248.0',21,'C',20040902233507,13);
INSERT INTO subnetmask VALUES (4096,'255.255.240.0',20,'C',20040902233620,14);
INSERT INTO subnetmask VALUES (8192,'255.255.224.0',19,'C',20040902233747,15);
INSERT INTO subnetmask VALUES (16384,'255.255.192.0',18,'C',20040902234459,16);
INSERT INTO subnetmask VALUES (32768,'255.255.128.0',17,'C',20040902234620,17);
INSERT INTO subnetmask VALUES (65536,'255.255.0.0',16,'B',20040902234808,18);
INSERT INTO subnetmask VALUES (131072,'255.254.0.0',15,'B',20040902234918,19);
INSERT INTO subnetmask VALUES (262144,'255.252.0.0',14,'B',20040902235050,20);
INSERT INTO subnetmask VALUES (524288,'255.248.0.0',13,'B',20040903000559,21);
INSERT INTO subnetmask VALUES (1048576,'255.249.0.0',12,'B',20040903000727,22);
INSERT INTO subnetmask VALUES (2097152,'255.224.0.0',11,'B',20040903000906,23);
INSERT INTO subnetmask VALUES (4194304,'255.192.0.0',10,'B',20040903001019,24);
INSERT INTO subnetmask VALUES (8388608,'255.128.0.0',9,'B',20040903001220,25);
INSERT INTO subnetmask VALUES (16777216,'255.0.0.0',8,'A',20040903001634,26);

ALTER TABLE `tcpip` DROP `sort`;
ALTER TABLE `tcpip` ADD `mask` INT( 2 ) AFTER `tcpip`;
ALTER TABLE `subnet` ADD `mask` INT( 2 ) AFTER `tcpip`;
ALTER TABLE `tcpip` ADD INDEX ( `subnet_id` );
ALTER TABLE `dhcp` CHANGE `a` `a` INT( 11 ) DEFAULT NULL;
ALTER TABLE `dhcp` CHANGE `b` `b` INT( 11 ) DEFAULT NULL;

Howto Linux:
Logon as root.
Command: mysql tcpdb
Paste the sql commands above in the mysql console.
Howto Windows EasyPHP:
Command: c:Program FilesEasyPHP1-7mysqlbinmysql tcpdb
Paste the sql commands above in the mysql console.

TCPDB 3.1
A major bug in adding D Class net is fixed.
Code Cleanup.

TCPDB 3.2
A bug in the modul search and edit is fixed.

TCPDB 3.3
A bug in export to csv is fixed.
It`s now possible to set an administrator user in the config file.
A new tool for optimizing the database.
MySql server information and PHP information has been added under tools.
Cursor is automatic set on username at login.
Under location it`s now possible to see the usage of every subnet.
Code Cleanup.

TCPDB 3.4
Cursor is automatic set on hostname when edit host.
Cursor is automatic set on Add Location.
Cursor is automatic set on Add OS.
Cursor is automatic set on Add Machine Type.
Cursor is automatic set on Add User.
Cursor is automatic set on Search in margin.
Back button on MySql info and PHP info.

TCPDB 3.5
Code cleanup and code documentation.

TCPDB 3.6
It`s now possible to edit the Location name.
Some new looks.

TCPDB 3.7
It`s now possible to edit the Subnet name and move it to another location.
It`s now possible to rename location in the config.php file.
It`s now possible to search for subnet`s.

TCPDB 3.8
If you have many locations it`s now possible to use an drop down box for locations.
Some new looks.