the comand "mysql -u root -p
Topic: [NEW] free rig-monitor 4.0 (alpha released) - page 12. (Read 14742 times)
I got stuck at "Create DB and rig-monitor metadata"
the comand "mysql -u root -p < ./rig-monitor/sql/create_db.sql" error
the comand "mysql -u root -p
Thanks. I have renamed the title of the original post to installation instructions and updated it accordingly.
Hey Rodney,
I`m managed to get grafana and everything done. However that CSV file import to the dashboard does not work, how do i import it? Why don't we use the GUI to get it installed but it needs to be in JSON format?
I`m managed to get grafana and everything done. However that CSV file import to the dashboard does not work, how do i import it? Why don't we use the GUI to get it installed but it needs to be in JSON format?
You need to make sure you're following his instructions from his latest post. It's the latest one on his blog. The instructions have changed slightly for importing csv files.
Code:
Import dashboards
Import template dashbords via sqlite:
sudo sqlite3 /var/lib/grafana/grafana.db
sqlite> .separator ","
sqlite> .import dashboards.csv dashboard
sqlite> .quit
Import template dashbords via sqlite:
sudo sqlite3 /var/lib/grafana/grafana.db
sqlite> .separator ","
sqlite> .import dashboards.csv dashboard
sqlite> .quit
Hey Rodney,
I`m managed to get grafana and everything done. However that CSV file import to the dashboard does not work, how do i import it? Why don't we use the GUI to get it installed but it needs to be in JSON format?
I`m managed to get grafana and everything done. However that CSV file import to the dashboard does not work, how do i import it? Why don't we use the GUI to get it installed but it needs to be in JSON format?
Ok. Here's the proper reply:
Thanks for the tip. I will do so this wkd
Fixed in dev branch
I could insert them directly, but keeping the data in CSV allows me to recover it in case I have issues with DBs or upgrades. I think your point is valid but it's more a matter of convenience. Not using CSVs would make the scripts simpler. What's your advice?
Cool. If you do please push it to the repo
Quote
You might want to update your first post when you update this. I was running off that for the latest instructions and they weren't up to date. It's a convention thing to help "updates" not get lost in longer threads.
Thanks for the tip. I will do so this wkd
Quote
There are some issues with your walk through and user permissions. Also I can see that you've edited out the create sql user in the create_db.sql, but your walk through does not indicate that you need to create the user. It also does't setup permissions quite right for your script (grafana only needs SELECT but your script needs a lot more than that). Not hard to fix, but just something to point out.
Fixed in dev branch
Quote
I'm a bit confused by all the local storage of data in CSVs. Aren't you using the database as well?
I could insert them directly, but keeping the data in CSV allows me to recover it in case I have issues with DBs or upgrades. I think your point is valid but it's more a matter of convenience. Not using CSVs would make the scripts simpler. What's your advice?
Quote
I use smartthings for HA and electricity monitoring. I'll probably write something that either works with your script or just writes to the DB directly. I believe I can get that data from their API. ST is pretty popular here in the US so others might like to use that as well.
Cool. If you do please push it to the repo
Thanks for the feedback.
I am on vacation this week (and promised my gf to stay away from the laptop
), so I'll have the fixes published later this week.
I'll also reply more in detail later today.
I am on vacation this week (and promised my gf to stay away from the laptop
), so I'll have the fixes published later this week.I'll also reply more in detail later today.
Great work! I've been playing around with trying to do more of the data/graphing locally. This really helps me get started.
Here are some thoughts.
You might want to update your first post when you update this. I was running off that for the latest instructions and they weren't up to date. It's a convention thing to help "updates" not get lost in longer threads.
There are some issues with your walk through and user permissions. Also I can see that you've edited out the create sql user in the create_db.sql, but your walk through does not indicate that you need to create the user. It also does't setup permissions quite right for your script (grafana only needs SELECT but your script needs a lot more than that). Not hard to fix, but just something to point out.
I'm a bit confused by all the local storage of data in CSVs. Aren't you using the database as well?
The rest of the bugs and issues I'll open on github, unless you'd prefer I put them here.
I use smartthings for HA and electricity monitoring. I'll probably write something that either works with your script or just writes to the DB directly. I believe I can get that data from their API. ST is pretty popular here in the US so others might like to use that as well.
Here are some thoughts.
You might want to update your first post when you update this. I was running off that for the latest instructions and they weren't up to date. It's a convention thing to help "updates" not get lost in longer threads.
There are some issues with your walk through and user permissions. Also I can see that you've edited out the create sql user in the create_db.sql, but your walk through does not indicate that you need to create the user. It also does't setup permissions quite right for your script (grafana only needs SELECT but your script needs a lot more than that). Not hard to fix, but just something to point out.
I'm a bit confused by all the local storage of data in CSVs. Aren't you using the database as well?
The rest of the bugs and issues I'll open on github, unless you'd prefer I put them here.
I use smartthings for HA and electricity monitoring. I'll probably write something that either works with your script or just writes to the DB directly. I believe I can get that data from their API. ST is pretty popular here in the US so others might like to use that as well.
version v1.2 released.
SUPPORT FOR (CLAYMORE) DUAL MINING, COINMARKETCAP, ETHERMINE POOL, NANO POOL AND MPOS-BASED POOLS
The latest version (1.2) of rig-monitor adds the following features:
Support for claymore single and dual mining mode
Integration with ethermine pool (currentStats, payouts) API
Integration with MPOS-based pools (e.g. miningpoolhib) pool (getdashboarddata) API
Integration with nanopool API (generalinfo, payments). Supports all crypto pools (ETH, ETC, SIA, PASC, XMR and ZEC)
Integration with coinmarketcap API for monitoring crypo prices in different quote currencies, trading volume and market cap. Supports conversion to different quote currencies.
Revised template dashboards
If you'd like other pools to be supported then please create issue
Pool dashboard
https://4.bp.blogspot.com/-rBw8xqspzHU/WbUDczF3fEI/AAAAAAAAADs/EjtJhwsw1CQl2mwbaH74p8OgjY-7ykkVACLcBGAs/s1600/Screen%2BShot%2B2017-09-10%2Bat%2B11.10.11.png
Mining overview dashboard
SUPPORT FOR (CLAYMORE) DUAL MINING, COINMARKETCAP, ETHERMINE POOL, NANO POOL AND MPOS-BASED POOLS
The latest version (1.2) of rig-monitor adds the following features:
Support for claymore single and dual mining mode
Integration with ethermine pool (currentStats, payouts) API
Integration with MPOS-based pools (e.g. miningpoolhib) pool (getdashboarddata) API
Integration with nanopool API (generalinfo, payments). Supports all crypto pools (ETH, ETC, SIA, PASC, XMR and ZEC)
Integration with coinmarketcap API for monitoring crypo prices in different quote currencies, trading volume and market cap. Supports conversion to different quote currencies.
Revised template dashboards
If you'd like other pools to be supported then please create issue
Pool dashboard
https://4.bp.blogspot.com/-rBw8xqspzHU/WbUDczF3fEI/AAAAAAAAADs/EjtJhwsw1CQl2mwbaH74p8OgjY-7ykkVACLcBGAs/s1600/Screen%2BShot%2B2017-09-10%2Bat%2B11.10.11.png
Mining overview dashboard
UPDATE:
Added support for Ethermine pool monitoring. Check version 1.1 https://github.com/rodneymo/rig-monitor
Current version supports currentStats and payouts APIs.
Upgrade instructions are here: http://randomcryptostuff.blogspot.nl/2017/09/update-ethermine-pool-monitoring-added.html
If you'd like other pools to be supported then please create issue
Added support for Ethermine pool monitoring. Check version 1.1 https://github.com/rodneymo/rig-monitor
Current version supports currentStats and payouts APIs.
Upgrade instructions are here: http://randomcryptostuff.blogspot.nl/2017/09/update-ethermine-pool-monitoring-added.html
If you'd like other pools to be supported then please create issue
Wow thank you and great job putting all this together! Looks clean and does the job well.
Just a bit confused with what you said here:
Do the smart plugs do the power monitoring or not?
Just a bit confused with what you said here:
Beware that, if you want to monitor power consumption you'll need the HS110s. The HS100 do not support power monitoring.
Do the smart plugs do the power monitoring or not?
Thanks.
Those are 2 different models: the HS100 supports remote power on/off, scheduling, etc... but not power consumption monitoring. For that you need the HS110, which are a bit more expensive.
Also, why use the raspberry pi as a server instead of just using the cpu on one of your rigs?
I decided to run in on a separate service for several reasons:
- I need to be able to keep monitoring the rest of the rigs during crashes and upgrades
- the raspberry will monitor rigs for "long" server freezes and reboot them automatically (this is in my TODO list)
- stability. those little things are very resilient. I have been running one for 3 years in a row without any issue
Or maybe all those reasons are bullshit and it's sys admin brain messing with me again
Awesome. That clears things up, i may have been sleepy when i wrote my post. Makes sense to have the RPI because all 3 rigs may go down at the same time. Again, great job! Thank you for the tutorial. I may do this when i get the time to do so.
Wow thank you and great job putting all this together! Looks clean and does the job well.
Just a bit confused with what you said here:
Do the smart plugs do the power monitoring or not?
Just a bit confused with what you said here:
Beware that, if you want to monitor power consumption you'll need the HS110s. The HS100 do not support power monitoring.
Do the smart plugs do the power monitoring or not?
Thanks.
Those are 2 different models: the HS100 supports remote power on/off, scheduling, etc... but not power consumption monitoring. For that you need the HS110, which are a bit more expensive.
Also, why use the raspberry pi as a server instead of just using the cpu on one of your rigs?
I decided to run in on a separate service for several reasons:
- I need to be able to keep monitoring the rest of the rigs during crashes and upgrades
- the raspberry will monitor rigs for "long" server freezes and reboot them automatically (this is in my TODO list)
- stability. those little things are very resilient. I have been running one for 3 years in a row without any issue
Or maybe all those reasons are bullshit and it's sys admin brain messing with me again
Wow thank you and great job putting all this together! Looks clean and does the job well.
Just a bit confused with what you said here:
Do the smart plugs do the power monitoring or not?
Also, why use the raspberry pi as a server instead of just using the cpu on one of your rigs?
Just a bit confused with what you said here:
Beware that, if you want to monitor power consumption you'll need the HS110s. The HS100 do not support power monitoring.
Do the smart plugs do the power monitoring or not?
Also, why use the raspberry pi as a server instead of just using the cpu on one of your rigs?
rig-monitor is a free monitoring tool for rigs, pools, smart plugs and market data.
What's new in version 4.0 (alpha):
- Updated market monitor module to use update coinmarketcap.com API
- Refactored code base to make it simpler to extend/add new miners/pools/smartplugs
Complete feature list:
- Single executable for monitoring pools, rigs, power and market data with support for logging, tracing
- Single, consolidated mining dashboard with drop-down menu to select pool, including mining rig metrics, environment metrics (temperature, fan, power usage), market, revenue and profitably charts, etc…
- Ability to pool thousands of rigs and dozens of pools simultaneously
- miner support
- claymore single/dual-mining (tested v12)
- cgminer (not tested)
- Xmr-stak (tested v2.4.2)
- sgminer (not tested)
- SRBMiner(tested v1.9.3)
- XMRig-proxy (not tested)
- XMRig
- PhoenixMiner
- CastXmr (not tested. Miner development stoped)
- bminer
- EWBF (not tested. Miner development stoped)
- Ethminer
- pool support
- Nanopool (all coins)
- Ethpool, Ethermine & Flypool (all coins)
- Mpos based pools e.g. miningpoolhub.com (all coins)
- Nodejs-pool based pools e.g. hashvaultpro.com (all coins)
- Fairpool
- Suprnova pools (not tested)
- Cryptoknight pools
- Yiimp pools (and pools using extended API e.g. Unimining)
- power monitoring using smartplugs
- TP-Link HS110 v1.0 and v2.0 hardware
- Wemo Insight
- power management rules enable users to trigger rig reset via smart plugs or external script in case a given KPI limit is crossed
- TP-Link HS110 v1.0 and v2.0 hardware
- Wemo Insight
- Revive devices
- User-defined scripts
- Market data monitoring
- Coinmarketcap.com
- whattomine.com
- Data storage using influxDB
- Cross-platform support
- linux/ARM
- linux/ARM64
- linux/x86-64
- macOS/x86-64
- windows/i386
- windows/x86-64
- Launch remote management applications like ssh or Team Viewer from Grafana
- Custom config file replaced with toml-based config file
- Automatic reload of rig, pool and power management rules in case of configuration file changes, during runtime
- Notifications via Telegram
Download and instructions here: https://www.rigmonitor.app/blog/
If you'd like other miners/pools/APIs to be supported then please submit a feature request on github.
For support please join the telegram group https://t.me/joinchat/IuYcwBKqbGqIeXpw9sfq7Q
Buy me a beer if you find this useful
BTC: 19zCtLQgUQPgZ24bPWw4CSC6N53BusXa6A
ETH: 0x0f2d4397CecB53883411cfe75882622c312c8340
MUSICOIN: 0x9a44a57041acd5f1511bf13a663d136ddbde1fb1
Jump to: