6 Replies Latest reply on Sep 30, 2014 10:28 AM by Mohammed

    Openfire 3.7.1 Offline Messages bug

      Good day!

       

      Problem: Sending offline messages in Russian codepage as result write ???? in jabber.ofOffline.

       

      I'm using CentOS Linux 6.3, Openfire 3.7.1, MySQL 5.1.61 and LDAP UserDB (MS AD DS).

       

      MySQL Server encoding UTF-8 Unicode (utf8)

      MySQL Openfire DB and table collation "utf8_general_ci"

       

      openfire.xml DB Config:

       

        <connectionProvider>

          <className>org.jivesoftware.database.DefaultConnectionProvider</className>

        </connectionProvider>

        <database>

          <defaultProvider>

            <driver>com.mysql.jdbc.Driver</driver>

            <serverURL>jdbc:mysql://mysql.factory.ru:3306/jabber</serverURL>

            <username>jabber</username>

            <password>password</password>

            <testSQL>select 1</testSQL>

            <testBeforeUse>true</testBeforeUse>

            <testAfterUse>true</testAfterUse>

            <minConnections>5</minConnections>

            <maxConnections>25</maxConnections>

            <connectionTimeout>1.0</connectionTimeout>

            <useUnicode>true</useUnicode>

          </defaultProvider>

        </database>

       

      useUnicode was added by following this threat http://community.igniterealtime.org/thread/28989.