How the QC modifies IP

Because of the intranet server reorganization, the original test machine IP address modified to 192.168.0.5, so I had bitter. Some of the QC records are written dead at the time of the IP address, alas, this place does not as Jira, the same is installed on the same machine, Jira as long as the basic information to modify the server, modify the IP access address as usual. QC is different. How to say, after all, QC the system is too large to HP such a large company can not make it more humane. Or, HP's QC hasn't been thoroughly researched.
Okay, let's talk about the actual situation, the server installed the QC site program, but also the use of the server database services, the system is a Windows 2003 English Enterprise Edition, the database is SQL server2005 (08 out, 05 also out of SP3, fast Ah, Following Microsoft to do something is really to update the knowledge quickly, and here is the record for this change,
The first is to modify JBoss service profile, how to know this file, is to refer to the modification of the network method, have to admire the QA team Taobao team You really are very passionate, see the article can see a lot of mood out.
The file in C:/Program files/mercury/quality Center/jboss/server/default/deploy I was installed in the C-drive, the specific people can be modified according to their actual situation. There are a lot of files under this folder, we need to modify the 10sabin.war, war file, rarely see it. Oh in Baidu and Google look for the next, this file format similar to the jar file, you can directly open with WinRAR, of course, you need to manually select the program, the first copy of this file out, and then decompression, find the unpacked folder in the Web-inf folder,

Modify the Siteadmin.xml file, open with Notepad,

Locate the database connection string:

Modify it, save it, and then package all the files in the Unpacked folder, but how to revert to the war file. hahaha, with a "folk prescription", the first package all the files into a zip format, and then modify the zip as a war. ^^, if you do not see the filename suffix .... Don't let me tell you.
The next step is to modify the database,
First, link the database and locate the QC's primary database:

Name is: dbo. Appservers and dbo. Dbservers.

Table dbo. The fields we mainly modify in Appservers are td_servername fields. Table dbo. Dbservers need to modify the Db_connstr_format field, servername can write IP address, or write the name of the computer currently installed QC site program, Db_connstr_format need to modify the IP address for the database server IP address.

It's almost finished, but if you've created a project before and you already have a user assigned to it, then one more step is to modify the database connection string for the project, which is why I haven't been able to do it for half a day, but also because I don't have a clear and strong problem solving myself. , a clear idea. Modify the project table: dbo. Projects the table, modify the Db_connstr_format field and Db_server_name field, and modify the IP address.

OK, that's it for now. Then to do is to restart the QC service, forget it or cut a picture to explain it. @@