|
|
This appendix describes how to set up SQL databases as a repository of network statistics to be used in reports.
This appendix contains the following sections specific to your environment:
This appendix contains the following sections specific to your environment:
The TrafficDirector application can use network statistics to create long-term trend reports with the Trend Reporter application. To do so, you must set up one or more SQL servers to log to a SQL database.
An embedded SQL database is bundled with the TrafficDirector application that you can use on Windows NT and Solaris platforms. The software that runs on the Windows NT Server platform also lets you use the Microsoft Windows SQL Server as a standalone SQL server database. You have many options for configuring the database.
When you ran the installation procedure, you chose the type of SQL database you will use---embedded SQL or Microsoft SQL Server.
The TrafficDirector application supports a distributed database architecture so you can track statistics from multiple sites. You can define multiple network management stations to monitor your network locally, then collect the information from these stations into one centralized SQL database.
By setting up the logging mechanism to perform most agent polling locally, you can avoid excessive traffic to and from the central SQL database.
You can also configure your environment so each local site generates reports based on the data gathered locally, or have the central site gather the reporting information from each remote site and compile reports globally.
To properly set up the SQL server environment, you must perform these major tasks:
Step 1 Install and configure the SQL Server database software.
Step 2 Identify the centralized logging server to the TrafficDirector application. You use the Configure SQL Servers application to do this. See the "Configuring SQL Servers for Reporting" chapter in Using the TrafficDirector Application for detailed information.
Step 3 Define any read-only servers from which to obtain statistics for the logging server. You use the Configure SQL Servers application to do this. See the "Configuring SQL Servers for Reporting" chapter in Using the TrafficDirector Application for detailed information.
Step 4 Identify the desired aging and utilization parameters to determine how long to maintain historical data in the SQL database. You use the Configure Rollup application to do this. See the section, "Logging and Aging Data for Reporting" in the "Configuring SQL Servers for Reporting" chapter in Using the TrafficDirector Application for detailed information.
Step 5 Associate the SQL servers with the appropriate agent definition. You use the Configuration Manager application to do this. See the "Using Configuration Manager" chapter in Using the TrafficDirector Application for detailed information.
Step 1 Define any read-only servers from which to obtain statistics for the logging server. You use the Configure SQL Servers application to do this. See the "Configuring SQL Servers for Reporting" chapter in Using the TrafficDirector Application for detailed information.
Step 2 Identify the desired aging and utilization parameters to determine how long to maintain historical data in the SQL database. You use the Configure Rollup application to do this. See the section, "Logging and Aging Data for Reporting" in the "Configuring SQL Servers for Reporting" chapter in Using the TrafficDirector Application for detailed information.
Step 3 Associate the SQL servers with the appropriate agent definition. You use the Configuration Manager application to do this. See the "Using Configuration Manager" chapter in Using the TrafficDirector Application for detailed information.
The TrafficDirector application on a Windows NT Server platform supports the configuration of a separate SQL server database using Microsoft SQL Server V7.0.
To set up the SQL database for use by the Trend Reporter application, you must complete the following tasks in the order listed.
1. Setting SQL Server Network Options
2. Setting SQL Client Network Options
5. Setting Permissions for Database Access
7. Establishing Permission to Access Tables (Windows NT Platforms Only)
8. Defining SQL Servers to the TrafficDirector Application (All Platforms)
To enable logging to the TrafficDirector SQL database, you must set the SQL Server network options on the system where the SQL Server is installed. To do so, follow these steps:
Step 1 From the Windows Programs menu, select Microsoft SQL Server 7.0.
The Microsoft SQL Server window is displayed.
Step 2 Start the Server Network Utility application.
From the General tab, at least three network library selections should be present:
Step 3 If all three selections are listed, click OK.
Step 4 If TCP/IP is not listed, do the following:
(a) Click Add.
(b) In the Add Network Library Configuration window, click TCP/IP.
(c) The server name and computer names should be filled in with the system name. If they are not complete, enter this information manually.
(d) The port number field should contain 1433; if not, enter 1433.
Step 5 To exit from the Add Network Library Configuration window, click OK.
Step 6 To save the changes, click OK in the SQL Server Network Utility window.
Step 7 Exit from Microsoft SQL Server.
To establish proper network communication, you must set the SQL client network options on the system on which the SQL Server is installed. To do so, follow these steps:
Step 1 From the Windows Programs menu, select Microsoft SQL Server 7.0.
The Microsoft SQL Server window is displayed.
Step 2 Click the Client Network Utility option.
Step 3 From the General tab, change the default network library to TCP/IP.
Step 4 Click OK.
You must create a database to establish a location where information collected by the TrafficDirector application is stored for use with the Trend Reporter application. To do so, follow these steps:
Step 1 From the Windows Programs menu, select Microsoft SQL Server 7.0.
Step 2 Start the Enterprise Manager application.
Step 3 Expand the navigation tree until the Databases folder is displayed under the correct SQL server.
Step 4 Highlight the Databases folder.
Step 5 Select Actions > New Database.
Step 6 In the Database Properties window, click the General tab.
Step 7 In the Name field, enter NSTREND_DB.
Step 8 Set database and transaction log default sizes by following these steps:
(a) From the Database tab, click the Space Allocated field.
(b) Enter a new size for the database.
(c) Click the Transaction Log tab.
(d) Click the Space Allocated field.
(e) Enter a new size for the transaction log.
Step 9 Click OK.
To access the NSTREND_DB database, you must create a SQL user. This information is the same as what you used when you set up the database with the TrafficDirector Configure Servers application.
To create a database user, follow these steps:
Step 1 From the SQL Server Enterprise Manager window, expand icons until the Security folder is displayed.
Step 2 Expand the Security folder.
Step 3 Highlight Logins.
Step 4 Select Actions > New Login.
Step 5 At the SQL Server Login Properties---New Login window, click the General tab.
Step 6 In the Name field, enter the user name of the SQL user account.
Step 7 Click the SQL Server authentication radio button.
Step 8 In the Password field, enter a password for the SQL user account.
Step 9 In the defaults section of the General tab, go to the database pulldown menu.
Step 10 Highlight NSTREND_DB.
Step 11 Click the Database Access tab.
Step 12 From the Database Access tab, click inside the Permit box to the left of NSTREND_DB.
Step 13 Click OK.
Step 14 When prompted, confirm the password by reentering it.
Step 15 Click OK.
To allow the TrafficDirector application to create tables, insert new data, and delete old data, the SQL user account must have full permission to access NSTREND_DB. To set database permissions, follow these steps:
Step 1 From the SQL Server Enterprise Manager window, open the Databases folder.
Step 2 Highlight NSTREND_DB.
Step 3 Select Action > Properties.
Step 4 Click the Options tab.
Step 5 In the settings section, check Truncate Log on Checkpoint.
Step 6 Click the Permissions tab.
Step 7 For the SQL Server user created, check all of the permissions boxes. (If necessary, use the scroll bar to show all of the boxes.)
Step 8 Click OK.
Step 9 Close the SQL Server Enterprise Manager window.
If the TrafficDirector software and the SQL Server software are not installed on the same system, you should install the client connectivity portion of the SQL Server Standard edition on the system on which the TrafficDirector application is installed.
The steps you follow depend on whether the system on which you are installing the software has the auto-run feature enabled.
To install the client software, follow these steps.
Step 1 Place the SQL Server CD in the CD-ROM drive of the system on which you installed the TrafficDirector application.
Step 2 Browse the contents of the CD.
Step 3 Double click autorun.exe.
Step 4 At the Microsoft SQL Server window, click Install SQL Server 7.0 Components.
Step 5 At the Install SQL Server 7.0 Components window, click the Database Server Standard Edition icon.
Step 6 At the Select Install Method window, click the Local Install radio button.
Step 7 Click Next.
A message is displayed to indicate that only Client components are available for installation.
Step 8 Click OK.
Step 9 At the Welcome window, click Next.
Step 10 At the Software License Agreement window, click Yes.
Step 11 If necessary, at the User Information window, enter user information.
Step 12 Click Next.
Step 13 At the Setup window, in the fields provided, enter the CD-key.
Step 14 Click OK.
Another setup window is displayed, showing Product ID information.
Step 15 Click OK.
Step 16 At the Setup Type window, accept the default installation directory by clicking Next, or browse to specify a different directory.
Step 17 Click Next.
Step 18 In the Select Components window, deselect all options except for Client Connectivity.
Step 19 Click Next.
Step 20 In the Start Copying Files window, click Next.
Files are copied to the directory you specified in Step 16.
Step 21 In the Setup Complete window, click Finish.
Step 22 Close all open windows.
Step 23 Remove the CD-ROM from the drive.
Step 24 Restart your computer.
Step 25 When your computer restarts, continue with the section, "Establishing Permission to Access Tables (Windows NT Platforms Only)."
Before the TrafficDirector application can access the various databases on the SQL Server, you must enable the proper permissions in the SQL Server software.
To establish permissions, follow these steps:
Step 1 From the Windows Programs menu, select Microsoft SQL Server.
The Microsoft SQL Server window is displayed.
Step 2 Select the SQL Enterprise Manager option.
The Server Manager window is displayed.
Step 3 Click the plus-sign (+) symbol to the left of the SQL server.
The folders within the SQL Server directory are displayed.
Step 4 Click the plus-sign (+) symbol to the left of the Databases folder.
The names of existing databases are displayed.
Step 5 Highlight the NSTREND_DB database.
Step 6 From the menu bar, select Object > Permissions.
The Permissions window is displayed.
Step 7 Highlight the first name listed.
Step 8 Click Grant All.
Step 9 Click Set.
The Configure Servers application lets you define the address and access information that the TrafficDirector application requires to either write to or read from an SQL database.
Although each copy of the TrafficDirector application writes only to a single SQL server, you can use this application to configure the TrafficDirector software to read from multiple SQL servers. You use Configure Servers to do the following:
If you installed the Microsoft SQL Server, use the Configure SQL Servers application to define the SQL server as the logging server. To do so, follow these steps:
Step 1 Click the Config Servers icon in the Admin level of the TrafficDirector software.
Step 2 Select Edit > New from the menu bar.
The Add Server Entry window is displayed.
Step 3 Enter the following information:
Step 4 To accept the server configuration and add the SQL Server to the TrafficDirector configuration, click OK.
Step 5 Close the Configure SQL Servers window.
Although the TrafficDirector application can only write report data to one SQL Server as the logging server, the distributed reporting feature enables the TrafficDirector application to read data from multiple SQL servers for use in generating trend reports.
To configure any read-only SQL servers to read data and generate reports from (on either Windows NT or Solaris platforms), follow these steps:
Step 1 Click the Config Servers icon in the Admin level of the TrafficDirector application.
The Configure SQL Servers window is displayed.
Step 2 Select Edit > New from the menu bar.
The Add Server Entry window is displayed.
Step 3 Enter the following information in the Add Server Entry window:
Step 4 To accept the server configuration and add the SQL server to the TrafficDirector configuration files, click OK.
After you define the SQL server as part of the TrafficDirector installation process, and utilization and aging parameters have been established for logging, you must associate the appropriate server with each agent installed in the TrafficDirector application.
To associate the server with each agent, follow these steps:
Step 1 From the TrafficDirector main window, click the Admin button.
Step 2 Click the Config Manager icon.
Step 3 Select an agent.
Step 4 Click Edit.
Step 5 Click the SQL Server list box.
Step 6 Select the appropriate server for the agent.
Step 7 Click OK twice.
The correct SQL server definition has been assigned to the agent.
Step 8 If necessary, repeat Steps 3 through 7 for each agent.
Before the TrafficDirector application can access the various databases on the SQL Server, you must enable the proper permissions in the SQL Server software.
To establish permissions, follow these steps:
Step 1 From the Windows Programs menu, select Microsoft SQL Server.
The Microsoft SQL Server window is displayed.
Step 2 Select the SQL Enterprise Manager option.
The Server Manager window is displayed.
Step 3 Click the plus-sign (+) symbol to the left of the SQL server.
The folders within the SQL Server directory are displayed.
Step 4 Click the plus-sign (+) symbol to the left of the Databases folder.
The names of existing databases are displayed.
Step 5 Highlight the NSTREND_DB database.
Step 6 From the menu bar, select Object > Permissions.
The Permissions window is displayed.
Step 7 Highlight the first name listed.
Step 8 Click Grant All.
Step 9 Click Set.
Step 10 Repeat this process for each table name listed.
Step 11 Click the By User tab.
All permissions that have been set are displayed in the Object Permissions window.
Step 12 Verify that all permissions are properly set for each table name by reviewing the contents of the display.
Step 13 Close the Object Permissions window.
Step 14 Close the Microsoft SQL Enterprise Manager window.
There may be times when you want to edit a SQL server definition or delete a definition that is no longer needed.
In these cases, you can either edit or delete the SQL server definitions as outlined in the following sections:
To edit a server definition, follow these steps:
Step 1 Click the Config Servers icon in the Admin level of the TrafficDirector application.
Step 2 Select the SQL server entry that you want to edit.
Step 3 Select Edit > Edit from the menu bar.
The Edit Server Entry window is displayed.
Step 4 Change any of the parameters for the selected SQL server entry.
Step 5 Click OK to accept the server definition and add the SQL server to the TrafficDirector configuration files with the new changes.
To delete a SQL server definition, follow these steps:
Step 1 Click the Config Servers icon in the Admin level of the TrafficDirector application.
Step 2 Select the SQL server entry you want to delete.
Step 3 Select Edit > Delete from the menu bar.
The TrafficDirector software deletes the SQL server configuration and removes it from the Configure SQL Servers main window.
Posted: Fri Mar 31 09:30:04 PST 2000
Copyright 1989 - 2000©Cisco Systems Inc.