openfire集成自己的用户

  最近在看OPenfire的用户集成管理Custom Database Integration Guide,按照官方的文档资料无论如何也集成不了;我们现有的系统,最后几经周折终于搞定.别的就不多说了具体配置文件如下:

<?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> 
  <admin>
    <authorizedUsernames>liwei, admin</authorizedUsernames>
  </admin> 
  <locale>zh_CN</locale> 
  <provider>
    <auth>
      <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
    </auth> 
    <user>
      <className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
    </user> 
    <group>
      <className>org.jivesoftware.openfire.group.JDBCGroupProvider</className>
    </group>
  </provider> 
  <jdbcProvider> //需要集成系统的数据库;
    <driver>com.mysql.jdbc.Driver</driver> 
    <connectionString>jdbc:mysql://localhost:3306/test?user=root&amp;password=root</connectionString>
  </jdbcProvider> 
  <jdbcAuthProvider>
    <passwordSQL>SELECT password FROM user_account WHERE Username=?</passwordSQL> 
    <passwordType>plain</passwordType>
  </jdbcAuthProvider> 
  <jdbcUserProvider> //集成用户
    <loadUserSQL>SELECT name,email FROM user_account WHERE Username=?</loadUserSQL> 
    <userCountSQL>SELECT COUNT(*) FROM user_account</userCountSQL> 
    <allUsersSQL>SELECT username FROM user_account</allUsersSQL> 
    <searchSQL>SELECT username FROM user_account WHERE</searchSQL> 
    <usernameField>Username</usernameField> 
    <nameField>name</nameField> 
    <emailField>email</emailField>
  </jdbcUserProvider> //------------
  <connectionProvider>
    <className>org.jivesoftware.database.DefaultConnectionProvider</className>
  </connectionProvider> 
  <database>
    <defaultProvider>
      <driver>com.mysql.jdbc.Driver</driver> 
      <serverURL>jdbc:mysql://localhost:3306/openfire</serverURL> 
      <username>root</username> 
      <password>root</password> 
      <testSQL>select 1</testSQL> 
      <testBeforeUse>true</testBeforeUse> 
      <testAfterUse>true</testAfterUse> 
      <minConnections>5</minConnections> 
      <maxConnections>15</maxConnections> 
      <connectionTimeout>1.0</connectionTimeout>
    </defaultProvider>
  </database> 
  <!-- Fin configuration  --> 
  <setup>true</setup> 
  <log>
    <debug>
      <enabled>true</enabled>
    </debug>
  </log>
</jive>

评论

7 楼 popo123 2009-07-03  

现在直接改在数据库里面配了，烦死了

6 楼 FGhost 2009-02-06  

hhren1984 写道

你这个和原教程写的有什么区别啊，除了Username字段大写以外

我看也没啥区别!

5 楼 hannover2008 2008-12-02  

该配置文件怎么不起作用?请指教下,[e-mail]

4 楼 hhren1984 2008-10-29  

你这个和原教程写的有什么区别啊，除了Username字段大写以外

3 楼 cary 2008-10-12  

