Unable to add domain alias, error: Alias is already exists

Created:

2016-11-16 13:01:57 UTC

Modified:

2017-08-17 07:21:27 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to add domain alias, error: Alias is already exists

Applicable to:

  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

Unable to add domain alias.The following error appears:

CONFIG_TEXT: 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. Connect the server using SSH and log into Plesk database
  2. Check if a record exists in database:

    MYSQL_LIN: mysql> select * from domain_aliases where name like '%example.com%';
    +----+--------+------------+-------------+-------------+--------+------+------+------+--------+-------------+
    | 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)

  3. Make sure that domain with id 82 is NOT available on the server (result should be empty):

    MYSQL_LIN: mysql> select * from domains where id=82;
    Empty set (0.00 sec)

  4. Delete orphaned records from psa tdatabase:

    MYSQL_LIN: 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 example.com can be created.

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