Openfire安装整合用户手册

Openfire安装整合用户手册
冷志勇

官网 http://www.igniterealtime.org/

安装手册 参考
http://wenku.baidu.com/view/3d27bccd0508763231121296.html

我选择第一种数据库安装
安装spark 测试可以通讯

Linux 安装 下载 带jre的rpm包
http://www.igniterealtime.org/downloads/index.jsp
openfire-3.7.1-1.i386.rpm


[img]http://dl.iteye.com/upload/attachment/602609/1b4e4cb8-d875-31a4-b3c7-814fa03ec14e.png[/img]

Wget http://download.igniterealtime.org/openfire/openfire-3.7.1-1.i386.rpm
rpm –ivh openfire-3.7.1-1.i386.rpm
默认安装到/opt/openfire目录
启动方式 /etc/init.d/openfire start

整合用户手册
修改目录/conf/openfire.xml配置文件 开发工程中/target/conf/openfire.xml
修改后如下所示：
<?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>
<!—默认管理员lzy -->
<admin>
<authorizedUsernames>14001,admin</authorizedUsernames>
</admin>
<!--lzy -->
<locale>zh_CN</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>
-->
<!-- Authentication IntegrationS lzy -->
<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://58.59.97.3:3306/fajxc?user=admin&password=fuao20091</connectionString>
</jdbcProvider>
<jdbcAuthProvider>
<passwordSQL>SELECT password FROM users WHERE loginName=?</passwordSQL>
<passwordType>plain</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT a.loginName as loginName,b.email as email FROM users a,employee b WHERE a.loginName=? and a.loginName = b.empNo</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM users</userCountSQL>
<allUsersSQL>SELECT loginName FROM users</allUsersSQL>
<searchSQL>SELECT loginName FROM users WHERE</searchSQL>
<usernameField>loginName</usernameField>
<nameField>userName</nameField>
<emailField>email</emailField>
</jdbcUserProvider>
<!-- Authentication IntegrationE lzy -->
<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://58.59.97.3:3306/openfire</serverURL>
<username>admin</username>
<password>fuao20091</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>
<log>
<debug>
<enabled>true</enabled>
</debug>
</log>
</jive>

替换原来服务器的配置文件 然后重启服务器 登录后台
服务器---服务器管理器---系统属性—修改privider.auth. className 和privider.user. className
有用户组的话也修改privider.group. className(值对应配置文件的路径)

注意

默认管理员要在系统中用户中存在
配置文件对应表ofProperty