Sun OpenSSO Enterprise 8.0 Integration Guide

ProcedureTo Configure the Application Server Data Source to Work with Identity Manager

  1. Download the MySQL Connector/J 5.0.

  2. Extract the archive mysql-connector-java-5.0.8.tar.gz.

  3. Copy mysql-connector-java-5.0.8-bin.jar from the above download to /opt/SUNWappserver91/domains/domain1/applications/j2ee-modules/idm/WEB_INF/lib/

  4. Set the password for the Waveset user in MySQL.

    # cd /opt/mysql
    # ./bin/mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 6
    Server version: 5.0.45-log MySQL Community Server (GPL)
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    mysql> SET PASSWORD FOR 'waveset'@'localhost' = PASSWORD('password');
    Query OK, 0 rows affected (0.00 sec)
    mysql> exit
  5. Start the Application Server.

    # /opt/SUNWappserver91/bin/asadmin start-domain domain1
  6. Connect to the data source.

    # cd /opt/SUNWappserver91/domains/domain1/applications/
    # chmod +x lh
    # export WSHOME=/opt/SUNWappserver91/domains/domain1/applications/
    # export CLASSPATH=/opt/SUNWappserver91/lib/appserv-rt.jar:
    # ./lh setRepo -v -tMySQL   -ujdbc:mysql://localhost/waveset -Uwaveset -Ppassword
    Defaulting administrator to 'configurator'.
    Defaulting credentials to 'configurator'.
    DB Server @ jdbc:hsqldb:hsql://
    Defaulting jdbcDriver to ''.
    Checking 'MysqlDataStore:jdbc:mysql://localhost/waveset'...
    Switching to 'MysqlDataStore:jdbc:mysql://localhost/waveset'...
    Getting current location....
    Current Location is 'MysqlDataStore:jdbc:mysql://localhost/waveset'
    userid is 'waveset'
    password is '(set)'
    jdbcDriver is ''