Remove default domain from IP in Plesk
by sudo on Dec.01, 2009, under Plesk
Of all the things Plesk does well, this which would seem like common sense to include within the interface, cannot be done. To rectify this issue, you must update the default_domain field within psa.IP_Addresses.
mysql -uadmin -p`cat etc/psa/.psa.shadow` -Dpsa -e "UPDATE IP_Addresses SET default_domain_id = 0 WHERE ip_address = 'IPGOESHERE';"
Remove the WHERE statement if you wish to do a blanket default domain removal.
mysql -uadmin -p`cat etc/psa/.psa.shadow` -Dpsa -e "UPDATE IP_Addresses SET default_domain_id = 0;"
April 18th, 2010 on 7:37 pm
hey there, im trying to remove the default domain of my server’s IP… and maybe i’d be solving some issues with joomla php mail function…
putting the real issue aside, i want to know where can i execute the above command line? my server has 27 domains, and is set to one of them..
thank you in advance, for your help
/av
April 21st, 2010 on 12:42 am
SSH into your server and run the above as root or a user with read access to /etc/psa/.psa.shadow . You can also do the following from a mySQL client.
mysql> use psa;
mysql> UPDATE IP_Addresses SET default_domain_id = 0;
or for a single IP. (Assuming 192.168.0.1)
mysql> use psa;
mysql> UPDATE IP_Addresses SET default_domain_id = 0 WHERE ip_address = ‘192.168.0.1’;
April 21st, 2010 on 6:56 am
hey, thanks for the reply… i’ll be using the mysql client, of course, the second method (single IP)
thank you very much for your help!