myDNS errors

Discussion in 'Server Operation' started by Traffic, Feb 9, 2008.

  1. Traffic

    Traffic New Member

    Hello...

    myDNS stopped working for some reason - possibly between the chair and the keyboard...

    I have not used it in many months - however, it is not returning results for domains I have setup in it anymore... It used to - but, now it does not...

    I have run:
    Code:
    mydnscheck -uUSER -pPASS consistency
    and get the following response:
    Code:
    mydnscheck: consistency.: error loading SOA record for zone
    I can't find anywhere that will tell me what this means - or, how to fix it...

    I have removed ALL records in the soa as well as the rr tables... I still get the same response...

    I appreciate any help you can give...


    ...
     
  2. falko

    falko Super Moderator ISPConfig Developer

    What are the results of
    and
    Code:
    SELECT * FROM rr;
    ?
     
  3. Traffic

    Traffic New Member

    soa:

    Code:
    Full Texts  	id 	origin 	ns 	mbox 	serial 	refresh 	retry 	expire 	minimum 	ttl 	active 	xfer 	sys_userid 	sys_groupid 	sys_perm_user 	sys_perm_group 	sys_perm_other
    	Edit 	Delete 	4 	doaffiliates.com. 	ns.domainplans.net. 	admin.domainplans.net. 	2008020804 	28800 	7200 	604800 	86400 	86400 	Y 	  	1 	1 	riud 	riud 	 
    	Edit 	Delete 	5 	126.184.70.in-addr.arpa. 	ns.domainplans.net. 	admin.domainplans.net. 	2008020801 	28800 	7200 	604800 	86400 	86400 	Y 	  	1 	0 	riud 	riud 	 
    rr:

    Code:
    Full Texts  	id 	zone 	name 	type 	data 	aux 	ttl 	sys_userid 	sys_groupid 	sys_perm_user 	sys_perm_group 	sys_perm_other
    	Edit 	Delete 	7 	4 	doaffiliates.com. 	A 	70.184.126.166 	0 	86400 	1 	1 	riud 	riud 	 
    	Edit 	Delete 	6 	4 	* 	A 	70.184.126.166 	0 	86400 	1 	1 	riud 	riud 	 
    	Edit 	Delete 	5 	5 	166 	PTR 	*.doaffiliates.com. 	0 	86400 	1 	0 	riud 	riud 	 

    I left just one test domain in there... The system is automatically adding a garbage line in both rr and soa... Even when I delete the garbage line - it comes back within minutes...


    ...
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Looks ok. What's the output of
    Code:
    netstat -tap
    ?
     
  5. Traffic

    Traffic New Member

    netstat -tap
    Code:
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
    tcp        0      0 localhost.localdom:2208 *:*                     LISTEN     5006/hpiod          
    tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     5107/mysqld         
    tcp        0      0 *:netbios-ssn           *:*                     LISTEN     5249/smbd           
    tcp        0      0 *:www                   *:*                     LISTEN     1614/apache2        
    tcp        0      0 192.168.1.149:domain    *:*                     LISTEN     15202/mydns         
    tcp        0      0 localhost.locald:domain *:*                     LISTEN     15202/mydns         
    tcp        0      0 localhost.localdoma:ipp *:*                     LISTEN     6012/cupsd          
    tcp        0      0 *:https                 *:*                     LISTEN     1614/apache2        
    tcp        0      0 *:microsoft-ds          *:*                     LISTEN     5249/smbd           
    tcp        0      0 localhost.localdom:2207 *:*                     LISTEN     5009/python         
    tcp6       0      0 *:5900                  *:*                     LISTEN     5613/vino-server    
    tcp6       0      0 ip6-localhost:domain    *:*                     LISTEN     15202/mydns         
    tcp6       0      0 *:ftp                   *:*                     LISTEN     5376/proftpd: (acce 
    ¨ßÓ·Ô8    0      0 *:ssh                   *:*                     LISTEN     5269/ii
    ¨ßÓ·Ô     0      0 ::ffff:192.168.1.14:ssh ::ffff:192.168.1.:50964 ESTABLISHED10462/ii
    ¨ßÓ·Ô8    0   1780 ::ffff:192.168.1.14:ssh IP-216-185-175-11:57755 ESTABLISHED7197/ii

    ...
     
  6. Traffic

    Traffic New Member

    Falko...

    I gave up on that install and reinstalled everything...

    It is working so far - however, the "sys_usr" table was not created in mydns database - and, I cannot login... I have tried admin:admin but, it doesn't seem to be working...

    We are using myDNSConfig in other places - so, I took a SQL dump of that table including the INSERT - I created the sys_usr table - inserted the data and was able to login...

    However, after logging in - I am unable to actually do anything as I get an error regarding an unknown field in the sys_usr table (sys_userid)...

    Any ideas...?


    Thanks again for your help...
     
  7. Traffic

    Traffic New Member

    Ok - I found this earlier article written by you:

    http://www.howtoforge.org/mydns_name_server_p2

    and, added the additional fields in rr and soa (these fields were not mentioned in the article I used for the install -

    The login now works - however, I am back to mydns not serving up my domains...

    I ran mydnscheck and got this result:
    Code:
    mydnscheck: Error connecting to MySQL server at localhost: Client does not support authentication protocol requested by server; consider upgrading MySQL client (errno=0)

    Thanks for any help you can give me...
     
  8. Traffic

    Traffic New Member

    Ok - I now have changed my passwords to the "old style = 16"...

    now when I run mydnscheck - I get this response:
    Code:
    mydnscheck: consistency.: zone not found
    I have never had any trouble setting up myDNS - and, we have myDNS running on several machines...

    Any ideas on this error...? I can't seem to find anything on the web for it...

    There are records in the rr and soa tables... They all look good...


    ...
     
  9. Traffic

    Traffic New Member

    Ok - I have been doing more and more reading... Always a good place to start...

    I have run the mydnscheck -uUSER -pPASS doaffiliates.com

    and, received:
    Code:
    mydnscheck: connected to localhost, database "mydns"
    mydnscheck: doaffiliates.com.: 3 resource records                       
    mydnscheck: No errors   
    Looks good...

    I can "dig" the domain - doaffiliates.com - using the proper nameserver - domainplans.net - and, get good results...
    Code:
    02/11/08 17:22:34 dig doaffiliates.com @ ns.domainplans.net
    Dig [email protected] (70.184.126.166) ...
    Authoritative Answer
     Query for doaffiliates.com type=255 class=1
      doaffiliates.com SOA (Zone of Authority)
            Primary NS: ns.domainplans.net
            Responsible person: [email protected]
            serial:2008021105
            refresh:28800s (8 hours)
            retry:7200s (2 hours)
            expire:604800s (7 days)
            minimum-ttl:86400s (24 hours)
      doaffiliates.com A (Address) 70.184.126.166
    I cannot run an "nslookup" on the domain - returns nothing but timeouts...

    Port 53 is open and pointed to the proper machine...

    I know it has to be something simple...

    Any suggestions...?


    Thanks again for your help...


    ...
     
  10. falko

    falko Super Moderator ISPConfig Developer

    Is your MyDNS server the authoritative DNS server for the domain you're trying to look up? If not, the "real" authoritative DNS server is queried instead, which might not exist or isn't running.
     
  11. Traffic

    Traffic New Member

    Falko...

    Thank you for the response...

    I just figured out the problem - seems to have been between the chair and the keyboard after all...

    My domain is registered at GoDaddy - and, they require me to "register" my particular DNS with their system for it to work... This was completed in the past - but, they have changed the way their system worked, and my DNS domain became "unregistered" with them...

    I was able to "register" my DNS with them - everything is working well...


    Thanks again for your help...
     

Share This Page