오픈메신저 설치법(openfire) + spark

Openfire 다운로드 

# wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.9.3-1.i386.rpm

Openfire 설치

# rpm -ivh openfire-3.9.3-1.i386.rpm

Openfire DB 설정(Mysql버전)

전제조건 1 mysql이 깔려있다.

전제조건 2 openfire라는 Database가 만들어져있다.

 

 

 

mysql -uroot -p

 

CREATE DATABASE openfire DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

exit

 

cd /opt/openfire/resources/database

cat openfire_mysql.sql | mysql openfire -p

 

cd /opt/openfire/jre/bin

cp java java.bak

rm -rf java

ln -s /usr/bin/java java 

 

vi /etc/my.cnf

======================================

[mysql]

default-character-set = utf8

[mysqld]

character-set-client-handshake=FALSE

init_connect="SET collation_connection = utf8_general_ci"

init_connect="SET NAMES utf8"

default-character-set = utf8

character-set-server = utf8

collation-server = utf8_general_ci

[client]

default-character-set = utf8

[mysqldump]

default-character-set = utf8

 

========================================================

Openfire 실행

# service openfire start

Openfire 세부 설정

웹사이트에서 접속

포트는 9090

http://(ip 혹은 도메인):9090

 

----------------------------------------------

한글 아이디 설정

jdbc:mysql://localhost:3306/openfire?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8

 

jdbc 적는곳에 저렇게 적어줘야 가능.

다시 호스트:9090접속

admin 입력하고

아까 입력했던 password 입력~

끝

참고 

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/install-guide.html

http://stackoverflow.com/questions/849199/why-cant-i-get-openfire-to-start

http://linuxrealtime.blogspot.kr/2013/08/open-fire-installation-on-cent-os-63.html

http://solutionsatexperts.com/openfire-server-installation-and-configuration/