Not able to add domain alias, error: Alias is already exists

Created:

2016-11-16 13:01:57 UTC

Modified:

2017-04-24 11:59:49 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Not able to add domain alias, error: Alias is already exists

Applicable to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

Not able to add domain alias.The following error appears:

Alias is already exists

Cause

Database inconsistency due to previous attempts to remove the main domain.

Entries for domain alias is available in psa database tables.

Resolution

  1. Log into psa database

Check is a record exist in database:

    mysql> select * from domain_aliases where name like '%dom_alias.tld%';
+----+--------+------------+-------------+-------------+--------+------+------+------+--------+-------------+
| id | dom_id | name | displayName | dns_zone_id | status | mail | web | dns | tomcat | seoRedirect |
+----+--------+------------+-------------+-------------+--------+------+------+------+--------+-------------+
| 88 | 82 | dom_alias.tld | dom_alias.tld | 194 | 0 | true | true | true | false | false |
+----+--------+------------+-------------+-------------+--------+------+------+------+--------+-------------+
1 row in set (0.00 sec)
  1. Make sure that domain with id 82 is NOT available on the server (result should be empty):

        mysql> select * from domains where id=82;   
    Empty set (0.00 sec)
  2. Delete unwanted recordы from psa database:

    mysql> delete from domain_aliases where dns_zone_id=194;
    Query OK, 1 row affected (0.00 sec)

    mysql> delete from dns_recs where dns_zone_id=194;
    Query OK, 34 rows affected (0.22 sec)

    mysql> delete from dns_zone where id=194;
    Query OK, 1 row affected (0.01 sec)

After that domain alias with name dom_alias.tld could be created.

Have more questions? Submit a request
Please sign in to leave a comment.