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
Hi, i have the same problem with my installation, since 2 weeks i can’t operate with the db,s, i have problems with phpmyadmin that logs me out automatically and also can’t download db’s from the hestia Database section.
slowpoke# grep -r lc-messages-dir /etc/mysql/
/etc/mysql/my.cnf:lc-messages-dir=/usr/share/mariadb
/etc/mysql/my.cnf.vst.back:lc-messages-dir=/usr/share/mysql
slowpoke#
slowpoke# ls -ld /usr/share/mariadb
lrwxrwxrwx 1 root root 16 Mar 21 17:25 /usr/share/mariadb -> /usr/share/mysql
slowpoke# ls -la /usr/share/mariadb
lrwxrwxrwx 1 root root 16 Mar 21 17:25 /usr/share/mariadb -> /usr/share/mysql
slowpoke#
slowpoke# ls -ld /usr/share/mysql
drwxr-xr-x 30 root root 4096 Mar 21 17:23 /usr/share/mysql
slowpoke# ls -la /usr/share/mysql
total 3716
drwxr-xr-x 30 root root 4096 Mar 21 17:23 .
drwxr-xr-x 146 root root 4096 Mar 21 17:25 ..
drwxr-xr-x 2 root root 4096 Feb 13 2024 bulgarian
drwxr-xr-x 2 root root 4096 Feb 13 2024 charsets
drwxr-xr-x 2 root root 4096 Feb 13 2024 chinese
drwxr-xr-x 2 root root 4096 Feb 13 2024 czech
drwxr-xr-x 2 root root 4096 Feb 13 2024 danish
-rwxr-xr-x 1 root root 2975 Nov 30 2023 debian-start.inc.sh
drwxr-xr-x 2 root root 4096 Feb 13 2024 dutch
-rwxr-xr-x 1 root root 27 Nov 30 2023 echo_stderr
drwxr-xr-x 2 root root 4096 Feb 13 2024 english
-rw-r--r-- 1 root root 830663 Nov 8 2023 errmsg-utf8.txt
drwxr-xr-x 2 root root 4096 Feb 13 2024 estonian
-rw-r--r-- 1 root root 2134791 Nov 8 2023 fill_help_tables.sql
drwxr-xr-x 2 root root 4096 Feb 13 2024 french
drwxr-xr-x 2 root root 4096 Feb 13 2024 georgian
drwxr-xr-x 2 root root 4096 Feb 13 2024 german
drwxr-xr-x 2 root root 4096 Feb 13 2024 greek
drwxr-xr-x 2 root root 4096 Feb 13 2024 hindi
drwxr-xr-x 2 root root 4096 Feb 13 2024 hungarian
drwxr-xr-x 2 root root 4096 Feb 13 2024 italian
drwxr-xr-x 2 root root 4096 Feb 13 2024 japanese
drwxr-xr-x 2 root root 4096 Feb 13 2024 korean
-rw-r--r-- 1 root root 1683 Nov 30 2023 maria_add_gis_sp_bootstrap.sql
lrwxrwxrwx 1 root root 18 Mar 21 17:23 mariadb -> /usr/share/mariadb
-rwxr-xr-x 1 root root 7372 Nov 30 2023 mini-benchmark
-rw-r--r-- 1 root root 1958 Nov 8 2023 mysql_performance_tables.sql
-rw-r--r-- 1 root root 619228 Nov 30 2023 mysql_sys_schema.sql
-rw-r--r-- 1 root root 3327 Nov 8 2023 mysql_system_tables_data.sql
-rw-r--r-- 1 root root 30575 Nov 8 2023 mysql_system_tables.sql
-rw-r--r-- 1 root root 10413 Nov 8 2023 mysql_test_data_timezone.sql
-rw-r--r-- 1 root root 1775 Nov 8 2023 mysql_test_db.sql
drwxr-xr-x 2 root root 4096 Feb 13 2024 norwegian
drwxr-xr-x 2 root root 4096 Feb 13 2024 norwegian-ny
drwxr-xr-x 2 root root 4096 Feb 13 2024 polish
drwxr-xr-x 2 root root 4096 Feb 13 2024 portuguese
drwxr-xr-x 2 root root 4096 Feb 13 2024 romanian
drwxr-xr-x 2 root root 4096 Feb 13 2024 russian
drwxr-xr-x 2 root root 4096 Feb 13 2024 serbian
drwxr-xr-x 2 root root 4096 Feb 13 2024 slovak
drwxr-xr-x 2 root root 4096 Feb 13 2024 spanish
drwxr-xr-x 2 root root 4096 Feb 13 2024 swedish
drwxr-xr-x 2 root root 4096 Feb 13 2024 ukrainian
-rw-r--r-- 1 root root 3474 Nov 30 2023 wsrep.cnf
-rwxr-xr-x 1 root root 4979 Nov 30 2023 wsrep_notify
Hi, this is my output: root@# grep -r lc-messages-dir /etc/mysql/
/etc/mysql/my.cnf:lc-messages-dir=/usr/share/mariadb
root@# ls -ld /usr/share/mariadb
ls: cannot access ‘/usr/share/mariadb’: No such file or directory
root@# ls -la /usr/share/mariadb
ls: cannot access ‘/usr/share/mariadb’: No such file or directory
root@# ls -ld /usr/share/mysql
drwxr-xr-x 30 root root 4096 Feb 13 11:10 /usr/share/mysql
root@*************# ls -la /usr/share/mysql
total 3728
drwxr-xr-x 30 root root 4096 Feb 13 11:10 .
drwxr-xr-x 263 root root 12288 Feb 28 01:41 …
drwxr-xr-x 2 root root 4096 Sep 25 2024 bulgarian
drwxr-xr-x 2 root root 4096 Sep 25 2024 charsets
drwxr-xr-x 2 root root 4096 Sep 25 2024 chinese
drwxr-xr-x 2 root root 4096 Sep 25 2024 czech
drwxr-xr-x 2 root root 4096 Sep 25 2024 danish
-rwxr-xr-x 1 root root 3527 Aug 3 2024 debian-start.inc.sh
drwxr-xr-x 2 root root 4096 Sep 25 2024 dutch
-rwxr-xr-x 1 root root 27 Aug 3 2024 echo_stderr
drwxr-xr-x 2 root root 4096 Sep 25 2024 english
-rw-r–r-- 1 root root 830803 Aug 3 2024 errmsg-utf8.txt
drwxr-xr-x 2 root root 4096 Sep 25 2024 estonian
-rw-r–r-- 1 root root 2134791 Aug 3 2024 fill_help_tables.sql
drwxr-xr-x 2 root root 4096 Sep 25 2024 french
drwxr-xr-x 2 root root 4096 Sep 25 2024 georgian
drwxr-xr-x 2 root root 4096 Sep 25 2024 german
drwxr-xr-x 2 root root 4096 Sep 25 2024 greek
drwxr-xr-x 2 root root 4096 Sep 25 2024 hindi
drwxr-xr-x 2 root root 4096 Sep 25 2024 hungarian
drwxr-xr-x 2 root root 4096 Sep 25 2024 italian
drwxr-xr-x 2 root root 4096 Sep 25 2024 japanese
drwxr-xr-x 2 root root 4096 Sep 25 2024 korean
-rw-r–r-- 1 root root 1683 Aug 3 2024 maria_add_gis_sp_bootstrap.sql
lrwxrwxrwx 1 root root 18 Feb 13 11:10 mariadb → /usr/share/mariadb
-rwxr-xr-x 1 root root 9594 Aug 3 2024 mini-benchmark
-rw-r–r-- 1 root root 1958 Aug 3 2024 mysql_performance_tables.sql
-rw-r–r-- 1 root root 619503 Aug 3 2024 mysql_sys_schema.sql
-rw-r–r-- 1 root root 3327 Aug 3 2024 mysql_system_tables_data.sql
-rw-r–r-- 1 root root 30575 Aug 3 2024 mysql_system_tables.sql
-rw-r–r-- 1 root root 10413 Aug 3 2024 mysql_test_data_timezone.sql
-rw-r–r-- 1 root root 1775 Aug 3 2024 mysql_test_db.sql
drwxr-xr-x 2 root root 4096 Sep 25 2024 norwegian
drwxr-xr-x 2 root root 4096 Sep 25 2024 norwegian-ny
drwxr-xr-x 2 root root 4096 Sep 25 2024 polish
drwxr-xr-x 2 root root 4096 Sep 25 2024 portuguese
drwxr-xr-x 2 root root 4096 Sep 25 2024 romanian
drwxr-xr-x 2 root root 4096 Sep 25 2024 russian
drwxr-xr-x 2 root root 4096 Sep 25 2024 serbian
drwxr-xr-x 2 root root 4096 Sep 25 2024 slovak
drwxr-xr-x 2 root root 4096 Sep 25 2024 spanish
drwxr-xr-x 2 root root 4096 Sep 25 2024 swedish
drwxr-xr-x 2 root root 4096 Sep 25 2024 ukrainian
-rw-r–r-- 1 root root 3474 Aug 3 2024 wsrep.cnf
-rwxr-xr-x 1 root root 4979 Aug 3 2024 wsrep_notify How i can solve the problem?
ln -s /usr/share/mysql /usr/share/mariadb
systemctl restart mariadb
Me funciono, gracias.