openfire 离线消息丢失解决方案

1、创建辅助离线消息存储表

-- Create table
create table OFOFFLINE2
(
  username     VARCHAR2(64) not null,
  messageid    INTEGER not null,
  creationdate CHAR(15) not null,
  messagesize  INTEGER not null,
  stanza       LONG not null,
  messageid2   VARCHAR2(500)
)
-- Create/Recreate primary, unique and foreign key constraints
alter table OFOFFLINE2 add constraint OFOFFLINE2_PK primary key (USERNAME, MESSAGEID);

跟openfire离线表结构一致，额外添加messageid2字段，用于当消息正常接收后删除记录的过滤条件。

2、将正常接收的消息存储到该表，代码如下：

在MessageRouter类的public void route(Message packet)方法中添加

    private void addMessage(Message message){
     if (message == null) {
            return;
        }
     JID recipient = message.getTo();
        String username = recipient.getNode();
        // If the username is null (such as when an anonymous user), don't store.
        if (username == null || !UserManager.getInstance().isRegisteredUser(recipient)) {
            return;
        }
        else
        if (!XMPPServer.getInstance().getServerInfo().getXMPPDomain().equals(recipient.getDomain())) {
            // Do not store messages sent to users of remote servers
            return;
        }

        long messageID = SequenceManager.nextID(JiveConstants.OFFLINE);
        String messageID2 = message.getID();
     // Get the message in XML format.
        String msgXML = message.getElement().asXML();
        String body = message.getBody();
       
        /**
         * 台席同事接收的消息不记录到ofOffline2表
         */
        String toNode = message.getTo().getNode();
        String regex = ".*-\\d+.*";
        if(toNode.matches(regex)) {
         return ;
        }
       
        //接收消息后，发送的删除Ofoffline2表中的消息，不需要存离线表
        if(msgXML.indexOf("delMessageOfoffline2") > -1) {
         return ;
        }
       
        Connection con = null;
        PreparedStatement pstmt = null;
        try {
            con = DbConnectionManager.getConnection();
            pstmt = con.prepareStatement("INSERT INTO ofOffline2 (username, messageID, messageID2, creationDate, messageSize, stanza) " +
        "VALUES (?, ?, ?, ?, ?, ?)");
            pstmt.setString(1, username);
            pstmt.setLong(2, messageID);
            pstmt.setString(3, messageID2);
            pstmt.setString(4, StringUtils.dateToMillis(new java.util.Date()));
            pstmt.setInt(5, msgXML.length());
            pstmt.setString(6, msgXML);
            pstmt.executeUpdate();
        } catch (Exception e) {
         log.error(LocaleUtils.getLocalizedString("admin.error"), e);
        } finally {
            DbConnectionManager.closeConnection(pstmt, con);
        }
    }

3、正常接收消息需要删除该表数据：

自定义消息监听插件