HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 39
Setting the max_allowed_packet parameter, Creating MySQL Users and Schema
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 39 highlights
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 "Editing Sampling Policies" (page 115)). • 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 Tools" (page 42)), the installer creates two Apache HTTP Server config.tcl files to store the user names and passwords for the cliuser and the webuser. See "Modifying the Apache 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