Facebook
Twitter
Bernard T
New Pleskian
Hi everyone,
mods: if this is wrong section for this post, please move it.
After a big migration from two older Plesk servers to a new Plesk 12 server I had to fix IP address assignment problems found by Plesk Webserver Configuration Troubleshooter in our server configs.
Since there is a manual 2-steps process described in KB http://kb.odin.com/en/113475, I made a new SQL query which will do everything in one step.
I thought someone else would be interested for it, so I decided to share it:
I hope it will be useful to someone else, maybe you can update it to the subject KB.
mods: if this is wrong section for this post, please move it.
After a big migration from two older Plesk servers to a new Plesk 12 server I had to fix IP address assignment problems found by Plesk Webserver Configuration Troubleshooter in our server configs.
Since there is a manual 2-steps process described in KB http://kb.odin.com/en/113475, I made a new SQL query which will do everything in one step.
I thought someone else would be interested for it, so I decided to share it:
Code:
UPDATE IpAddressesCollections
LEFT JOIN DomainServices ON IpAddressesCollections.ipCollectionId = DomainServices.ipCollectionId
LEFT JOIN domains ON DomainServices.dom_id = domains.id
LEFT JOIN dom_param ON dom_param.dom_id = domains.id
SET ipAddressId = cast(dom_param.val as char)
WHERE IpAddressesCollections.ipAddressId = 0
AND dom_param.param LIKE 'ip%_addr_id'I hope it will be useful to someone else, maybe you can update it to the subject KB.
