{"id":19601,"date":"2017-06-17T06:03:46","date_gmt":"2017-06-16T22:03:46","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/17\/opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-ubuntu\/"},"modified":"2021-03-18T17:25:04","modified_gmt":"2021-03-18T09:25:04","slug":"opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-ubuntu","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/17\/opennms-apache-cassandra-%e5%ae%89%e8%a3%9d%e8%88%87-newts-%e8%a8%ad%e5%ae%9a-ubuntu\/","title":{"rendered":"OpenNMS – Apache Cassandra \u5b89\u88dd\u8207 Newts \u8a2d\u5b9a – Ubuntu"},"content":{"rendered":"

\u53c3\u8003\u7db2\u9801\uff1a
OpenNMS Installation Guide<\/a>
\u96dc\u4e82\u7684\u5b78\u7fd2\u7b46\u8a18\u672c: OpenNMS – OpenNMS \u5b89\u88dd\u7bc7(04) – Cassandra \u7684\u5b89\u88dd\u8207 Newts \u7684\u8a2d\u5b9a<\/a> <\/p>\n

\u6839\u64da\u5b98\u65b9\u7db2\u7ad9\u4e0a\u7684\u89e3\u91cb\uff1a
Newts \u662f\u57fa\u65bc Apache Cassandra \u7684\u6642\u9593\u5e8f\u5217\u8cc7\u6599\u5132\u5b58\uff0c\u662f\u4e00\u500b\u6301\u4e45\u6027\u7684\u7b56\u7565\uff0c\u53ef\u4ee5\u7528\u4f86\u53d6\u4ee3 JRobin \u6216\u662f RRDtool\u3002 <\/p>\n

\u5728 Ubuntu 16.04 \u4e0b\u5b89\u88dd
1. \u65b0\u589e DataStax \u5957\u4ef6\u5eab\u8a2d\u5b9a\u6a94
# vim \/etc\/apt\/sources.list.d\/cassandra.sources.list<\/span>
deb https:\/\/debian.datastax.com\/community stable main<\/span> <\/p>\n

2. \u5b89\u88dd GPG Key
# wget -O – https:\/\/debian.datastax.com\/debian\/repo_key | apt-key add –<\/span> <\/p>\n

3. \u66f4\u65b0\u5957\u4ef6\u5eab
# apt-get update<\/span>[@more@]
4. \u5b89\u88dd Cassandra 3.0.x package
# apt-get install dsc30<\/span>
\u5982\u679c\u51fa\u73fe\u4e0b\u9762\u7684\u932f\u8aa4\u8a0a\u606f\uff0c\u8acb\u4e0b\u8f09 python-support \u9032\u884c\u5b89\u88dd
The following packages have unmet dependencies:<\/span>
\u00a0dsc30 : Depends: python-support (>= 0.90.0) but it is not installable<\/span>
E: Unable to correct problems, you have held broken packages.<\/span> <\/p>\n

# wget http:\/\/launchpadlibrarian.net\/109052632\/python-support_1.0.15_all.deb<\/span>
# dpkg -i python-support_1.0.15_all.deb<\/span>
Selecting previously unselected package python-support.<\/span>
(Reading database … 72575 files and directories currently installed.)<\/span>
Preparing to unpack python-support_1.0.15_all.deb …<\/span>
Unpacking python-support (1.0.15) …<\/span>
Setting up python-support (1.0.15) …<\/span>
Processing triggers for man-db (2.7.5-1) .<\/span>.. <\/p>\n

5. \u8a2d\u5b9a OpenNMS Horizon
# cp \/usr\/share\/opennms\/etc\/opennms.properties \/usr\/share\/opennms\/etc\/opennms.properties.$(date +%F)<\/span>
\u5c07 false \u6539\u70ba true
# sed -i ‘\/rrd.storeByForeignSource\/s\/false\/true\/’ \/usr\/share\/opennms\/etc\/opennms.properties<\/span>
\u53d6\u6d88\u524d\u9762\u7684\u8a3b\u89e3\uff0c\u4e26\u5c07 rrd \u6539\u70ba newts
# sed -i ‘\/^#org.opennms.timeseries\/s\/#org.opennms.timeseries.strategy=rrd\/org.opennms.timeseries.strategy=newts\/’ \/usr\/share\/opennms\/etc\/opennms.properties<\/span>
\u53d6\u6d88\u524d\u9762\u7684\u8a3b\u89e3
# sed -i ‘\/newts.config.hostname\/s\/^#org\/org\/’ \/usr\/share\/opennms\/etc\/opennms.properties<\/span>
# sed -i ‘\/keyspace\/s\/^#org\/org\/’ \/usr\/share\/opennms\/etc\/opennms.properties<\/span>
# sed -i ‘\/9042\/s\/^#org\/org\/’ \/usr\/share\/opennms\/etc\/opennms.properties<\/span> <\/p>\n

6. \u521d\u59cb\u5316 newts
# \/usr\/share\/opennms\/bin\/newts init<\/span> <\/p>\n

7. \u9032\u884c\u9a57\u8b49
# cqlsh<\/span>
Connected to Test Cluster at 127.0.0.1:9042.<\/span>
[cqlsh 5.0.1 | Cassandra 3.0.9 | CQL spec 3.4.0 | Native protocol v4]<\/span>
Use HELP for help.<\/span>
cqlsh> use newts;<\/span>
cqlsh:newts> describe table terms;<\/span> <\/p>\n

CREATE TABLE newts.terms (<\/span>
\u00a0\u00a0\u00a0 context text,<\/span>
\u00a0\u00a0\u00a0 field text,<\/span>
\u00a0\u00a0\u00a0 value text,<\/span>
\u00a0\u00a0\u00a0 resource text,<\/span>
\u00a0\u00a0\u00a0 PRIMARY KEY ((context, field, value), resource)<\/span>
) WITH CLUSTERING ORDER BY (resource ASC)<\/span>
\u00a0\u00a0\u00a0 AND bloom_filter_fp_chance = 0.01<\/span>
\u00a0\u00a0\u00a0 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’}<\/span>
\u00a0\u00a0\u00a0 AND comment = ”<\/span>
\u00a0\u00a0\u00a0 AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’}<\/span>
\u00a0\u00a0\u00a0 AND compression = {‘chunk_length_in_kb’: ’64’, ‘class’: ‘org.apache.cassandra.io.compress.LZ4Compressor’}<\/span>
\u00a0\u00a0\u00a0 AND crc_check_chance = 1.0<\/span>
\u00a0\u00a0\u00a0 AND dclocal_read_repair_chance = 0.1<\/span>
\u00a0\u00a0\u00a0 AND default_time_to_live = 0<\/span>
\u00a0\u00a0\u00a0 AND gc_grace_seconds = 864000<\/span>
\u00a0\u00a0\u00a0 AND max_index_interval = 2048<\/span>
\u00a0\u00a0\u00a0 AND memtable_flush_period_in_ms = 0<\/span>
\u00a0\u00a0\u00a0 AND min_index_interval = 128<\/span>
\u00a0\u00a0\u00a0 AND read_repair_chance = 0.0<\/span>
\u00a0\u00a0\u00a0 AND speculative_retry = ’99PERCENTILE’;<\/span> <\/p>\n

