GroundWork Configuration Management Installation |
';
if ($step == 1) {
$connection = mysql_connect($mysql_host, $mysql_user, $mysql_pwd);
mysql_select_db($mysql_db) or die(mysql_error());
mysql_query("
CREATE TABLE services (
id int(11) NOT NULL auto_increment,
name varchar(60) default NULL,
PRIMARY KEY (id)
)")or die(mysql_errno() . " " . mysql_error());
mysql_query("
CREATE TABLE interfaces (
id int(11) NOT NULL auto_increment,
name varchar(60) default NULL,
PRIMARY KEY (id)
)")or die(mysql_errno() . " " . mysql_error());
mysql_query("
CREATE TABLE host_interface (
id int(11) NOT NULL auto_increment,
host_id int(11) NOT NULL,
interface_id int(11) NOT NULL,
PRIMARY KEY (id)
)")or die(mysql_errno() . " " . mysql_error());
mysql_query("
CREATE TABLE host_service (
id int(11) NOT NULL auto_increment,
host_id int(11) NOT NULL,
service_id int(11) NOT NULL,
PRIMARY KEY (id)
)")or die(mysql_errno() . " " . mysql_error());
mysql_query("
CREATE TABLE hosts (
id int(11) NOT NULL auto_increment,
name varchar(60) default NULL,
address varchar(60) default NULL,
os varchar(60) default NULL,
serial varchar(60) default NULL,
type varchar(60) default NULL,
PRIMARY KEY (id)
)")or die(mysql_errno() . " " . mysql_error());
if (isset($samdat)) {
mysql_query("insert into hosts values(NULL, 'mercury', '192.168.2.7', 'redhat', 'F897342HG', 'intel')");
mysql_query("insert into hosts values(NULL, 'venus', '192.168.2.3', 'aix', 'F897342HG', 'aix')");
mysql_query("insert into hosts values(NULL, 'earth', '192.168.2.2', 'os400', 'F897342HG', 'as400')");
mysql_query("insert into hosts values(NULL, 'mars', '192.168.2.16', 'redhat', 'F897342HG', 'intel')");
mysql_query("insert into hosts values(NULL, 'jupiter', '192.168.2.17', 'redhat', 'F897342HG', 'intel')");
mysql_query("insert into hosts values(NULL, 'saturn', '192.168.2.15', 'redhat', 'F897342HG', 'intel')");
mysql_query("insert into hosts values(NULL, 'uranus', '192.168.2.11', 'redhat', 'F897342HG', 'intel')");
mysql_query("insert into hosts values(NULL, 'neptune', '192.168.2.13', 'solaris', 'F897342HG', 'sun')");
mysql_query("insert into hosts values(NULL, 'pluto', '192.168.2.12', 'windows', 'F897342HG', 'intel')");
mysql_query("insert into services values(NULL, 'cpu')");
mysql_query("insert into services values(NULL, 'disk')");
mysql_query("insert into services values(NULL, 'memory')");
mysql_query("insert into services values(NULL, 'process')");
mysql_query("insert into services values(NULL, 'service')");
}
echo '
';
} else {
echo '
';
}
echo '
|