Chapter 2   Database and Additional Software


Additional software must be installed to operate the iPlanet Market Maker software correctly. See the section "Software Requirements" contained in Chapter 1 of this Installation Guide.

The following sections are contained in this chapter:

• iPlanet Market Maker Database Setup

• JDK

• iPlanet Directory Server (iDS)

• iPlanet Web Server (iWS)

• iPlanet Application Server (iAS)

• iPlanet Messaging Queue (iMQ)

• Actuate

iPlanet Market Maker Database Setup

---

---

Note	This section is informational only. No user installation steps are performed in this section. The directory structures changed from Version 1.0 SP1 to Version 4.0.

---

Each of the modules (Catalog, Pricing, Community, Architecture, Auction, Negotiations, Exchange, and Order Management System) has its own module owned by separate database schema owners. The schema owners are CAT, COM, CMN, PRI, OMS, ESV, AUC, EXC, and RFX. All of the objects (for example, table, sequences, and so forth) owned by these schema owners are granted to the application user (for example, VORTEX). The iPlanet Market Maker User Interface connects to the database using the application user.

The installation of each module is performed by using <install_directory>/setup/bin/installsql.sh, which in turn calls the install.sh file from the <install_directory>/<modulename>B/sql directory (for example, iMM/auctionB/sql). The create table scripts of respective modules (for example, <install_directory>/iMM/<modulename>B/sql/schema) should be examined, and modified depending on the expected size of the iPlanet Market Maker database, especially for table and index storage. The following table shows the default schema setup for the iPlanet Market Maker database

Table 2-1    Default Schema

MODULE NAME	DEFAULT SCHEMA NAME	DEFAULT DATA TABLESPACE	DEFAULT INDEX TABLESPACE	DEFAULT TEMPORARY TABLESPACE
Architecture (common)	CMN	CMN_TS	CMN_XTS	TEMP
Catalog	CAT	CAT_TS	CAT_XTS	TEMP
Pricing	PRI	PRI_TS	PRI_XTS	TEMP
Auction	AUC	AUC_TS	AUC_XTS	TEMP
Negotiations	RFX	RFX_TS	OMS_XTS	TEMP
Order Management System	OMS	OMS_TS	OMS_XTS	TEMP
ESV	ESV	ESV_TS	ESV_XTS	TEMP
Exchange	EXC	EXC_TS	EXC_XTS	TEMP
Community	COM	COM_TS	COM_XTS	TEMP
iPlanet Market Maker Application User	VORTEX	CMN_TS	CMN_XTS	TEMP

JDK

---

How to Identify the JDK Version

After installing JDK 1.2.2_07, confirm that the right JDK is being used: java -version

If the wrong version of JDK is reported, try which java and change your PATH accordingly (the default location for JDK 1.2.2_07 is /usr/java1.2)

Installing the JDK Patches

You must install any patches to the Java Development Kit (JDK) before installing the JDK 1.2.2 Standard Edition. Download these patches from the web site:

http://java.sun.com/products/jdk/1.2/.

Download the 1.2.2_07_

_ sparc_5.6 or 5.8 patch. Confirm the Solaris version number (must be 2.6 or 8).

For additional JDK Patch Information, see the section, JDK Patch Information, contained in Chapter 1 of this Installation Guide.

To install the JDK patches:

1. Expand and decompress this patch, which can be identified by its gz extension, by entering:

   % tar xvf <filename>

   This should create a directory which contains four .tar.z files.

2. Change your directory to this newly created one and decompress these files in that directory by entering:

   % compress -d *.Z

3. Expand these files by entering:

   %find . name "*.tar" exec tar xvf {} \ ;

   Each of these files, in turn, creates a directory with a readme.txt file and the actual patch. You may want to copy these patch files to your var/spool/patch directory for future reference. If you do this, remember to do a cp -r because it is a directory.

4. Install these patches by entering:

   % patchadd <filename> with path (for each patch)

Installing JDK

Download the J2SE: Java 2 Standard Edition (1.2.2_07) Production Release for Solaris (English) from the web site:

http://www.sun.com/software/solaris/java/download.html

1. Follow Steps 1-3 in the previous section to expand and decompress these files. The 1.2.2_07_jdk_sparc.tar file that you just downloaded from the Java web site gives you six sets of files and four packages after extraction.

2. Delete the tar files and extracted directories because they are not needed.

3. To install the JDK, run the following command:

   pkgadd -d . SUNWj2rt SUNWj2dev SUNWj2man SUNWj2dem

iPlanet Directory Server (iDS)

---

How to Identify the iPlanet Directory Server Version

The command to find out the version of iPlanet Directory Server that is running on NT/Solaris:

Go to /export/home/ids/shared/bin and execute this line:

ldapsearch -b "cn=monitor" -s base -h <ldap_host> -p <ldap_portnumber> "objectclass=*" | grep version

It prints something like this:

version=Netscape-Directory/4.13 B00.139.0843 dataversion=us77273.red.iplanet.com:389 020000927002141 0

Installing the iPlanet Directory Server

1. Run setup.

