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
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
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;
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 SupuS
Till wrote... After logging in as a root in to MySQL and executing the command I didnt get anything. Only next line. ?!? Sam
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
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.
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
Hi, I will add this to the bugtracker for further investigation. I did not recognize this on my servers yet.
