Openfire 설치 및 한글작업

# MariaDB 다운로드
https://downloads.mariadb.org/interstitial/mariadb-10.1.11/bintar-linux-x86_64/mariadb-10.1.11-linux-x86_64.tar.gz/from/http%3A//ftp.kaist.ac.kr/mariadb/?serve

# MariaDB 외부접속
http://rea1man.tistory.com/67
http://sqlmvp.kr/220342552224
http://ora-sysdba.tistory.com/43

# Openfire 다운로드
http://www.igniterealtime.org/downloads/download-landing.jsp?file=openfire/openfire-4.0.1-1.i386.rpm

# Openfire 설치
http://mangolassi.it/topic/7956/installing-openfire-4-0-1-on-centos-7
http://egloos.zum.com/repository/v/5848861

# ftp 설치
http://brian-s.tistory.com/6

# 무료 ftp
http://winscp.net/eng/download.php

--------------------------------------------------------------------------------------
[방화벽]

firewall-cmd --zone=public --add-port=5269/tcp --permanent
firewall-cmd --zone=public --add-port=5222/tcp --permanent
firewall-cmd --zone=public --add-port=5223/tcp --permanent
firewall-cmd --zone=public --add-port=9090/tcp --permanent
firewall-cmd --reload
--------------------------------------------------------------------------------------
[한글]
데이터베이스 생성시 : utf8_general_ci

jdbc:mysql://172.16.10.188:3306/openfire?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8

vi /opt/openfire/conf/openfire.xml
<locale>en</locale> -> <locale>ko</locale>

참조!!!!!!!!! : http://www.jopenbusiness.com/wordpress/?p=535

1. 첫번째 방법
-------------------------------------------------------------------
[root@]# vi /etc/my.cnf.d/client.cnf

[client]
default-character-set = utf8
-------------------------------------------------------------------
[root@]# vi /etc/my.cnf.d/mysql-clients.cnf

[mysql]
default-character-set = utf8

[mysqldump]
default-character-set = utf8
-------------------------------------------------------------------
[root@]# vi /etc/my.cnf.d/server.cnf

[mysqld]
init_connect = “SET collation_connection = utf8_general_ci”
init_connect = “SET NAMES utf8″
character-set-server=utf8
collation-server = utf8_general_ci
-------------------------------------------------------------------

2. 두번째 방법
mysql> use mysql
mysql> set names utf8;
mysql> set session character_set_server=utf8;
mysql> set session character_set_database=utf8;
mysql> status 
mysql> show variables like 'c%';

3. 세번째 방법
#vi /etc/my.cnf   //mysql 설정 파일 

#---- my.cnf -----------------------------------------------------#
...

[mysql]
default-character-set = utf8
 
[client]
default-character-set = utf8
 
[mysqld]
character-set-client-handshake=FALSE
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci
 
[mysqldump]
default-character-set = utf8

...
#----------------------------------------------------------------#

이렇게 했는데 계속 한글이 제대로 입력이 안되서 검색해보니

기존에 만들어진 데이터베이스 및 테이블은 지우고 다시 만들어야됩니다.


openfire 관련 테이블 삭제 후 다시 재생성....!!!!!

--------------------------------------------------------------------------------------
passwd : rmatjdcnfvkstk
--------------------------------------------------------------------------------------
[start : stop]

systemctl start mariadb
systemctl enable mariadb

systemctl start openfire
systemctl enable openfire

service openfire start
service openfire stop

service mysql start
service mysql stop



[한글이 죽어도 안되는 openfire + mysql]
http://underfree.tistory.com/62

[openfire에서 한글처리방법]
http://calmroad.blog.me/100135060045
 
[mysql 라이센스]
http://fpem.tistory.com/58

[ 윈도우 8에서 Spark설치 시 에러 조치 사항 ]
내컴퓨터(내PC) -> 속성 -> 고급 시스템 설정 -> 환경 변수에서 아래와 같이 TEMP, TMP디렉토리를 수정한다.
(관리자 권한으로 실행)
 
[환경변수]
-----------------
변수   값
-----------------
TEMP   c:Temp
TMP    c:Temp
-----------------