HP 3PAR System Reporter Software - Manual (Page 39)

NOTE: Beginning with the 2.2 release, System Reporter can use a MySQL database on a remote
server. The MySQL installation and configuration steps are the same for the remote server. See
section for configuring System Reporter to use a remote MySQL database. This type of configuration
is highly recommended.
After downloading the MySQL executable, use the MySQL Server Setup Wizard to set up and
configure MySQL as follows:
1.
Open the MySQL executable.
2. When prompted, click Next.
3. Choose a Typical installation and click Next.
4. Click Install.
5. Click Skip Sign-Up then click Next.
6. Make sure that Configure MySQL Server now is checked and then click Finish.
The MySQL Server Instance ConfigurationWizard appears.
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:
Create a symbolic link using the following command:
ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock
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)
Configuring the MySQL Database
Use the MySQL Server Instance ConfigurationWizard to configure the MySQL database as follows:
1.
In the MySQL Server Instance ConfigurationWizard, 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.
9. Confirm the following and then click Next:
•
Install As Windows Service is selected
•
the default Service Name is MySQL
•
the Launch the MySQL Server automatically checkbox is checked
Installing the Database Server 39