[Pdns-users] Problem with wildcard records

[Dominik Dausch]

Dear Bert,

bh> Which version please, and please all exact records from the database.

Dear Bert,

it was 2.9.16, but i upgraded to 2.9.19 and the problem still exists.
Here are the db entrys of the domain mentioned in my mailing list
post, with table layout because we modified the domain table layout a
litte for our web interface user management:

CREATE TABLE `domains` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(70) NOT NULL default '',
  `Ben_Nr` int(11) unsigned NOT NULL default '0',
  `Tmp_Nr` int(11) unsigned NOT NULL default '0',
  `master` varchar(20) default NULL,
  `last_check` int(11) unsigned default NULL,
  `type` varchar(6) NOT NULL default '',
  `notified_serial` int(11) unsigned default NULL,
  `account` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name_index` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=34566 ;

-- 
-- Dumping data for table `domains`
-- 

INSERT INTO `domains` VALUES (34548, 'drogensucht.de', 16, 10, NULL, NULL, '', NULL, NULL);

CREATE TABLE `records` (
  `id` int(11) NOT NULL auto_increment,
  `domain_id` int(11) default NULL,
  `name` varchar(200) default NULL,
  `type` varchar(6) default NULL,
  `content` varchar(200) default NULL,
  `ttl` int(11) default NULL,
  `prio` int(11) default NULL,
  `change_date` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unique_name_type_content` (`name`,`type`,`content`),
  KEY `rec_name_index` (`name`),
  KEY `nametype_index` (`name`,`type`),
  KEY `domain_id` (`domain_id`)
) TYPE=MyISAM AUTO_INCREMENT=276997 ;

-- 
-- Dumping data for table `records`
-- 

INSERT INTO `records` VALUES (276863, 34548, 'drogensucht.de', 'MX', 'mail.drogensucht.de', 10800, 10, NULL);
INSERT INTO `records` VALUES (276862, 34548, 'www.drogensucht.de', 'A', '62.80.125.202', 10800, 0, NULL);
INSERT INTO `records` VALUES (276861, 34548, 'mail.drogensucht.de', 'A', ' 62.80.125.202', 10800, 0, NULL);
INSERT INTO `records` VALUES (276860, 34548, '*.drogensucht.de', 'A', ' 62.80.125.202', 10800, 0, NULL);
INSERT INTO `records` VALUES (276859, 34548, 'drogensucht.de', 'A', '62.80.125.202', 10800, 0, NULL);
INSERT INTO `records` VALUES (276858, 34548, 'drogensucht.de', 'NS', 'ns3.net2daymedia.de', 10800, 0, NULL);
INSERT INTO `records` VALUES (276857, 34548, 'drogensucht.de', 'NS', 'ns2.net2daymedia.de', 10800, 0, NULL);
INSERT INTO `records` VALUES (276855, 34548, 'drogensucht.de', 'SOA', 'ns1.net2daymedia.de hostmaster.megaspace.de 2005113001', 10800, 0, NULL);
INSERT INTO `records` VALUES (276856, 34548, 'drogensucht.de', 'NS', 'ns1.net2daymedia.de', 10800, 0, NULL);

-- 
Mit freundlichen GrÌssen
Dominik Dausch                            mailto:maillist at megaspace.de