C H A P T E R

2

Installing MySQL Subscriber Database This chapter describes how the optional MySQL subscriber database is installed for use with the Cisco SIP Proxy Server. An installation script, “install_mysql_db”, is used. This script only runs on Linux and has been successfully tested on Redhat 6.2, 7.0 and 7.1 platforms. During installation, the script does the following: •

Install the MySQL client and MySQL server RPMs.

•

Create the SIP database and subscriber table.

After a successful installation, you can use the functionalities offered by script “sysadmin_mysql_user”. This script allows you to add, remove and modify subscriber records in the MySQL subscriber database.

MySQL Subscriber Database This database is needed when the Cisco SIP Proxy Server performs the following. •

Authorization (using HTTP-Digest or HTTP-Basic), or

•

Call Forwarding features: – Call Forward Unconditional – Call Forward on Busy – Call Forward on (user) No Answer – Call Forward on (device) Unavailable

It can be installed on either the same or different computer system from the Cisco SIP Proxy Server(s). For Linux installation of the Cisco SIP Proxy Server, refer to CD Installation Guide for Cisco SIP Proxy Server on Linux.

Installing the MySQL Subscriber Database Step 1

At the system prompt, log in as root. % su root

Step 2

Enter the password at the next prompt.

Cisco SIP Proxy Server Administrator Guide

2-1

Chapter 2

Installing MySQL Subscriber Database

Installing the MySQL Subscriber Database

Note

Step 3

If you are not logged in as the root user, the following error message appears.

Run the install_mysql_db script from the bin directory of the Cisco SIP Proxy Server. /usr/local/sip/bin/install_mysql_db

The following screen appears.

Step 4

Enter Y for Yes to continue installation, and N for No to quit. If you enter Y, the following screen appears.

Step 5

If your system is connected to the public internet, enter Y to “ftp” to MySQL RPMs. Otherwise, “ftp” the following RPM files from URL ftpeng.cisco.com. The following files are in directory MySQL-3.23. – MySQL-client-3.23.33-1.i386.rpm – MySQL-3.23.33-1.i386.rpm – MySQL-shared-3.23.33-1.i386.rpm

If you enter Y in the above step, the following screen appears.

Cisco SIP Proxy Server Administrator Guide

2-2

Chapter 2

Installing MySQL Subscriber Database Installing the MySQL Subscriber Database

Step 6

Press Enter key to accept the default values. These defaults are valid for most users. If you do not want the default values, enter a FTP server, MySQL RPM directory, MySQL client RPM (remote) filename, MySQL server RPM (remote) filename and MySQL Shared Library RPM (remote) filename as you are prompted. The following screen appears.

When ftp is done, the following screen appears.

Step 7

As prompted, enter the local pathnames where the MySQL client RPM, server RPM and shared library RPM reside. The following screen shows these prompts.

Cisco SIP Proxy Server Administrator Guide

2-3

Chapter 2

Installing MySQL Subscriber Database

Installing the MySQL Subscriber Database

The following screens show a successful file transfer of the MySQL client, MySQL server and MySQL shared library RPMs respectively.

If the file transfer is stalled, the following screen appears. The script will automatically retry the file transfer up to five times.

Cisco SIP Proxy Server Administrator Guide

2-4

Chapter 2

Installing MySQL Subscriber Database Installing the MySQL Subscriber Database

The following screen appears after five unsuccessful retries. This indicates your system is not connected to the public internet. Manually “ftp” your files as mentioned in step 6.

If the file transfer is successful, the following screen appears.

Step 8

Enter the MySQL Administrator’s root password as prompted. This password is not the same as the root user password. The following screen appears.

Step 9

As prompted, enter a username and password for the Cisco SIP Proxy Server(s) to access the MySQL server. The defaults shown are valid for most users. The following screen appears.

Cisco SIP Proxy Server Administrator Guide

2-5

Chapter 2

Installing MySQL Subscriber Database

MySQL Subscriber Database Uninstallation

Step 10

Enter MySQL database name and subscriber table name as prompted. The defaults shown are valid for most users. Message on installation completion appears as follows.

MySQL Subscriber Database Uninstallation This section describes how to uninstall the MySQL server and MySQL client. Step 1

At the system prompt, log in as root.

Step 2

At next prompt, enter ./uninstall_mysql_db. The following screen appears.

Step 3

Enter Y or N to the question “Do you wish to continue?” The following screen appears.

Cisco SIP Proxy Server Administrator Guide

2-6

Chapter 2

Installing MySQL Subscriber Database MySQL Subscriber Database Uninstallation

Warning

Step 4

Use caution. If you enter Y to the question showed in the next step, your existing MySQL databases will be removed.

Enter Y or N to the question “Do you wish to delete the MySQL databases?” Message “Uninstall operation completion” appears as in the following screen.

Cisco SIP Proxy Server Administrator Guide

2-7

Chapter 2 MySQL Subscriber Database Uninstallation

Cisco SIP Proxy Server Administrator Guide

2-8

Installing MySQL Subscriber Database