{"id":360,"date":"2009-04-22T01:52:00","date_gmt":"2009-04-21T16:52:00","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=360"},"modified":"2021-10-25T14:48:12","modified_gmt":"2021-10-25T05:48:12","slug":"%e3%83%a1%e3%83%bc%e3%83%ab%e5%8f%97%e4%bf%a1%e3%82%92db%e3%81%8b%e3%82%89%e5%81%9c%e6%ad%a2%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=360","title":{"rendered":"\u30e1\u30fc\u30eb\u53d7\u4fe1\u3092DB\u304b\u3089\u505c\u6b62\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

\u30e1\u30fc\u30eb\u53d7\u4fe1\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u5225\u74b0\u5883\uff08\u691c\u8a3c\u74b0\u5883\u306a\u3069\uff09\u306eServiceDesk Plus\u306b\u30ea\u30b9\u30c8\u30a2\u3057\u3066\u3001ServiceDesk Plus \u3092\u8d77\u52d5\u3059\u308b\u3068\u3001ServiceDesk Plus\u306f\u81ea\u52d5\u7684\u306b\u30e1\u30fc\u30eb\u3092\u53d7\u4fe1\u3057\u307e\u3059\u3002ServiceDesk Plus \u3092\u8d77\u52d5\u3059\u308b\u524d\u306b\u3001\u30e1\u30fc\u30eb\u53d7\u4fe1\u3092\u505c\u6b62\u3059\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

 <\/p>\n

\u3010\u6ce8\u610f\u3011<\/b><\/span><\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u300cUpdate\u300d\u3001\u300cDelete\u300d\u306a\u3069\u306e\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u306f\u304a\u5ba2\u69d8\u8cac\u4efb\u306b\u3066\u884c\u3063\u3066\u3044\u305f\u3060\u3044\u3066\u304a\u308a\u307e\u3059\u306e\u3067\u3001\u3054\u4e86\u627f\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u3010\u624b\u9806\u3011<\/b><\/span><\/p>\n

1. \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u505c\u6b62\u3057\u305f\u72b6\u614b\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u8d77\u52d5\u3057\u307e\u3059\u3002<\/span><\/p>\n

1) ServiceDesk Plus \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b5\u30fc\u30d0\u304b\u3089\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u304d\u3001\u6b21\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/span><\/p>\n

[ServiceDesk\u30db\u30fc\u30e0]bin<\/span><\/p>\n

2) \u6b21\u306ebat\/sh\u30d5\u30a1\u30a4\u30eb\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/span><\/p>\n

<Windows><\/p>\n

cmd>startDB.bat\u00a0<\/span><\/p>\n

<Linux><\/p>\n

# sh startDB.sh<\/span><\/p>\n

 <\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304cPostgreSQL\u306e\u5834\u5408\u306f\u3001\u5f15\u6570\u3068\u3057\u3066\u30dd\u30fc\u30c8\u756a\u53f7(\u521d\u671f\u8a2d\u5b9a: 65432)\u3092\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u4f8b\uff09
\ncmd> startDB.bat 65432<\/p>\n

 <\/p>\n

3) \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/span><\/p>\n

[\u5404\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u624b\u9806<\/a>]\n

\u00a0<\/span><\/p>\n

* \u4e0b\u8a18\u306e4)-7)\u306f\u3001\u691c\u8a3c\u74b0\u5883\u306b\u5fdc\u3058\u3066\u5fc5\u8981\u306a\u30af\u30a8\u30ea\u306e\u307f\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

* \u30e1\u30fc\u30eb\u53d7\u4fe1\u306e\u307f\u3092\u505c\u6b62\u3059\u308b\u5834\u5408\u306f\u30017)\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

\u00a0<\/span><\/p>\n

4) \u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u21d2\u9001\u4fe1\u30e1\u30fc\u30eb\u30b5\u30fc\u30d0\u540d\u3092\u300cALPHA\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/span><\/p>\n

update outgoingmailserver set HOSTNAME = 'ALPHA';<\/p>\n

\u00a0<\/span><\/p>\n

5) \u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u21d2\u9001\u4fe1\u30e1\u30fc\u30eb\u30b5\u30fc\u30d0\u540d\uff08\u4ee3\u66ff\uff09\u3092\u300cBETA\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/span><\/p>\n

update outgoingmailserver set ALTERNATEHOSTNAME = 'BETA';<\/p>\n

\u00a0<\/span><\/p>\n

6) \u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u21d2\u53d7\u4fe1\u30e1\u30fc\u30eb\u30b5\u30fc\u30d0\u540d\u3092\u300cALPHA1\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/span><\/p>\n

update incomingmailserver set HOSTNAME = 'ALPHA1';<\/p>\n

\u00a0<\/span><\/p>\n

7) \u30e1\u30fc\u30eb\u53d7\u4fe1\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u3092\u505c\u6b62\u3059\u308b\u305f\u3081\u306b\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/span><\/p>\n

select schedule_id, schedule_name from schedule where schedule_name='MailFetchingSchedule';<\/p>\n

\u5b9f\u884c\u7d50\u679c\u304b\u3089\u30e1\u30fc\u30eb\u53d6\u5f97\u306e\u30b9\u30b1\u30b8\u30e5\u30fc\u30ebID(schedule_id)\u3092\u78ba\u8a8d\u3057\u3066\u3001\u6b21\u306e\u66f4\u65b0\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n

update task_input set operational_status=4 where schedule_id=\u30af\u30a8\u30ea\u7d50\u679c\u306eschedule_id;<\/p>\n

 <\/p>\n

\u4f8b)<\/p>\n

\u30af\u30a8\u30ea\u7d50\u679c\u304c\u3001100\u306e\u5834\u5408\u306f\u6b21\u306b\u306a\u308a\u307e\u3059\u3002
\nupdate task_input set operational_status=4 where schedule_id=100;<\/p>\n

 <\/p>\n

8) \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30ed\u30b0\u30a2\u30a6\u30c8\u3057\u307e\u3059\u3002<\/p>\n

9) \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n

\u00a0<\/span><Windows><\/p>\n

cmd>stopDB.bat\u00a0<\/span><\/p>\n

<Linux><\/p>\n

# sh stopDB.sh<\/span><\/p>\n

\u00a0<\/span><\/p>\n

10) \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u30e1\u30fc\u30eb\u53d7\u4fe1\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u5225\u74b0\u5883\uff08\u691c\u8a3c\u74b0\u5883\u306a\u3069\uff09\u306eServiceDesk Plus\u306b\u30ea\u30b9\u30c8\u30a2\u3057\u3066\u3001ServiceDesk Pl\u2026 \uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[3,7],"tags":[311,201,3612150,3612126],"class_list":["post-360","post","type-post","status-publish","format-standard","hentry","category-trouble-sdp","category-config-sdp","tag-311","tag-201","tag-3612150","tag-admin"],"modified_by":"ayaka","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=360"}],"version-history":[{"count":6,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/360\/revisions"}],"predecessor-version":[{"id":6778,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/360\/revisions\/6778"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}