一 、mysql乱码

解决方法：openfire.xml 进行配置如下

       <serverURL>jdbc:mysql://localhost:3306/openfire?useUnicode=true&amp;characterEncoding=utf8</serverURL>  

二、问题
      

org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool (attempt 2 out of 10).
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

解决方法： my.cnf下配置如下

wait_timeout = 600
max_connections=2000
interactive_timeout = 600