{"id":398754,"date":"2024-06-29T14:15:34","date_gmt":"2024-06-29T14:15:34","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=398754"},"modified":"-0001-11-30T00:00:00","modified_gmt":"2024-06-29T14:15:34","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=398754","title":{"rendered":"\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u0441\u0447\u0435\u0442\u0447\u0438\u043a\u043e\u0432 \u0437\u0430 \u043e\u0434\u0438\u043d \u0432\u0435\u0447\u0435\u0440<\/span>"},"content":{"rendered":"
<\/div>\n
\n
\n
\n
\n
<\/figcaption><\/figure>\n

\u0418\u043c\u0435\u0435\u0442\u0441\u044f 25 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u043e\u0432 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u044d\u043d\u0435\u0440\u0433\u0438\u0438 \u041c\u0435\u0440\u043a\u0443\u0440\u0438\u0439 236 ART, \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u043d\u044b\u0445 \u0441\u0435\u0442\u044c\u044e RS485 \u0434\u043b\u044f \u0434\u0438\u0441\u0442\u0430\u043d\u0446\u0438\u043e\u043d\u043d\u043e\u0433\u043e \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0437\u0430\u0434\u0430\u0447\u0430 — \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0441\u043a\u043e\u0440\u0435\u0435 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u043f\u0440\u0438\u0431\u043e\u0440\u043e\u0432 \u0443\u0447\u0435\u0442\u0430 \u0438 \u0432 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u0440\u0435\u0436\u0438\u043c\u0435 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0438\u043c\u0438 \u044d\u043d\u0435\u0440\u0433\u0438\u0438.<\/p>\n

\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u043e\u0442 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u043e\u0432<\/h3>\n

\u041f\u043e\u0441\u043b\u0435 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0434\u043e\u0440\u0430\u0431\u043e\u0442\u043e\u043a \u0443\u0442\u0438\u043b\u0438\u0442\u044b mercury236<\/a> \u044f \u043f\u043e\u043b\u0443\u0447\u0438\u043b \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u043e\u0431\u0440\u0430\u0449\u0430\u0442\u044c\u0441\u044f \u043a \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430\u043c \u043f\u043e \u0438\u043d\u0434\u0438\u0432\u0438\u0434\u0443\u0430\u043b\u044c\u043d\u044b\u043c \u0430\u0434\u0440\u0435\u0441\u0430\u043c \u0438 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u043e\u0442 \u043d\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 JSON. \u041f\u0440\u043e\u0446\u0435\u0441\u0441 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0443\u0442\u0438\u043b\u0438\u0442\u044b \u0438 \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u044f \u0435\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u043d\u0438\u0436\u0435.<\/p>\n

[root@localhost ~]# git clone https:\/\/github.com\/ensoelectric\/mercury236 [root@localhost ~]# cd mercury236 [root@localhost mercury236]# make -std=c99 -lpthread -lrt cc mercury-cli.c mercury236.c -std=c99 -lpthread -lrt -o mercury236 cc mercury-mon.c mercury236.c -std=c99 -lpthread -lrt -o mercury-mon [root@localhost mercury236]# cp mercury236\/mercury236 \/usr\/bin\/ [root@localhost mercury236]# mercury236 \/dev\/ttyr00 115   Mains status:                               On   Voltage (V):                            228.38   227.51   226.93   Current (A):                              9.06     8.09    11.87   Cos(f):                                   0.58     0.43     0.74 (    0.60)   Frequency (Hz):                          49.97   Phase angles (deg):                     119.83   240.15   120.32   Active power (W):                      1208.21   792.42  1991.39 ( 3992.02)   Reactive power (VA):                   2070.08  1839.36  2695.36 ( 6604.80)   Total consumed, all tariffs (KWh):     766174.88     including day tariff (KWh):          500278.53     including night tariff (KWh):        265896.28   Yesterday consumed (KWh):                 90.32   Today consumed (KWh):                     40.33 [root@localhost mercury236]# mercury236 \/dev\/ttyr00 115 --json {\"mainsStatus\":1,\"U\":{\"p1\":228.14,\"p2\":227.41,\"p3\":226.68},\"I\":{\"p1\":9.11,\"p2\":8.13,\"p3\":12.39},\"CosF\":{\"p1\":0.58,\"p2\":0.43,\"p3\":0.75,\"sum\":0.61},\"F\":49.97,\"A\":{\"p1\":119.90,\"p2\":240.01,\"p3\":120.11},\"P\":{\"p1\":1207.87,\"p2\":794.27,\"p3\":2094.69,\"sum\":4096.83},\"S\":{\"p1\":2078.40,\"p2\":1848.64,\"p3\":2809.92,\"sum\":6736.96},\"PR\":{\"ap\":766174.88},\"PR-day\":{\"ap\":500278.53},\"PR-night\":{\"ap\":265896.28},\"PY\":{\"ap\":90.32},\"PT\":{\"ap\":40.33}}<\/code><\/pre>\n
\u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433<\/h2>\n
\u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0443\u0434\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f Zabbix 5.4. \u041a\u0430\u0436\u0434\u044b\u0439 \u043f\u0440\u0438\u0431\u043e\u0440 \u0443\u0447\u0435\u0442\u0430 \u044f \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e \u043a\u0430\u043a \u0445\u043e\u0441\u0442, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u0448\u0430\u0431\u043b\u043e\u043d<\/a>. \u041e\u043d \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u044d\u043b\u0435\u043c\u0435\u043d\u0442 \u0442\u0438\u043f\u0430 «Zabbix \u0442\u0440\u0430\u043f\u043f\u0435\u0440» \u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u044b\u0445 \u043e\u0442 \u043d\u0435\u0433\u043e \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432.<\/p>\n
<\/figcaption><\/figure>\n
\u041f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0445\u043e\u0441\u0442\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0448\u0430\u0431\u043b\u043e\u043d \u0438 \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435, \u043f\u0440\u0438\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044f\u0441\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u043f\u0440\u0430\u0432\u0438\u043b\u0430: «Mercury [0-255]», \u0433\u0434\u0435 [0-255] — \u0441\u0435\u0442\u0435\u0432\u043e\u0439 \u0430\u0434\u0440\u0435\u0441 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430.<\/p>\n
<\/figcaption><\/figure>\n
\u0425\u0440\u0430\u043d\u0435\u043d\u0438\u0435 «\u043f\u043e\u043a\u0430\u0437\u0430\u043d\u0438\u0439»<\/h2>\n
\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430\u043c\u0438 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+).<\/p>\n
-- \u0412\u0435\u0440\u0441\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430: 10.3.22-MariaDB  DROP DATABASE IF EXISTS Mercury236Reports;  CREATE DATABASE Mercury236Reports;   USE Mercury236Reports;  -- -- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 `daily_consumed` \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f  -- \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+) \u0437\u0430 \u0441\u0443\u0442\u043a\u0438. --  CREATE TABLE `daily_consumed` (   `addr` tinyint(4) UNSIGNED NOT NULL,   `report` date NOT NULL,   `ap` float NOT NULL,   `created_at` datetime NOT NULL DEFAULT current_timestamp(),   `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),   PRIMARY KEY (`addr`,`report`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  -- -- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 `total_consumed` \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u043e\u0442 \u0441\u0431\u0440\u043e\u0441\u0430  -- \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+) \u043f\u043e \u0441\u0443\u043c\u043c\u0435 \u0442\u0430\u0440\u0438\u0444\u043e\u0432. \u0421\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, -- \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u043e\u0435 \u0432 \u0442\u0435\u043a\u0443\u0449\u0435\u043c \u0447\u0430\u0441\u0435. --  CREATE TABLE `total_consumed` (   `addr` tinyint(4) UNSIGNED NOT NULL,   `report` datetime NOT NULL,   `ap` float NOT NULL,   `created_at` datetime NOT NULL DEFAULT current_timestamp(),   `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),   PRIMARY KEY (`addr`,`report`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;<\/code><\/pre>\n
\u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435<\/h2>\n
\u0414\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 Zabbix \u0441\u0435\u0440\u0432\u0435\u0440\u0443 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432 \u0411\u0414 \u043f\u043e\u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0443\u0442\u0438\u043b\u0438\u0442\u0430 zabbix_sender \u0438 shell-\u0441\u043a\u0440\u0438\u043f\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u044f.<\/p>\n
#!\/bin\/bash  # mercury236polling.sh  #Power meters address pm_address=(7 34 43 48 50 54 67 70 73 76 80 81 82 84 89 93 97 115 125 142 144 146 158 199 234)  #ZBX Server zbx_host=\"127.0.0.1\"  #DB credential db_host=\"127.0.0.1\" db_name=\"Mercury236Reports\" db_user=\"user\" db_passwd=\"passwd\"  while [ 1 = 1 ] do     for i in ${!pm_address[@]}     do           data=$(mercury236 \/dev\/ttyr00 ${pm_address[$i]} --json)         zabbix_sender -z $zbx_host -s \"Mercury ${pm_address[$i]}\" -k data -o \"$data\"                  #Save A+ values         py=$(echo \"$data\" | jq '.PY.ap')         pr=$(echo \"$data\" | jq '.PR.ap')         mysql --host=$db_host --user=$db_user --password=$db_passwd $db_name -e \"INSERT INTO daily_consumed (addr, report, ap) VALUES (${pm_address[$i]}, SUBDATE(CURRENT_DATE, 1), $py) ON DUPLICATE KEY UPDATE ap=$py;\"         mysql --host=$db_host --user=$db_user --password=$db_passwd $db_name -e \"INSERT INTO total_consumed (addr, report, ap) VALUES (${pm_address[$i]}, DATE_FORMAT(NOW(), \\\"%Y-%m-%d %H:59:59\\\"), $pr) ON DUPLICATE KEY UPDATE ap=$pr;\"          sleep 1     done done<\/code><\/pre>\n
\u041f\u043e\u0441\u043b\u0435 \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u0438 \u0442\u0440\u0430\u043f\u043f\u0435\u0440-\u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c JSON, \u0430 \u0411\u0414 — \u043f\u043e\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u043e \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438.<\/p>\n
\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0441\u0435\u0440\u0432\u0438\u0441 \u0432 systemd<\/h2>\n
\u0414\u043b\u044f \u0442\u043e\u0433\u043e \u0447\u0442\u043e\u0431\u044b \u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u043e \u0437\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043e\u0442 \u043f\u0440\u0438\u0431\u043e\u0440\u043e\u0432 \u0443\u0447\u0435\u0442\u0430, \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0441\u0435\u0440\u0432\u0438\u0441 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 mercury236polling.sh.<\/p>\n
[root@localhost ~]# cp mercury236polling.sh \/usr\/bin\/ [root@localhost ~]# cat \/etc\/systemd\/system\/mercury236polling.service [Unit] Description=Monitoring of electricity meters \"Incotex Mercury 236\" After=network.target  [Service] Type=simple ExecStart=mercury236polling.sh  [Install] WantedBy=multi-user.target [root@localhost ~]# systemctl enable mercury236polling.service [root@localhost ~]# systemctl start mercury236polling.service [root@localhost ~]# systemctl -l status mercury236polling.service \u25cf mercury236polling.service - Monitoring of electricity meters \"Incotex Mercury 236\"    Loaded: loaded (\/etc\/systemd\/system\/mercury236polling.service; enabled; vendor preset: disabled)    Active: active (running) since Tue 2021-11-09 17:26:48 +03; 10min ago  Main PID: 3458296 (mercury236polli)     Tasks: 2 (limit: 23669)    Memory: 672.0K    CGroup: \/system.slice\/mercury236polling.service            \u251c\u25003458296 \/bin\/bash \/usr\/bin\/mercury236polling.sh            \u2514\u25003462352 sleep 1<\/code><\/pre>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/h2>\n
\u0412 \u0434\u0430\u043b\u044c\u043d\u0435\u0439\u0448\u0435\u043c, \u0432\u0435\u0440\u043e\u044f\u0442\u043d\u043e, \u043f\u043e\u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u043e\u043f\u043e\u0432\u0435\u0449\u0435\u043d\u0438\u0439, \u043f\u043e\u043a\u0430 \u0436\u0435 \u043d\u0430 \u0434\u043e\u0441\u0442\u0438\u0433\u043d\u0443\u0442\u043e\u043c \u043c\u043e\u0436\u043d\u043e \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c\u0441\u044f. \u041d\u0438\u0436\u0435 \u0441\u043a\u0440\u0438\u043d\u0448\u043e\u0442\u044b \u0434\u0430\u0448\u0431\u043e\u0440\u0434\u043e\u0432 \u0441 \u0433\u0440\u0430\u0444\u0438\u043a\u0430\u043c\u0438 \u0444\u0430\u0437\u043d\u043e\u0433\u043e \u043d\u0430\u043f\u0440\u044f\u0436\u0435\u043d\u0438\u044f, \u043c\u0433\u043d\u043e\u0432\u0435\u043d\u043d\u043e\u0439 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0438 \u0432 web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0435 Zabbix \u0438 \u043f\u0440\u0438\u043c\u0435\u0440 \u0432\u044b\u0431\u043e\u0440\u043a\u0438 \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u044b\u0445 \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u0438\u0439 \u0438\u0437 \u0411\u0414.<\/p>\n
\"Dashboard
Dashboard \u0438 \u043a\u0430\u0440\u0442\u0430 \u0441\u0435\u0442\u0438 \u0432 web \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441e.<\/figcaption><\/figure>\n
\"\u0412\u044b\u0431\u043e\u0440\u043a\u0430
\u0412\u044b\u0431\u043e\u0440\u043a\u0430 \u0438\u0437 \u0411\u0414. <\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n

 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  https:\/\/habr.com\/ru\/articles\/588218\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
<\/div>\n
\n
\n
\n
\n
<\/figcaption><\/figure>\n
\u0418\u043c\u0435\u0435\u0442\u0441\u044f 25 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u043e\u0432 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u044d\u043d\u0435\u0440\u0433\u0438\u0438 \u041c\u0435\u0440\u043a\u0443\u0440\u0438\u0439 236 ART, \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u043d\u044b\u0445 \u0441\u0435\u0442\u044c\u044e RS485 \u0434\u043b\u044f \u0434\u0438\u0441\u0442\u0430\u043d\u0446\u0438\u043e\u043d\u043d\u043e\u0433\u043e \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0437\u0430\u0434\u0430\u0447\u0430 — \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0441\u043a\u043e\u0440\u0435\u0435 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u043f\u0440\u0438\u0431\u043e\u0440\u043e\u0432 \u0443\u0447\u0435\u0442\u0430 \u0438 \u0432 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u0440\u0435\u0436\u0438\u043c\u0435 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0438\u043c\u0438 \u044d\u043d\u0435\u0440\u0433\u0438\u0438.<\/p>\n
\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u043e\u0442 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u043e\u0432<\/h3>\n
\u041f\u043e\u0441\u043b\u0435 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0434\u043e\u0440\u0430\u0431\u043e\u0442\u043e\u043a \u0443\u0442\u0438\u043b\u0438\u0442\u044b mercury236<\/a> \u044f \u043f\u043e\u043b\u0443\u0447\u0438\u043b \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u043e\u0431\u0440\u0430\u0449\u0430\u0442\u044c\u0441\u044f \u043a \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430\u043c \u043f\u043e \u0438\u043d\u0434\u0438\u0432\u0438\u0434\u0443\u0430\u043b\u044c\u043d\u044b\u043c \u0430\u0434\u0440\u0435\u0441\u0430\u043c \u0438 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u043e\u0442 \u043d\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 JSON. \u041f\u0440\u043e\u0446\u0435\u0441\u0441 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0443\u0442\u0438\u043b\u0438\u0442\u044b \u0438 \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u044f \u0435\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u043d\u0438\u0436\u0435.<\/p>\n
[root@localhost ~]# git clone https:\/\/github.com\/ensoelectric\/mercury236 [root@localhost ~]# cd mercury236 [root@localhost mercury236]# make -std=c99 -lpthread -lrt cc mercury-cli.c mercury236.c -std=c99 -lpthread -lrt -o mercury236 cc mercury-mon.c mercury236.c -std=c99 -lpthread -lrt -o mercury-mon [root@localhost mercury236]# cp mercury236\/mercury236 \/usr\/bin\/ [root@localhost mercury236]# mercury236 \/dev\/ttyr00 115   Mains status:                               On   Voltage (V):                            228.38   227.51   226.93   Current (A):                              9.06     8.09    11.87   Cos(f):                                   0.58     0.43     0.74 (    0.60)   Frequency (Hz):                          49.97   Phase angles (deg):                     119.83   240.15   120.32   Active power (W):                      1208.21   792.42  1991.39 ( 3992.02)   Reactive power (VA):                   2070.08  1839.36  2695.36 ( 6604.80)   Total consumed, all tariffs (KWh):     766174.88     including day tariff (KWh):          500278.53     including night tariff (KWh):        265896.28   Yesterday consumed (KWh):                 90.32   Today consumed (KWh):                     40.33 [root@localhost mercury236]# mercury236 \/dev\/ttyr00 115 --json {\"mainsStatus\":1,\"U\":{\"p1\":228.14,\"p2\":227.41,\"p3\":226.68},\"I\":{\"p1\":9.11,\"p2\":8.13,\"p3\":12.39},\"CosF\":{\"p1\":0.58,\"p2\":0.43,\"p3\":0.75,\"sum\":0.61},\"F\":49.97,\"A\":{\"p1\":119.90,\"p2\":240.01,\"p3\":120.11},\"P\":{\"p1\":1207.87,\"p2\":794.27,\"p3\":2094.69,\"sum\":4096.83},\"S\":{\"p1\":2078.40,\"p2\":1848.64,\"p3\":2809.92,\"sum\":6736.96},\"PR\":{\"ap\":766174.88},\"PR-day\":{\"ap\":500278.53},\"PR-night\":{\"ap\":265896.28},\"PY\":{\"ap\":90.32},\"PT\":{\"ap\":40.33}}<\/code><\/pre>\n
\u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433<\/h2>\n
\u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0443\u0434\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f Zabbix 5.4. \u041a\u0430\u0436\u0434\u044b\u0439 \u043f\u0440\u0438\u0431\u043e\u0440 \u0443\u0447\u0435\u0442\u0430 \u044f \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e \u043a\u0430\u043a \u0445\u043e\u0441\u0442, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u0448\u0430\u0431\u043b\u043e\u043d<\/a>. \u041e\u043d \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u044d\u043b\u0435\u043c\u0435\u043d\u0442 \u0442\u0438\u043f\u0430 «Zabbix \u0442\u0440\u0430\u043f\u043f\u0435\u0440» \u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u044b\u0445 \u043e\u0442 \u043d\u0435\u0433\u043e \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432.<\/p>\n
<\/figcaption><\/figure>\n
\u041f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0445\u043e\u0441\u0442\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0448\u0430\u0431\u043b\u043e\u043d \u0438 \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435, \u043f\u0440\u0438\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044f\u0441\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u043f\u0440\u0430\u0432\u0438\u043b\u0430: «Mercury [0-255]», \u0433\u0434\u0435 [0-255] — \u0441\u0435\u0442\u0435\u0432\u043e\u0439 \u0430\u0434\u0440\u0435\u0441 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430.<\/p>\n
<\/figcaption><\/figure>\n
\u0425\u0440\u0430\u043d\u0435\u043d\u0438\u0435 «\u043f\u043e\u043a\u0430\u0437\u0430\u043d\u0438\u0439»<\/h2>\n
\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0430\u043c\u0438 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+).<\/p>\n
-- \u0412\u0435\u0440\u0441\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430: 10.3.22-MariaDB  DROP DATABASE IF EXISTS Mercury236Reports;  CREATE DATABASE Mercury236Reports;   USE Mercury236Reports;  -- -- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 `daily_consumed` \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f  -- \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+) \u0437\u0430 \u0441\u0443\u0442\u043a\u0438. --  CREATE TABLE `daily_consumed` (   `addr` tinyint(4) UNSIGNED NOT NULL,   `report` date NOT NULL,   `ap` float NOT NULL,   `created_at` datetime NOT NULL DEFAULT current_timestamp(),   `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),   PRIMARY KEY (`addr`,`report`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  -- -- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 `total_consumed` \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u043e\u0442 \u0441\u0431\u0440\u043e\u0441\u0430  -- \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438 (A+) \u043f\u043e \u0441\u0443\u043c\u043c\u0435 \u0442\u0430\u0440\u0438\u0444\u043e\u0432. \u0421\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, -- \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u043e\u0435 \u0432 \u0442\u0435\u043a\u0443\u0449\u0435\u043c \u0447\u0430\u0441\u0435. --  CREATE TABLE `total_consumed` (   `addr` tinyint(4) UNSIGNED NOT NULL,   `report` datetime NOT NULL,   `ap` float NOT NULL,   `created_at` datetime NOT NULL DEFAULT current_timestamp(),   `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),   PRIMARY KEY (`addr`,`report`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;<\/code><\/pre>\n
\u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435<\/h2>\n
\u0414\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 Zabbix \u0441\u0435\u0440\u0432\u0435\u0440\u0443 \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432 \u0411\u0414 \u043f\u043e\u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0443\u0442\u0438\u043b\u0438\u0442\u0430 zabbix_sender \u0438 shell-\u0441\u043a\u0440\u0438\u043f\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u044f.<\/p>\n
#!\/bin\/bash  # mercury236polling.sh  #Power meters address pm_address=(7 34 43 48 50 54 67 70 73 76 80 81 82 84 89 93 97 115 125 142 144 146 158 199 234)  #ZBX Server zbx_host=\"127.0.0.1\"  #DB credential db_host=\"127.0.0.1\" db_name=\"Mercury236Reports\" db_user=\"user\" db_passwd=\"passwd\"  while [ 1 = 1 ] do     for i in ${!pm_address[@]}     do           data=$(mercury236 \/dev\/ttyr00 ${pm_address[$i]} --json)         zabbix_sender -z $zbx_host -s \"Mercury ${pm_address[$i]}\" -k data -o \"$data\"                  #Save A+ values         py=$(echo \"$data\" | jq '.PY.ap')         pr=$(echo \"$data\" | jq '.PR.ap')         mysql --host=$db_host --user=$db_user --password=$db_passwd $db_name -e \"INSERT INTO daily_consumed (addr, report, ap) VALUES (${pm_address[$i]}, SUBDATE(CURRENT_DATE, 1), $py) ON DUPLICATE KEY UPDATE ap=$py;\"         mysql --host=$db_host --user=$db_user --password=$db_passwd $db_name -e \"INSERT INTO total_consumed (addr, report, ap) VALUES (${pm_address[$i]}, DATE_FORMAT(NOW(), \\\"%Y-%m-%d %H:59:59\\\"), $pr) ON DUPLICATE KEY UPDATE ap=$pr;\"          sleep 1     done done<\/code><\/pre>\n
\u041f\u043e\u0441\u043b\u0435 \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u0438 \u0442\u0440\u0430\u043f\u043f\u0435\u0440-\u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c JSON, \u0430 \u0411\u0414 — \u043f\u043e\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u043e \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u043e\u0439 \u044d\u043d\u0435\u0440\u0433\u0438\u0438.<\/p>\n
\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0441\u0435\u0440\u0432\u0438\u0441 \u0432 systemd<\/h2>\n
\u0414\u043b\u044f \u0442\u043e\u0433\u043e \u0447\u0442\u043e\u0431\u044b \u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u043e \u0437\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043e\u0442 \u043f\u0440\u0438\u0431\u043e\u0440\u043e\u0432 \u0443\u0447\u0435\u0442\u0430, \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0441\u0435\u0440\u0432\u0438\u0441 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 mercury236polling.sh.<\/p>\n
[root@localhost ~]# cp mercury236polling.sh \/usr\/bin\/ [root@localhost ~]# cat \/etc\/systemd\/system\/mercury236polling.service [Unit] Description=Monitoring of electricity meters \"Incotex Mercury 236\" After=network.target  [Service] Type=simple ExecStart=mercury236polling.sh  [Install] WantedBy=multi-user.target [root@localhost ~]# systemctl enable mercury236polling.service [root@localhost ~]# systemctl start mercury236polling.service [root@localhost ~]# systemctl -l status mercury236polling.service \u25cf mercury236polling.service - Monitoring of electricity meters \"Incotex Mercury 236\"    Loaded: loaded (\/etc\/systemd\/system\/mercury236polling.service; enabled; vendor preset: disabled)    Active: active (running) since Tue 2021-11-09 17:26:48 +03; 10min ago  Main PID: 3458296 (mercury236polli)     Tasks: 2 (limit: 23669)    Memory: 672.0K    CGroup: \/system.slice\/mercury236polling.service            \u251c\u25003458296 \/bin\/bash \/usr\/bin\/mercury236polling.sh            \u2514\u25003462352 sleep 1<\/code><\/pre>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/h2>\n
\u0412 \u0434\u0430\u043b\u044c\u043d\u0435\u0439\u0448\u0435\u043c, \u0432\u0435\u0440\u043e\u044f\u0442\u043d\u043e, \u043f\u043e\u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u043e\u043f\u043e\u0432\u0435\u0449\u0435\u043d\u0438\u0439, \u043f\u043e\u043a\u0430 \u0436\u0435 \u043d\u0430 \u0434\u043e\u0441\u0442\u0438\u0433\u043d\u0443\u0442\u043e\u043c \u043c\u043e\u0436\u043d\u043e \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c\u0441\u044f. \u041d\u0438\u0436\u0435 \u0441\u043a\u0440\u0438\u043d\u0448\u043e\u0442\u044b \u0434\u0430\u0448\u0431\u043e\u0440\u0434\u043e\u0432 \u0441 \u0433\u0440\u0430\u0444\u0438\u043a\u0430\u043c\u0438 \u0444\u0430\u0437\u043d\u043e\u0433\u043e \u043d\u0430\u043f\u0440\u044f\u0436\u0435\u043d\u0438\u044f, \u043c\u0433\u043d\u043e\u0432\u0435\u043d\u043d\u043e\u0439 \u043c\u043e\u0449\u043d\u043e\u0441\u0442\u0438 \u0432 web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0435 Zabbix \u0438 \u043f\u0440\u0438\u043c\u0435\u0440 \u0432\u044b\u0431\u043e\u0440\u043a\u0438 \u043d\u0430\u043a\u043e\u043f\u043b\u0435\u043d\u043d\u044b\u0445 \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u0438\u0439 \u0438\u0437 \u0411\u0414.<\/p>\n
Dashboard \u0438 \u043a\u0430\u0440\u0442\u0430 \u0441\u0435\u0442\u0438 \u0432 web \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441e.<\/figcaption><\/figure>\n
\u0412\u044b\u0431\u043e\u0440\u043a\u0430 \u0438\u0437 \u0411\u0414. <\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n

 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  https:\/\/habr.com\/ru\/articles\/588218\/<\/a>
<\/br><\/br><\/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-398754","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/398754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=398754"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/398754\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=398754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=398754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}