xwiki 7.14 Windows安装教程(jetty + MySQL5.7+jdk1.7)

环境： mysql5.7  win7  jdk1.7（配置环境变量）

http://forge.ow2.org/project/showfiles.php?group_id=170 所有历史版本下载

http://forge.ow2.org/project/download.php?group_id=170&file_id=20840 下载7.14版本

1、解压xwiki-enterprise-jetty-hsqldb-7.1.4.zip

2、mysql

用root登录mysql

create database xwiki default character set utf8 collate utf8_bin

grant all privileges on xwiki.* to xwiki@localhost  identified by "xwiki"; 

3、修改xwiki-enterprise-jetty-hsqldb-7.1.4\webapps\xwiki\WEB-INF\hibernate.cfg.xml
修改mysql数据库配置以及注释hql配置

<!-- <property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property>    <property name="connection.username">sa</property>    <property name="connection.password"></property>    <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>    <property name="dialect">org.hibernate.dialect.HSQLDialect</property>    <mapping resource="xwiki.hbm.xml"/>    <mapping resource="feeds.hbm.xml"/>    <mapping resource="activitystream.hbm.xml"/>    <mapping resource="instance.hbm.xml"/>    <mapping resource="mailsender.hbm.xml"/>-->    <!-- MySQL configuration.         Uncomment if you want to use MySQL and comment out other database configurations.         Notes:           - if you want the main wiki database to be different than "xwiki"             you will also have to set the property xwiki.db in xwiki.cfg file-->    <property name="connection.url">jdbc:mysql://localhost/xwiki</property>    <property name="connection.username">xwiki</property>    <property name="connection.password">xwiki</property>    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>    <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>    <property name="dbcp.poolPreparedStatements">true</property>    <property name="dbcp.maxOpenPreparedStatements">20</property>    <mapping resource="xwiki.hbm.xml"/>    <mapping resource="feeds.hbm.xml"/>    <mapping resource="activitystream.hbm.xml"/>    <mapping resource="instance.hbm.xml"/>    <mapping resource="mailsender.hbm.xml"/>

4、上传mysql-connector-java-5.1.35-bin.jar 到xwiki-enterprise-jetty-hsqldb-7.1.4\webapps\xwiki\WEB-INF\lib

5、xwiki.cfg 参考xwiki中文网安装教程
修改supueradmin  编辑xwiki.cfg文件并启用xwiki.superadminpassword属性
6、启动start_xwiki.bat

7、登录超级管理员

用户superadmin密码system

8、进入管理员后台

9、修改mysql 

在[mysqld]下面加上
max_allowed_packet=64M

重启mysql服务

或者在命令行输入  set global max_allowed_packet = 64*1024*1024*10

通过show VARIABLES like '%max_allowed_packet%'; 查看是否修改成功

导入UI包前 这个最好要先改 不然有时候会出现XWiki.XWikiPreferences导入失败等一些问题


10、修改xwiki-enterprise-jetty-hsqldb-7.1.4 下的start_xwiki.bat

if not defined XWIKI_OPTS set XWIKI_OPTS=-Xmx1024m -XX:MaxPermSize=196m

加大内存，参考xwiki中文网性能文章

11、下载xwiki-enterprise-ui-mainwiki-all-7.1.4.xar 并导入

修改日志级别
xwiki-enterprise-jetty-hsqldb-7.1.4\jetty\resources\jetty-logging.properties

log.LEVEL=DEBUG
org.xwiki.tools.jetty.listener.NotifyListener.LEVEL=DEBUG

可以设置DEBUG 、WARN、 INFO等