Articles in this section

Unable to repair domains in Plesk using "plesk repair db" utility: The following domains are assigned to already removed IP addresses

kb: bug kb: fixed Plesk for Linux

Applicable to:

  • Plesk for Linux

Symptoms

IP address of subscriptions was changed and after that plesk repair db utility shows the error message below for domains with “Forwarding” hosting type:

# plesk repair db -n
The following domains are assigned to already removed IP addresses.
Reassign the domains to existing IP addresses:
example.com ...................................................... [ERROR]

Cause

Product issue:

  • #PPPM-13256 "Changing the IP address for a subscription now correctly updates the IP address of all domains owned by the subscription with the “Forwarding” hosting type."
    Fixed in:

Resolution

Please consider updating your server:

Workaround

If update is not possible for some reason you may try the following

workaround
  1. Login to the server via SSH.

  2. Create backup of psa database:

    # plesk db dump > psa.sql

  3. Check what val is used for all other domains:

    # plesk db "select domains.name,dom_param.param,dom_param.val from domains, dom_param where domains.id=dom_param.dom_id and dom_param.param='ip_addr_id'"

  4. Update dom_param.val with correct value:

    # plesk db "update dom_param set val=1 where param='ip_addr_id' and val=9;"

    where 1 - is a correct value, 9 - is old wrong value.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.