No Russian language Hestia Control Panel v1.9.0~beta1

Hello, I found on the forum that the Russian language has been added to the beta version, but as I see in the panel, as well as in PHPadmin, it is not there, although it is selected in the settings. Perhaps I don’t understand something, or is there something worth downloading, for example a Russian localization package?

Error

SQL query: Copy Edit Edit

SET lc_messages = 'ru_RU';

MySQL Answer: Documentation
#1231 - Variable 'lc_messages' can't be set to the value of 'ru_RU'


We don’t set the language in PHPmyadmin…

But in version 1.8 it was

We do not change or modify any language related settings in phpmyadmin, maybe there was a change in pma version.

Ok, but what about the Russian language in the panel, there is a setting, but there is no language, everything is in English

does it work with another language?

Beta has bug with the languages not working it has been fixed in main

Okay, is there an option to install the main one now, even as a test? Thanks

1 Like
2 Likes

I installed 1.82 back, got some problems with 1.9 beta, and I see that PHPadmin has Russian. I am 100% sure that this is related to the version of MariaDB, version 10 with Russian is fine, but if you upgrade to 11, it disappears. It’s good if this is fixed in 1.9 and Russian will be in PHPAdmin

Double check that you have the dir /usr/share/mariadb/

❯ ls -l /usr/share/mariadb/
total 2936
drwxr-xr-x 2 root root    4096 nov 20 23:42 bulgarian
drwxr-xr-x 2 root root    4096 nov 20 23:42 charsets
drwxr-xr-x 2 root root    4096 nov 20 23:42 chinese
drwxr-xr-x 2 root root    4096 nov 20 23:42 czech
drwxr-xr-x 2 root root    4096 nov 20 23:42 danish
-rwxr-xr-x 1 root root    3527 oct 30 15:38 debian-start.inc.sh
drwxr-xr-x 2 root root    4096 nov 20 23:42 dutch
-rwxr-xr-x 1 root root      27 oct 30 15:38 echo_stderr
drwxr-xr-x 2 root root    4096 nov 20 23:42 english
drwxr-xr-x 2 root root    4096 nov 20 23:42 estonian
-rw-r--r-- 1 root root 2165262 oct 30 15:38 fill_help_tables.sql
drwxr-xr-x 2 root root    4096 nov 20 23:42 french
drwxr-xr-x 2 root root    4096 nov 20 23:42 georgian
drwxr-xr-x 2 root root    4096 nov 20 23:42 german
drwxr-xr-x 2 root root    4096 nov 20 23:42 greek
drwxr-xr-x 2 root root    4096 nov 20 23:42 hindi
drwxr-xr-x 2 root root    4096 nov 20 23:42 hungarian
drwxr-xr-x 2 root root    4096 nov 20 23:42 italian
drwxr-xr-x 2 root root    4096 nov 20 23:42 japanese
drwxr-xr-x 2 root root    4096 nov 20 23:42 korean
-rw-r--r-- 1 root root    1683 oct 30 16:09 maria_add_gis_sp_bootstrap.sql
-rw-r--r-- 1 root root    1958 oct 30 15:38 mariadb_performance_tables.sql
-rw-r--r-- 1 root root  623733 oct 30 16:09 mariadb_sys_schema.sql
-rw-r--r-- 1 root root    3327 oct 30 15:38 mariadb_system_tables_data.sql
-rw-r--r-- 1 root root   30685 oct 30 15:38 mariadb_system_tables.sql
-rw-r--r-- 1 root root   10506 oct 30 15:38 mariadb_test_data_timezone.sql
-rw-r--r-- 1 root root    1786 oct 30 15:38 mariadb_test_db.sql
-rwxr-xr-x 1 root root    9594 oct 30 16:09 mini-benchmark
drwxr-xr-x 2 root root    4096 nov 20 23:42 norwegian
drwxr-xr-x 2 root root    4096 nov 20 23:42 norwegian-ny
drwxr-xr-x 2 root root    4096 nov 20 23:42 polish
drwxr-xr-x 2 root root    4096 nov 20 23:42 portuguese
drwxr-xr-x 2 root root    4096 nov 20 23:42 romanian
drwxr-xr-x 2 root root    4096 nov 20 23:42 russian
drwxr-xr-x 2 root root    4096 nov 20 23:42 serbian
drwxr-xr-x 2 root root    4096 nov 20 23:42 slovak
drwxr-xr-x 2 root root    4096 nov 20 23:42 spanish
drwxr-xr-x 2 root root    4096 nov 20 23:42 swahili
drwxr-xr-x 2 root root    4096 nov 20 23:42 swedish
drwxr-xr-x 2 root root    4096 nov 20 23:42 ukrainian
-rw-r--r-- 1 root root    3474 oct 30 16:09 wsrep.cnf
-rwxr-xr-x 1 root root    4979 oct 30 16:09 wsrep_notify

If you have this dir with the language contents then:

Option 1

Create a new symbolic link pointing mysql to mariadb:

ln -s /usr/share/mariadb /usr/share/mysql

Option 2

Edit mariadb conf file /etc/mysql/my.cnf and replace this:

lc-messages-dir=/usr/share/mysql

by this:

lc-messages-dir=/usr/share/mariadb

Once done, restart mariadb.

systemctl restart mariadb

Hello, thanks for your help, look what I got.

  1. I installed version 1.8.12, by default there is version 10 of Maria
  2. Updated like this
  3. Everything is in Russian, everything is fine
  4. If I install 1.9 beta, then I get PHPadmin+Maria11.4 in English, and as I showed above, errors occur.
  5. Also in 1.9 beta I get errors this and [this](https://forum.hestiacp.com/t/the-phpmyadmin-configuration-store-is-not-fully-configured-and-some-advanced-features-have-been-disabled-find-out- the-reason-or-go-to-the-operations-tab-of-any-database-to-configure-storage-in-it/17354). I checked it again now, installing it again, there are no such errors as in 1.9, only there is no Russian language (it’s definitely not there)
    So, it would be nice for the creators to look at version 1.9 for corrections or changes to avoid what I got.

    6. And yet, after updating according to the instructions above, but without deleting (I tried it with deleting before), I get a hyperlink to my.cnf, without the file itself, and as a result there is a lack of settings.
  6. The question remains: how to return this file, or just set it up and leave the hyperlink?
    I deleted the symbolic link, just added the my.cnf file, everything became correct