Cisco Systems, Inc.
170 West Tasman Drive
San Jose, CA 95134-1706
USA
http://www.cisco.com
Tel: 408 526-4000
800 553-NETS (6387)
Fax: 408 527-0883
Text Part Number: OL-16908-01
THE SPECIFICATIONS AND INFORMATION REGARDING THE PRODUCTS IN THIS MANUAL ARE SUBJECT TO CHANGE WITHOUT NOTICE. ALL
STATEMENTS, INFORMATION, AND RECOMMENDATIONS IN THIS MANUAL ARE BELIEVED TO BE ACCURATE BUT ARE PRESENTED WITHOUT
WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. USERS MUST TAKE FULL RESPONSIBILITY FOR THEIR APPLICATION OF ANY PRODUCTS.
THE SOFTWARE LICENSE AND LIMITED WARRANTY FOR THE ACCOMPANYING PRODUCT ARE SET FORTH IN THE INFORMATION PACKET THAT
SHIPPED WITH THE PRODUCT AND ARE INCORPORATED HEREIN BY THIS REFERENCE. IF YOU ARE UNABLE TO LOCATE THE SOFTWARE LICENSE
OR LIMITED WARRANTY, CONTACT YOUR CISCO REPRESENTATIVE FOR A COPY.
The following information is for FCC compliance of Class A devices: This equipment has been tested and found to comply with the limits for a Class A digital device, pursuant
to part 15 of the FCC rules. These limits are designed to provide reasonable protection against harmful interference when the equipment is operated in a commercial
environment. This equipment generates, uses, and can radiate radio-frequency energy and, if not installed and used in accordance with the instruction manual, may cause
harmful interference to radio communications. Operation of this equipment in a residential area is likely to cause harmful interference, in which case users will be required
to correct the interference at their own expense.
The following information is for FCC compliance of Class B devices: This equipment has been tested and found to comply with the limits for a Class B digital device, pursuant
to part 15 of the FCC rules. These limits are designed to provide reasonable protection against harmful interference in a residential installation. This equipment generates,
uses and can radiate radio frequency energy and, if not installed and used in accordance with the instructions, may cause harmful interference to radio communications.
However, there is no guarantee that interference will not occur in a particular installation. If the equipment causes interference to radio or television reception, which can be
determined by turning the equipment off and on, users are encouraged to try to correct the interference by using one or more of the following measures:
• Reorient or relocate the receiving antenna.
• Increase the separation between the equipment and receiver.
• Connect the equipment into an outlet on a circuit different from that to which the receiver is connected.
• Consult the dealer or an experienced radio/TV technician for help.
Modifications to this product not authorized by Cisco could void the FCC approval and negate your authority to operate the product.
NOTWITHSTANDING ANY OTHER WARRANTY HEREIN, ALL DOCUMENT FILES AND SOFTWARE OF THESE SUPPLIERS ARE PROVIDED “AS IS” WITH
ALL FAULTS. CISCO AND THE ABOVE-NAMED SUPPLIERS DISCLAIM ALL WARRANTIES, EXPRESSED OR
LIMITATION, THOSE OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OR ARISING FROM A COURSE OF
DEALING, USAGE, OR TRADE PRACTICE.
IN NO EVENT SHALL CISCO OR ITS SUPPLIERS BE LIABLE FOR ANY INDIRECT, SPECIAL, CONSEQUENTIAL, OR INCIDENTAL DAMAGES, INCLUDING,
WITHOUT LIMITATION, LOST PROFITS OR LOSS OR DAMAGE TO DATA ARISING OUT OF THE USE OR INABILITY TO USE THIS MANUAL, EVEN IF CISCO
OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
CCDE, CCENT, Cisco Eos, Cisco HealthPresence, the Cisco logo, Cisco Lumin, Cisco Nexus, Cisco StadiumVision, Cisco TelePresence, Cisco WebEx, DCE, and Welcome
to the Human Network are trademarks; Changing the Way We Work, Live, Play, and Learn and Cisco
Bringing the Meeting To You, Catalyst, CCDA, CCDP, CCIE, CCIP, CCNA, CCNP, CCSP, CCVP, Cisco, the Cisco
Cisco
Press, Cisco Systems, Cisco Systems Capital, the Cisco Systems logo, Cisco Unity, Collaboration Without Limitation, EtherFast, EtherSwitch, Event Center, Fast Step,
Follow Me Browsing, FormShare, GigaDrive, HomeLink, Internet Quotient, IOS, iPhone, iQuick Study, IronPort, the IronPort
MeetingPlace, MeetingPlace Chime Sound, MGX, Networkers, Networking Academy, Network Registrar, PCNow, PIX, PowerPanels, ProConnect, ScriptShare, SenderBase,
SMARTnet, Spectrum Expert, StackWise, The Fastest Way to Increase Your Internet Quotient, TransPath, WebEx, and the WebEx
Cisco
Systems, Inc. and/or its affiliates in the United States and certain other countries.
All other trademarks mentioned in this document or website are the property of their respective owners. The use of the word partner does not imply a partnership relationship
between Cisco and any other company. (0812R)
Any Internet Protocol (IP) addresses used in this document are not intended to be actual addresses. Any examples, command display output, and figures included in the
document are shown for illustrative purposes only. Any use of actual IP addresses in illustrative content is unintentional and coincidental.
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
Minimum System Requirements1-1
Installing the Server Operating System1-2
LDAP Server Types1-3
Supported Devices1-3
SNMP Service1-3
Port Requirements1-3
How to Install Cisco Unified Videoconferencing Manager1-4
Confirming Installation1-8
Running the Cisco Unified Videoconferencing Manager Service1-9
Logging in for the First Time1-9
Obtaining a License1-10
Changing Server Name and Web Port1-10
2Backing up and Restoring Cisco Unified Videoconferencing Manager Data2-1
Overview2-1
How to Back up Cisco Unified Videoconferencing Manager Data2-2
Backing Up the Internal Database2-2
Backing Up an MSSQL 2005/2000/MSDE Database2-2
Back-up File Locations for Configuration Files2-3
Backing Up Branding and Sound Files2-4
Backing Up the License2-4
How to Restore Cisco Unified Videoconferencing Manager Data2-4
Restoring Configurations2-5
Restoring the Internal Database2-5
Restoring an MSSQL 2005/2000/MSDE Database2-6
Restoring Configuration Files2-7
Restoring Branding and Sound Files2-8
Restoring the License2-8
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
iii
Contents
iv
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
Read this section before installing Cisco Unified Videoconferencing Manager.
• Minimum System Requirements, page 1-1
• Installing the Server Operating System, page 1-2
• LDAP Server Types, page 1-3
CHAP T ER
1
• Supported Devices, page 1-3
• SNMP Service, page 1-3
• Port Requirements, page 1-3
Minimum System Requirements
Cisco Unified Videoconferencing Manager must be installed on one of the following Cisco MCS server
models:
• Cisco MCS 7825 Series
–
MCS-7825-H2
–
MCS-7825-I2
–
MCS-7825-H3
–
MCS-7825-I3
• Cisco MCS 7835 Series
–
MCS-7835-H2
–
MCS-7835-I2
OL-16908-01
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
1-1
Pre-installation
• Cisco MCS 7845 Series
–
MCS-7845-H2
–
MCS-7845-I2
Installing the Server Operating System
Cisco Unified Videoconferencing Manager Release 5.6 requires the servers to run the Cisco Media
Convergence Server operating system, which is a Cisco Systems version of the Windows 2003 version
1.3b. This version of the operating system is shipped automatically to customers purchasing this product
for the first time. Customers who are upgrading from previous releases of this product that are installed
on a Windows 2000 operating system will need to upgrade the server operating system before installing
the Cisco Unified Videoconferencing Manager Release 5.6.
You can download the Media Convergence Server operating system software from the Cisco.com
Software Download tool at this location:
Step 1On Cisco.com, select Support > Download Software.
Step 2Select the Voice Software product category.
Step 3Log in with your Cisco.com account to obtain the full list of categories on this page.
Step 4Click the To Access Voice Software Downloads link.
Step 5Expand these folders: IP Telephony > Call Control > Cisco Unified Communications Manager
(CallManager).
Step 6Click Cisco Unified Communications Manager Version 4.3.
Step 7Click Voice Applications OS and BIOS Updates.
The required operating system 2003.1(3b) is listed in the All Releases folder under CCM-OS v.2K
folder. The latest Service Release (SR) at the time of this document’s creation was SR5. Updated Service
Releases are routinely posted, and you should use the latest service release.
Step 8Click 2003.1(3b)_SR5 (or latest available SR number).
Step 9Click the download link to download the software.
Technical documentation, release notes, and other file information are available to the right.
1-2
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
How to Install Cisco Unified Videoconferencing Manager
Table 1-1Required Ports (continued)
ProtocolPortsTypeDirectionPurposeDestination
SNMP161UDPIn from Resource
Manager and Network
Configuration/StatusCisco Unified
Videoconferencing Manager
Manager
FTP21TCPIn from Network
Manager
XML3271TCPLocal connectionResource Manager connects to the
Log retrievalCisco Unified
Videoconferencing Manager
Cisco Unified
XML API interface of the internal
Videoconferencing Manager
gatekeeper
MCU Ports
HTTP80TCPIn from WebWeb UI accessMCU
XML3336TCPIn from Resource
MCU Call Control XML APIMCU
Manager
XML3337TCPIn from another MCU or
MCU Cascade XML APIMCU
Desktop
SNMP161UDPIn from Resource
Configuration/StatusMCU
Manager and Network
Manager
Telnet23TCPIn from Network
Manager
Gateway Ports
Log retrieval and advanced
commands
MCU
HTTP80TCPIn from WebWeb UI accessgateway
SNMP161UDPIn from Resource
Configuration/Statusgateway
Manager and Network
Manager
Telnet23TCPIn from Network
Manager
Log retrieval and advanced
commands
gateway
How to Install Cisco Unified Videoconferencing Manager
During Cisco Unified Videoconferencing Manager installation Resource Manager and Network
Manager components are installed. The Desktop component of Cisco Unified Videoconferencing
Manager is installed separately.
During the installation you perform a basic Desktop configuration by defining servers which Desktop
uses. Follow recommendations in this section to configure Desktop correctly:
• In a single Cisco Unified Videoconferencing 3545 MCU deployment, use the same gatekeeper as
Cisco Unified Videoconferencing 3545 MCU is configured to use. If you install Cisco Unified
Videoconferencing Manager as a part of your deployment, specify the Cisco Unified
Videoconferencing Manager internal gatekeeper.
• In a multiple Cisco Unified Videoconferencing 3545 MCU deployment, you must use Cisco Unified
Videoconferencing Manager as your meeting control server. In a single Cisco Unified
Videoconferencing 3545 MCU deployment, you can use either Cisco Unified
Videoconferencing 3545 MCU or Cisco Unified Videoconferencing Manager.
• The default Desktop web server port is 80. If other applications are using port 80, the installer
prompts you to specify a different port.
If you wish to use port 80 in such cases, access the Services panel on your computer and disable the
IIS Administration, HTTP SSL and World Wide Web Publishing services. You can do this before
installing the Desktop server software or when you receive the "ip address/ port is in use" error
during installation.
After disabling these services, installation completes normally and Desktop clients can connect to
the Desktop server using port 80.
• If you wish to use the HTTPs protocol for security, configure the Desktop web server port to 443
after installation is complete.
• The Desktop serial key is required for the installation and operation of the Desktop and is not
included in this package. For more information about obtaining the serial key, refer to the License
Fulfillment Instructions for Cisco Unified Videoconferencing Manager at
Step 5In the License Agreement window, read the agreement, choose I accept the terms in the license
agreement, and then click Next.
Step 6In the Customer Information window, enter information for software registration, choose the user access
option for Desktop, and then click Next.
Step 7In the Cisco Unified Videoconferencing Desktop Desktop Serial Key window, enter the Desktop key
number, and click Next.
Step 8In the Custom Setup window, define which Desktop components to install on this server, specify the
installation location, and then click Next.
NoteThe default directory for Cisco Unified Videoconferencing Streaming Server installation is
C:\Program Files\Darwin Streaming Server.
For a single server installation, install both components.
Step 9In the Cisco Unified Videoconferencing Desktop Network Configuration window, configure the Desktop
Network Interface and Desktop web server port, and click Next.
Step 10In the Configure Servers window, configure server settings:
How to Install Cisco Unified Videoconferencing Manager
a. Enter the IP address of your gatekeeper in the Gatekeeper IP address field.
b. Enter the server’s NIC IP address in the IP address field under Use Cisco Unified
Videoconferencing Manager for moderation.
Alternatively, choose Do not enable moderation to work without a meeting control server in a
multiple Cisco Unified Videoconferencing 3545 MCU deployment. If you use Cisco Unified
Videoconferencing Manager as your meeting control server, enter the Cisco Unified
Videoconferencing Manager IP address in the IP address of Cisco IOS H.323 Gatekeeper field
so that Desktop uses the Cisco Unified Videoconferencing Manager internal gatekeeper.
NoteYou must use the specific IP addresses, not loopback addresses.
Step 11In the Configure Streaming window, choose a server to manage streaming:
a. When your deployment includes multiple Desktop servers, you must define which one of your
Desktop servers is enabled for streaming.
Choose This Cisco Unified Videoconferencing Desktop will be used to manage streaming services to define the Desktop server that you are currently configuring as the Desktop server
that is enabled for streaming.
NoteWe recommend that you choose only one Desktop server to be a streaming server.
If you install the Cisco Unified Videoconferencing Streaming Server on a separate server, type
the IP address of that server in the Darwin Streaming Server IP address field.
OL-16908-01
b. When your deployment includes multiple Desktop servers, and you do not want to define the
Desktop server that you are currently configuring as the Desktop server that is enabled for
streaming, choose Use an alternative Cisco Unified Videoconferencing Desktop to manage streaming services.
Type the Fully Qualified Domain Name (FQDN) of the Desktop server that is enabled for
streaming in the Server URL field.
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
1-7
How to Perform Post-installation Procedures
c. Choose Disable streaming for this Cisco Unified Videoconferencing Desktop to disable
streaming for the Desktop server that you are currently configuring.
Step 12In the Cisco Unified Videoconferencing Desktop Hostname Configuration window, specify the
hostname of the server that clients should use to connect to the Desktop.
NoteMake sure that you specify the hostname that clients can resolve.
Step 13In the Ready to Install the Program window, click Install.
Step 14Click Finish.
Step 15After installation is completed, verify that the Desktop server is operational:
a. Access the Desktop Server Administration interface by connecting to the following URL:
http://<SERVERFQDN:PORT>/cuvm/admin
b. Log in using the default user name (admin) and password (admin).
c. Open the Status tab of the Desktop Server Administration interface, and verify that all four
NoteThe light next to each link indicates whether or not the connection to the target server or
registration with the Gatekeeper is successful. When the light is red, a tooltip containing
error details is available. Click the red light to view further error information.
Step 16Remove the product CD-ROM.
How to Perform Post-installation Procedures
• Confirming Installation, page 1-8
• Running the Cisco Unified Videoconferencing Manager Service, page 1-9
• Logging in for the First Time, page 1-9
• Obtaining a License, page 1-10
• Changing Server Name and Web Port, page 1-10
Confirming Installation
Procedure
1-8
Step 1Wait 2-3 minutes for server initialization.
Step 2Go to http://host-URL:port-number.
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
Step 3Verify that the Resource Manager login window appears.
Step 4Verify that you can log in to the web interface using the administrator account specified in the
installation process.
Running the Cisco Unified Videoconferencing Manager Service
Cisco Unified Videoconferencing Manager is installed as a Windows Service on your server.
Cisco Unified Videoconferencing Manager automatically starts when the server is started.
Procedure
Step 1Go to Start > Settings > Control Panel > Administrative Tools > Services and find the list of
Cisco Unified Videoconferencing Manager related services.
Step 2Verify that the following services are installed:
• Cisco Unified Videoconferencing Manager—The service that Resource Manager and Network
Manager run on. This is started automatically.
• Cisco SipServer—The service for the SIP User agent included with Resource Manager for SIP call
control. This is started automatically.
You can turn off this service in H.323-only deployments. Access the vcs-core.properties file located
by default under
At the end of the installation process, a temporary license is automatically installed. This license is valid
for 30 days. To obtain an Cisco Unified Videoconferencing Manager license, perform a procedure
described in the License Fulfillment Instructions for Cisco Unified Videoconferencing Manager at
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
OL-16908-01
CHAP T ER
2
Backing up and Restoring Cisco Unified
Videoconferencing Manager Data
You can back up and restore the Cisco Unified Videoconferencing Manager database and configuration
files.
Only backup and restore of the database and configuration files within the same Cisco Unified
Videoconferencing Manager version is supported. Do not attempt to backup the database and
configuration files from an old Cisco Unified Videoconferencing Manager version and restore these files
to a newer version.
• Overview, page 2-1
• How to Back up Cisco Unified Videoconferencing Manager Data, page 2-2
• How to Restore Cisco Unified Videoconferencing Manager Data, page 2-4
Overview
There are many reasons for performing system backups on a regular basis, such as:
• Hardware failure
• Software failure
• Data corruption
• User mistakes
• Before any software upgrade
To restore Cisco Unified Videoconferencing Manager data, stop the Cisco Unified Videoconferencing
Manager service before restoring the database, configuration files, branding and sound files. Restart the
Cisco Unified Videoconferencing Manager service after restoration is complete.
OL-16908-01
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
2-1
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
How to Back up Cisco Unified Videoconferencing Manager Data
How to Back up Cisco Unified Videoconferencing Manager
Data
• Backing Up the Internal Database, page 2-2
• Backing Up an MSSQL 2005/2000/MSDE Database, page 2-2
• Back-up File Locations for Configuration Files, page 2-3
• Backing Up Branding and Sound Files, page 2-4
• Backing Up the License, page 2-4
Backing Up the Internal Database
Procedure
Step 1Open a DOS window and go to the MySQL bin directory located by default at one of the following
locations:
C:\Program Files\MySQl\mysql-4.0.21-win\bin, or
C:\MySQl\mysql-4.0.21-win\bin
Step 2Run the following DOS command to export the contents of the internal database to a file called mydump:
This section is only relevant if your Cisco Unified Videoconferencing Manager installation is using an
external MSSQL database. For demonstration purposes, we assume the installed Cisco Unified
Videoconferencing Manager database name is “temp_db” and that the database owner is “temp_user”.
You can modify the database name and its owner name during the installation process.
Procedure
Step 1Use Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Enterprise Manager
Management Studio to access temp_db.
MSDE database does not include a management console by default. You need to use an external
management console to connect to a MSDE database.
2-2
Step 2Right-click temp _db and select All Tasks > Backup Database, or Task > Backup to create a database
backup file.
Assume the name of the backup file is “temp_db.bak”.
Step 3Save temp_db.bak to a safe location.
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
OL-16908-01
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
How to Back up Cisco Unified Videoconferencing Manager Data
Back-up File Locations for Configuration Files
This section describes how to back up the following files by copying them to a safe physical location.
• Database Connectivity Property File, page 2-3
• Configuration Files, page 2-3
• LDAP Configuration Files, page 2-3
• Network Manager Configuration Files, page 2-3
• OCS 2007 Connector Files, page 2-4
Database Connectivity Property File
For Cisco Unified Videoconferencing Manager version 5.5 or later—Place the following files under
C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\deploy
For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Place the following files under
C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\deploy
• mssql-ds.xml (when working with Microsoft SQL server)
• mysql-ds.xml (when working with the internal database server)
Configuration Files
Backup the following configuration files from C:\Program Files\Cisco\Unified Videoconferencing
Manager\CUVCMRM\jboss\bin:
vcs-cdr-config.xml
vsc-config.xml
vcs-core.properties
vnex.properties
LDAP Configuration Files
Place the following files under the C:\Program Files\Cisco\Unified Videoconferencing
Manager\CUVCMRM\jboss\bin\configFiles directory:
• All files (if any) under this directory.
Network Manager Configuration Files
For Cisco Unified Videoconferencing Manager version 5.5 or later—Place the following under
C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\deploy\
vcs.ear\nms.war\WEB-INF\classes
For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Place the following under
C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\deploy\
vcs.ear\nms.war\WEB-INF\classes
• adminconfig folder
• config folder
OL-16908-01
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
2-3
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
How to Restore Cisco Unified Videoconferencing Manager Data
OCS 2007 Connector Files
Cisco Unified Videoconferencing Manager version 5.6 or later supports OCS 2007. Back up the
following files:
where ICM_HOME is the Cisco Unified Videoconferencing Manager installation directory.
By default, ICM_HOME is C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM
Backing Up Branding and Sound Files
For Cisco Unified Videoconferencing Manager version 5.5 or later—Back up all files (if any) located
under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\
deploy\branding.war\image.
For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Back up all files (if any) located
under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\
deploy\branding.war\image.
Backing Up the License
Procedure
Step 1Go to Start > Run and enter regedit to open the Windows registry.
Step 2For Cisco Unified Videoconferencing Manager version 5.5 or later—Back up the license key under:
\HKEY_LCOAL_MACHINE\SOFTWARE\CISCO > RESOURCE MANAGER > serial
How to Restore Cisco Unified Videoconferencing Manager Data
• Restoring Configurations, page 2-5
• Restoring the Internal Database, page 2-5
• Restoring an MSSQL 2005/2000/MSDE Database, page 2-6
• Restoring Configuration Files, page 2-7
2-4
• Restoring Branding and Sound Files, page 2-8
• Restoring the License, page 2-8
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
OL-16908-01
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
Restoring Configurations
Procedure
Step 1Stop the Cisco Unified Videoconferencing Manager service
• Go to Control Panel > Administrative Tools > Services.
• Locate the service named “Cisco Unified Videoconferencing Manager” and stop it.
Step 2Restore the database—see the“Restoring the Internal Database” section on page 2-5.
Step 3Restore the configuration files—see the“Restoring Configurations” section on page 2-5.
Step 4Restore the Branding and Sound Files—see the“Restoring Branding and Sound Files” section on
page 2-8.
Step 5Restore the License Files—see the“Restoring the License” section on page 2-8.
Step 6Start the Cisco Unified Videoconferencing Manager service.
How to Restore Cisco Unified Videoconferencing Manager Data
Restoring the Internal Database
Procedure
Step 1Open a DOS window and go to the MySQL bin directory located by default at one of the following
locations:
C:\Program Files\MySQl\mysql-4.0.21-win\bin
or
C:\MySQl\mysql-4.0.21-win\bin
Step 2Copy the mydump file to the bin directory where mydump is the name of the database backup file.
Step 3In the DOS window, enter the “mysql -u root” command to access the MySQL database command line
user interface.
The command link prompt changes to
mysql>.
OL-16908-01
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
2-5
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
How to Restore Cisco Unified Videoconferencing Manager Data
Step 4Run the following command to restore the content that has been dumped into the backup file to the
database:
mysql> source mydump
Step 5Run the following command to exit the MySQL command line window:
mysql > exit
Restoring an MSSQL 2005/2000/MSDE Database
This section is only relevant if your Cisco Unified Videoconferencing Manager installation is using an
external MSSQL database. For demonstration purposes, we assume the installed Cisco Unified
Videoconferencing Manager database name is “temp_db” and that the database owner is “temp_user”.
You can modify the database name and its owner name during the installation process.
Procedure
Step 1Use Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Enterprise Manager
Management Studio to access temp_db.
MSDE database does not include a management console by default. You need to use an external
management console to connect to a MSDE database.
Step 2If you are restoring temp_db to the same database server, make sure that temp_db exists.
If "temp_db does not exist, create a new database called temp_db.
Step 3If you are restoring temp_db to a new database server, delete the temp_db database on that new database
server if it exists, and create a new database called temp_db.
Step 4Ensure no other applications are using temp_db.
Step 5Right-click temp _db and select All Tasks > Restore Database, or Task > Restore > Database.
Step 6Select From device on the General tab, and use the temp_db.bak as the backup file.
Step 7Click Options.
Step 8Select either Force restore over existing database or Overwrite the existing database.
Step 9Click OK.
Step 10Select temp_db and open the Query Analyzer window.
Step 11From the Query Analyzer, run
sp_helpuser 'temp_user'
where temp_user is the name of the database user.
The database restore procedure has succeeded if the LoginName entry is the same as the UserName entry
in the returned table, and if the DefDBName entry is temp_db.
Step 12If the LoginName and DefDBName entries are null:
a. Run
sp_addlogin 'temp_user', 'temp_user_password', 'temp_db', null, [SID value from
the table returned at 11]
where
2-6
Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6
OL-16908-01
Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data
“temp_user” is the name of the database user
“temp_db” is the name of the database
“temp_user_password” is the database user password. Its value should be the same as the
“temp_user” password from the old backup database.
You can create a new password if you wish. Update the new password in the mssql-ds.xml file
in clear text, as shown below. The old password is stored in encrypted format.