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

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)