'server does not appear utf8 complaint' message,MariaDB Centos

[voytek]

just a comment, I have Cacti on Centos with MariaDB, during 1.21 upgrade (I might have seen this message in prior upgrades/install) I get a warning that I'm not UTF8, though, looking it /etc/my.cnf, it seems I am

Linux 3.10.0-1160.66.1.el7.x86_64 #1 SMP Wed May 18 16:02:34 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
# mysql --version
mysql Ver 15.1 Distrib 10.2.33-MariaDB, for Linux (x86_64) using EditLine wrapper

no real issue, just commenting

Screenshot 2022-05-31 070242.png (56.43 KiB) Viewed 618 times

[macan]

show result of these queries:
show variables like '%chara%';
show variables like '%coll%';

Maybe your mysql server is not using ini file you configured.

[voytek]

Macan, thanks

server .8

Server version: 10.2.33-MariaDB MariaDB Server

MariaDB [(none)]> show variables like '%chara%';
+--------------------------+--------------------------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /opt/rh/rh-mariadb102/root/usr/share/mariadb/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.00 sec)

MariaDB [(none)]> show variables like '%coll%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+----------------------+--------------------+
3 rows in set (0.00 sec)

MariaDB [(none)]> status;
--------------
mysql Ver 15.1 Distrib 10.2.33-MariaDB, for Linux (x86_64) using EditLine wrapper

Connection id: 4573
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.2.33-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 22 hours 3 min 58 sec

Threads: 13 Questions: 1959557 Slow queries: 0 Opens: 174 Flush tables: 1 Open tables: 149 Queries per second avg: 24.667
--------------

MariaDB [(none)]> help


server g

Server version: 10.2.33-MariaDB MariaDB Server

MariaDB [(none)]> show variables like '%chara%';
+--------------------------+--------------------------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /opt/rh/rh-mariadb102/root/usr/share/mariadb/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.00 sec)

MariaDB [(none)]> show variables like '%coll%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
MariaDB [(none)]> status;
--------------
mysql Ver 15.1 Distrib 10.2.33-MariaDB, for Linux (x86_64) using EditLine wrapper

Connection id: 23985
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.2.33-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 day 45 min 3 sec

Threads: 33 Questions: 1014757 Slow queries: 0 Opens: 276 Flush tables: 1 Open tables: 251 Queries per second avg: 11.388
--------------

[macan]

I didn't understand .. Is it result from 2 different servers? The first has correct settings but the second one doesn't.

here is cnf file location table :
https://mariadb.com/kb/en/configuring-m ... ion-files/