Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    K-1246: Database connection does not support 4-byte UTF-8

    Kopano Groupware Core
    3
    7
    442
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • yythoss
      yythoss last edited by

      Hello Forum,
      I switched from mysql to mariadb 10.2.26 on CentOS 6, but I still get this error:

      Sat Aug  3 22:55:40 2019: [notice ] K-1246: Database connection does not support 4-byte UTF-8. Going for 3-byte UTF-8. The content of some mails may not be representable.
      
      

      kopano-dbadm usmp was running, with the same Error.
      My my.cnf:

      [client]
      default-character-set=utf8mb4
      
      [mysqld]
      character-set-server=utf8mb4
      character_set_client=utf8mb4
      
      

      THX

      1 Reply Last reply Reply Quote 0
      • AnotherAndy
        AnotherAndy last edited by AnotherAndy

        Hi,
        can you please paste the result of this query:

        SHOW GLOBAL VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;

        Check this out:
        https://scottlinux.com/2017/03/04/mysql-mariadb-set-character-set-and-collation-to-utf8/

        regards
        Andreas

        1 Reply Last reply Reply Quote 0
        • yythoss
          yythoss last edited by

          This is the output:

          +--------------------------+------------------------------+
          | 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       | /opt/mariadb/share/charsets/ |
          | collation_connection     | utf8mb4_general_ci           |
          | collation_database       | utf8mb4_general_ci           |
          | collation_server         | utf8mb4_general_ci           |
          +--------------------------+------------------------------+
          
          
          1 Reply Last reply Reply Quote 0
          • AnotherAndy
            AnotherAndy last edited by

            Maybe in the my.cnf the parameter
            skip-character-set-client-handshake
            helps.
            Your output looks good, same as mine.

            1 Reply Last reply Reply Quote 0
            • yythoss
              yythoss last edited by

              After I insert skip-character-set-client-handshake in my.cnf I have the same error.

              1 Reply Last reply Reply Quote 0
              • longsleep
                longsleep Kopano last edited by

                @yythoss said in K-1246: Database connection does not support 4-byte UTF-8:

                I switched from mysql to mariadb 10.2.26 on CentOS 6, but I still get this error:

                How did you do that? MySQL or MariaDB are client and server. So if you only switched the server (e.g. by installing it from a third party repo on CentOS 6) but still use the system’s mysql client library (which might not support utf8mb4) that is what causes your issue.

                Support for utf8mb4 was introduced in MySQL 5.5.3 (released in 2010-03-24) where CentOS 6 comes with MySQL 5.1(?). If you use supported Kopano builds for CentOS 6, those are linked with libmysqlclient.so.16 which comes from mysqlclient16-5.1.59-2 package and thus does not support utf8mb4 on that platform (thus the warning is logged).

                1 Reply Last reply Reply Quote 0
                • yythoss
                  yythoss last edited by

                  Ok, I think that is my problem.
                  I only change mariadb Server and use supported kopano centos6 rpm‘s.
                  So I must accept this warning.

                  THX

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post