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

10. Confirm that Modify Security Settings is selected, enter a root password, and then retype the
password to confirm.
CAUTION: Be sure to record the password for later reference.
11. Make sure that Create An Anonymous Account is not selected and then click Next.
12. Click Execute.
13. When prompted, click Finish.
CAUTION: System Reporter only supports and creates MyISAM tables. Conversion of these
tables to use any other type of storage engine is not supported.
Setting the max_allowed_packet parameter
Change the max_allowed_packet MySQL parameter by editing its value in the MySQL initialization
file.
•
On Linux, the default initialization file is /etc/my.cnf.
•
On Windows, the default initialization file is C:\Program Files\MySQL\MySQL Server
5.1\my.ini
.
The initialization file should include the following line:
max_allowed_packet=32M
After changing the max_allowed_packet parameter, you need to restart the MySQL server.
•
On Windows you can do this by restarting the MySQL service.
•
On Linux, you can run:
/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.
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.
1.
Log 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
2. Run the following command at the mysql prompt to create the database (named inservstats
by default):
create database inservstats;
3. Run the following commands to create the two users cliuser and webuser.
create user cliuser identified by ’cliuserpassword’;
create user webuser identified by ’webuserpassword’;
40 Installation, Configuration, Update, and Removal