> Installing the Administration Server > Database Setup

Installing the Administration Server

     Previous  Next    Open TOC in new window    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Database Setup

It has the following topics:

 

Overview

In order to run the installation program, you must first run a script that is downloadable from a BEA web site. The script adds a user account to the database that is used during installation.

NOTE: It is also possible to perform the database setup steps manually. For instructions, see Appendix F: Manual Database Setup Steps..

 

Obtaining the Database Script

To obtain the program:

  1. Open a browser and go to the ALES download site.
  2. Click the AquaLogic Enterprise Security 3.0 link.
  3. On the next page, click the AquaLogic Enterprise Security Database Configuration Tool link.
  4. On the ensuing pages, complete as required and download one of the following files:

    5. Windows—ales300_DBConfigTool_Win32.zip

    UNIX/Linux—ales300_DBConfigTool_unix.tar.gz

 

Running the Database Configuration Tool

After obtaining the file, unzip and run it as follows:

  1. Open DBConfig.bat|sh in an editor and set the following properties:
    • JAVA-HOME — specify the fully-qualified path to a JDK.
    • INSTALL_HOME — specify the fully-qualified path to the directory where you unzipped ales300_DBConfigTool_Win32.zip or ales300_DBConfigTool_unix.tar.gz.
    • DB_JDBC_DRIVER_LOC — For Pointbase and MSSQL, specify the fully-qualified path to the JDBC driver. (This is not required for Oracle or Sybase databases.) Examples:

      • (Pointbase) C:\bea\weblogic92\common\eval\pointbase\lib\pbclient.jar

      (MS-SQL) C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar

  2. Enter dbconfig.bat or dbconfig.sh on a command line. The program issues a number of prompts to answer.
  3. Respond to the prompts as described in the table below:

    4. Prompt
    Description
    Please input DB type<oracle|sybase|mssql|pointbase>
    Enter one of the database names listed.
    Please input JDBC URL
    Enter the JDBC URL for the database server.
    Oracle—jdbc:oracle:thin:@<server>:<port>:<sid>
    Sybase— jdbc:sybase:Tds:<server>:<port>
    Sql Server— jdbc:sqlserver://<server>:<port>
    Pointbase—jdbc:pointbase:server://<server>/ales
    <server>—name or IP address of database machine
    <port>—port where the database listener is running
    <sid>—SID for Oracle database
    Please input JDBC Driver
    Enter the JDBC driver used to connect to the database. This entry varies by database type:
    Oracle—oracle.jdbc.driver.OracleDriver
    Sybase—com.sybase.jdbc3.jdbc.SybDriver
    Sql—com.microsoft.sqlserver.jdbc.SQLServerDriver
    Pointbase—com.pointbase.jdbc.jdbcUniversalDriver
    Please input new database user name
    Enter a username for the account being created.
    Please input new database user password
    Enter a password for the new user.
    Please input database admin username (not required for Pointbase)
    Enter the database administrator user name.
    Please input database admin password (not required for Pointbase)
    Enter the database administrator password.
    Additional Sybase Prompts
    Respond to prompts by entering:
    —Logical name of the device storing policy data
    —Path to the above device (c:\sybase15\ales_policy.dat)
    —Logical name of the device storing log data
    —Path to the above device (c:\sybase15\ales_log.dat)
    —Database name

  4. The script runs and displays messages like the following:

-- Configuring table space [ales_oracle]
** Tablespace [ales_oracle] exists in DB server. Continuing with the same.
-- Creating new user [ales_db_admin] .......Done
-- Configuring ALES role [asi_role]
-- Assigning privs to ALES role .......Done
-- Assigning privs to new user [ales_db_admin].......Done
-- Closing down connection
-- Successfully created ALES Database Account --

At the completion of these steps, you may install the Administration Server. See the next section for instructions.


  Back to Top       Previous  Next