{"id":3376,"date":"2019-04-05T12:24:37","date_gmt":"2019-04-05T04:24:37","guid":{"rendered":"http:\/\/ros.tw\/wp\/?p=3376"},"modified":"2019-04-05T12:37:38","modified_gmt":"2019-04-05T04:37:38","slug":"unifi-controller-mongodb-%e6%90%8d%e6%af%80%e7%84%a1%e6%b3%95%e5%95%9f%e5%8b%95","status":"publish","type":"post","link":"https:\/\/ros.tw\/wp\/?p=3376","title":{"rendered":"UniFi Controller MongoDB \u640d\u6bc0\u7121\u6cd5\u555f\u52d5"},"content":{"rendered":"

\u5982\u679c\u4f60\u7684<\/strong>Cloud Key\u6216\u662f<\/strong>Debian UniFi Controller \u56e0\u70ba\u67d0\u4e9b\u539f\u56e0\u5c0e\u81f4 MongoDB\u00a0\u8cc7\u6599\u5eab\u640d\u6bc0\u800c\u7121\u6cd5\u6b63\u5e38\u555f\u52d5<\/strong><\/h3>\n

\u8a66\u8a66\u5e95\u4e0b\u5b98\u65b9<\/a>\u7684\u4fee\u5fa9\u547d\u4ee4\u80fd\u8b93\u4f60\u7684UniFi Controller\u518d\u6d3b\u904e\u4f86.<\/strong><\/h3>\n
    \n
  1. Repairing a Database on Cloud Key<\/a><\/li>\n
  2. Repairing a Database on Debian-based Linux<\/a><\/li>\n
  3. Repairing a Database on Windows<\/a><\/li>\n<\/ol>\n

    <\/p>\n

    How to Repair a Database on Cloud Key (\u5b98\u65b9\u786c\u9ad4\u63a7\u5236\u5668)<\/strong><\/h1>\n

    1. Download the mongo pruning script. As written, the script will only keep entries from the past 7 days. It will not remove entries that are required for UniFi administration. Do so by running the following command:<\/p>\n

    \n
    cd \/tmp\/\r\nwget https:\/\/help.ubnt.com\/hc\/en-us\/article_attachments\/360008640574\/CK_repair.js<\/a><\/pre>\n<\/div>\n
    2. Stop the UniFi service<\/p>\n
    \n
    service unifi stop<\/pre>\n<\/div>\n
    3. The UniFi service will shut down the mongo process. Make sure that the UniFi service has been completely shut down. Repair the database to compact the data entries and free unused disk space\u00a0field that is included in the query criteria.<\/p>\n
    \n
    mongod --dbpath \/usr\/lib\/unifi\/data\/db --smallfiles --logpath \/usr\/lib\/unifi\/logs\/server.log --repair<\/pre>\n<\/div>\n
    \n
    \n\n\n\n
    <\/td>\n\n
    NOTE:\u00a0<\/strong><\/span>Steps 4-7 are optional if you need to prune back the database to conserve disk space.<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    4. Restart mongo with this command:<\/p>\n
    \n
    mongod --dbpath \/usr\/lib\/unifi\/data\/db --smallfiles --logpath \/usr\/lib\/unifi\/logs\/server.log --journal --fork<\/pre>\n<\/div>\n
    \n
    \n\n\n\n
    <\/td>\n\n
    NOTE:\u00a0<\/strong>Journaling may not be have been enabled in your mongo database. If so, then remove the –journal option in the above command.<\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    5. Execute the script to prune the\u00a0stat<\/code>\u00a0collections that are causing the problem:<\/p>\n
    \n
    mongo < \/tmp\/CK_repair.js<\/pre>\n<\/div>\n
    6. Shut down the mongo server with this command:<\/p>\n
    \n
    mongod --dbpath \/usr\/lib\/unifi\/data\/db --smallfiles --logpath \/usr\/lib\/unifi\/logs\/server.log --shutdown<\/pre>\n<\/div>\n
    \n
    \n\n\n\n
    <\/td>\n\n
    NOTE:\u00a0<\/strong>The last command in the CK_repair.js script is “db.repairDatabase()”. It may result in an error if the stats collections have already grown too large to be repaired while the mongo server is running. If you see such an error running the script then you will need to repair the database from the command line once again by running the command in step 3.<\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    7. Finally, restart the UniFi service:<\/p>\n
    \n
    service unifi start<\/pre>\n<\/div>\n
    \n
    <\/p>\n
    How to Repair a Database on Debian-based Linux\u00a0<\/strong>(<\/strong>D<\/strong>ebian \u63a7\u5236\u5668)<\/strong><\/h1>\n
    \n
    1. Stop the UniFi service<\/p>\n
    \n
    service unifi stop<\/pre>\n<\/div>\n
    2. Repair the database with this command:<\/p>\n
    \n
    mongod --dbpath \/usr\/lib\/unifi\/data\/db --smallfiles --logpath \/usr\/lib\/unifi\/logs\/server.log --repair<\/pre>\n<\/div>\n
    3. Finally, restart the UniFi service:<\/p>\n
    \n
    service unifi start<\/pre>\n<\/div>\n
    \"\"<\/p>\n
     <\/p>\n
    \n
    <\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    \u5982\u679c\u4f60\u7684Cloud Key\u6216\u662fDebian UniFi Controller \u56e0 … \u95b1\u8b80\u5168\u6587 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"gallery","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3376","post","type-post","status-publish","format-gallery","hentry","category-ros","post_format-post-format-gallery"],"_links":{"self":[{"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/posts\/3376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3376"}],"version-history":[{"count":5,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/posts\/3376\/revisions"}],"predecessor-version":[{"id":3382,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=\/wp\/v2\/posts\/3376\/revisions\/3382"}],"wp:attachment":[{"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ros.tw\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}