Installing and configuring the Openfire chat server
This topic provides instructions for installing and configuring the Openfire chat server.
Prerequisites
Download the latest Openfire installer from http://www.igniterealtime.org/downloads. Ensure that Openfire is installed and functional before proceeding to the following section.
For documentation related to Openfire, see http://www.igniterealtime.org/projects/openfire/documentation.jsp.
To configure the Openfire database
The following procedure provides instructions for configuring the Openfire database:
Manually create the database. For more information, see the Openfire Database Installation Guide.
- (For Oracle database only) When using Oracle database for Openfire, the following error is displayed in the Openfire logs:
org.jivesoftware.openfire.group.Group - ORA-01400: cannot insert NULL into ("SYSTEM"."OFGROUPPROP"."PROPVALUE")
java.sql.SQLException: ORA-01400: cannot insert NULL into ("SYSTEM"."OFGROUPPROP"."PROPVALUE")
This error occurs because the Oracle database treats the empty string as NULL and the default OfGroupProp table PROPVALUE column setting is NOT NULL. To resolve this issue, alter the table to allow NULL values as shown in the following figure:
NULL values - After the installation is complete, start the OpenFire server using one of the following options:
- Navigate to the OpenfireInstallDir/bindirectory and run one of the following files:
- For Microsoft Windows — openfire.exe
- For Linux — openfire
OR
- Create the Openfire service as per the instructions given in the Openfire Installation Guide and start the service.
- Navigate to the OpenfireInstallDir/bindirectory and run one of the following files:
To configure the Openfire chat server to work with BMC Remedy AR System server
- Open the Openfire Administration Console (default location http://127.0.0.1:9090) and follow the setup steps given below in the Setup wizard:
- Choose the language.
This setting is only for setting the language for web-based administration portal and not for messaging. Under Server settings, provide the host name where Openfire is installed and enter the appropriate values for the ports.
Make sure that the Openfire host name is the same as the XMPPServerName property specified during the Configuring-the-BMC-Remedy-AR-System-server-to-work-with-the-chat-server procedure.- Under Database Settings, choose Standard Database Connection. Select the database name created in step 3 above from the drop-down menu for the Database Driver Presets field and enter the JDBC connection settings and the database user settings.
For example, if the server is MS SQL server and it is hosted on ofserver, that is, the same host name as that of the DB name (openfire) and the DB user (ofuser), the values would be:- Database Driver Presets: 'Microsoft SQLServer'
- (Automatically populated once preset is selected) JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver
- (Provide the hostname:port and the database name) Database URL: jdbc:jtds:sqlserver://DatabaseServer:1433/openfire;appName=jive
- Username: ofuser
Password: <password>
- Choose the language.
- Under Profile Settings, choose the Default option.
- Under Administrator Account, enter a valid password for the user admin.
The Openfire chat server configuration is complete.