FastPath offline message

Openfire Openfire Support
1

Hi,

Last week i found out that Openfire 3.3.1 offline message did not working…

It worked OK for english, but it did not for double byte character

such as

???

???

???

???

???

will be

???

???

???

???

???

and

???Unicode(???)?

will be

???Unicode(???)?

Anyone know what has happened?

Thanks.

2

Welly,

I would make sure your database is setup to support UTF-8 if that is the case then you should be able to see UTF-8 characters being stored in the jiveoffline table. Instructions for setting up your database to handle UTF-8 are different for each database so you will probably need to google for your particular setup.

Cheers,

Nate

3

Hi Nate,

The SQL is utf8 , i can save data to SQL in utf 8 format.

The problem is that offline message/ test email that was sent out, couldn’'t be seen properly

Thanks

Welly

4

Hi,

Any update or idea how to solve this issue?

Thanks

Welly

5

Same problem when you email the chat transcript. If the email contains any double-byte characters the body

of the email is empty. Here is part of the stack trace when that happens:

2007.08.02 08:16:36 org.jivesoftware.openfire.component.InternalComponentManager$2.error(InternalCom ponentManager.java:280)

java.sql.SQLException: Incorrect string value: ‘’\xE3\x82\x88\xE3\x82\x8A…’’ for column ‘‘transcript’’ at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.ja va:1125)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement. java:677)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)

at com.jivesoftware.xmpp.workgroup.utils.DbWorkgroup.updateTranscript(DbWorkgroup. java:55)

6

Thanks for the report. I’ve gone ahead and filed ENT-166 to fix this issue.

Cheers,

Derek

7

Derek,

I just tested the 3.3.3 Enterprise plugin and this encoding issues still exists. But I see that ENT-166 has been closed and fixed for 3.3.3. Can you reopen the issue?

8

Hi,

This issue actually existed within the Openfire core side of things. Have you updated to the latest 3.3.3?

Cheers,

Derek

9

Yes. I upgraded to Openfire 3.3.3 at the same time.

10

Derek,

I had tested the 3.3.3 vserion and this encoding issues

still exists.

I try to send chinese, korean, japanese and russian .

Thanks

Welly