2. Choose all defaults during installation.

   
   

   ---

   Note	For more information, go to: http://docs.iplanet.com/docs/manuals/directory.html or consult your iPlanet Directory Server Installation Manual.

   ---

   
   

iPlanet Web Server (iWS)

---

Installing iPlanet Web Server

1. Run setup.

2. Choose all defaults during installation.

   
   

   ---

   Note	For more information, go to: http://docs.iplanet.com/docs/manuals/enterprise.html or consult your iPlanet Web Server Installation Manual.

   ---

   
   

Web Server Component Issue

When installing the web server component alone, the following error is displayed in the iPlanet_MarketMaker_postinstall.log file:

IAS_SERVER_ROOT=null instsupp/bin/postinstall: /export/home/imm/iMM/mm.cshrc: cannot create

The user can ignore this error message.

iPlanet Application Server (iAS)

---

Installing the iPlanet Application Server

1. Run setup.

2. Choose all defaults during installation.

iPlanet Messaging Queue (iMQ)

---

Installing iPlanet Messaging Queue

See: http://docs.iplanet.com/docs/manuals/javamq.html

Troubleshooting the iMQ Installation

iMQ Memory Error
iMQ should be started with at least 128Mb. If not, it will use the default of 16Mb which is too low.

If there is not enough memory for imqbroker, you might see the following error in the imm.log file:

java.lang.OutOfMemoryError

This error can come either from imqbroker or from iMM router (used in the Exchange module). An out of memory error in the imm.log file comes from iPlanet Market Maker (router) and not from the iMQ server (imqbroker). To fix this you should increase the maximum memory used by imqbroker. Following is an example of how to do this:

jmqbroker -vmargs -Xmx128Mb

or, for setting minimum and maximum:

jmqbroker -vmargs -Xmx128Mb - Xms64Mb

The administrator should refer to the iMQ log for errors in the iMQ.

If an out of memory error results from the router process, the imm/bin/ExchangeRouter.bash should be modified to increase the amount of maximum memory (the default value is 128MB).

The router should then be stopped and restarted.

On Solaris 2.6 - When Patch is Not Installed
When starting imqbroker, an error message might appear:

/bin/sparc/native_threads/java: fatal: libCrun.so.1: open failed: No such file or directory

This is not an iPlanet Market Maker problem, however. It happens specifically on Solaris 2.6 when patch 105591-08 is not installed.

You can obtain the required path from:

http://sunsolve.Sun.COM/pub-cgi/show.pl?target=patches/patch-access

Actuate

---

Actuate Report Writer Deployment

The Actuate reporting system allows you to create reports for the iPlanet Market Maker software. Actuate reports support graphical representations of the data, and data can also be displayed in spreadsheets.

The Actuate software is included (along with documentation) on a separate CD (3RD PARTY PRODUCTS) in your iPlanet Market Maker system package.

There are two versions of the developer workbench in Desktop Products:

• e.Reporting Designer

• e.Reporting Designer Professional

The e.Reporting Designer Professional software has Java support through JNI. The Actuate server components are ReportCast and e.Reporting Server. The iPlanet Market Maker software supports Actuate e.Reporting Suite 5, Release 5.

