In this section: |
MySQL is a free open source database server that you can use for the WebFOCUS Repository. Official information on MySQL is available at:
This section is provided to help those less familiar with MySQL with the installation and configuration of MySQL for use with WebFOCUS.
You can install MySQL as follows:
The following page contains links to download MySQL:
http://dev.mysql.com/downloads/mysql/5.0.html
You can download either the regular Windows install or the Windows essential install.
The following page includes documentation on installing, configuring, administering, and using MySQL:
A typical installation is sufficient for WebFOCUS. You can keep all default settings during the installation and configuration.
When you configure or migrate a MySQL repository for WebFOCUS 8.0, you must increase the size of the max_allowed_packet parameter. MySQL recommends that the value of the max_allowed_packet parameter for MySQL Client and MySQL Server should be increased for applications that use of binary large objects (BLOBs) and character large objects (CLOBs), such as WebFOCUS.
For more information on this topic and how to change the value of the max_allowed_packet parameter for MySQL Client and MySQL Server, see the following website:
http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
By default, you run MySQL as a Windows service. To start, stop, or restart MySQL:
After you install MySQL it may be running by default and may start automatically with Windows.
You administer MySQL using a command line tool. You can launch this from the Start menu by selecting Programs, MySQL, MySQL Server 5.0, and then MySQL Command Line Client.
Log on to the command line tool using the password you specified during the MySQL installation.
The following prompt should appear:
mysql>
From this prompt, you can execute SQL commands and administer the database server.
MySQL documentation is available online at the following website:
How to: |
You can use the MySQL command line tool to create a database and user for ReportCaster.
You can do this by selecting Start, Programs, MySQL, MySQL Server 5.0, and then MySQL Command Line Client.
CREATE DATABASE webfocus8;
where:
Is the name of the database you will use for WebFOCUS repository. This is case-sensitive.
You should receive a response like the following:
Query OK, 1 row affected (0.03 sec)
show databases;
You should receive a response that includes your new database. For example:
+----------+
| Database |
+----------+
| mysql |
| webfocus8|
| test |
+----------+
3 rows in set (0.00 sec)
GRANT ALL PRIVILEGES ON wf.* TO 'wfuser'@'%' IDENTIFIED BY 'wfpass';
where:
Is the name of the database you will use for WebFOCUS. This is case-sensitive in some environments.
Indicates that the database is accessible from any host. To limit which hosts can access the database, provide the host name or IP address of the machine running the WebFOCUS Client and the ReportCaster Distribution Server in place of %. If the application server is on a different machine, you will need to type the command twice to grant access from both hosts.
Is the user ID you are creating. This is case-sensitive in some environments. The user ID and password are part of MySQL and not the operating system.
Is the password for the user ID. This is case-sensitive.
If you need to change your password, you can retype the GRANT command to provide the new password. The new values will overwrite any existing password.
use mysql
This selects the default mysql database within the MySQL Database Server.
Ensure that the user ID you created exists and is associated with your database by typing the following command at the mysql> prompt:
select user,host,db from db;
This query returns all user IDs and associated host names with the databases they can access. For example:
+--------+------+---------+ | user | host | db | +--------+------+---------+ | wfuser |% | wf +--------+------+---------+
After making user ID changes, you can ensure they are refreshed by typing the following command at the mysql> prompt:
FLUSH PRIVILEGES;
use wf
where:
Is the name of the database you will use for WebFOCUS. This is case-sensitive in some environments.
show tables;
If you have not yet created tables, you should receive the following:
Empty set (0.00 sec)
After creating the repository tables, you can use this to confirm that the tables exist.
The MySQL JDBC driver is known as MySQL Connector/J 3.1.
The following page contains links to download MySQL Connector/J 3.1:
http://dev.mysql.com/downloads/connector/j/3.1.html
Download the latest ZIP file containing the source code and Java binary. For example:
mysql-connector-java-3.1.14.zip
MySQL has an aggressive release cycle, so the number in this file name may vary.
mysql-connector-java-3.1.14-bin.jar
WebFOCUS |