Contents

Introduction

Prerequisites

Requirements

Components Used

Problem: How to enable SQL logging in UCS Director (UCSD)?

Solution

Log review with the shelladmin user

Log review with the root user

Related Information

Introduction

This document describes how to enable SQL logging within the UCS Director (UCSD) 6.6 environment.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

- UCS Director (UCSD)

- Structured Query Language (SQL)

Components Used

The information in this document is based on UCS Director (UCSD) 6.6.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, ensure that you understand the potential impact of any command.

Problem: How to enable SQL logging in UCS Director (UCSD)?

A more detailed troubleshooting and problem analysis require in certain case to enable SQL logging. For example this log information helps to understand which database tables are accessed or may encounter errors during the table access.

Solution

Connect to the UCSD UI and go to Administration -> Support Information -> Enable debug logging

To view the UCSD application logfile (logfile.txt) from the command line interface (CLI) there are two different approaches possible.

Log review with the shelladmin user

1. Open a ssh terminal

2. Specify the shelladmin credentials

3. Select option 18 - tail inframgr logs

Log review with the root user

1. Open a ssh terminal

2. Specify the root user credentials

3. Execute the following comand

tail -f /opt/infra/inframgr/logfile

Related Information

- UCSD Maintain and Operate Guides

- Technical Support & Documentation - Cisco Systems