Started by jwest, May 21, 2014, 02:07:54 am
mysql> show create table nt_zone_record\G*************************** 1. row *************************** Table: nt_zone_recordCreate Table: CREATE TABLE `nt_zone_record` ( `nt_zone_record_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nt_zone_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `ttl` int(10) unsigned NOT NULL DEFAULT '0', `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `type_id` smallint(2) unsigned NOT NULL, `address` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '', `weight` smallint(5) unsigned DEFAULT '0', `priority` smallint(5) unsigned DEFAULT '0', `other` smallint(5) unsigned DEFAULT '0', `location` varchar(2) CHARACTER SET utf8 DEFAULT NULL, `timestamp` timestamp NULL DEFAULT NULL, `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`nt_zone_record_id`), KEY `nt_zone_record_idx1` (`name`), KEY `nt_zone_record_idx2` (`address`(255)), KEY `nt_zone_record_idx3` (`nt_zone_id`), KEY `nt_zone_record_idx4` (`deleted`)) ENGINE=InnoDB AUTO_INCREMENT=6982 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Quote from: jwest on May 22, 2014, 08:42:50 amThanks a ton matt... just to doublecheck... my nictoolserver is only an apache host, not a dns server (nor db server). I was hoping to not install djbdns on it at all (just on the other machines that are nameservers). But it looks like when you set up exports from nictoolserver (on the nictoolserver) to the nameservers, djbdns has to be installed (as does tinydns and axfrdns) on the nictoolserver host as well.
QuoteOdd, I thought that nictools exports went by rsync - not using axfrdns and/or tinydns. Hokay - proceeding. Thanks!
address VARCHAR(512) NOT NULL
Quote from: jwest on May 23, 2014, 05:15:01 amThrough the nictool client I can add/remove nameservers, and add/remove zones. However, I can not add RR's to a zone that was imported, nor can I add RR records to a new zone that I create. The web interface just reports "Failed to complete request". httpd-error.log reports:DBD::mysql::st execute failed: Incorrect integer value: '' for column 'weight' at row 1 at /usr/local/lib/perl5/site_perl/5.16/DBIx/Simple.pm line 172.exec_query called by NicToolServer::Zone::Record, 39 INSERT INTO nt_zone_record(nt_zone_id, name, ttl, description, type_id, address, weight, priority, other) VALUES(??) 13, test, 86400, , 1, 188.8.131.52, , , DBI error: Incorrect integer value: '' for column 'weight' at row 1 at /usr/local/lib/perl5/site_perl/5.16/NicToolServer.pm line 1586.Client error: 600: : ModPerl::ROOT::ModPerl::Registry::u1_www_nictool_client_htdocs_zone_2ecgi:/u1/www/nictool/client/htdocs/zone.cgi:845 at /u1/www/nictool/client/lib/NicToolClient.pm line 1307.The above error seems to reference "weight", but I was adding an A record, not an MX record. Previously to the above error I did try to add a MX record, but there wasn't any field to enter the weight :\Any thoughts to get me running folks? Thanks in advance!
Page created in 0.083 seconds with 21 queries.