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'
eris
January 12, 2025, 10:12am
2
We don’t set the language in PHPmyadmin…
But in version 1.8 it was
Raphael
January 12, 2025, 11:00am
4
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?
eris
January 12, 2025, 2:48pm
7
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
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
sahsanu
January 14, 2025, 1:28am
11
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.
I installed version 1.8.12, by default there is version 10 of Maria
Updated like this
Everything is in Russian, everything is fine
If I install 1.9 beta, then I get PHPadmin+Maria11.4 in English, and as I showed above, errors occur.
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.
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