Skip to Content

How to fix Hebrew characters missing after Ezeelogin upgrade?

428  Nesvin KN July 13, 2021  Common Errors & Troubleshooting

How to fix Hebrew characters missing after Ezeelogin upgrade in CentOS and Ubuntu?

If you find missing Hebrew characters after Ezeelogin upgrade, edit the user and save it correctly and follow the below steps to fix the error.

If you are using CentOS 7 or 8, edit /etc/my.cnf and add below command in it.
[email protected] ~]# vim /etc/my.cnf
[mysqld]
character_set_server = utf8mb4
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
Restart MySQL server and check the value of variables using the below commands.
[email protected] ~]# systemctl restart mariadb
[email protected] ~]# mysql -u root -p
Enter password:
MariaDB [(none)]> show variables like "%char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
If you get the above output, do upgrade Ezeelogin and the error will be fixed. Refer article to upgrade Ezeelogin.
If you are using Ubuntu 18, edit /etc/mysql/mysql.conf.d/mysqld.cnf and add below command in it.
[email protected] ~]# vim /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
character_set_server = utf8mb4
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
Restart MySQL server and check the value of variables using the below commands.
[email protected] ~]# systemctl restart mysql
[email protected] ~]# mysql -u root -p
Enter password:
mysql> show variables like "%char%";
+--------------------------------------+----------------------------+
| Variable_name                        | Value                      |
+--------------------------------------+----------------------------+
| character_set_client                 | utf8mb4                    |
| character_set_connection             | utf8mb4                    |
| character_set_database               | utf8mb4                    |
| character_set_filesystem             | binary                     |
| character_set_results                | utf8mb4                    |
| character_set_server                 | utf8mb4                    |
| character_set_system                 | utf8                       |
| character_sets_dir                   | /usr/share/mysql/charsets/ |
+--------------------------------------+----------------------------+
If you get the above output, do upgrade Ezeelogin and the error will be fixed. Refer article to upgrade Ezeelogin.
Not Rated