Do we get to the other side?
Dave Horner's Website - Yet another perspective on things...
Home Tech Talk Unix/Linux/BSD/etc MyDNS - mysql based dns server.
68 guests
Rough Hits : 3543929
moon and stars
how did u find my site?

our entire universe; minuscule spec in gigantic multiverse which is mostly lethal.

I know one thing: that I know nothing.
I know that I know nothing.
--Socratic paradox

MyDNS - mysql based dns server.

Thursday, 26 February 2009 01:10
MyDNS - Next Generation DNS Server - looks like a new fork of MyDNS with more features...

MyDNS: Home - serve records directly from an SQL database
MyDNS is pretty neat in that you can use the mydnsimport to import zones from existing DNS servers with AXFR transfers. 'mydnsimport' (may have to perform permissions updates as described below) :: My domains, MyDNS
Installing MyDNS And The MyDNSConfig Control Panel On CentOS 5.1 | HowtoForge - Linux Howtos and Tutorials
Simple Dynamic DNS with MyDNS - Blink - scripts to do dynamic dns with mydns.

Testing your mydns server

Make sure you have "allow-axfr = yes" and "listen =" or "listen = *" in /etc/mydns.conf.
dig @localhost -t axfr
intoDNS: checks DNS and mail servers health

Permissions with MyDnsConfig

When I first installed MyDnsConfig, I got the following error:
Error: You don't have the permission to view this record or this record does not exist!
With a little work, I found a place to debug the queries...and this was the offending SQL.
SELECT * FROM soa WHERE id = 1 AND ((sys_userid = 1 AND sys_perm_user like '%u%') OR (sys_groupid IN (1,2) AND sys_perm_group like '%u%') OR sys_perm_other like '%u%')

So, looks like you need to make sure to set a default on the rr and soa table for sys_userid and sys_perm_user to match the sys_userid of admin. I used the mydnsimport tool to create records, and the defaults were 0 and empty string. Not good, not associated to any user!
--set the defaults to 1, and u for user based auth.
 ALTER TABLE `soa` CHANGE `sys_userid` `sys_userid` INT( 11 ) NOT NULL DEFAULT '1';
 ALTER TABLE `soa` CHANGE `sys_perm_user` `sys_perm_user` VARCHAR( 5 ) 
 CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'riud'; 
 ALTER TABLE `rr` CHANGE `sys_userid` `sys_userid` INT( 11 ) NOT NULL DEFAULT '1';
 ALTER TABLE `rr` CHANGE `sys_perm_user` `sys_perm_user` VARCHAR( 5 )
 CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'riud';
--update the existing records
UPDATE soa SET `sys_userid`='1', `sys_groupid`='1', `sys_perm_user`='riud', `sys_perm_group`='riud';
UPDATE rr SET `sys_userid`='1', `sys_groupid`='1', `sys_perm_user`='riud', `sys_perm_group`='riud';

YoDNSConf - a fork of the MyDNSConfig project...

DNS servers (doesn't belong on this page, but hey, it works)

Free Secondary DNS
Free Secondary DNS Services
PUCK Free Secondary DNS Service
BuddyNS - Secondary DNS with no delays - Activate
OpenDNS > Use OpenDNS > Best Practices - opendns is free recursive dns servers with content filtering. DNS Hosting, E-mail Delivery, VPS Hosting and Other Services - free dynamic DNS hosting. But, using something like MyDNS - mysql based dns server. would make it a little nicer. ;)
Using Google Public DNS - Google now provides free public DNS name resolution! * *
namebench - Project Hosting on Google Code - Open-source DNS Benchmark Utility.
Unbound DNS Server Tutorial @
NSD DNS Server Tutorial @
FreeDNS - Free DNS - Dynamic DNS - Static DNS subdomain and domain hosting

DNS resolution (client code)

bagder/c-ares · GitHub - c-ares is a C library that performs DNS requests and name resolves asynchronously.

DNS encryption

DNSCrypt by jedisct1
Introduction to DNSCurve

rate limiting dns

Response Rate Limiting in the Domain Name System (DNS RRL) | Red Barn - BIND

powerdns and poweradmin

Welcome to PowerDNS
Poweradmin - a web-based control panel for PowerDNS
Migrating DBs FROM MyDNS · PowerDNS/pdns Wiki
checking that all your records are good: pdnssec check-all-zones
Which is now renamed and called "pdnsutil" so pdnsutil check-all-zones
Last Updated on Tuesday, 14 November 2017 00:30