Hi, after updating to Hestia 1.9.2, when we connect to phpmyadmin, we get the error:
"Errore
Query SQL: Copia Modifica Modifica
SET lc_messages = ‘it_IT’;
Messaggio di MySQL: Documentazione
#1231 - Variable ‘lc_messages’ can’t be set to the value of ‘it_IT’"
can you help us solve the problem? Thank you
Hi @pigi76
Take a look to this fix:
Hi, the command “ln -s /usr/share/mariadb /usr/share/mysql” create symbolic link
mariadb → /usr/share/mariadb
inside inside /usr/share/mysql and it doesn’t work.
Editing /etc/mysql/my.cnf I already have “lc-messages-dir=/usr/share/mariadb” . Can you help us to fix this? Thanks
Sorry, I don’t understand:
ln -s /usr/share/mariadb /usr/share/mysql
Creates a symbolic link /usr/share/mysql -- pointing to -> /usr/share/mariadb
Show the output of theses commands:
grep -r lc-messages-dir /etc/mysql/
ls -ld /usr/share/mariadb
ls -la /usr/share/mariadb
ls -ld /usr/share/mysql
ls -la /usr/share/mysql
I have same problem.
ubuntu@admin:~$ grep -r lc-messages-dir /etc/mysql/
/etc/mysql/my.cnf:lc-messages-dir=/usr/share/mariadb
grep: /etc/mysql/debian.cnf: Permission denied
ubuntu@admin:~$ sudo grep -r lc-messages-dir /etc/mysql/
/etc/mysql/my.cnf:lc-messages-dir=/usr/share/mariadb
ubuntu@admin:~$ ls -ld /usr/share/mariadb
ls: cannot access '/usr/share/mariadb': No such file or directory
ubuntu@admin:~$ ls -la /usr/share/mariadb
ls: cannot access '/usr/share/mariadb': No such file or directory
ubuntu@admin:~$ ls -ld /usr/share/mysql
drwxr-xr-x 29 root root 4096 Feb 23 18:33 /usr/share/mysql
ubuntu@admin:~$ ls -la /usr/share/mysql
total 3612
drwxr-xr-x 29 root root 4096 Feb 23 18:33 .
drwxr-xr-x 174 root root 4096 Dec 29 12:38 ..
drwxr-xr-x 2 root root 4096 Jun 21 2024 bulgarian
drwxr-xr-x 2 root root 4096 Jun 21 2024 charsets
drwxr-xr-x 2 root root 4096 Jun 21 2024 chinese
drwxr-xr-x 2 root root 4096 Jun 21 2024 czech
drwxr-xr-x 2 root root 4096 Jun 21 2024 danish
-rwxr-xr-x 1 root root 2975 May 25 2024 debian-start.inc.sh
drwxr-xr-x 2 root root 4096 Jun 21 2024 dutch
-rwxr-xr-x 1 root root 27 May 25 2024 echo_stderr
drwxr-xr-x 2 root root 4096 Jun 21 2024 english
-rw-r--r-- 1 root root 716577 May 9 2024 errmsg-utf8.txt
drwxr-xr-x 2 root root 4096 Jun 21 2024 estonian
-rw-r--r-- 1 root root 2155153 May 9 2024 fill_help_tables.sql
drwxr-xr-x 2 root root 4096 Jun 21 2024 french
drwxr-xr-x 2 root root 4096 Jun 21 2024 german
drwxr-xr-x 2 root root 4096 Jun 21 2024 greek
drwxr-xr-x 2 root root 4096 Jun 21 2024 hindi
drwxr-xr-x 2 root root 4096 Jun 21 2024 hungarian
drwxr-xr-x 2 root root 4096 Jun 21 2024 italian
drwxr-xr-x 2 root root 4096 Jun 21 2024 japanese
drwxr-xr-x 2 root root 4096 Jun 21 2024 korean
-rw-r--r-- 1 root root 1683 May 25 2024 maria_add_gis_sp_bootstrap.sql
lrwxrwxrwx 1 root root 18 Feb 23 18:33 mariadb -> /usr/share/mariadb
-rw-r--r-- 1 root root 1958 May 9 2024 mysql_performance_tables.sql
-rw-r--r-- 1 root root 619446 May 25 2024 mysql_sys_schema.sql
-rw-r--r-- 1 root root 30571 May 9 2024 mysql_system_tables.sql
-rw-r--r-- 1 root root 3327 May 9 2024 mysql_system_tables_data.sql
-rw-r--r-- 1 root root 10413 May 9 2024 mysql_test_data_timezone.sql
-rw-r--r-- 1 root root 1679 May 9 2024 mysql_test_db.sql
drwxr-xr-x 2 root root 4096 Jun 21 2024 norwegian
drwxr-xr-x 2 root root 4096 Jun 21 2024 norwegian-ny
drwxr-xr-x 2 root root 4096 Jun 21 2024 polish
drwxr-xr-x 2 root root 4096 Jun 21 2024 portuguese
drwxr-xr-x 2 root root 4096 Jun 21 2024 romanian
drwxr-xr-x 2 root root 4096 Jun 21 2024 russian
drwxr-xr-x 2 root root 4096 Jun 21 2024 serbian
drwxr-xr-x 2 root root 4096 Jun 21 2024 slovak
drwxr-xr-x 2 root root 4096 Jun 21 2024 spanish
drwxr-xr-x 2 root root 4096 Jun 21 2024 swedish
drwxr-xr-x 2 root root 4096 Jun 21 2024 ukrainian
-rw-r--r-- 1 root root 3474 May 25 2024 wsrep.cnf
-rwxr-xr-x 1 root root 4979 May 25 2024 wsrep_notify
In your case, the dir /usr/share/mariadb doesn’t exist but /usr/share/mysql does. To fix it:
ln -s /usr/share/mysql /usr/share/mariadb
systemctl restart mariadb
Yep, thank you. Solved