Cisco Cisco Smart CallConnector Server and Advanced Client Maintenance Manual
Chapter 6 Configuring CallConnector Servers
6-54 Cisco CallConnector Server
6.7.4.1 Database Server
The CallConnector Database Server provides access to the configuration, contact and
transactional data to all the CallConnector servers and clients.
The Database Server provides gateway functions between SIP messages and the SQL
database command. SIP User Agents such as CallConnector clients’ access configuration,
contact and transaction data from standard SQL databases by sending SIP messages to the
Database Server. The Database Server supports the SIP Message methods. When it receives a
database request, it fulfills the request from the attached SQL database and returns the
data/response to the requestor.
Database Server supports synchronization feature; allowing add/delete/updates to be kept
current
If the Database Server fails, then:
transactional data to all the CallConnector servers and clients.
The Database Server provides gateway functions between SIP messages and the SQL
database command. SIP User Agents such as CallConnector clients’ access configuration,
contact and transaction data from standard SQL databases by sending SIP messages to the
Database Server. The Database Server supports the SIP Message methods. When it receives a
database request, it fulfills the request from the attached SQL database and returns the
data/response to the requestor.
Database Server supports synchronization feature; allowing add/delete/updates to be kept
current
If the Database Server fails, then:
Step 1
User cannot log-in– cannot be authenticated.
Step 2
Call Logs lost for the down-time.
Step 3
If Database Tables corrupted; then database has to be restored from
customer backup of CallConnector Server.
customer backup of CallConnector Server.
There are two aspects to the configuration – setting up the communication parameters to handle
the SIP messages and setting up the access to the database system.
1. The Database Server uses Microsoft ADO objects to connect to the Access
compatible database files stored in the Data folder under Smart CallConnector
Server.
Server.
2. Windows Data Source tools in the Control Panel Administrative Tools-> ODBC
Drivers provides interface to administer and verify settings.
3. The Database Server connects to three databases – UCCDatabase database that
contains the provisioning information, Corporate database that contains the corporate
directory data and the CallLog database that stores the transaction data for example
call logs.
directory data and the CallLog database that stores the transaction data for example
call logs.
4. The databases should be regularly backed up and in the event of corruption or other
problems that latest configurations can be restored from the backups.
6.7.5 To Configure Database Server Communication
Step 1
Select Server Options/Addresses and Ports.
Step 2
Select the IP address or network address of the computer with the
System SIP Server. If the Smart CallConnector Server components are
all installed on one computer, then this address will be the IP address of
this machine.
System SIP Server. If the Smart CallConnector Server components are
all installed on one computer, then this address will be the IP address of
this machine.
Step 3
Enter the port used by the Database Server to receive messages. The
default value is 5061 and is used for both TCP and UDP connections. If
this port is not available, then change this to a port available on the
computer.
default value is 5061 and is used for both TCP and UDP connections. If
this port is not available, then change this to a port available on the
computer.
Step 4
Click Save or press Alt + S to save the changes.