Problem with Cirillic text in all areas of Wildfire

Openfire Openfire Support
1

I have problems with Cirillic text in large number of areas

all cirillic history after server restarting becomes like ???

plugin settings with cirillic text(i have found problem with ContentFilter plugin) also after restarting become like ???

I can’'t understand what is the problem, did anybody have this problem before?

Environment

JVM Version and Vendor: 1.5.0_06 Sun Microsystems Inc. – Java HotSpot™ Client VM

Appserver: Jetty/5.1.x

OS / Hardware: Windows XP / x86

Locale / Timezone: en / Eastern European Time (2 GMT)

Java Memory

16.29 MB of 63.56 MB (25.6%) used

Database Connection Info

Database and Version: MySQL 3.23.41

JDBC Driver: MySQL-AB JDBC Driver

JDBC Driver Version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )

DB Connection URL: jdbc:mysql://URL

DB User:

Transaction Support: Yes

Transaction Isolation Level: TRANSACTION_READ_COMMITTED

Supports multiple connections

open at once: Yes

In read-only mode: No

2

Hi YAN,

You have not specified the client.

  If you mean only offline messages that delivers to you, then possible case what MySQL may be not configured correctly, see knowledge base for details      http://www.jivesoftware.org/community/entry.jspa?externalID=502&categoryID=22

In other case, see the client’'s history manager - the charset should be utf-8

See ya

3

I’'m using Spark 1.0.4 and Miranda 0.4.3.45 with jabber protocol and chat plugin.

I can see history for contacts with correct symbols but for Conference not,

Also I’'m using MySQL 3.2.9

4

Hey Andrey,

Since you are using an old MySQL version I think that this url=http://www.jivesoftware.org/community/entry.jspa?externalID=502&categoryID=2 2KB document[/url] may come handy. In summary, you have to specify the encoding to use in the jdbc URL.

Regards,

– Gato

5

I have made all changes syggested by author but it diidn’'t help.

let me add some additional note:

During work of server after restart I don’'t have any problem with any client with new history - I can log in Conference, add something, read something? log out and log in again and read and write cirillic and everything is OK. But after server restarting all previous history with cirillic text becomes unreadable (cirillic symbols changed to ?).

6

one more question, there is no utf8 character set on my MySQL server, if I add in connection URL utf8 - is it correct? which one do I have to add?

7 
  If you mean only offline messages that delivers to you, then possible case what MySQL may be not configured correctly, see knowledge base for details      http://www.jivesoftware.org/community/entry.jspa?externalID=502&categoryID=22

Could somebody point me to the correct link to this article ?

8

Hopefully http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/database.h tml#mysql help also this is not the somehow gone KB article.

LG