|
Configuring
the Access Component for Record Builder (UNIX)
Contents
Introduction
Requirements
Document Conventions
Procedure
Using the Access Component with Your User Data
Introduction
This document
explains how to configure the Access
component for Record Builder in UNIX operating systems, using MySQL
AB's MySQL software (beginning with SiteSearch 4.1.2) or Hughes
Technologies Pty. Ltd.'s Mini Structured Query Language (mSQL) software
(SiteSearch 4.1.1 and erarlier versions.). The
instructions below describe how to create a SQL database called rbdb
from a sample data file and configure the Access component to start when
Record Builder starts up.
Requirements
Before completing
the steps below, you must install
version 4.1.x of the Open SiteSearch WebZ Extension, WebZ, and
Database Builder. See these Web sites for MySQL or mSQL documentation,
which contains information about creating and administering MySQL or mSQL
databases:
Document
Conventions
- <WebZ_root>
refers to the location of your installed WebZ environment that includes
Record Builder.
- SQL server
is the database server used in the Access
component:
- MySQL (beginning
with SiteSearch 4.1.2)
- mSQL (SiteSearch
4.1.1 and earlier versions)
- Items you type
appear in quotes, like this "mysql_rb drop". Type them without
the quotes.
- In some commands
that contain "msql_rb" or "mysql_rb", a link may
obscure the "_" (underscore) in this document.
Procedure
Follow the instructions
below to configure the Access component to work with Record Builder and
to set up a sample database for testing the configuration.
1. Start
your SQL server:
|
2. Does
the <WebZ_root>/mysql/data/rbdb directory (beginning
with SiteSearch 4.1.2) or <WebZ_root>/msql/msqldb/accessdb
directory (SiteSearch 4.1.0/4.1.1) exist in your WebZ directory
structure?
- Yes.
You will delete the existing rbdb database and create a database
from a sample data file for testing purposes. If you wish to retain
any data in your existing rbdb database before continuing, dump
its contents to a text file, as described in step
7. Then go to step 3.
- No.
Go to step 5.
|
3. Drop the
rbdb database.
- Beginning
with version 4.1.2:
- Move
to the <WebZ_root>/scripts directory.
- At
the command prompt, type "mysql
drop" and press Enter.
- You
see this message:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the "rbdb" database? [Y/N]
|
- Type
"y" and press Enter.
- You
see this message:
- Version
4.1.0/4.1.1:
- Move
to the <WebZ_root>/scripts directory.
- At
the command prompt, type "msql
drop" and press Enter.
- You
see this message:
|
4. Stop
and restart your SQL server:
|
5. Create
the rbdb sample SQL database.
This creates
the directory <WebZ_root>/msql/msqldb/rbdb.
|
6. Import
the rbdb.dump sample data file into the rbdb database.
- Beginning
with version 4.1.2:
- At the
command prompt in <WebZ_root>/scripts,
type "mysql_rb
load" and press Enter.
- The
file <WebZ_root>/mysql/rbdb.out
contains the time the database load started and ended.
- Version
4.1.0/4.1.1:
- At the
command prompt in <WebZ_root>/scripts,
type "msql_rb
load" and press Enter.
- The file
<WebZ_root>/msql/rbdb.out
contains a record of the database load.
This creates
the ten database tables that
comprise rbdb and adds sample data to each table.
|
7.
Create and then review the contents of a database "dump" from rbdb
to ensure that the sample data was imported correctly.
- Beginning
with version 4.1.2:
- At the
command prompt in <WebZ_root>/scripts/,
type "mysql_rb
dump" and press Enter.
- This
creates a text file named <WebZ_root>/mysql/rbdb.dump.Dyyyymmdd.Thhmmss,
where yyyymmdd is the current year, month, and day,
and hhmmss is the current time in hours (on a 24-hour
clock), minutes, and seconds.
- Version
4.1.0/4.1.1:
- At the
command prompt in <WebZ_root>/scripts/,
type "msql_rb
dump" and press Enter.
- This
creates a text file named <WebZ_root>/msql/rbdb.dump.Dyyyymmdd.Thhmmss,
where yyyymmdd is the current year, month, and day,
and hhmmss is the current time in hours (on a 24-hour
clock), minutes, and seconds.
All versions:
View the text file in a text editor to see the contents of the database.
The text file should show that the rbdb database has the following
tables: authos, access, dbs, default_groups, groups, members, objects,
pup, resources, and userresource. See rbdb
Database for details about the structure of each table.
|
8. Turn
on the user name and password authorization for the JaSSIRB Access
client in the Access_rb.ini
configuration file:
|
9. Verify
the port for the SQL server. You
were prompted for this port during the Database Builder installation.
If you would like to change the SQL server port or view the current
value of the port, edit/view the SQL server's configuration file
and the AccessServer_rb.ini
configuration file.
The port
is defined in the SQL server's .conf file, as follows:
- Beginning
with version 4.1.2: In
the port variable in the [mysqld] section of the <WebZ_root>/mysql/data/my.cnf
file.
- Version
4.1.1 and earlier:
In the TCP_Port variable in the [general] section of the <WebZ_root>/msql/msql.conf
file.
It is also
defined in the URL variable
in the [JDBC] section of the AccessServer.ini file located in
the <WebZ_root>/ini directory.
Important
Notes: |
(1) The
port values contained in these two variables
MUST be identical for the Access component to run successfully
through the SQL server. |
(2) The port must also have the same value as the URL variable
in the [JDBC] section in AccessServer.ini, the access server
configuration file for WebZ. In other words, the port must have
the same value in my.cnf or msql.conf, AccessServer_rb.ini and
AccessServer.ini. |
(3) If
you change the SQL port, stop
and restart the SQL server:
|
|
10. Shut
down both Record Builder and WebZ.
If Record
Builder or WebZ is running, stop all of the servers (JaSSIRB, ZBaseRB,
JaSSI, ZBase, and OpServe).
Note: |
You
do not need to stop the Web server(s) or the SQL server.
|
|
11. Start
Record Builder and WebZ. |
12. Test
the Access configuration for Record Builder. |
Return
to Contents
Using
the Access Component with Your User Data
After you successfully
test your Access component configuration with the sample rbdb database,
use the schema specified in the rbdb.dump data file or the rbdb
Database topic to create a new instance of the rbdb database. However,
keep the rbdb.dump sample data file intact to be able to recreate the
sample rbdb database if necessary.
Then populate your
new rbdb database with user access data for your Record Builder users
and retest the Access configuration. See Sample
Data for rbdb in the rbdb Database topic for ways that the sample
data illustrates possible uses of the Access component with Record Builder.
Return
to Contents
See Also
Access
Component Overview
Access Client Configuration Files
Access Server Configuration Files
rbdb Database
SQL Scripts and Templates
Operating Record Builder
|