Contact Actuate (http://www.actuate.com) Professional Services for help on developing additional reports.

---

Note	iPlanet Market Maker ships with seven sample Actuate reports. Those reports are installed in the reports directory within the iPlanet Market Maker software.

---

Report Deployment Instructions

The iPlanet Market Maker 4.5 reports are certified with Actuate 5.0.

To run the reports, install Actuate 5.0 according to the instructions below. After installing and configuring all of the Actuate components, run the LDAP 2 Database sync utility that comes with the iPlanet Market Maker product to sync up the LDAP data with the Oracle database. This utility needs to be run before executing the Actuate reports. The instructions for this utility appear at the end of this document.

Run the Report on the Report Server

1. Insert the CD labeled eReporting Server Release5 into the CDROM drive. You can run the report server either on SunOS or Windows NT. To install on Solaris, you need to insert the CD into a Solaris box with a CDROM and mount it.

2. Find the directory Manual and SunOS (for the Windows version, open the directory NTServer).

3. Follow the instructions included in the file SERVER-UNIX-INSTALL.PDF in this directory. For installation on Windows NT, follow the instructions in the file SERVER-NT-INSTALL.PDF.

4. To install report server, open the SunOS (for the Windows version, open the directory NTServer) to find the installation executable file.

5. Install the report server following the instructions in the files described in step # 3 above.

6. Once the report server is installed, Actuate Administrator Desk Top (ADT) needs to be installed to administer the report server. The report server itself does not have a UI. ADT is the UI for the report server. This is available only on Windows.

7. In the same CD, open the folder ADT and run Setup.exe to install ADT on a Windows OS machine. Again, ADT does not need to be installed on the same machine as the report server.

8. Once installation is complete, launch the ADT and click on the menu File/ Administrator.

   In the Encyclopedia login window, type in the user name as Administrator, the password that was created when installing report server (default is blank), and volume as the name of the report server. For example Administrator, no password (just empty), and volume as myreportservermachinename.mydomain.com

9. In the IMM CD, find \imm_home\Reports\ directory.

   The reports are saved under five directories:

   • Auction

   • Catalog

   • Pricing

   • RFX

   • OMS

   There are, in total, seven sample reports included with the iPlanet Market Maker software.

10. In ADT, at the left palette, click on the report server name slot, (right under main slot labeled Encyclopedia) to select it (for example, yourmachine.yourdomai.com).

11. Click the menu File/New Folder to create a folder for iPlanet Market Maker reports. You can name this folder whatever you would like (for example, iMM).

12. Select the new (iMM) folder, right click on it, and create five new folders. For these five new folders that you created under the root folder iMM, you may name them the same as the ones in your IMM CD (for example, Auction, Catalog), or any names you prefer.

13. Select the first folder, Auction, under iMM, and right click.
    1. Select Add to open the browser.

    2. Select the .rox file (which is the executable file) from the Auction directory (Auction Summary.rox) from your iPlanet Market Maker installation.

    3. Follow the same procedure to add the remaining report executables for each of the modules. Auction, Catalog and Pricing will have one executable, while OMS and RFX will have two executables.

14. Click Save to upload the file into your report server.

    The reports are ready to execute on your report server.

15. Execute your reports by double clicking each of the seven reports, one by one. After you double click a report, a window opens allowing you to enter the Database connection details. Click Database on the second row and enter values for user/passwd/Hoststring (for example, vortex/vortex/vortex).

16. Enter OK to execute your entries.

View and Run the Report Through a Web Browser (Netscape Navigator or Microsoft IE)

1. The Reportcast Server component needs to be installed to view the reports on your report server web. Make sure that Reportcast is installed in the same machine as your web server. Actuate has certified Reportcast Server with iPlanet Web Server.

2. Insert the CD labeled Desktop Products Reportcast Release 5 into the CD ROM. Find the installation information in the folder labeled Manual in the root directory of the CD ROM. For installation information, open the file REPORTCAST-UNIX-INSTALL.PDF.

3. Find the directory labeled REPORTCAST. Inside this directory, there are separate folders for different web servers.

4. Follow the instructions in REPORTCAST-UNIX-INSTALL.PDF to install Reportcast. When installing the Reportcast Server, you also have to install the agent.

5. After you successfully install the Reportcast Server, open your browser, and type http://<web server name>/acweb/<report server name> to access your folders in the report server and run or view reports.

   For example, if the Reportcast Server and the web server are installed on machine1.foo.com/port 8080, and the Report server on machine2.foo.com, in the browser type http://machine1.foo.com:8080/acweb/machine2.foo.com and press the Enter key. This asks for userid and passwd. Default is Administrator, and no passwd.

6. After the login, click on your iMM folder. You should now see all five folders: Auction,...OMS. Click on a particular module to view or run the reports.

View and Run the Report Using Actuate End User Desk Top (EUDT)

1. Insert the CD labeled Desktop Products Reportcast into the CD ROM. Find the installation information in the folder labeled Manual in the root directory of the CD ROM. Open the file ENDUSER-DESKTOP-INSTALL.PDF for installation information.

2. Find the directory labeled EUDT. Run Setup.exe to install End user desk top.
   • Once EUDT is open, it lists all of the folders and report instances and executables from the report server.

   • The report instances can be viewed, and the executables can be run.

Setup and Run Reports (MappingMain Program)

Follow the steps outlined below to run the MappingMain program that synchronizes the community information from LDAP to Oracle community tables. The iPlanet Market Maker reports developed using Actuate need to have Oracle community tables populated before running them.

Before executing this program you need to setup the properties in MappingData.properties. Look at all of the properties, and set the correct values accordingly.

1. Execute MappingMain program periodically:

   * Set up the environment by running $IMM_HOME/mm.kshrc (if you use korn shell) or $IMM_HOME/mm.cshrc (if you use c shell) for iPlanet Market Maker user or custom user. This sets up iPlanet Market Maker environment.

   * Edit $IMM_HOME/properties/MappingData.properties file to:

   1. Setup MAIL section (MAIL_SERVER, MAIL_TO, MAIL_FROM, MAIL_SUBJECT values) for the program to notify by email in case of program failure.

   2. Setup LOGFILE section (LOGFILE_FREQUENCY, LOGFILE_BASEDIRECTORY, LOGFILE_EXTENSION) for the program to write logging information. This directory needs cleanup on periodic basis.

      * Setup a cron job in the iPlanet Market Maker user or custom user to run the following program at desired intervals, preferably daily, before running the daily reports. This can be executed on the command line, and whenever the community information needs to be synchronized to Oracle for reporting purposes.
      java com.iplanet.ecommerce.vortex.reports.MappingMain

2. Refer to $IMM_HOME/reports/ReadmeReportsIMM.htm for deployment of the iPlanet Market Maker reports using Actuate tools.

The report files in the $IMM_HOME/reports/ directory need to be deployed from Windows client. You need to transfer these binary files from UNIX to Windows so that Actuate Administration Desktop can be used. Actuate Administration Desktop is available in Windows only.