<div class='quote_title'>liwei888 写道</div>
<div class='quote_div'>
<p>  最近在看OPenfire的用户集成管理Custom Database Integration Guide,按照官方的文档资料无论如何也集成不了;我们现有的系统,最后几经周折终于搞定.别的就不多说了具体配置文件如下:</p>
<p>&lt;?xml version="1.0" encoding="UTF-8"?&gt;</p>
<p>&lt;!--<br/>    This file stores bootstrap properties needed by Openfire.<br/>    Property names must be in the format: "prop.name.is.blah=value"<br/>    That will be stored as:<br/>        &lt;prop&gt;<br/>            &lt;name&gt;<br/>                &lt;is&gt;<br/>                    &lt;blah&gt;value&lt;/blah&gt;<br/>                &lt;/is&gt;<br/>            &lt;/name&gt;<br/>        &lt;/prop&gt;</p>
<p>    Most properties are stored in the Openfire database. A<br/> property viewer and editor is included in the admin console.<br/>--&gt;<br/>&lt;!-- root element, all properties must be under this element --&gt;<br/>&lt;jive&gt; <br/>  &lt;adminConsole&gt; <br/>    &lt;!-- Disable either port by setting the value to -1 --&gt;  <br/>    &lt;port&gt;9090&lt;/port&gt;  <br/>    &lt;securePort&gt;9091&lt;/securePort&gt; <br/>  &lt;/adminConsole&gt;  <br/>  &lt;admin&gt; <br/>    &lt;authorizedUsernames&gt;liwei, admin&lt;/authorizedUsernames&gt; <br/>  &lt;/admin&gt;  <br/>  &lt;locale&gt;zh_CN&lt;/locale&gt;  <br/>  &lt;provider&gt; <br/>    &lt;auth&gt; <br/>      &lt;className&gt;org.jivesoftware.openfire.auth.JDBCAuthProvider&lt;/className&gt; <br/>    &lt;/auth&gt;  <br/>    &lt;user&gt; <br/>      &lt;className&gt;org.jivesoftware.openfire.user.JDBCUserProvider&lt;/className&gt; <br/>    &lt;/user&gt;  <br/>    &lt;group&gt; <br/>      &lt;className&gt;org.jivesoftware.openfire.group.JDBCGroupProvider&lt;/className&gt; <br/>    &lt;/group&gt; <br/>  &lt;/provider&gt;  <br/>  &lt;jdbcProvider&gt; //需要集成系统的数据库;<br/>    &lt;driver&gt;com.mysql.jdbc.Driver&lt;/driver&gt;  <br/>    &lt;connectionString&gt;jdbc:mysql://localhost:3306/test?user=root&amp;amp;password=root&lt;/connectionString&gt; <br/>  &lt;/jdbcProvider&gt;  <br/>  &lt;jdbcAuthProvider&gt; <br/>    &lt;passwordSQL&gt;SELECT password FROM user_account WHERE Username=?&lt;/passwordSQL&gt;  <br/>    &lt;passwordType&gt;plain&lt;/passwordType&gt; <br/>  &lt;/jdbcAuthProvider&gt;  <br/>  &lt;jdbcUserProvider&gt; //集成用户<br/>    &lt;loadUserSQL&gt;SELECT name,email FROM user_account WHERE Username=?&lt;/loadUserSQL&gt;  <br/>    &lt;userCountSQL&gt;SELECT COUNT(*) FROM user_account&lt;/userCountSQL&gt;  <br/>    &lt;allUsersSQL&gt;SELECT username FROM user_account&lt;/allUsersSQL&gt;  <br/>    &lt;searchSQL&gt;SELECT username FROM user_account WHERE&lt;/searchSQL&gt;  <br/>    &lt;usernameField&gt;Username&lt;/usernameField&gt;  <br/>    &lt;nameField&gt;name&lt;/nameField&gt;  <br/>    &lt;emailField&gt;email&lt;/emailField&gt; <br/>  &lt;/jdbcUserProvider&gt; //------------ <br/>  &lt;connectionProvider&gt; <br/>    &lt;className&gt;org.jivesoftware.database.DefaultConnectionProvider&lt;/className&gt; <br/>  &lt;/connectionProvider&gt;  <br/>  &lt;database&gt; <br/>    &lt;defaultProvider&gt; <br/>      &lt;driver&gt;com.mysql.jdbc.Driver&lt;/driver&gt;  <br/>      &lt;serverURL&gt;jdbc:mysql://localhost:3306/openfire&lt;/serverURL&gt;  <br/>      &lt;username&gt;root&lt;/username&gt;  <br/>      &lt;password&gt;root&lt;/password&gt;  <br/>      &lt;testSQL&gt;select 1&lt;/testSQL&gt;  <br/>      &lt;testBeforeUse&gt;true&lt;/testBeforeUse&gt;  <br/>      &lt;testAfterUse&gt;true&lt;/testAfterUse&gt;  <br/>      &lt;minConnections&gt;5&lt;/minConnections&gt;  <br/>      &lt;maxConnections&gt;15&lt;/maxConnections&gt;  <br/>      &lt;connectionTimeout&gt;1.0&lt;/connectionTimeout&gt; <br/>    &lt;/defaultProvider&gt; <br/>  &lt;/database&gt;  <br/>  &lt;!-- Fin configuration  --&gt;  <br/>  &lt;setup&gt;true&lt;/setup&gt;  <br/>  &lt;log&gt; <br/>    &lt;debug&gt; <br/>      &lt;enabled&gt;true&lt;/enabled&gt; <br/>    &lt;/debug&gt; <br/>  &lt;/log&gt; <br/>&lt;/jive&gt;</p>
</div>
<p> </p>

2 楼 liwei888 2008-10-11  

修改原来的配置文件!

1 楼 spiderbob 2008-10-07  

你这xml文件怎么命名啊
你这xml配置文件放在哪啊，是放在openfire的conf目录下？