Exemplo n.º 1
0
function checkMysql()
{
    $q = new mysql();
    if (!$q->DATABASE_EXISTS("powerdns")) {
        echo "Starting......: PowerDNS creating 'powerdns' database\n";
        if (!$q->CREATE_DATABASE("powerdns")) {
            echo "Starting......: PowerDNS creating 'powerdns' database failed\n";
            return;
        }
    }
    echo "Starting......: PowerDNS 'powerdns' database OK\n";
    if (!$q->TABLE_EXISTS("domains", "powerdns")) {
        echo "Starting......: PowerDNS creating 'domains' table\n";
        $sql = "create table domains (\n\t\t\t id\t\t INT auto_increment,\n\t\t\t name\t\t VARCHAR(255) NOT NULL,\n\t\t\t master\t\t VARCHAR(128) DEFAULT NULL,\n\t\t\t last_check\t INT DEFAULT NULL,\n\t\t\t type\t\t VARCHAR(6) NOT NULL,\n\t\t\t notified_serial INT DEFAULT NULL, \n\t\t\t account         VARCHAR(40) DEFAULT NULL,\n\t\t\t primary key (id)\n\t\t\t) Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'domains' table FAILED\n";
        } else {
            $q->QUERY_SQL("CREATE UNIQUE INDEX name_index ON domains(name);", "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("records", "powerdns")) {
        echo "Starting......: PowerDNS creating 'records' table\n";
        $sql = "CREATE TABLE records (\n\t\t\t  id              INT auto_increment,\n\t\t\t  domain_id       INT DEFAULT NULL,\n\t\t\t  name            VARCHAR(255) DEFAULT NULL,\n\t\t\t  type            VARCHAR(10) DEFAULT NULL,\n\t\t\t  content         VARCHAR(255) DEFAULT NULL,\n\t\t\t  ttl             INT DEFAULT NULL,\n\t\t\t  prio            INT DEFAULT NULL,\n\t\t\t  change_date     INT DEFAULT NULL,\n\t\t\t  primary key(id)\n\t\t\t)Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'records' table FAILED\n";
        }
        $q->QUERY_SQL("CREATE INDEX rec_name_index ON records(name);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX nametype_index ON records(name,type);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX domain_id ON records(domain_id);", "powerdns");
        $q->QUERY_SQL("alter table records add ordername VARCHAR(255);", "powerdns");
        $q->QUERY_SQL("alter table records add auth bool;", "powerdns");
        $q->QUERY_SQL("create index orderindex on records(ordername);", "powerdns");
        $q->QUERY_SQL("alter table records change column type type VARCHAR(10);", "powerdns");
    }
    if (!$q->TABLE_EXISTS("supermasters", "powerdns")) {
        echo "Starting......: PowerDNS creating 'supermasters' table\n";
        $sql = "create table supermasters (\n\t\t\t\t  ip VARCHAR(25) NOT NULL, \n\t\t\t\t  nameserver VARCHAR(255) NOT NULL, \n\t\t\t\t  account VARCHAR(40) DEFAULT NULL\n\t\t\t\t) Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'supermasters' table FAILED\n";
        }
        $q->QUERY_SQL("CREATE INDEX rec_name_index ON records(name);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX nametype_index ON records(name,type);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX domain_id ON records(domain_id);", "powerdns");
    }
    if (!$q->TABLE_EXISTS("domainmetadata", "powerdns")) {
        echo "Starting......: PowerDNS creating 'domainmetadata' table\n";
        $sql = "create table domainmetadata (\n\t\t\t id              INT auto_increment,\n\t\t\t domain_id       INT NOT NULL,\n\t\t\t kind            VARCHAR(16),\n\t\t\t content        TEXT,\n\t\t\t primary key(id)\n\t\t\t);";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'domainmetadata' table FAILED\n";
        } else {
            $q->QUERY_SQL("create index domainmetaidindex on domainmetadata(domain_id);", "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("cryptokeys", "powerdns")) {
        echo "Starting......: PowerDNS creating 'cryptokeys' table\n";
        $sql = "create table cryptokeys (\n\t\t\t id             INT auto_increment,\n\t\t\t domain_id      INT NOT NULL,\n\t\t\t flags          INT NOT NULL,\n\t\t\t active         BOOL,\n\t\t\t content        TEXT,\n\t\t\t primary key(id)\n\t\t\t); ";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'cryptokeys' table FAILED\n";
        } else {
            $q->QUERY_SQL("create index domainidindex on cryptokeys(domain_id);", "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("tsigkeys", "powerdns")) {
        echo "Starting......: PowerDNS creating 'tsigkeys' table\n";
        $sql = "create table tsigkeys (\n\t\t\t id             INT auto_increment,\n\t\t\t name           VARCHAR(255), \n\t\t\t algorithm      VARCHAR(255),\n\t\t\t secret         VARCHAR(255),\n\t\t\t primary key(id)\n\t\t\t);";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'tsigkeys' table FAILED\n";
        } else {
            $q->QUERY_SQL("create unique index namealgoindex on tsigkeys(name, algorithm);", "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("users", "powerdns")) {
        echo "Starting......: PowerDNS creating 'users' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `users` (\n\t\t\t  `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t  `username` varchar(16) NOT NULL DEFAULT '0',\n\t\t\t  `password` varchar(34) NOT NULL DEFAULT '0',\n\t\t\t  `fullname` varchar(255) NOT NULL DEFAULT '0',\n\t\t\t  `email` varchar(255) NOT NULL DEFAULT '0',\n\t\t\t  `description` varchar(1024) NOT NULL DEFAULT '0',\n\t\t\t  `perm_templ` tinyint(4) NOT NULL DEFAULT '0',\n\t\t\t  `active` tinyint(4) NOT NULL DEFAULT '0',\n\t\t\t  PRIMARY KEY (`id`))";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'users' table FAILED\n";
        }
    }
    if (!$q->TABLE_EXISTS("perm_items", "powerdns")) {
        echo "Starting......: PowerDNS creating 'perm_items' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_items` (\n\t\t  `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t  `name` varchar(64) NOT NULL DEFAULT '0',\n\t\t  `descr` varchar(1024) NOT NULL DEFAULT '0',\n\t\t  PRIMARY KEY (`id`)\n\t\t) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'perm_items' table FAILED\n";
        } else {
            $sql = "INSERT INTO `perm_items` (`id`, `name`, `descr`) VALUES\n\t\t\t(41, 'zone_master_add', 'User is allowed to add new master zones.'),\n\t\t\t(42, 'zone_slave_add', 'User is allowed to add new slave zones.'),\n\t\t\t(43, 'zone_content_view_own', 'User is allowed to see the content and meta data of zones he owns.'),\n\t\t\t(44, 'zone_content_edit_own', 'User is allowed to edit the content of zones he owns.'),\n\t\t\t(45, 'zone_meta_edit_own', 'User is allowed to edit the meta data of zones he owns.'),\n\t\t\t(46, 'zone_content_view_others', 'User is allowed to see the content and meta data of zones he does not own.'),\n\t\t\t(47, 'zone_content_edit_others', 'User is allowed to edit the content of zones he does not own.'),\n\t\t\t(48, 'zone_meta_edit_others', 'User is allowed to edit the meta data of zones he does not own.'),\n\t\t\t(49, 'search', 'User is allowed to perform searches.'),\n\t\t\t(50, 'supermaster_view', 'User is allowed to view supermasters.'),\n\t\t\t(51, 'supermaster_add', 'User is allowed to add new supermasters.'),\n\t\t\t(52, 'supermaster_edit', 'User is allowed to edit supermasters.'),\n\t\t\t(53, 'user_is_ueberuser', 'User has full access. God-like. Redeemer.'),\n\t\t\t(54, 'user_view_others', 'User is allowed to see other users and their details.'),\n\t\t\t(55, 'user_add_new', 'User is allowed to add new users.'),\n\t\t\t(56, 'user_edit_own', 'User is allowed to edit their own details.'),\n\t\t\t(57, 'user_edit_others', 'User is allowed to edit other users.'),\n\t\t\t(58, 'user_passwd_edit_others', 'User is allowed to edit the password of other users.'),\n\t\t\t(59, 'user_edit_templ_perm', 'User is allowed to change the permission template that is assigned to a user.'),\n\t\t\t(60, 'templ_perm_add', 'User is allowed to add new permission templates.'),\n\t\t\t(61, 'templ_perm_edit', 'User is allowed to edit existing permission templates.');";
            $q->QUERY_SQL($sql, "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("perm_templ", "powerdns")) {
        echo "Starting......: PowerDNS creating 'perm_templ' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_templ` (\n\t\t\t  `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t  `name` varchar(128) NOT NULL DEFAULT '0',\n\t\t\t  `descr` varchar(1024) NOT NULL DEFAULT '0',\n\t\t\t  PRIMARY KEY (`id`)\n\t\t\t) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'perm_templ' table FAILED\n";
        } else {
            $sql = "INSERT INTO `perm_templ` (`id`, `name`, `descr`) VALUES (1, 'Administrator', 'Administrator template with full rights.');";
            $q->QUERY_SQL($sql, "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("perm_templ_items", "powerdns")) {
        echo "Starting......: PowerDNS creating 'perm_templ_items' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_templ_items` (\n\t\t  `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t  `templ_id` int(11) NOT NULL DEFAULT '0',\n\t\t  `perm_id` int(11) NOT NULL DEFAULT '0',\n\t\t  PRIMARY KEY (`id`)\n\t\t) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=250 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'perm_templ_items' table FAILED\n";
        } else {
            $sql = "INSERT INTO `perm_templ_items` (`id`, `templ_id`, `perm_id`) VALUES (249, 1, 53);";
            $q->QUERY_SQL($sql, "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("zones", "powerdns")) {
        echo "Starting......: PowerDNS creating 'zones' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zones` (\n\t\t  `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t  `domain_id` int(11) NOT NULL DEFAULT '0',\n\t\t  `owner` int(11) NOT NULL DEFAULT '0',\n\t\t  `comment` varchar(1024) DEFAULT '0',\n\t\t  `zone_templ_id` int(11) NOT NULL,\n\t\t  PRIMARY KEY (`id`)\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'zones' table FAILED\n";
        }
    }
    if (!$q->TABLE_EXISTS("zone_templ", "powerdns")) {
        echo "Starting......: PowerDNS creating 'zone_templ' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zone_templ` (\n\t\t\t  `id` bigint(20) NOT NULL AUTO_INCREMENT,\n\t\t\t  `name` varchar(128) NOT NULL DEFAULT '0',\n\t\t\t  `descr` varchar(1024) NOT NULL DEFAULT '0',\n\t\t\t  `owner` bigint(20) NOT NULL DEFAULT '0',\n\t\t\t  PRIMARY KEY (`id`)\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'zone_templ' table FAILED\n";
        }
    }
    if (!$q->TABLE_EXISTS("zone_templ_records", "powerdns")) {
        echo "Starting......: PowerDNS creating 'zone_templ_records' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zone_templ_records` (\n\t\t  `id` bigint(20) NOT NULL AUTO_INCREMENT,\n\t\t  `zone_templ_id` bigint(20) NOT NULL DEFAULT '0',\n\t\t  `name` varchar(255) NOT NULL DEFAULT '0',\n\t\t  `type` varchar(6) NOT NULL DEFAULT '0',\n\t\t  `content` varchar(255) NOT NULL DEFAULT '0',\n\t\t  `ttl` bigint(20) NOT NULL DEFAULT '0',\n\t\t  `prio` bigint(20) NOT NULL DEFAULT '0',\n\t\t  PRIMARY KEY (`id`)\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: PowerDNS creating 'zone_templ_records' table FAILED\n";
        }
    }
    echo "Starting......: PowerDNS Mysql done...\n";
    poweradmin();
}
Exemplo n.º 2
0
function checkMysql($nollop = false)
{
    $unix = new unix();
    $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time";
    if ($unix->file_time_min($timefile) < 1) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS need at least 1mn, aborting\n";
        return;
    }
    @unlink($timefile);
    @file_put_contents($timefile, time());
    $passwdcmdline = null;
    $mysql = $unix->find_program("mysql");
    $q = new mysql();
    if (!$q->TestingConnection(true)) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating, MySQL seems not ready..\n";
        return;
    }
    forward_zones();
    if (!$q->DATABASE_EXISTS("powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'powerdns' database\n";
        if (!$q->CREATE_DATABASE("powerdns")) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'powerdns' database failed\n";
            return;
        }
    }
    echo "Starting......: " . date("H:i:s") . " PowerDNS 'powerdns' database OK\n";
    $f["cryptokeys"] = true;
    $f["domainmetadata"] = true;
    $f["domains"] = true;
    $f["perm_items"] = true;
    $f["perm_templ"] = true;
    $f["perm_templ_items"] = true;
    $f["records"] = true;
    $f["supermasters"] = true;
    $f["tsigkeys"] = true;
    $f["users"] = true;
    $f["zones"] = true;
    $f["zone_templ"] = true;
    $f["zone_templ_records"] = true;
    $resultTables = true;
    while (list($tablename, $line2) = each($f)) {
        if (!$q->TABLE_EXISTS($tablename, "powerdns")) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS Table `{$tablename}` failed...\n";
            $resultTables = false;
            continue;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS Table `{$tablename}` OK...\n";
    }
    if ($resultTables) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS pass tests Success...\n";
        return true;
    }
    $dumpfile = "/usr/share/artica-postfix/bin/install/pdns/powerdns.sql";
    if (!is_file($dumpfile)) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS /usr/share/artica-postfix/bin/install/pdns/powerdns.sql no such file...\n";
        return;
    }
    echo "Starting......: " . date("H:i:s") . " PowerDNS installing database...\n";
    if ($q->mysql_password != null) {
        $passwdcmdline = " -p{$q->mysql_password}";
    }
    $cmd = "{$mysql} -B -u {$q->mysql_admin}{$passwdcmdline} --database=powerdns -E < {$dumpfile} >/dev/null 2>&1";
    shell_exec($cmd);
    reset($f);
    $resultTables = true;
    while (list($tablename, $line2) = each($f)) {
        if (!$q->TABLE_EXISTS($tablename, "powerdns")) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS Table `{$tablename}` failed...\n";
            $resultTables = false;
            continue;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS Table `{$tablename}` OK...\n";
    }
    if ($resultTables) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS Success...\n";
        return true;
    }
    if (!$q->TABLE_EXISTS("domains", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'domains' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS domains (\n\t\t\t id\t\t INT auto_increment,\n\t\t\t name\t\t VARCHAR(255) NOT NULL,\n\t\t\t master\t\t VARCHAR(128) DEFAULT NULL,\n\t\t\t last_check\t INT DEFAULT NULL,\n\t\t\t type\t\t VARCHAR(6) NOT NULL,\n\t\t\t notified_serial INT DEFAULT NULL, \n\t\t\t account         VARCHAR(40) DEFAULT NULL,\n\t\t\t primary key (id)\n\t\t\t) Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'domains' table FAILED\n";
        } else {
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS table 'domains' Success\n";
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS table 'domains' Success\n";
        $q->QUERY_SQL("CREATE UNIQUE INDEX name_index ON domains(name);", "powerdns");
    }
    if (!$q->TABLE_EXISTS("records", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'records' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS records (\n\t\t\t  id              INT auto_increment,\n\t\t\t  domain_id       INT DEFAULT NULL,\n\t\t\t  name            VARCHAR(255) DEFAULT NULL,\n\t\t\t  type            VARCHAR(10) DEFAULT NULL,\n\t\t\t  content         VARCHAR(255) DEFAULT NULL,\n\t\t\t  ttl             INT DEFAULT NULL,\n\t\t\t  prio            INT DEFAULT NULL,\n\t\t\t  change_date     INT DEFAULT NULL,\n\t\t\t  explainthis     VARCHAR(255) DEFAULT NULL,\n\t\t\t  primary key(id)\n\t\t\t)Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'records' table FAILED\n";
            return;
        }
        $q->QUERY_SQL("CREATE INDEX rec_name_index ON records(name);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX nametype_index ON records(name,type);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX domain_id ON records(domain_id);", "powerdns");
        $q->QUERY_SQL("alter table records add ordername VARCHAR(255);", "powerdns");
        $q->QUERY_SQL("alter table records add auth bool;", "powerdns");
        $q->QUERY_SQL("create index orderindex on records(ordername);", "powerdns");
        $q->QUERY_SQL("alter table records change column type type VARCHAR(10);", "powerdns");
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'records' table success\n";
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'records' table success\n";
    }
    if (!$q->TABLE_EXISTS("supermasters", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'supermasters' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS supermasters (\n\t\t\t\t  ip VARCHAR(25) NOT NULL, \n\t\t\t\t  nameserver VARCHAR(255) NOT NULL, \n\t\t\t\t  account VARCHAR(40) DEFAULT NULL\n\t\t\t\t) Engine=InnoDB;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'supermasters' table FAILED\n";
            return;
        }
        $q->QUERY_SQL("CREATE INDEX rec_name_index ON records(name);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX nametype_index ON records(name,type);", "powerdns");
        $q->QUERY_SQL("CREATE INDEX domain_id ON records(domain_id);", "powerdns");
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'supermasters' table success\n";
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'supermasters' table success\n";
    }
    if (!$q->TABLE_EXISTS("domainmetadata", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'domainmetadata' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS domainmetadata (\n\t\t\t id              INT auto_increment,\n\t\t\t domain_id       INT NOT NULL,\n\t\t\t kind            VARCHAR(16),\n\t\t\t content        TEXT,\n\t\t\t primary key(id)\n\t\t\t);";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'domainmetadata' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'domainmetadata' table success\n";
        $q->QUERY_SQL("create index domainmetaidindex on domainmetadata(domain_id);", "powerdns");
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'domainmetadata' table success\n";
    }
    if (!$q->TABLE_EXISTS("cryptokeys", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'cryptokeys' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS cryptokeys (\n\t\t\t id             INT auto_increment,\n\t\t\t domain_id      INT NOT NULL,\n\t\t\t flags          INT NOT NULL,\n\t\t\t active         BOOL,\n\t\t\t content        TEXT,\n\t\t\t primary key(id)\n\t\t\t); ";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'cryptokeys' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'cryptokeys' table success\n";
        $q->QUERY_SQL("create index domainidindex on cryptokeys(domain_id);", "powerdns");
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'cryptokeys' table success\n";
    }
    if (!$q->TABLE_EXISTS("tsigkeys", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'tsigkeys' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS tsigkeys (\n\t\t\t id             INT auto_increment,\n\t\t\t name           VARCHAR(255), \n\t\t\t algorithm      VARCHAR(255),\n\t\t\t secret         VARCHAR(255),\n\t\t\t primary key(id)\n\t\t\t);";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'tsigkeys' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'tsigkeys' table success\n";
        $q->QUERY_SQL("create unique index namealgoindex on tsigkeys(name, algorithm);", "powerdns");
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'tsigkeys' table success\n";
    }
    if (!$q->TABLE_EXISTS("users", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'users' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL DEFAULT '0', `password` varchar(34) NOT NULL DEFAULT '0', `fullname` varchar(255) NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '0', `description` varchar(1024) NOT NULL DEFAULT '0', `perm_templ` tinyint(4) NOT NULL DEFAULT '0', `active` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'users' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'users' table success\n";
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'users' table success\n";
    }
    if (!$q->TABLE_EXISTS("perm_items", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_items' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '0', `descr` varchar(1024) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_items' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_items' table success\n";
        $sql = "INSERT INTO `perm_items` (`id`, `name`, `descr`) VALUES (41, 'zone_master_add', 'User is allowed to add new master zones.'), (42, 'zone_slave_add', 'User is allowed to add new slave zones.'), (43, 'zone_content_view_own', 'User is allowed to see the content and meta data of zones he owns.'), (44, 'zone_content_edit_own', 'User is allowed to edit the content of zones he owns.'), (45, 'zone_meta_edit_own', 'User is allowed to edit the meta data of zones he owns.'), (46, 'zone_content_view_others', 'User is allowed to see the content and meta data of zones he does not own.'), (47, 'zone_content_edit_others', 'User is allowed to edit the content of zones he does not own.'), (48, 'zone_meta_edit_others', 'User is allowed to edit the meta data of zones he does not own.'), (49, 'search', 'User is allowed to perform searches.'), (50, 'supermaster_view', 'User is allowed to view supermasters.'), (51, 'supermaster_add', 'User is allowed to add new supermasters.'), (52, 'supermaster_edit', 'User is allowed to edit supermasters.'), (53, 'user_is_ueberuser', 'User has full access. God-like. Redeemer.'), (54, 'user_view_others', 'User is allowed to see other users and their details.'), (55, 'user_add_new', 'User is allowed to add new users.'), (56, 'user_edit_own', 'User is allowed to edit their own details.'), (57, 'user_edit_others', 'User is allowed to edit other users.'), (58, 'user_passwd_edit_others', 'User is allowed to edit the password of other users.'), (59, 'user_edit_templ_perm', 'User is allowed to change the permission template that is assigned to a user.'), (60, 'templ_perm_add', 'User is allowed to add new permission templates.'), (61, 'templ_perm_edit', 'User is allowed to edit existing permission templates.');";
        $q->QUERY_SQL($sql, "powerdns");
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'perm_items' table success\n";
    }
    if (!$q->TABLE_EXISTS("perm_templ", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_templ' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_templ` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL DEFAULT '0', `descr` varchar(1024) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_templ' table FAILED\n";
        } else {
            $sql = "INSERT INTO `perm_templ` (`id`, `name`, `descr`) VALUES (1, 'Administrator', 'Administrator template with full rights.');";
            $q->QUERY_SQL($sql, "powerdns");
        }
    }
    if (!$q->TABLE_EXISTS("perm_templ_items", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_templ_items' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `perm_templ_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `templ_id` int(11) NOT NULL DEFAULT '0', `perm_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=250 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_templ_items' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'perm_templ_items' table success\n";
        $sql = "INSERT INTO `perm_templ_items` (`id`, `templ_id`, `perm_id`) VALUES (249, 1, 53);";
        $q->QUERY_SQL($sql, "powerdns");
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'perm_templ_items' table success\n";
    }
    if (!$q->TABLE_EXISTS("zones", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zones' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zones` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain_id` int(11) NOT NULL DEFAULT '0', `owner` int(11) NOT NULL DEFAULT '0', `comment` varchar(1024) DEFAULT '0', `zone_templ_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zones' table FAILED\n";
            return;
        }
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'zones' table success\n";
    }
    if (!$q->TABLE_EXISTS("zone_templ", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zone_templ' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zone_templ` ( \n\t\t\t\t`id` bigint(20) NOT NULL AUTO_INCREMENT, \n\t\t\t\t`name` varchar(128) NOT NULL DEFAULT '0', \n\t\t\t\t`descr` varchar(1024) NOT NULL DEFAULT '0', \n\t\t\t\t`owner` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) \n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zone_templ' table FAILED\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zone_templ' table success\n";
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS 'zone_templ' table success\n";
    }
    $q->QUERY_SQL("CREATE TABLE IF NOT EXISTS zone_templ_records (\n\tid            INTEGER      NOT NULL AUTO_INCREMENT,\n\tzone_templ_id INTEGER      NOT NULL,\n\tname          VARCHAR(255) NOT NULL,\n\t`type`        VARCHAR(6)   NOT NULL,\n\tcontent       VARCHAR(255) NOT NULL,\n\tttl           INTEGER      NOT NULL,\n\tprio          INTEGER      NOT NULL,\n\tPRIMARY KEY (id)\n\t) ENGINE=InnoDB DEFAULT CHARSET=latin1;", "powerdns");
    $q->QUERY_SQL("CREATE TABLE IF NOT EXISTS records_zone_templ (\n\tdomain_id INTEGER NOT NULL,\n\trecord_id INTEGER NOT NULL,\n\tzone_templ_id INTEGER NOT NULL\n\t) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
    if (!$q->TABLE_EXISTS("zone_templ_records", "powerdns")) {
        echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zone_templ_records' table\n";
        $sql = "CREATE TABLE IF NOT EXISTS `zone_templ_records` (\n\t\t  `id` bigint(20) NOT NULL AUTO_INCREMENT,\n\t\t  `zone_templ_id` bigint(20) NOT NULL DEFAULT '0',\n\t\t  `name` varchar(255) NOT NULL DEFAULT '0',\n\t\t  `type` varchar(6) NOT NULL DEFAULT '0',\n\t\t  `content` varchar(255) NOT NULL DEFAULT '0',\n\t\t  `ttl` bigint(20) NOT NULL DEFAULT '0',\n\t\t  `prio` bigint(20) NOT NULL DEFAULT '0',\n\t\t  PRIMARY KEY (`id`)\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
        $q->QUERY_SQL($sql, "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS creating 'zone_templ_records' table FAILED\n";
        }
    }
    if (!$q->TABLE_EXISTS("domainmetadata", "powerdns")) {
        $q->QUERY_SQL("create table domainmetadata ( id INT auto_increment, domain_id INT NOT NULL, kind VARCHAR(16), content TEXT, primary key(id) );", "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/domainmetadata failed {$q->mysql_error}\n";
            return;
        }
        echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/domainmetadata success\n";
        $q->QUERY_SQL("create index domainmetaidindex on domainmetadata(domain_id);", "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/domainmetadata failed {$q->mysql_error}\n";
        }
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/domainmetadata OK\n";
    }
    if (!$q->TABLE_EXISTS("cryptokeys", "powerdns")) {
        $q->QUERY_SQL("create table cryptokeys (\n\tid             INT auto_increment,\n \tdomain_id      INT NOT NULL,\n\tflags          INT NOT NULL,\n \tactive         BOOL,\n \tcontent        TEXT,\n\tprimary key(id)\n\t);", "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/cryptokeys failed {$q->mysql_error}\n";
        } else {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/cryptokeys success\n";
            $q->QUERY_SQL("create index domainidindex on cryptokeys(domain_id);", "powerdns");
            if (!$q->ok) {
                echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/cryptokeys failed {$q->mysql_error}\n";
            }
        }
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/cryptokeys OK\n";
    }
    if ($q->TABLE_EXISTS("records", "powerdns")) {
        if (!$q->FIELD_EXISTS("records", "ordername", "powerdns")) {
            $q->QUERY_SQL("alter table records add ordername  VARCHAR(255)", "powerdns");
            if (!$q->ok) {
                echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/records failed {$q->mysql_error}\n";
            }
            $q->QUERY_SQL("create index orderindex on records(ordername)", "powerdns");
        }
        if (!$q->FIELD_EXISTS("records", "auth", "powerdns")) {
            $q->QUERY_SQL("alter table records add auth bool", "powerdns");
            if (!$q->ok) {
                echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/records failed {$q->mysql_error}\n";
            }
        }
        if (!$q->FIELD_EXISTS("records", "disabled", "powerdns")) {
            $q->QUERY_SQL("alter table records add `disabled` TINYINT(1) DEFAULT 0, ADD INDEX `disabled`(`disabled`)", "powerdns");
            if (!$q->ok) {
                echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/records/disabled failed {$q->mysql_error}\n";
            }
        }
        $q->QUERY_SQL("alter table records change column type type VARCHAR(10);", "powerdns");
    }
    if (!$q->TABLE_EXISTS("tsigkeys", "powerdns")) {
        $q->QUERY_SQL("create table tsigkeys (\n\t\t id             INT auto_increment,\n\t\t name           VARCHAR(255), \n\t\t algorithm      VARCHAR(50),\n\t\t secret         VARCHAR(255),\n\t\t primary key(id)\n\t\t);", "powerdns");
        if (!$q->ok) {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/tsigkeys failed {$q->mysql_error}\n";
        } else {
            echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/tsigkeys success\n";
            $q->QUERY_SQL("create unique index namealgoindex on tsigkeys(name, algorithm);", "powerdns");
            if (!$q->ok) {
                echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/tsigkeys failed {$q->mysql_error}\n";
            }
        }
    } else {
        echo "Starting......: " . date("H:i:s") . " PowerDNS patching database/tsigkeys OK\n";
    }
    echo "Starting......: " . date("H:i:s") . " PowerDNS Mysql done...\n";
    poweradmin();
}