Archive for the '技术-软件工程' Category


Subversion库迁移及备份方案

在做迁移操作前,请停止对svn进行提交操作。

1. 迁移方案(采用dump -load方案):

源SVN服务器:192.168.1.200,Windows服务器

目标SVN服务器:192.168.1.201,Windows服务器。采用CollabNet Subversion Server,假定subversion安装在D:\Program Files\CollabNet Subversion Server上,SVN的Repository为d:\Subversion\svnbackup

也即Windows服务中,可执行文件的路径为:

“d:\Program Files\CollabNet Subversion Server\svnserve.exe” –service -r “d:\Subversion\svnbackup” –listen-port “3690″

由于目前在subversion服务器上实际上只有svn://192.168.1.200/rd目录下才有内容,因此只需要迁移svn://192.168.1.201/rd下的内容,步骤如下:

1、 在源服务器192.168.1.200上执行dump操作

注意此处实际上把repository中所有的目录都备份了,需要在load时候采用svndumpfilter命令过滤需要的目录。

svnadmin dump D:\Subversion\svnworkspace\bak >svn_all_20080520.dump

2、 在192.168.1.201上创建svnbackup Repository

svnadmin create d:\Subversion\svnbackup

3、 下载一个windows 版本gnu 工具(例如http://sourceforge.net/projects/gnuwin32/),主要是使用cat方法

4、 将dump文件拷贝到上并执行load操作

        cat svn_all_20080520.dump | svndumpfilter --include:rd >svn_rd_20080520.dump

5、 执行svnadmin load

        svnadmin load d:\Subversion\svnbackup < svn_rd_20080520.dump

6、 在192.168.1.201上配置svnserve.conf、passwd、authz文件

2. 迁移方案(采用svnsync方案)

从subversion 1.4.4开始,提供了svnsync命令,可用于Subversion的库迁移和备份,这里我们用于备份操作的初始化同步。

假定从源服务器192.168.1.201备份到192.168.1.88

SVN服务器:192.168.1.201,Windows服务器,采用CollabNet Subversion Server,假定subversion安装在D:\Program Files\CollabNet Subversion Server上,SVN的Repository为d:\Subversion\svnbackup。

备份服务器: 192.168.1.88,Redhat As 4服务器

采用svnsync进行数据迁移,方法如下:

1、 在备份服务器192.168.1.88上创建源服务器192.168.1.201上对应的备份库目录

mkdir /opt/subversion

svnadmin create  /opt/subversion/svnbackup

2、在备份服务器192.168.1.88上启用钩子文件

cd  /opt/subversion/svnbackup/hooks

echo “#!/bin/sh”> pre-revprop-change

chmod 755 pre-revprop-change

3、在备份服务器192.168.1.88上运行svnsync init命令

svnsync init file:////opt/subversion/svnbackup  svn://192.168.1.201 –username username –password password

注意,svnsync的语法为:svnsync init DEST SOURCE

4、在备份服务器192.168.1.88上执行同步操作

svnsync sync file:////opt/subversion/svnbackup

由于svnsyc只能同步整个svn库,并不能同步指定的项目,因此建议迁移时候使用dump-load方案,备份时候采用svnsync方案

3. 备份方案:

为保证svn服务器的安全,由脚本每天定时对svn库进行备份,以保证svn库的安全性。备份仍然采用svnsync来完成。

1. 在192.168.1.88  上安装subversion 服务器端

2. 在192.168.1.88上创建备份用户帐号svnsync,以供192.168.1.201能够以此帐号实时把变更的同步到192.168.1.88上

配置文件svnserve.conf

[general]

anon-access = none

auth-access = write

password-db = passwd

authz-db = authz

配置文件passwd

svnsync=svnsync

配置文件authz

[groups]

developer = svnsync

[/]

@developer=rw

* =

3. 在备份机上开启iptables的3690端口

4. 在备份机192.168.1.88上创建备份库目录

svnadmin create /opt/subversion/svnbackup

chown –R svnsync:svnsync  /opt/subversion/svnbackup

5. 按照上述采用svnsync方案的步骤,将库同步到192.168.1.88上,初始化svn库

cd  /opt/subversion/svnbackup/hooks

echo “#!/bin/sh”> pre-revprop-change

chmod 755 pre-revprop-change

svnsync init file:////opt/subversion/svnbackup  svn://192.168.1.201 –username username –password password

svnsync sync file:////opt/subversion/svnbackup

6. 在源服务器192.168.1.201上,创建钩子文件,保证192.168.1.201上的变动实时同步到192.168.1.88上:

post-commit
# Propagate the data to the remote repository
D:\Program Files\CollabNet Subversion Server\svnsync synchronize --username svnsync --password svnsync  svn:// 192.168.1.88
post-rev-changes
# Propagating changes to the remote repository.
D:\Program Files\CollabNet Subversion Server\bin\svnsync copy-revprops --username svnsync --password svnsync  svn:// 192.168.1.88 $REV  
4. 参考文档:

http://blog.notreally.org/articles/2006/11/30/setting-up-a-subversion-mirror-repository-using-svnsync/

http://whynotwiki.com/How_I_moved_my_code_repository_to_Google_Code

Technorati 标签: ,,,

Subversion Redhat Linux版本简易安装指南

  记录一下采用简易的安装步骤,没有与apache集成,只是把subversion作为一个单独的服务安装和使用。

操作系统版本:Redhat AS 4

1、 下载安装rpm包

http://the.earth.li/pub/subversion/summersoft.fay.ar.us/pub/subversion/latest/rhel-4/i386/

下载并安装如下包:

apr-0.9.12-2.i386.rpm              

apr-util-0.9.12-1.i386.rpm         

subversion-1.4.6-1.i386.rpm        

subversion-debuginfo-1.4.6-1.i386.rpm

subversion-devel-1.4.6-1.i386.rpm  

subversion-perl-1.4.6-1.i386.rpm   

subversion-tools-1.4.6-1.i386.rpm  

swig-1.3.25-1.i386.rpm             

由于AS4的Subversion的版本较老,使用最新版本的SVN,因此需要卸载与新版本冲突的包,安装最新的包:

卸载包:rpm –e 包名

安装包:rpm –ivh *rpm

2、 创建svn目录

mkdir /opt/svn

3、 修改svnserve.conf

anon-access = none

auth-access = write

password-db = passwd

4、 修改authz

[groups]

developer = liang1,liang2,liang3

[repository:/opt/svn/eSales]

@developer =rw

5、 在passwd中创建对应用户的密码

[users]

liang1= liang1

liang2=liang2

liang3=liang3

6、 在/opt/svn下创建eSales的代码库

svnadmin create /opt/svn/eSales

7、 导入eSales的代码

svn import eSales svn://localhost/eSales -m “Initial Import” –username liang1 –password liang1

8、 启动svn

svnserve -d -r /opt/svn

9、 把启动命令放到启动脚本中

echo “svnserve -d -r /opt/svn”>>/etc/rc.local

 

Technorati 标签: ,,

在jira中集成tinymce 支持wysiwyg功能

    由于我使用的3.9版本的jira本身的编辑器缺省为textarea,在录入缺陷及添加备注时候很不是方便,捣腾了一上午终于把TinyMCE 集成到jira中作为wysiywg编辑器,记录一下过程,其实基本上是按照文章WYSIWYG Editor in Jira 描写的步骤做的,只是按照自己所用的3.9版本的安装包调整了安装步骤及细节。

1、系统环境:

jira版本:atlassian-jira-enterprise-3.9-standalone

jira安装路径:/opt/jira (实际上是tomcat路径,jira的webapp应用在/opt/jira/atlassian-jira下)

2、安装步骤

  • http://tinymce.moxiecode.com/下载TinyMCE
  • 把TinyMCE解压到/opt/jira/atlassian-jira/includes/js
  • 在/opt/jira/atlassian-jira/includes/decorators/header.jsp中添加TinyMCE的js代码,采用的是TinyMCE的Full Feature的代码,可以参看tinymce的文档,按照自己要求调整一下TinyMCE的属性。
 <script language=“JavaScript” type=“text/javascript” src=“<%=request.getContextPath()%>/includes/js/tinymce/jscripts/tiny_mce/tiny_mce.js”></script>
<script language=“javascript” type=“text/javascript”>
tinyMCE.init({
        mode : “textareas”,
        theme : “advanced”,
        plugins : “table,save,advhr,advimage,advlink,emotions,iespell,insertdatetime,preview,zoom,flash,searchreplace,print,contextmenu”,
        theme_advanced_buttons1_add_before : “save,separator”,
        theme_advanced_buttons1_add : “fontselect,fontsizeselect”,
        theme_advanced_buttons2_add : “separator,insertdate,inserttime,preview,zoom,separator,forecolor,backcolor”,
        theme_advanced_buttons2_add_before: “cut,copy,paste,separator,search,replace,separator”,
        theme_advanced_buttons3_add_before : “tablecontrols,separator”,
        theme_advanced_buttons3_add : “emotions,iespell,flash,advhr,separator,print”,
        theme_advanced_toolbar_location : “top”,
        theme_advanced_toolbar_align : “left”,
        theme_advanced_statusbar_location : “bottom”,
        plugin_insertdate_dateFormat : “%Y-%m-%d”,
        plugin_insertdate_timeFormat : “%H:%M:%S”,
        height:“350px”,
        width:“550px”,
        extended_valid_elements : “a[name|href|target|title|onclick],img[class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]”,
});
</script>
  • 修改国际化资源文件/opt/jira/atlassian-jira/WEB-INF/lib/language_default.jar 中的com/atlassian/jira/web/action/JiraWebActionSupport和/opt/jira/atlassian-jira/WEB-INF/lib/language_zh_CN.jar中的com/atlassian/jira/web/action/JiraWebActionSupport_zh_CN.properties,添加如下的内容。
admin.renderer.plugin.wysiwyg.renderer.name=Wysiwyg Style Renderer
admin.renderer.plugin.wysiwyg.renderer.desc=A renderer that will renderer content as entered into a wysiwyg editor.
  • 修改/opt/jira/atlassian-jira/WEB-INF/classes/system-renderers-plugin.xml,添加如下内容
<jira-renderer system=“true” key=“jira-wysiwyg-renderer” name=“Wysiwyg Style Renderer”
i18n-name-key=“admin.renderer.plugin.wysiwyg.renderer.name”
class=“com.atlassian.jira.issue.fields.renderer.wysiwyg.WysiwygRenderer”>
<description key=“admin.renderer.plugin.wysiwyg.renderer.desc”>A renderer that will renderer content from a wysiwyg editor.</description>
<resource type=“velocity” name=“edit” location=“templates/plugins/renderers/wysiwyg/wysiwyg-renderer-edit.vm”/>
</jira-renderer>

  • 创建/opt/jira/atlassian-jira/WEB-INF/classes/com/atlassian/jira/issue/fields/renderer/wysiwyg/WysiwygRenderer.java ,内容如下
package com.atlassian.jira.issue.fields.renderer.wysiwyg;

import com.atlassian.jira.issue.fields.renderer.JiraRendererPlugin;
import com.atlassian.jira.issue.fields.renderer.IssueRenderContext;
import com.atlassian.jira.plugin.renderer.JiraRendererModuleDescriptor;
import com.atlassian.jira.util.JiraKeyUtils;

/*\*
* A simple text renderer for jira..
\*/
public class WysiwygRenderer implements JiraRendererPlugin
{
public static final String RENDERER_TYPE = “jira-wysiwyg-renderer”;

private JiraRendererModuleDescriptor jiraRendererModuleDescriptor;

public String render(String value, IssueRenderContext context)
{ return JiraKeyUtils.linkBugKeys(value); }
public String renderAsText(String value, IssueRenderContext context)
{ return value; }
public String getRendererType()
{ return RENDERER_TYPE; }
public Object transformForEdit(Object rawValue)
{ return rawValue; }
public Object transformFromEdit(Object editValue)
{ return editValue; }
public void init(JiraRendererModuleDescriptor jiraRendererModuleDescriptor)
{ this.jiraRendererModuleDescriptor = jiraRendererModuleDescriptor; }
public JiraRendererModuleDescriptor getDescriptor()
{ return jiraRendererModuleDescriptor; }
}
  • 编译WysiwygRenderer.java

export classpath=/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-bandana-0.1.13.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-cache-servlet-0.5.4.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-configurableobjects-0.4.22.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-core-2007-04-23.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-extras-0.7.29.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-jdk-utilities-0.1.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-jira-rpc-plugin-3.9-1.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-jira-subversion-plugin-0.9.10.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-johnson-2006-11-03.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-mail-2007_03_23.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-ofbiz-0.3.8.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-plugins-2006-11-10.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-profiling-1.1.4.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-renderer-2007.01.17.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-scheduler-2007-04-05.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-tagutil-0.1.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-trackback-2007-01-25.jar:/opt/jira/atlassian-jira/WEB-INF/lib/atlassian-velocity-0.3.19.jar:.:$JAVA_HOME/lib/tools.jar:/opt/jira/atlassian-jira/WEB-INF/classes ;

cd /opt/jira/atlassian-jira/WEB-INF/classes;

javac com/atlassian/jira/issue/fields/renderer/wysiwyg/WysiwygRenderer.java

  • 创建/opt/jira/atlassian-jira/templates/plugins/renderers/wysiwyg/wysiwyg-renderer-js.vm ,内容如下
tinyMCE.init(
{ mode : “textareas” }

);
  • 创建/opt/jira/atlassian-jira/templates/plugins/renderers/wysiwyg/wysiwyg-renderer-edit.vm,内容如下
<DIV style=“width:90%”>
#if($singleLine)
<input style=“width:100%”
type=“text”
name=“$fieldId”
value=“$textutils.htmlEncode($!value)”
id=“$fieldId”
class=“textfield”
#if($maxlength)maxlength=“$maxlength”#end
/>
#else
<textarea style=“width:100%”
name=“$fieldId”
id=“$fieldId”
#if($rows)rows=“$rows”#end
#if($wrap)wrap=“$wrap”#end
#if($cols)cols=“$cols”#end
#if($accesskey)accesskey=“$accesskey”#end
class=“textarea”
>$textutils.htmlEncode($!value)</textarea>
#end
</DIV>
<script language=“javascript” type=“text/javascript”>
tinyMCE.execCommand(‘mceAddControl’, true, “$fieldId”);
</script>
  • 重启tomcat
  • 以管理员登录jira管理界面,查看Renderer是否生效

  菜单项System->Plugins->Renderer Plugin->Wysiwyg Style Renderer

  • 配置Renderer:

菜单项Issue Fields->Field Configurations->View Field Configurations->Default Field Configuration,点击在Comment和Description的Renderer属性后,进入”Edit Field Renderer”属性页,选择Wysiwyg Style Renderer皆可。

jira

wysiwyg

3、参考文章

http://confluence.atlassian.com/display/JIRACOM/WYSIWYG+Editor+in+Jira 

http://tinymce.moxiecode.com/documentation.php

apache与jira集成

  由于jira与deki知识库(mindtouch deki wiki 安装配置指南)安装在同一台机器上,80端口已被架设deki的apache占用,原本懒得将apache和tomcat集成,打算直接用8080端口访问jira算了,安装完成后发现路由器上没有做8080端口影射的,不能直接从公网访问,放假了网管还没有上班,看来还是只有借助jk2将apache和tomcat集成,以便能够从外网直接通过80端口访问jira服务。记录一下架设过程。

1、环境说明

操作系统:Redhat AS4

php:5.2.5,用于deki

httpd:httpd-2.0.52-25.ent ,as4缺省安装版本

数据库:mysql 5.0.5

Jira:atlassian-jira-enterprise-3.9-standalone

Tomcat(jira自带) :5.5.20

JDK:1.6.0_01

2、安装apache和php

apache采用AS4的httpd 2.0.52的缺省安装包,安装路径为/etc/httpd

php5.2.5 安装过程参看mindtouch deki wiki 安装配置指南

3、安装jira

jira的安装路径为/opt/jira

  • 修改缺省的hsql数据库,采用mysql,同时将缺省Context修改为jira,以便以http://ip/jira方式访问

  修改/opt/jira/conf/server.xml,将如下内容

<Context path=”" docBase=”${catalina.home}/atlassian-jira” reloadable=”false”>
  <Resource name=”jdbc/JiraDS” auth=”Container” type=”javax.sql.DataSource”
    username=”sa”
    password=”"
    driverClassName=”org.hsqldb.jdbcDriver”
    url=”jdbc:hsqldb:${catalina.home}/database/jiradb”
    minEvictableIdleTimeMillis=”4000″
    timeBetweenEvictionRunsMillis=”5000″
    maxActive=”20″ />

修改为

<Context path=”/jira” docBase=”${catalina.home}/atlassian-jira” reloadable=”true” crossContext=”true”>
  <Resource name=”jdbc/JiraDS” auth=”Container” type=”javax.sql.DataSource”
    username=”root”
    password=”"
    driverClassName=”com.mysql.jdbc.Driver”
    url=”jdbc:mysql://localhost/jira?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8″
    minEvictableIdleTimeMillis=”4000″
    timeBetweenEvictionRunsMillis=”5000″
    maxActive=”20″ />

  • 取消jk2协议的注释

<!– To connect to an external web server (typically Apache) –>
<!– Define an AJP 1.3 Connector on port 8009 –>
    <Connector port=”8009″
      enableLookups=”false” redirectPort=”8443″ protocol=”AJP/1.3″ />

  • 上传mysql 的driver mysql-connector-java-5.0.5.jar到common/lib/下
  • 修改/opt/jira/atlassian-jira/WEB-INF/classes/entityengine.xml,修改ofbiz的实体引擎的Datasource数据库类型为mysql

    <datasource name=”defaultDS” field-type-name=”mysql”
      helper-class=”org.ofbiz.core.entity.GenericHelperDAO”
      check-on-start=”true”
      use-foreign-keys=”false”
      use-foreign-key-indices=”false”
      check-fks-on-start=”false”
      check-fk-indices-on-start=”false”
      add-missing-on-start=”true”
      check-indices-on-start=”true”>
        <jndi-jdbc jndi-server-name=”default” jndi-name=”java:comp/env/jdbc/JiraDS”/>
<!– Orion format: <jndi-jdbc jndi-server-name=”default” jndi-name=”jdbc/JiraDS”/> –>
<!– JBoss format: <jndi-jdbc jndi-server-name=”default” jndi-name=”java:/DefaultDS”/> –>
<!– Weblogic format: <jndi-jdbc jndi-server-name=”default” jndi-name=”JiraDS”/> –>
    </datasource>

NrqqMtMXgitAOknSLGRrfsaoRmOaAOBIXwBmivsMNxvIUTb
mj2KfRo<HPcFdS2zJdF61oBI2L09vXHct>jJtNVA3pOOw8L
NmRuuqrRqRRNOmQRpRXWQOpmQRqoMropnsvtUvUsXOvwvos
tUUnntvqmuopqvmvUUnntvqmuopqvmvUUvbbmXvkZlj

  • 安装jira 的subversion插件

要在jira中集成subversion,使用JIRA Subversion Plugin。很奇怪的是,在官方的version compatibility table上竟然没有针对3.9版本的subversion插件,好在下面的变更历史中有一段关于v3.9的说明

0.9.10 released

Contains a fix for SVN-133 (commit data does not follow Project Permission Scheme - honoring current assignee and reporter) and upped source dependencies for JIRA v3.9.

因此看来对应jira 3.9版本的subversion的插件需要使用0.9.10版本,下载地址为:
atlassian-jira-subversion-plugin-0.9.10.zip

安装过程很简单:

把javasvn-1.0.5.jar,ganymed.jar,atlassian-jira-subversion-plugin-0.9.10.jar复制到/opt/jira/atlassian-jira/WEB-INF/lib下。

修改subversion-jira-plugin.properties的svn.root、svn.username、svn.password,上传到/opt/jira/atlassian-jira/WEB-INF/classes下

4、编译安装 JK2 2.0.4

wget http://archive.apache.org/dist/tomcat/tomcat-connectors/jk2/jakarta-tomcat-connectors-jk2-src-current.tar.gz

tar zxvf jakarta-tomcat-connectors-jk2-src-current.tar.gz

cd jakarta-tomcat-connectors-jk2-2.0.4-src/jk/native2/

./configure –with-apxs2=/usr/bin/apxs

make

cd ../build/jk2/apache2

apxs -n jk2 -i mod_jk2.so

修改/etc/httpd/conf/httpd.conf,在httpd.conf中的LoadModule部分添加jk2_module

  LoadModule jk2_module modules/mod_jk2.so

同时修改DirectoryIndex

DirectoryIndex index.html index.html.var,index.php,index.jsp

5、创建JK2 的配置文件

需要手工创建JK2所用的2个配置文件:

  • /opt/jira/conf/jk2.properties

touch //opt/jira/conf/jk2.properties

内容如下:

# list of needed handlers.
handler.list=channelSocket,request
# Override the default port for the channelSocket
channelSocket.port=8009

 

  • /etc/httpd/conf/workers2.properties

touch /etc/httpd/conf/workers2.properties

内容如下:

[channel.socket:localhost:8009]
port=8009
host=localhost
[ajp13:localhost:8009]
channel=channel.socket:localhost:8009
[uri:/jira/*]
worker=ajp13:localhost:8009

# Define the log file location and file size
[shm]
file=/etc/httpd/logs/shm.file
size=1048576

6、重启jira及apache

apachectl restart

killall -9 java; sleep 5;/opt/jira/bin/startup.sh

访问jira:http://ip/jira

或者http://ip:8080/jira

 

Technorati 标签: ,,,,