{"id":66,"date":"2017-09-28T17:15:24","date_gmt":"2017-09-28T08:15:24","guid":{"rendered":"http:\/\/dev.e-luda.com\/dev-note\/?p=122"},"modified":"2017-09-29T08:56:10","modified_gmt":"2017-09-28T23:56:10","slug":"openfire-%ec%84%9c%eb%b2%84-%ec%84%a4%ec%b9%98-%eb%b0%8f-%ec%84%a4%ec%a0%95-windows","status":"publish","type":"post","link":"http:\/\/dev.e-luda.com\/dev-note\/?p=66","title":{"rendered":"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows"},"content":{"rendered":"

[\uc124\uce58 \ud658\uacbd]
\nOS : windows 7(Professional)
\n\uc124\uce58 \ubc84\uc804 : 4.1.5
\nDatabase : mysql 5.7.19<\/p>\n

[download]
\nhttp:\/\/www.igniterealtime.org\/downloads\/download-landing.jsp?file=openfire\/openfire_4_1_5.exe<\/p>\n

[\uc124\uce58\uc804 \uc900\ube44]
\n– \ubcc4\ub3c4 database\uc5d0\uc124\uce58\uc2dc database \uc0dd\uc131
\n> HeidiSQL \uc0ac\uc6a9.<\/p>\n

\"\"
mysql \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc0dd\uc131<\/figcaption><\/figure>\n
\"\"
openfire\uc5d0\uc11c\uc0ac\uc6a9\ud560 \ubcc4\ub3c4 database \uc0dd\uc131<\/figcaption><\/figure>\n

> command console\uc744\ud1b5\ud574 mysql \uc811\uc18d\ud6c4 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0
\n>> mysql -u <\uc0ac\uc6a9\uc790> -p
\n>> create database openfire;<\/p>\n

[ \uc124\uce58\ub2e8\uacc4 – 1 ]
\n1. \uc124\uce58 \ud30c\uc77c \uc2e4\ud589
\n\"\"<\/p>\n

2. \uc5b8\uc5b4 \uc120\ud0dd : English\ub85c \uc120\ud0dd.
\n\"\"<\/p>\n

3. \uc124\uce58\uc9c4\ud589
\n\"\"<\/p>\n

4. \ub77c\uc774\uc120\uc2a4\ub3d9\uc758
\n\"\"<\/p>\n

5. \uc124\uce58\uc704\uce58\uc124\uc815
\n\"\"<\/p>\n

6. \uc124\uce58 \uc9c4\ud589
\n\"\"<\/p>\n

7. \ud30c\uc77c \uc124\uce58
\n\"\"<\/p>\n

8. \uc124\uce58\uc644\ub8cc
\n\"\"<\/p>\n

 <\/p>\n

[ \uc124\uc815 ]<\/p>\n

1. \uc5b8\uc5b4 \uc124\uc815
\n\"\"<\/p>\n

2.\u00a0 \ub3c4\uba54\uc778\uc124\uc815 ( ip\ub85c\ub3c4\uc124\uc815 \uac00\ub2a5)
\n\"\"<\/p>\n

3. \uc124\uce58 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc120\ud0dd(\uc790\uccb4 \ub370\uc774\ud0c0 \ubca0\uc774\uc2a4, \ubcc4\ub3c4 \ub370\uc774\ud0c0 \ubca0\uc774\uc2a4)
\n\"\"<\/p>\n

4. \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc5f0\uacb0 \uc124\uc815
\n\"\"<\/p>\n

– Database Driver Presets : MySQL
\n– JDBC Driver Class : Database Driver Proesets \uc120\ud0dd\uc2dc \uc790\ub3d9 \uc120\ud0dd
\n– Database URL : jdbc:mysql:\/\/<host name, ip>:<port>\/<database-name>?rewriteBatchedStatements=true
\n– Username : database \uc811\uc18d id
\n– Password : database \uc811\uc18d password<\/p>\n

5. database profile \uc120\ud0dd
\n\"\"<\/p>\n

6. \uad00\ub9ac\uc790 \uc124\uc815
\n\"\"<\/p>\n

7. \uc124\uc815 \uc644\ub8cc
\n\"\"<\/p>\n

[ \uc124\uce58 \uc644\ub8cc]
\n1. \uad00\ub9ac\uc790 \ud654\uba74 \ub85c\uadf8\uc778
\n\"\"<\/p>\n

2. \uad00\ub9ac\uc790\ud654\uba74
\n\"\"<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

[\uc124\uce58 \ud658\uacbd] OS : windows 7(Professional) \uc124\uce58 \ubc84\uc804 : 4.1.5 Database : mysql 5.7.19 [download] http:\/\/www.igniterealtime.org\/downloads\/download-landing.jsp?file=openfire\/openfire_4_1_5.exe [\uc124\uce58\uc804 \uc900\ube44] – \ubcc4\ub3c4 database\uc5d0\uc124\uce58\uc2dc database \uc0dd\uc131 > HeidiSQL \uc0ac\uc6a9. > command console\uc744\ud1b5\ud574 mysql \uc811\uc18d\ud6c4 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 >> mysql -u <\uc0ac\uc6a9\uc790> -p >> create database openfire; [ \uc124\uce58\ub2e8\uacc4 – 1 ] 1. \uc124\uce58 \ud30c\uc77c \uc2e4\ud589 2. \uc5b8\uc5b4 \uc120\ud0dd … <\/p>\n

\ub354 \ubcf4\uae30 “Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-66","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\nOpenfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/dev.e-luda.com\/dev-note\/?p=66\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"og:description\" content=\"[\uc124\uce58 \ud658\uacbd] OS : windows 7(Professional) \uc124\uce58 \ubc84\uc804 : 4.1.5 Database : mysql 5.7.19 [download] http:\/\/www.igniterealtime.org\/downloads\/download-landing.jsp?file=openfire\/openfire_4_1_5.exe [\uc124\uce58\uc804 \uc900\ube44] – \ubcc4\ub3c4 database\uc5d0\uc124\uce58\uc2dc database \uc0dd\uc131 > HeidiSQL \uc0ac\uc6a9. > command console\uc744\ud1b5\ud574 mysql \uc811\uc18d\ud6c4 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 >> mysql -u <\uc0ac\uc6a9\uc790> -p >> create database openfire; [ \uc124\uce58\ub2e8\uacc4 – 1 ] 1. \uc124\uce58 \ud30c\uc77c \uc2e4\ud589 2. \uc5b8\uc5b4 \uc120\ud0dd … \ub354 \ubcf4\uae30 "Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows"\" \/>\n<meta property=\"og:url\" content=\"http:\/\/dev.e-luda.com\/dev-note\/?p=66\" \/>\n<meta property=\"og:site_name\" content=\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-28T08:15:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-28T23:56:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"wizardlee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/\",\"name\":\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"description\":\"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66#primaryimage\",\"inLanguage\":\"ko-KR\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg\",\"contentUrl\":\"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg\",\"width\":501,\"height\":531,\"caption\":\"class \uc0dd\uc131 - 3\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66#webpage\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66\",\"name\":\"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"isPartOf\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66#primaryimage\"},\"datePublished\":\"2017-09-28T08:15:24+00:00\",\"dateModified\":\"2017-09-28T23:56:10+00:00\",\"author\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\"},\"breadcrumb\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/dev.e-luda.com\/dev-note\/?p=66\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=66#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/dev.e-luda.com\/dev-note\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\",\"name\":\"wizardlee\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#personlogo\",\"inLanguage\":\"ko-KR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"caption\":\"wizardlee\"},\"sameAs\":[\"http:\/\/dev.e-luda.com\/dev-note\"],\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/dev.e-luda.com\/dev-note\/?p=66","og_locale":"ko_KR","og_type":"article","og_title":"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","og_description":"[\uc124\uce58 \ud658\uacbd] OS : windows 7(Professional) \uc124\uce58 \ubc84\uc804 : 4.1.5 Database : mysql 5.7.19 [download] http:\/\/www.igniterealtime.org\/downloads\/download-landing.jsp?file=openfire\/openfire_4_1_5.exe [\uc124\uce58\uc804 \uc900\ube44] – \ubcc4\ub3c4 database\uc5d0\uc124\uce58\uc2dc database \uc0dd\uc131 > HeidiSQL \uc0ac\uc6a9. > command console\uc744\ud1b5\ud574 mysql \uc811\uc18d\ud6c4 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 >> mysql -u <\uc0ac\uc6a9\uc790> -p >> create database openfire; [ \uc124\uce58\ub2e8\uacc4 – 1 ] 1. \uc124\uce58 \ud30c\uc77c \uc2e4\ud589 2. \uc5b8\uc5b4 \uc120\ud0dd … \ub354 \ubcf4\uae30 \"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows\"","og_url":"http:\/\/dev.e-luda.com\/dev-note\/?p=66","og_site_name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","article_published_time":"2017-09-28T08:15:24+00:00","article_modified_time":"2017-09-28T23:56:10+00:00","og_image":[{"url":"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"wizardlee","Est. reading time":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/dev.e-luda.com\/dev-note\/#website","url":"http:\/\/dev.e-luda.com\/dev-note\/","name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","description":"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"ImageObject","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=66#primaryimage","inLanguage":"ko-KR","url":"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg","contentUrl":"http:\/\/dev.e-luda.com\/dev-note\/wp-content\/uploads\/2017\/09\/openfire_0_1.jpg","width":501,"height":531,"caption":"class \uc0dd\uc131 - 3"},{"@type":"WebPage","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=66#webpage","url":"http:\/\/dev.e-luda.com\/dev-note\/?p=66","name":"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 - Windows - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","isPartOf":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#website"},"primaryImageOfPage":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=66#primaryimage"},"datePublished":"2017-09-28T08:15:24+00:00","dateModified":"2017-09-28T23:56:10+00:00","author":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c"},"breadcrumb":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=66#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/dev.e-luda.com\/dev-note\/?p=66"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=66#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/dev.e-luda.com\/dev-note"},{"@type":"ListItem","position":2,"name":"Openfire \uc11c\ubc84 \uc124\uce58 \ubc0f \uc124\uc815 – Windows"}]},{"@type":"Person","@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c","name":"wizardlee","image":{"@type":"ImageObject","@id":"http:\/\/dev.e-luda.com\/dev-note\/#personlogo","inLanguage":"ko-KR","url":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","caption":"wizardlee"},"sameAs":["http:\/\/dev.e-luda.com\/dev-note"],"url":"http:\/\/dev.e-luda.com\/dev-note\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/66","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=66"}],"version-history":[{"count":0,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions"}],"wp:attachment":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}