MX record exist after delete and trash is empty

Discussion in 'Installation/Configuration' started by SupuS, Oct 16, 2007.

  1. SupuS

    SupuS Member HowtoForge Supporter

    Hi all

    If I delete MX record it disappears from MX list but trash is still empty .. and than I cannot create new MX record with same priority or name as deleted one .. ispconfig tells me about existing similar record .. any idea?

    thanx SupuS
     
    Last edited: Oct 16, 2007
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you check all recycle bin's in the DNS-Manager part?
     
  3. SupuS

    SupuS Member HowtoForge Supporter

    hi till

    yes I checked all (3 :) ) my bin's in DNS section .. if I deleted spf records everything was ok but MX records still remains invisible and unrewritable :(
     
    Last edited: Oct 17, 2007
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, thats bad. I will try to explain how the record can be removed manually in the database.

    1) Make a backup of the ISPConfig database!

    2) Execute the following SQL statement:

    Code:
    SELECT dns_dep.child_doc_id FROM dns_isp_dns, dns_dep WHERE dns_isp_dns.dns_soa = '<domain>' AND dns_isp_dns.doc_id = dns_dep.parent_doc_id and dns_dep.child_doctype_id = 1020
    Replace <domain> with your domain name. Write down the ID number that gets returned. I will refer to this ID number in the next SQL statements with <id>

    Code:
    DELETE FROM dns_mx WHERE doc_id = <id>;
    Code:
    DELETE FROM dns_nodes WHERE doc_id = <id> and doctype_id = 1020;
    Code:
    DELETE FROM dns_dep WHERE child_doc_id = <id> and child_doctype_id = 1020;
     
  5. SupuS

    SupuS Member HowtoForge Supporter

    Thanks for solution .. I'll try it when it will be necessary .. now I select another priority when create new MX record and it works ok .. I cannot create MX record with same name as deleted but I don't need it for now .. I don't want break anything :)
    But I think it is a possible bug .. because I get same error on the different ispconfig box with different version of ubuntu.
    If is a way how I can help you with searching a base of problem just tell me :D

    SupuS
     
  6. falko

    falko Super Moderator ISPConfig Developer

    You can manually add your MX records in the zone file of your domain.
     
  7. SamTzu

    SamTzu Member HowtoForge Supporter

    Till wrote...
    After logging in as a root in to MySQL and executing the command I didnt get anything. Only next line.

    ?!?


    Sam
     
  8. SamTzu

    SamTzu Member HowtoForge Supporter

    Never mind. Installed Webmin and with it manually changed the DNS.

    Has this bug been fixed in newer version?
    How can I check which version I'm using? (It's almost a year since I started using it.)

    Sam
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    The problem in this thread is caused by a database corruption and not a bug, so there is nothing that we can do to fix it.

    The changes that you did with webmin are incompatible with ISPConfig and will get overridden when you use the ISPConfig DNS-Manager the next time.
     
  10. SupuS

    SupuS Member HowtoForge Supporter

    Hi till

    Are you sure it is not a bug? It happens in my ispconfig installations constantly .. I had to use your sql commands ( it works fine ;) ) .. If it is not a bug how I can prevent this behaviour?

    SupuS
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    Hi,

    I will add this to the bugtracker for further investigation. I did not recognize this on my servers yet.
     

Share This Page