Shulou(Shulou.com)06/01 Report--

Redmine migration

(redmine uses bitnami redmine one-click installation and the environment is apache+mysql+php)

Click to install bitnami redmine in the new environment, and when you are finished, do the following

1. Back up the original environment database and restore it to the new environment

A, backup database, mysql database backup by instruction

The cmd command window boots to the mysql/bin directory

Cd F:\ Program Files\ BitNami Redmine Stack\ mysql\ bin

Execute export instruction

Mysqldump-ubitnami-p8a83cf48ac bitnami_redmine > f:\ 2013-09-23 Monday. Sql

Explanation:

Mysqldump export instruction

-ubitnami-u + database user name

-p8a83cf48ac-p + database password

(database username and password check the database.yml file under BitNami Redmine Stack\ apps\ redmine\ htdocs\ config, and find username and password)

Bitnami_redmine mysql database name (usually under mysql\ data, check the my.ini file configuration)

F:\ 2013-09-23 Monday. Sql backup destination file path

2. Restore in the new environment

Before restoring, clear the redmine database that was newly created when the new environment was installed.

(the cmd command window boots to the mysql/bin directory

Cd F:\ Program Files\ BitNami Redmine Stack\ mysql\ bin)

Mysql drop database bitnami_redmine

B. Restore the database

Mysql-ubitnami-p8a83cf48ac bitnami_redmine

< f:\2013-09-23星期一.sql 数据库名和密码查看新环境下的BitNami Redmine Stack\apps\redmine\htdocs\config下database.yml文件，找到username、password 3、备份原环境附件 将BitNami Redmine Stack\apps\redmine\htdocs下files文件复盖到新环境路径 重启服务 另：配置邮箱发信功能 # default configuration options for all environments default: # Outgoing emails configuration (see examples above) email_delivery: delivery_method: :smtp smtp_settings: #tls: true address: smtp.163.com port: 25 domain: 163.com authentication: :login user_name: "cjpgredmine@163.com" password: "cjpgjykj" enable_starttls_auto: true 将上述代码复制到BitNami Redmine Stack\apps\redmine\htdocs\config下configuration.yml文件 在configuration.yml文件# http://wiki.rubyonrails.org/rails/pages/HowToSendEmailsWithActionMailer后粘贴 上面的代码配置的是163的邮箱，可以自己配置其他的(其实也可以在redmine安装时配置邮箱) 配置完后使用管理员账户登录redmine,选择管理--配置--邮件通知,点击发送测试邮件，应该提示发送成功，如果不成功，请查看代码是否正确 testlink迁移 前置配置：安装mysql-5.5.13-win32版数据库(速度快点)，设置root密码为123465(mysql5.5数据库端口号不要与redmine的mysql冲突) 1、安装testlink(版本1.9(Beta 5)) 将testlink解压文件放在apache\htdocs文件夹下(安装redmine时会自带apache,放在该文件下即可) 网页打开testlink/install/index.php,进入配置页面配置testlink (需要注意数据库端口号与mysql5.5保持一致)

2. Back up the original environment database and restore it to the new environment (same as redmine)

Backup

Mysqldump-uroot-p123456 testlink > F:\ testlink\ 2013-09-24 Monday. Sql

(refer to redmin backup)

Restore

Mysql-uroot-p123456 testlink

< f:\testlink备份\2013-09-23星期一.sql (参考redmin恢复) 3、登录Testlink后，可能会出现如下提示： There are security warnings for your consideration. See details on file: C:/xampp/htdocs/testlink/logs/config_check.txt. To disable any reference to these checkings, set $tlCfg->

Config_check_warning_mode = 'SILENT'

Solution:

Open the config.inc.php file under the Testlink installation folder and change $tlCfg- > config_check_warning_mode = 'FILE'

Change to tlCfg- > config_check_warning_mode = 'SILENT'; save! Refresh the page again, there is no prompt!

4. Integrate redmine

A. Change custom_config.inc.php.example to custom_config.inc.php under testlink, and add at the end

$g_interface_bugs = 'REDMINE'

B. Modify the redmine.cfg.php file under testlink\ cfg

Define ('BUG_TRACK_DB_HOST',' localhost')

Define ('BUG_TRACK_DB_NAME',' bitnami_redmine')

Define ('BUG_TRACK_DB_TYPE',' mysql')

Define ('BUG_TRACK_DB_USER',' bitnami')

Define ('BUG_TRACK_DB_PASS',' 8a83cf48ac')

Define ('BUG_TRACK_DB_CHARSET', "UTF-8")

Define ('BUG_TRACK_HREF', "http://192.168.100.21:81/redmine/issues/");

Define ('BUG_TRACK_ENTER_BUG_HREF', "http://192.168.100.21:81/redmine/projects/%s/issues/new");

Analysis

BUG_TRACK_DB_HOST: database address. The local database is connected here. If it is remote, enter the IP address.

BUG_TRACK_DB_NAME: database name

BUG_TRACK_DB_TYPE: database type. Here redmine uses mysql.

BUG_TRACK_DB_USER: database user name

BUG_TRACK_DB_PASS: database password (username and password view the database.yml file under the new environment redmine\ htdocs\ config)

BUG_TRACK_DB_CHARSET: encoding format (if garbled, change to another format)

Issues address of BUG_TRACK_HREF:redmine

Create a new BUG address for the project corresponding to BUG_TRACK_ENTER_BUG_HREF:redmine

Restart apache. Over.

Also: define ('BUG_TRACK_ENTER_BUG_HREF', "http://192.168.100.21:81/redmine/projects/%s/issues/new"); this function is that testlink can automatically link to the corresponding redmine project, to achieve the goal, you need to configure the testlink.

Go to testlink\ lib\ bugtracking and open the int_redmine.php file

Add the following code at the end

Function getEnterBugURL ()

{if (strstr (BUG_TRACK_ENTER_BUG_HREF,'% s')) {

$tproject_prefix = isset ($_ SESSION ['testprojectPrefix'])? Trim ($_ SESSION ['testprojectPrefix']):''

$BugURL = sprintf (BUG_TRACK_ENTER_BUG_HREF, $tproject_prefix)

}

Return $BugURL;}

The purpose of the above code is to take the project ID of testlink and pay it to s.

Set the project identity of testlink, which is configured by logging in to testlink with admin.

Once configured, you can link to the redmine add question when you execute the use case

Integration completed

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.