3PAR System Reporter User’s Guide

System Reporter 2.8

/etc/init.d/mysqld restart

CAUTION: It is necessary to use a large max_allowed_packet length because, when sampling a large number of systems or very large systems, the SQL INSERT command length can be quite large and the max_allowed_packet must be large enough to hold the entire statement. If the max_allowed_packet is not large enough, the sampler will get an error and sampling will stop.

3.8.2.4 Creating MySQL Users and Schema

If you are using MySQL, after installing and configuring MySQL you must create the MySQL users and schema as described in this section.

1Log in to MySQL as root. You may need to do this on the machine on which MySQL is installed since root login is typically restricted to local logins only.

mysql -u root -p

2Run the following command at the mysql prompt to create the database (named inservstats by default):

create database inservstats;

3Run the following commands to create the two users cliuser and webuser.

create user cliuser identified by ’cliuserpassword’; create user webuser identified by ’webuserpassword’;

These users have different privilege levels that correspond with optional Apache HTTP Server privilege levels, as described in 3.9 Installing or Upgrading the System Reporter Tools on page 3.24.

■cliuser is the default user name for the sampler and policy change user. This user can create and edit database tables and change database sampling policies (see 7.2.2 Editing Sampling Policies on page 7.4).

■webuser is the default user name for the Web reports user. This user has database read privileges only.

3.20

Installing the Database Server