Foglight for Sybase 5.7.5.40 - User and Reference Guide

Configuring Sybase Login Privileges

Configuring Sybase Login Privileges

The Sybase_MDA agent collects performance metrics using the Sybase MDA tables. This requires the Sybase login to have only the role mon_role assigned to it, as described above. The Sybase login does not need to have the role sa_role assigned to it. From Cartridge for Sybase version 5.5.8.39, the agent installs the Foglight for Sybase stored procedures during the initial activation. Therefore, if you are upgrading the Cartridge for Sybase, no action is required regarding the stored procedures. If you are installing the agent for the first time, you must perform the following pre-requisite procedure.

To create a login account without 'sa' privileges:

1	Ensure that all of your MDA configuration parameters are set properly.

TIP: The file setup_mon_tables.sql contains all of the required parameters with sample values.

2	Create a Foglight login account. For example, fog123:

sp_addlogin 'fog123' , 'foglight' , sybsystemprocs

go

grant role mon_role to fog123

go

3	Run the rapsAdmin.sql script as the sa user.

The scripts included with the Foglight for Sybase can be found in the directory <FglAM_Home>/agents/SybaseCartridge/<version>/config/Sybase/scripts.

isql -Usa -P<password> -S<serverName> -i rapsAdmin.sql -o

rapsAdmin.out

The above command creates two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser. In addition, the script drops previously installed stored procedures and previously created temporary tables.

4	Run the sp_fgl_adduser procedure as the sa user. For example:

sp_fgl_adduser 'fog123' , 'foglightGroup'

go

The above command creates a group named foglightGroup and a user named fog123 in each database, and in the sybsystemprocs database, it grants the permission for creating procedures to that user account.

IMPORTANT: The group and user names used here (foglightGroup and fog123) are just examples, you can substitute them with more appropriate values.

To update a non-sa user after the cartridge upgrade:

1	Complete Step 3 and Step 4 described in To create a login account without 'sa' privileges:.

The above procedure results in the new user being created (fog123 in this example) in the group foglightGroup in each database, including the model database. Having that user and group in the model database causes a creation of a temporary database using these credentials when the Sybase server is restarted.

Using a secondary database to store collected data

Using a secondary database to store collected data

Foglight stores data collected by monitoring an ASE server in the default tempdb database. In case the default database fills up, it is possible to store the collected metrics in another database. The cartridge includes a set of scripts that enable this feature:

•	rapsinstall2_questdb.sql

•	rapsinstall2-1253_questdb.sql

•	rapsinstall2_cluster_questdb.sql

The following code block shows how to create a temporary database (questdb_temp), and bind a Foglight user (fogqdb) to that database.

disk init name = 'questdb_temp',

physname = 'C:\sybase\data\questdb_temp.dat', size = '50M',

dsync = false

create temporary database questdb on questdb_temp = 50

sp_tempdb bind, 'LG', 'fogqdb', 'DB', 'questdb'

Configuring the Sybase_MDA Agent for Remote Monitoring

Configuring the Sybase_MDA Agent for Remote Monitoring

The Sybase_MDA Agent can be configured for remote monitoring. Remote monitoring does not require a Sybase_MDA Agent instance to run on the monitoring host. The agent instance can run on another machine, provided that you point it to the monitored machine using Sybase_MDA Agent properties.

To configure the Sybase_MDA Agent for remote monitoring:

1	Install and run the Foglight Agent Manager on the monitored host. You can use the Agent Manager embedded on the Foglight Management Server.

2	On the computer running the Agent Manager, install Sybase Open Client.

3	On the Sybase Open Client, use the dsedit tool to add an entry representing the monitored Sybase Server in the interface file.

4	Define a Sybase user for the Sybase cartridge.

5	Configure the Sybase_MDA Agent’s Sybase Home property to point to the Open Client home directory: %Sybase% (Windows) or $Sybase (Unix).

TIP: The Sybase Home agent property can be found in the Connection Details group of agent properties. For more information, see Setting Connection Details.

6	Configure the Sybase_MDA Agent’s Server Name property to point to the host name or IP address of the monitored server, as defined in dsedit.

Sybase_MDA Agent Properties

Sybase_MDA Agent Properties

When an agent connects to the Foglight Management Server, it is provided with sets of properties that it uses to configure its correct running state.

Each agent is provided with a combination of two types of properties: agent properties and shareable properties.

Default versions of these properties are installed with the Foglight for Sybase. However, you can edit the default shareable and agent properties, configure agent properties that apply only to a specific agent instance, and create edited clones of shareable properties that are used by a subset of the agents of a certain type.

For more information about working with agent properties, see the Foglight Administration and Configuration Guide.

The Sybase_MDA Agent is shipped with default properties that can be modified to suit your system requirements.

Agent properties described in this section comprise:

▪	Setting Connection Details

▪	Setting Callback Connection Properties

▪	Setting Data Management Properties

▪	Setting Table Space Management Properties

▪	Setting Data Retrieval Properties

▪	Setting Benchmark Properties

▪	Setting Configuration Properties

To modify agent properties:

1	Ensure that the navigation panel on the left is open.

To open the navigation panel, click the right-facing arrow on the left .

2	Open the dashboard that lets you navigate to the agent properties by completing one of the following steps:

▪	On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties.

In the Agent Properties dashboard, in the Namespace > Type pane, select Legacy > Sybase_MDA.

▪	On the navigation panel, under Dashboards, click Administration > Agents > Agent Status.

In the Agent Status dashboard, select the instance of the Sybase_MDA agent whose properties you want to modify and click Edit Properties.

A list of agent properties appears in the Sybase_MDA pane.

Figure 47. Agent Properties

The position of the Properties pane depends on the dashboard you used to access agent properties. If you used the Agent Properties dashboard, the Properties pane appears to the right of the Namespace > Type pane in the display area. If you used the Agent Status dashboard, the Properties pane appears across the display area.