cqlsh:newts> describe table samples;<\/span> <\/p>\n

CREATE TABLE newts.samples (<\/span>
\u00a0\u00a0\u00a0 context text,<\/span>
\u00a0\u00a0\u00a0 partition int,<\/span>
\u00a0\u00a0\u00a0 resource text,<\/span>
\u00a0\u00a0\u00a0 collected_at timestamp,<\/span>
\u00a0\u00a0\u00a0 metric_name text,<\/span>
\u00a0\u00a0\u00a0 attributes map<text, text>,<\/span>
\u00a0\u00a0\u00a0 value blob,<\/span>
\u00a0\u00a0\u00a0 PRIMARY KEY ((context, partition, resource), collected_at, metric_name)<\/span>
) WITH CLUSTERING ORDER BY (collected_at ASC, metric_name ASC)<\/span>
\u00a0\u00a0\u00a0 AND bloom_filter_fp_chance = 0.01<\/span>
\u00a0\u00a0\u00a0 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’}<\/span>
\u00a0\u00a0\u00a0 AND comment = ”<\/span>
\u00a0\u00a0\u00a0 AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’}<\/span>
\u00a0\u00a0\u00a0 AND compression = {‘chunk_length_in_kb’: ’64’, ‘class’: ‘org.apache.cassandra.io.compress.LZ4Compressor’}<\/span>
\u00a0\u00a0\u00a0 AND crc_check_chance = 1.0<\/span>
\u00a0\u00a0\u00a0 AND dclocal_read_repair_chance = 0.1<\/span>
\u00a0\u00a0\u00a0 AND default_time_to_live = 0<\/span>
\u00a0\u00a0\u00a0 AND gc_grace_seconds = 864000<\/span>
\u00a0\u00a0\u00a0 AND max_index_interval = 2048<\/span>
\u00a0\u00a0\u00a0 AND memtable_flush_period_in_ms = 0<\/span>
\u00a0\u00a0\u00a0 AND min_index_interval = 128<\/span>
\u00a0\u00a0\u00a0 AND read_repair_chance = 0.0<\/span>
\u00a0\u00a0\u00a0 AND speculative_retry = ’99PERCENTILE’;<\/span> <\/p>\n

cqlsh:newts> quit<\/span><\/p>\n

8.\u91cd\u65b0\u555f\u52d5 OpenNMS
# systemctl restart opennms<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u53c3\u8003\u7db2\u9801\uff1a OpenNMS Installation Guide \u96dc\u4e82\u7684\u5b78\u7fd2\u7b46\u8a18\u672c: OpenNMS &#82 … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008OpenNMS – Apache Cassandra \u5b89\u88dd\u8207 Newts \u8a2d\u5b9a – Ubuntu\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[151,119],"tags":[],"class_list":["post-19601","post","type-post","status-publish","format-standard","hentry","category-c-78534","category-c-78464"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["689038"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19601"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=19601"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19601\/revisions"}],"predecessor-version":[{"id":21106,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19601\/revisions\/21106"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=19601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=19601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=19601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}