Some more error messages I came upon...
==== Your have 1 clients with no domains defined ====
Client can be deleted before updating
==== You have 1 clients who are free to manage resources on their domains themselves ====
Seems to cause no problems when switching the business model after the update.
==== You have client 1 with default permissions. ====
Find the client within "/root/parallels/PSA_10.4.4/examiners/clients_have_default_permissions.log", open the client in Plesk and go to "Account > Permissions". Just hit "ok" once.
==== Your have 1 clients with Domain Administrators defined on more than one domain. ====
Seems to be no problem for switching the business model after the update.
==== Some customers have e-mail addresses coinciding with the Panel administrator's e-mail address ====
Find those customers within "/root/parallels/PSA_10.4.4/examiners/plesk10_preupgrade_checker.log" and change their email-address
==== Each subdomain registered in Panel has a number of DNS records that derive from the Panel DNS template ====
Check with:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select dns_zone_id, type, host, val, opt from dns_recs where host in (select concat(s.name,'.', d.name,'.') from subdomains s, domains d where s.dom_id = d.id order by dns_zone_id);"
Sometimes need to be recreated after the update.
==== You have ... mailbox users that will be converted to subscription-level auxiliary users after upgrading to Panel 10 ====
(Text from Parallels)
Before upgrading the Plesk to 10.x version, you need to find the mail accounts which are having encrypted passwords:
mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT CONCAT(m.mail_name,'@',d.name) AS mail, a.type, a.password FROM domains d, mail m, accounts a WHERE m.dom_id=d.id AND m.account_id=a.id AND a.type <> 'plain'" psa
After executing this command you will get the details of the mail accounts with encrypted password. In-order to change the password to plain text you should change the password of this mail account from the Plesk panel. When a password is changed through Parallels Plesk Panel, it's saved as a "plain" type
If there is no mail accounts with encrypted password, you can start upgrading the Plesk without making any changes.
After completing the upgrade you need to check whether any mail accounts is present in the database with user ID other than '0'. If any such mail accounts are present, you need to update the user ID to value '0'. In Plesk 10.x versions all mail accounts are having user ID as 0.
To check mail accounts with user ID other than 0
mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "select * from mail where userId !=0" psa
To update user ID to 0:
mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "update mail set userId=0 where userId !=0;" psa
==== There is a number of DNS records for the subdomains that you manually added to domain DNS zones ====
If you upgrade to Panel 10.4.4, these records will be lost. Check
http://kb.parallels.com/en/113310 for more details.
Check with:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e "SELECT DISTINCT dns_recs.dns_zone_id, dns_recs.type, host, val, opt FROM dns_recs, subdomains, domains WHERE host = concat(subdomains.name,'.', domains.name,'.') AND dns_recs.dns_zone_id IN ( SELECT dns_recs.dns_zone_id FROM dns_recs, subdomains, domains, hosting, IP_Addresses WHERE host = concat(subdomains.name,'.', domains.name,'.') AND subdomains.dom_id = domains.id AND domains.id = hosting.dom_id AND hosting.ip_address_id = IP_Addresses.id AND IP_Addresses.ip_address <> dns_recs.val)"
Only TXT- and MX-records seem to get lost
=== Problems with subdomains ===
* vhost.conf needs to be copied to another place
mv /var/www/vhosts/##domain##/subdomains/##subdomain##/conf/vhost.conf /var/www/vhosts/##subdomain##.##domain##/conf
* SSL will be activated even if it wasn´t before
* PHP might need to be reactivated again
=== Transition to new business model won´t complete ===
(Text from Parallels)
The root cause of this issue that was in some obsolete limits for customers, which was remove in new version, but for some reasons this did not transitioned.
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select id,NAME,cl_id,vendor_id from domains where cl_id = vendor_id;"
--> die zugehörigen cl_id,vendor_id gibt es vermutlich nicht
Applied transition scheme should set vendor_id for such domains to parent_id of domain owner, i.e. domains.vendor_id = clients.parent_id for clients.id = domains.cl_id. Now there is only one such vendor - 'admin':
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select id,login from clients where parent_id is null;"
Use this ID in the following statements.
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select id,login from clients where parent_id != ##ID##;"
--> will probably be empty
The solution is to set vendor_id = ##ID## for all domains mentioned above (where cl_id = vendor_id):
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "update domains set vendor_id=##ID## where cl_id=vendor_id;"
Facebook
Twitter
