Can't create alias: DNS Zone already exists

[hansel]

Hi,

I'm using Plesk 9.2.1 on Ubuntu 8.0.4 and had a domain as an vhost alias on my master domain. I removed that vhost alias and wanted to rename the master domain to the removed alias. Just a simple rename function.

It errors;

Error: not possible to change domainname: Domain Mgmt backend failed: domainmng: /usr/lib/plesk-9.0/mailmng_domain_rename execution failed:
Unable to execute the mail domain authorization name change query: column name is not unique
Fatal error: plesk::mail:ostfix:ostfixAuthenticationDBError(unable to update domain name in mail authentication database): domainmng: /usr/lib/plesk-9.0/mailmng_domain_rename execution failed:
Unable to execute the mail domain authorization name change query: column name is not unique
Fatal error: plesk::mail:ostfix:ostfixAuthenticationDBError(unable to update domain name in mail authentication database)
DNS record already exists

Even if I want to add a simple domain as an alias to the master domain name, it states: "Error: DNS zone already exists". Even if I want to add 'thisisjustareallynotexistingdomainname.com' as an alias.

Anyone had this before or any suggested solutions are welcome. The masterdomain name is currently offline because of this error :|

Thanks!

Hans

 

[hansel]

Well,

That was a silent 2 days..

In the meanwhile, I have found the problem, how to solve:

/usr/local/psa/admin/sbin# ./mail_auth_view |grep DOMAIN.COM

This wel probably result in a hit:

| something@DOMAIN | | USERNAME |

Now we know there is still a domain in the database, even if the Plesk interface doesn't say so.

We need to remove the domain:

/usr/local/psa/admin/sbin# ./mailmng --remove-domain --domain-name DOMAIN.COM

That's it!

 

[DavidT]

This was very helpful to me today. Thanks for posting this solution.

David