Routing the world

Routing & IT System Administration

Archive for July 2010

Change Plesk default language

leave a comment »

If you only have paid for a basic Plesk Licence and need to change the default language pack from english to other this are the instructions. This is a sample to change it to Spanish.

Please follow the below mentioned steps to help resolve the issue :

– Create Plesk database backup:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa_backup.sql

– Stop Plesk CP:
# /etc/init.d/psa stop1

– Login into Plesk database:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

– Find what locales are available in Plesk:

mysql> select * from locales;
| id    | active |
| es-ES | false  |
| en-US | true   |

– In table ‘misc’ replace ‘en-US’ with desired locale name what you found in the step 3 ( for example ‘es-ES’) in ‘admin_locale’ and ‘def_locale’:
mysql> update misc set val="es-ES" where param in
mysql> ("admin_locale","def_locale");

– In table ‘mn_param’ replace ‘en-US’ with the desired locale:
mysql> update mn_param set val="es-ES" where val="en-US";

– In table ‘clients’ replace locale for all clients:
mysql> update clients set locale="es-ES";

– In table ‘module_watchdog_param’:
mysql> update module_watchdog_param set val="es-ES" where
mysql> param="locale";

– In ‘dom_param’ there are locales for each domain:
mysql> update dom_param set val="es-ES" where param="locale";

– Change locale for mailboxes in the ‘Parameters’ table:
mysql> update Parameters set value="es-ES" where Parameter in
mysql> ("s:locale", "s:country_locale");

– Also, in order to keep everything correct, alter locales table to display active locale correctly:
mysql> update locales set active="false" where id="en-US"; update
mysql> locales set active="true" where id="es-ES";

– Exit from MySQL:
mysql> quit

– Start Plesk CP:
# /etc/init.d/psa start

Good luck


Written by Root

July 15, 2010 at 13:10

Posted in Linux, Plesk

Tagged with

%d bloggers like this: