2 configuring the mysql database, Configuring the mysql database – HP 3PAR System Reporter Software User Manual

Page 54

Advertising
background image

3.18

Installing the Database Server

3PAR System Reporter User’s Guide

System Reporter 2.8

3.8.2.2 Configuring the MySQL Database

Use the MySQL Server Instance Configuration Wizard to configure the MySQL

database as follows:

1

In the MySQL Server Instance Configuration Wizard, click Next to begin

configuring the database.

2

Select Detailed Configuration and then click Next.

3

Select Server Machine then click Next.

4

Select Multifunctional Database then click Next.

5

When prompted to select a drive for the

warehousing

data file, accept the default drive

and directory and click Next.

6

Choose Decision Support (DSS)/OLAP and click Next.

7

Confirm that Enable TCP/IP Networking is selected and that the Port Number is

3306 and then click Next.

8

Confirm that Standard Character Set is selected and then click Next.

NOTE: When installing on a Redhat Linux server where the MySQL server is

running locally on the same server, you must complete one of the following

procedures:

1

Create a symbolic link using the following command:

ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock

2

Or, make the following change in the /etc/my.cnf file:

socket=/var/run/mysqld/mysqld.sock

and then restart the MySQL server.

Without one of these modifications, the sampleloop logs the following error:

2010-03-09 12:54:01: Could not connect to database: mysqlconnect/db

server: Can't connect to local MySQL server through socket

'/var/run/mysqld/mysqld.sock' (2)

Advertising