局域网聊天服务器(openfire)安装与配置
一.安装mysql
tar -zxvf mysql-5.1.44.tar.gz
cd mysql-5.1.44
./configure --prefix=/usr/local/mysql/
make && make install
cp support-files/my-medium.cnf /etc/my.cnf
/usr/local/mysql/bin/mysql_install_db --user=mysql
chown -R root:mysql /usr/local/mysql/
chown -R mysql /usr/local/mysql/var/
echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
ldconfig
/usr/local/mysql/bin/mysqld_safe --user=mysql &
netstat -tupln | grep 3306
echo "/usr/local/mysql/bin/mysqld_safe --user=mysql & " >> /etc/profile
二.安装openfire
下载openfire.tar.gz (这个是我已经做好的,直接解压就可以用)安装的时候也不会出先错误
下载地址: http://www.kuaipan.cn/file/id_27533970182769603.html
选择普通下载就可以
在mysql数据库中新建openfire数据库,命名为openfire
下在完成后将openfire.tar.gz解压到/usr/local下面
并重新命名 mv openfire.bak openfire
进入到/usr/local/openfire/bin
./openfire start #开启服务
在浏览器中输入http://ip:9090 可看到访问页面(如果不能正常访问在重新开启服务)
在这得用户名为admin 密码为admin 这是我设定的密码,到管理控制台里面可以进行更改
进入之后如下图所示
新建聊天用户
也可在数据库中批量导入,进入openfire数据库,sql> show tables;
mysql> show tables;
+----------------------+
| Tables_in_openfire |
+----------------------+
| fpAgent |
| fpAgentProp |
| fpAgentSession |
| fpChatSetting |
| fpDispatcher |
| fpDispatcherProp |
| fpOfflineSetting |
| fpQueue |
| fpQueueAgent |
| fpQueueGroup |
| fpQueueProp |
| fpRouteRule |
| fpSearchIndex |
| fpSession |
| fpSessionMetadata |
| fpSessionProp |
| fpSetting |
| fpWorkgroup |
| fpWorkgroupProp |
| fpWorkgroupRoster |
| ofBookmark |
| ofBookmarkPerm |
| ofBookmarkProp |
| ofConParticipant |
| ofConversation |
| ofExtComponentConf |
| ofGroup |
| ofGroupProp |
| ofGroupUser |
| ofID |
| ofMessageArchive |
| ofMucAffiliation |
| ofMucConversationLog |
| ofMucMember |
| ofMucRoom |
| ofMucRoomProp |
| ofMucService |
| ofMucServiceProp |
| ofOffline |
| ofPfRules |
| ofPresence |
| ofPrivacyList |
| ofPrivate |
| ofProperty |
| ofPubsubAffiliation |
| ofPubsubDefaultConf |
| ofPubsubItem |
| ofPubsubNode |
| ofPubsubNodeGroups |
| ofPubsubNodeJIDs |
| ofPubsubSubscription |
| ofRRDs |
| ofRemoteServerConf |
| ofRoster |
| ofRosterGroups |
| ofSASLAuthorized |
| ofSecurityAuditLog |
| ofSipPhoneLog |
| ofSipUser |
| ofUser |
| ofUserFlag |
| ofUserProp |
| ofVCard |
| ofVersion |
| phoneDevice |
| phoneServer |
| phoneUser |
+----------------------+
67 rows in set (0.01 sec)
其中用户列表为 ofUser , 组的列表为ofGroup ,组用户表ofGroupUser, 查看ofUser 表的架构
mysql> desc ofUser;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| username | varchar(64) | NO | PRI | NULL | |
| plainPassword | varchar(32) | YES | | NULL | |
| encryptedPassword | varchar(255) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
| email | varchar(100) | YES | | NULL | |
| creationDate | char(15) | NO | MUL | NULL | |
| modificationDate | char(15) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
7 rows in set (0.03 sec)
根据实际的情况添加用户然后导入就可以了批量导入的命令是
mysql > load data local infile "/home/filename" into table tables_name;(如有什么问题可以问我)
然后在客户端登陆即可,下载spark客户端,进行登陆即可
其中服务器为安装的服务器地址,登入的界面如图
到此安装完成!
转载于:https://blog.51cto.com/yijiaxin/738283