OpenFire Joomla Integration Plugin

OpenFire Joomla Integration Plugin allows the OpenFire XMPP (Jabber) Server to authenticate against the Joomla user database. This allows members of your Joomla website to have Instant Messenger accounts at your domain. Please see the Joomla Instant Messaging extensions page for the full list of free extensions we provide.

OpenFire Joomla Integration Plugin Compatibility

Download OpenFire Joomla Integration Plugin

OpenFire Joomla Plugin Installation

• Download the latest version of OpenFire Joomla from our Joomla OpenFire Integration Project.
• Install the Plugin using the Joomla1.5 online installer.
• Plublish the plugin in your Joomla Plugins manager.
• Edit the openfire configuration file: /config/openfire.xml. The location of this file depends on your OpenFire installation. If you did a manual install, it would be at: /opt/openfire/config/openfire.xml.
• Insert the following lines at end of openfire.xml but before the ending </jive>:

  <!-- Joomla authentication -->  
    <provider>
      <auth>
        <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
      </auth>
      <user>
        <className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
      </user>
    </provider>  
    <jdbcProvider>
      <driver>com.mysql.jdbc.Driver</driver>
      <connectionString>jdbc:mysql://{host}/{db}?user={user}&password={password}</connectionString>
    </jdbcProvider>  
    <jdbcAuthProvider> 
      <passwordSQL>SELECT password FROM jos_openfire_users WHERE username=?</passwordSQL> 
    </jdbcAuthProvider>
    <jdbcUserProvider> 
      <loadUserSQL>SELECT name,email FROM jos_users WHERE username=?</loadUserSQL>  
      <userCountSQL>SELECT COUNT(*) FROM jos_users</userCountSQL>  
      <allUsersSQL>SELECT username FROM jos_users</allUsersSQL>  
      <searchSQL>SELECT username FROM jos_users WHERE</searchSQL>
      <usernameField>username</usernameField>  
       <nameField>name</nameField>  
       <emailField>email</emailField>
       <useConnectionProvider>true</useConnectionProvider>
    </jdbcUserProvider>
    <admin>
      <authorizedUsernames>admin</authorizedUsernames>
    </admin>
    <!-- end Joomla authentication -->

  The values inside <connectionString> should be replaced with the following.
  jdbc:mysql://{host}/{db}?user={user}&password={password}
  {host} is joomla db server, usually its: localhost.
  {user} is Joomla db user.
  {password} is Joomla db password.
  You can get this information from the configuration.php file in Joomla root, or Global configuration page in Joomla admin panel.
• Restart Openfire (/etc/init.d/openfire restart)

Sometimes Openfire does not update the configuration file on restart. So you may have to stop and restart openfire until you see the configuration updated in the openfire database. The database if using SQL would have a table called ofProperties which contains the name and value of the configuration reflected in the XML. When Openfire updates the configuration, it will also remove values from openfire.xml. So don't be alarmed if your edits were removed, it just means openfire finally read it.

In Joomla1.6 and up, the database table prefix is no longer jos_ by default but is a random value. You need to replace all jos_ prefixes in the openfire.xml file with the correct prefix. This is also in your Joomla configuration or you can view it in the database.

Frequently Asked Questions

What are the requirements to run OpenFire Joomla Integration Plugin? You will need OpenFire Server, and Joomla1.5+. Where can I get help with installation You can post your issue in the community forum or contact us for a paid installation and configuration.

Live Showcase

• Coming soon...