I really love the fact that I can integrate the userbases for Openfire and Joomla 1.5 but I can't seem to get this fully functional.
The servers are both functioning normally on their own, however Openfire is not recognizing any of the users from Joomla.
in opt/conf/openfire.xml I have the following:
<jive>
<adminConsole>
<!-- Disable either port by setting the value to -1 -->
<port>9090</port>
<securePort>9091</securePort>
</adminConsole>
<locale>en</locale>
<!-- Network settings. By default, Openfire will bind to all network interfaces.
Alternatively, you can specify a specific network interfaces that the server
will listen on. For example, 127.0.0.1. This setting is generally only useful
on multi-homed servers. -->
<!--
<network>
<interface></interface>
</network>
-->
<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://localhost:3306/w00tie_joom15</serverURL>
<username>w00tie_joom15</username>
<password>*****</password>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>25</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>
<setup>true</setup>
<jdbcAuthProvider>
<passwordSQL>select password from jos_openfire_users where username = ?</passwordSQL>
<passwordType>sha1</passwordType>
</jdbcAuthProvider>
</jive>
To keep things simple I let Openfire use the same database as Joomla (hence the DB calls to w00tie_joom15 as the openfire db. Is there anything I'm missing here?