Setting the max_allowed_packet parameter, Creating mysql users and schema – HP 3PAR StoreServ 7000 Storage User Manual
Page 39
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’;
These users have different privilege levels that correspond with optional Apache HTTP Server
privilege levels, as described in
“Installing or Upgrading the System Reporter Tools” (page 42)
.
•
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
).
•
webuser is the default user name for the Web reports user. This user has database read
privileges only.
As part of installing the System Reporter tools (see
“Installing or Upgrading the System Reporter
), the installer creates two Apache HTTP Server config.tcl files to store
the user names and passwords for the cliuser and the webuser. See
HTTP Server Configuration Files” (page 125)
for instructions on editing these config.tcl
files if you change the MySQL usernames and passwords at a later time.
NOTE:
When creating the users, you must assign them passwords in order for System
Reporter to function properly.
Installing the Database Server
39