Can we change siteadmin db name?

Question ID: 110144
0
0

What is the level of work if we change siteadmin db name? or what are the impact?

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on April 30, 2021 3:00 pm
7 views
Answers (1)
0
Private answer

My recommendation would be to leave the Site Administrator as it is and during your next upgrade you will have the option to rename it at that time. Below is the process for renaming the Site Administrator database assuming that the Site Administrator database is staying on the same server. The amount of time that it will take will depend on how many projects have to removed and imported.

To rename the site admin database

Create a new database server

1. Open the Site Administrator
2. Click on the DB Servers tab
3. Click on New in the upper left corner of the tab
4. In the window that opens enter the new name for the qcsiteadmin_db in the Database Name field
5. Enter the Database Admin Username
6. Enter the Database Admin Password
7. Enter the Host Name for the Database server where the renamed site admin database is located
8. Click on the Ping button to test the connection to the database server.
9. Click OK if the Ping is successful
10. You should now see a new server in the list on the left-hand side of the tab

At this point, you can shut down the ALM service and rename the site admin database from within your database management software.

Next, you will need to edit three files all named siteadmin.xml. The files are located at the following default locations
• C:Program FilesMicro FocusALMapplication20qcbin.warWEB-INF
• C:ProgramDataMicro FocusALMapplication20qcbin.warWEB-INF
• C:ProgramDataMicro FocusALMwebappsqcbinWEB-INF

You will need to change/verify the following entries
• DbUrl
• DbName *** This must match what you renamed the qcsiteadmin_db to ***
• DefaultUserPassword

At this point, you can restart the ALM service and once the service is back up and running you will need to remove each project, edit the DBID.xml file for each project (including the lab management project) and point it to the new database server name, then restore the projects.

To remove the projects
1. Open the Site Administrator
2. Click on the Site Projects tab
3. Click on a project
4. Make a note of the project’s Project Directory
5. Right-click on the project and Select “Remove Project” *** DO NOT DELETE THE PROJECT YOU WILL DELETE THE PROJECT AND REPOSITORY AND HAVE TO RESTORE FROM BACKUP ***

Once the project has been removed you will need to go to the Project Directory and edit the DBID.xml for the project to point to the new Site Admin database
1. Open File Explorer
2. Navigate to the Project Directory
3. Open the DBID.xml
4. Edit the DBSERVER_NAME to match the new site administrator database name
5. Repeat this process for all project databases and the Lab Project database
6. Once this is done you should see the database server name that you entered listed in the Database Server on the Project Details tab.

At this point, you should be able to go to the DB Servers tab and remove the old database server from the list on the left-hand side of the tab.

Marked as spam
Posted by (Questions: 0, Answers: 307)
Answered on April 30, 2021 3:01 pm