DPS Telecom “Techno Knowledge” Paper “Your Partners in Network Alarm Management”

Problem: Unable to Install MySQL for T/Mon SQL Agent Platform: T/Mon SQL Agent

T/Mon SQL software module allows you to integrate multiple T/Mon alarm data history files into a single advanced SQL database. You can store millions of alarmevents into a single SQL database.

This techno knowledge paper can help you if:

• You are attempting to Install MySQL for T/Mon SQL Agent

Quick Reference Chart (for more details, review the troubleshooting checklist, starting on page 2 of this guide)

START HERE

Download MySQL installation file

Open up MySQL command prompt

Configure MySQL Server Instance

Change Password to root

Select DSS OLAP

Click Execute to start Configuration

Install T/Mon SQL Agent

View database history

Create Database

Launch T/Mon SQL Agent

Troubleshooting Checklist

Download or copy the MySQL installation file onto your desktop.

Double click the icon for MySQL installation file.

Click on ‘Next’ on MySQL installation wizard welcome screen.

Select ‘Typical’ installation.

Use the Default Path.

Click on Install.

Click on ‘Finish’ after Installation.

Configure MySQL Server instance.

Select ‘Detailed Configuration’ option.

Select ‘Developer Machine’

Select ‘Multifunctional Database’

Select drive ‘C:’ and ‘Installation Path’ directory for InnoDB Tablespaces setting

Select ‘Decision Support (DSS) OLAP’

Select ‘Enable TCP/IP Networking’ De-select ‘Enable Strict Mode’

Select ‘Standard Character Set’

Select ‘Install as Windows Service’

Enter in Password Confirm Password

Select ‘Enable root access from remote machines’

Click on ‘Execute’ to start configuration

Click on ‘Finish’ to close Wizard after configuration is complete

Basic installation should now be complete

Open up your MySQL command prompt:

o Click on ‘Start’ icon o Select ‘Programs’ o Select ‘Files’ o Select ‘MySQL’ o Select ‘MySQL Server 5.0’ o Select ‘MySQL Command Line Client

Type your Password: root Change the format of your password to root:

o Type use mysql and press ‘Enter’ o Type select user, host from user; and press ‘Enter’

You should see a box like the one shown below that displays the passwords that are set for the remote password as well as the local (localhost) password

o To set the password to the correct format, type the password found in the box and use that in the command below:

o Type set password for ‘root’@’%’=old_password(‘root’); and press ‘Enter’

o Repeat the same steps for the local host password format change

o The entire sequence should look very similar to the picture below:

Install T/Mon SQL Agent o Go to DPS website (www.dpstele.com) o Click on Support on bottom left hand corner

o Log into Support account o Go to Firmware/Software downloads o Select T/Mon SQL Agent o Select version 1.02.0000 o Save to desktop

o Unzip both T/Mon SQL agent and MyODBC o Double click MyODBC installation o Should see “Welcome to MyODBC” page as shown below:

o Click ‘Next’ o Click ‘Next’ to agree to the terms o Click ‘Next’ the read me statement

o Click ‘Next’ to start installation

o Click ‘Next’ to finish OBDC installation

Install T/Mon SQL Agent

Click on ‘Installation Program’

Click ‘Next’ for InstallShield Wizard

Select ‘I accept the terms to the license agreement’

Click ‘Next’ Fill in customer information

Select ‘Typical Installation’

Click on ‘Next’ Click on ‘Install’

Click on ‘Finish’

Create database on machine running MySQL

o Launch MySQL administrative tool (Navicat) o Click on ‘Start’ icon o Select ‘Programs’ o Select ‘Administrative Tool’ (Premium Navicat)

Go to ‘File’

Select ‘New Connection’

Fill in the Name, IP information and Password of the machine that will be running MySQL

Click ‘OK’ for Test Connection

Go to ‘Connection’ box

Click on the server that you defined in the previous step

Right click this server connection

Select new database

Fill in the database name you will be using (for example tmon2_data)

Click on database name in connections box (tmon2_data) to view

database history

Setup the T/Mon for an SQL job and setup the DPS SQL Agent

Launch DPS SQL Agent to see connection status for the T/Mon and database

––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––

If you continue to have issues installing MySQL for T/Mon SQL Agent, please contact DPS Telecom Tech Support