Plesk 10 Upgrade – WWW Site Prefix Shows Default Page

A recent upgrade from Plesk 9 to Plesk 10 resulted in us experiencing an issue where the Plesk Default Page is shown for the WWW prefix for a number of sites. Turns out it is a documented issue however the Parallels suggested solution hardly scales.

This is frustrating, very frustrating. Someone might want to send a copy of the relevant DNS RFC to Parallels as its also plain wrong.

Disclaimer: I won’t be held liable for any data loss, downtime or customer angst as a result of the following. While this will work in most environments, YMMV. Backup your PSA database before starting.

First step is to create a small shell script (Ie. vim /root/fixissue.sh) containing the following

#! /bin/csh
foreach domain (`cat /root/domains`)
/usr/local/psa/bin/dns --add $domain -cname 'www' -canonical $domain
/usr/local/psa/admin/sbin/httpdmng --reconfigure-domain $domain
echo $domain Fixed
end

Following this, complete the following. This could also be scripted without effort.

echo "select host from dns_recs WHERE host LIKE 'www%' AND type = 'A';" | mysql -N -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/domains