JSPWiki数据迁移以及同CAS整合

 

1 JSPWiki数据迁移

1.1 内容数据迁移

1.      配置内容数据源

在Tomcat的.xml中添加如下内容

<Resource name="PostgreSQLDataSource"

              auth="Container"

              type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"

              url="jdbc:postgresql://192.168.0.180:5432/jspwiki_trial"

              username="pgsql"

              password="javac"

              maxActive="5"

              maxIdle="3"

              maxWait="-1"/>

 

2.      复制JDBC插件到lib

从下载的包中复制JDBCProvider.jar到WEB-INF下的lib目录中

 

3.      在/WEB-INF下创建文件jdbcprovider.properties

 

connectionProvider = com.forthgo.jspwiki.jdbcprovider.JNDIConnectionProvider

jndi.datasource = PostgreSQLDataSource

 

database.flavour = pgsql          ## POSTGRESQL; other, mysql,oracle etc.

 

## Copy the jdbcprovider.<flavour>.properties file to .../WEB-INF

 

driver.useUnicode = true

driver.characterEncoding = utf8

driver.connectionCollation = utf8_bin

 

database.create = false

 

continuationEditMinutes = 15

 

4.      复制文件

从下载的包中复制文件jdbcprovider.pgsql.properties到/WEB-INF目录下

 

5.      修改jspwiki.properties

注释如下内容

jspwiki.pageProvider = FileSystemProvider

jspwiki.fileSystemProvider.pageDir = /p/web/www-data/jspwiki/

jspwiki.attachmentProvider = BasicAttachmentProvider

jspwiki.basicAttachmentProvider.storageDir = /p/web/www-data/jspwiki/

 

在文件中添加如下内容

jspwiki.pageProvider = com.forthgo.jspwiki.jdbcprovider.JDBCPageProvider

jspwiki.attachmentProvider = com.forthgo.jspwiki.jdbcprovider.JDBCAttachmentProvider

jspwiki.jdbcprovider.configuration=jdbcprovider.properties

 

6.      新建数据库

在新建180上新建数据库jspwiki_trial，字符集编码UTF-8

脚本如下：

CREATE TABLE "WIKI_PAGE"

    (

         "NAME" character varying(100) NOT NULL,

         "VERSION" integer NOT NULL,

         "CHANGE_TIME" timestamp without time zone,

         "CHANGE_BY" character varying(50),

         "CHANGE_NOTE" character varying(100),

         "CONTENT" text

    );