Fiji Web Design
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Unable to get this working (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Unable to get this working
#700
admin (Admin)
Admin
Posts: 475
graph
User Online Now Click here to see the profile of this user
Re:Unable to get this working 2 Years, 11 Months ago Karma: 10  
Yes, the correct config file would look like:

<?xml version="1.0" encoding="UTF-8"?>

<!--
    This file stores bootstrap properties needed by Openfire.
    Property names must be in the format: "prop.name.is.blah=value"
    That will be stored as:
        <prop>
            <name>
                <is>
                    <blah>value</blah>
                </is>
            </name>
        </prop>

    Most properties are stored in the Openfire database. A
    property viewer and editor is included in the admin console.
-->
<!-- root element, all properties must be under this element -->
<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/databasename</serverURL>  
      <username>databaseuser</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>  
  <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://localhost/databasename?user=databasename&amp;password=*******</connectionString>
  </jdbcProvider>
  <jdbcAuthProvider>
     <passwordSQL>SELECT password FROM jos_users WHERE username=?</passwordSQL>
     <passwordType>md5</passwordType>
  </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>
  </jdbcUserProvider>
  <admin>
    <authorizedUsernames>username, username, username</authorizedUsernames>
  </admin>
  <setup>true</setup>
</jive>
The bbcode parser for this forum component is converting the &amp; to &. Otherwise the XML won't be well-formed. DJJester, thanks for sharing this.
 
Report to moderator   Logged Logged  
 
Last Edit: 2009/02/23 00:10 By admin.
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Unable to get this working
DJJester 2008/12/01 20:54
    thread link
thread linkthread link Re:Unable to get this working
admin 2008/12/01 23:33
    thread link
thread linkthread linkthread link Re:Unable to get this working
DJJester 2008/12/02 14:31
    thread link
thread linkthread linkthread linkthread link Re:Unable to get this working
schmutzler 2009/02/06 08:15
    thread link
thread linkthread linkthread linkthread linkthread link Re:Unable to get this working
admin 2009/02/06 08:21
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
schmutzler 2009/02/06 08:39
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
DJJester 2009/02/06 10:09
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
schmutzler 2009/02/06 10:37
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
DJJester 2009/02/14 08:58
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
schmutzler 2009/02/21 05:37
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
admin 2009/02/23 00:09
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
ratzeputz 2009/04/02 00:57
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working
Tomekk1985m 2010/01/21 15:03
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Unable to get this working [resolved]
myn900 2010/03/03 04:08
    thread link
thread linkthread link Re:Unable to get this working
BeerAndPizza 2010/03/19 14:35
    thread link
thread linkthread link Re:Unable to get this working
myn900 2010/03/19 14:52
    thread link
thread linkthread link Re:Unable to get this working
BeerAndPizza 2010/03/19 17:03
    thread link
thread linkthread link Re:Unable to get this working
BeerAndPizza 2010/03/19 17:10
    thread link
thread linkthread linkthread link Re:Unable to get this working
myn900 2010/03/19 17:13
    thread link
thread linkthread linkthread linkthread link Re:Unable to get this working
BeerAndPizza 2010/03/19 17:21
    thread link
thread linkthread linkthread linkthread linkthread link Re:Unable to get this working
myn900 2010/03/19 17:38
    thread link
thread linkthread link Re:Unable to get this working
BeerAndPizza 2010/03/20 00:28
    thread link
thread linkthread link Re:Unable to get this working
jay1980 2010/07/29 00:40
    thread link
thread linkthread link Re:Unable to get this working
Aiken 2011/07/08 00:41
    thread link
thread linkthread link Re:Unable to get this working
BeerAndPizza 2011/07/08 10:12
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.