Fiji Web Design
Welcome, Guest
Please Login or Register.    Lost Password?
Unable to get this working (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Unable to get this working
#390
DJJester (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Unable to get this working 3 Years, 2 Months ago Karma: 0  
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?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#397
admin (Admin)
Admin
Posts: 475
graph
User Online Now Click here to see the profile of this user
Re:Unable to get this working 3 Years, 2 Months ago Karma: 10  
That looks fine. Did you try loggin into the account once with Joomla?
It takes Joomla one login to sync the users.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#404
DJJester (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:Unable to get this working 3 Years, 2 Months ago Karma: 0  
I did log into the account in joomla and my account shows up in the jos_openfire_users table. However there appears to be no connection occurring between openfire and that table.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#662
schmutzler (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:Unable to get this working 3 Years ago Karma: 0  
I have the same problem. I'm using the latest Openfire and Plugin, when an account logs on to Joomla, an entry is made in jos15_openfire_users, but Openfire does not recognize it. (Yes, I've changed the prefix to jos15 in the XML file ) There is still only the admin user shown in the user list and I can only logon to Openfire with this account.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#663
admin (Admin)
Admin
Posts: 475
graph
User Online Now Click here to see the profile of this user
Re:Unable to get this working 3 Years ago Karma: 10  
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#664
schmutzler (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:Unable to get this working 3 Years ago Karma: 0  
You've got mail Hopefully you can figure out, why it doesn't work.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Joomla Downloads

DownloadsDownload our free Joomla! Components, Modules and Plugins.