Bitcoin Forum
December 04, 2022, 01:54:06 AM *
News: Latest Bitcoin Core release: 23.0 [Torrent]
  Home Help Search Login Register More  
  Show Posts
Pages: [1]
1  Economy / Computer hardware / [SOLD] iPhone 5s 64 GB - Perfect condition - US sales only on: February 26, 2017, 08:38:07 PM
I'm selling my iPhone 5s. Here's some info on the sale:

  • The phone is the 64 GB model.
  • The phone is in perfect condition. Works great. Not a scratch on it.
  • A Spigen SlimArmor case is included.
  • The SIM card has been removed.
  • Lightning cable, charger, and headphones are not included.

I'll pay shipping in the continental US. US sales only.

Escrow with OgNasty or philipma1957 is fine by me, buyer pays the fee.

The price is $200 - BTC @ current BitStamp rate.

Here's a picture of the front of the phone:

Here's the back:

PM me if you're interested.

EDIT: Updated to indicate that this is a 64 GB model.
2  Bitcoin / Bitcoin Discussion / How to make Bitcoin spreadsheets that automatically update on: September 04, 2016, 11:36:01 PM
UPDATE! As my script has grown in functionality, I decided to share it on GitHub here:

Original post follows below...


I'm on a Mac, so up until recently I used Numbers as the spreadsheet application for mining ROI and other Bitcoin investment worksheets. The thing is that I wanted values in the spreadsheet to automatically update, which Numbers doesn't support.

After searching for a solution, I decided to try Google Sheets. It supports automatic currency rate updates, including BTC. It also supports Javascript, so it's easy to access various blockchain info APIs.

I've used this functionality to automate my spreadsheets. It's pretty cool to get notification of a mining pool payment, then open the spreadsheet and see the ROI numbers automatically recalculate.

This info is probably not news to veteran forum members. Also much of this info can be found by Google searching. But in case anyone finds it helpful, I'm including the formulas and scripts that I'm using for my BTC spreadsheets.

First, you can paste the following formula into a cell and it provides the current BTC/dollar rate:


On reddit a poster indicated that the above value comes from the Coinbase broker prices, but I have not confirmed that. For my purposes the value returned by the above function is close enough.

Next, here's some simple scripts that will return information about a given bitcoin address:

// Use to receive JSON info for a given bitcoin address
function getAddressInfoJson(address)
var url = "" + address;
var response = UrlFetchApp.fetch(url);
var json = response.getContentText();
var parsed = JSON.parse(json);
var data =
return data

// Return the total received by a bitcoin address
function walletReceived(address)
var data = getAddressInfoJson(address)
return data.totalreceived;

// Return the total transactions for a bitcoin address
function walletNumTransactions(address)
var data = getAddressInfoJson(address)
return data.nb_txs;

// Test the above functions
function test()
  var address = "18wQtEDmhur2xAd3oE8qgrZbpCDeuMsdQW"
  var received = walletReceived(address)
  var numTransactions = walletNumTransactions(address)
  Logger.log(address + ":     ");
  Logger.log("  received:     " + received);
  Logger.log("  transactions: " + numTransactions);

  // Blocks if Safari popups blocked

To use the above scripts, go to the Tools -> Script editor... page and paste the above script code and save it. Then you can go back to the spreadsheet and use the script functions.

For example, to get the total received by a given address enter a formula like the following into a cell:


Originally I tried using, because I found a script example using their API. But I started getting errors indicating that the endpoint had been used too much, or something to that effect. So I switched to and haven't had a problem.

If you want to add a new function to access different information about an address, it's pretty easy to add. Just go to the Script editor, copy one of the functions (renaming it as appropriate) and change it to return the JSON data you're interested in. You can see the list of JSON data items returned by just pasting the following URL (with your Bitcoin address) into a browser:

I realize that Google isn't for everyone, especially sidehack Wink  But if you can get past the potential privacy issues and working with a monster company like Google, the functionality they provide is very convenient.
3  Economy / Computer hardware / [SOLD] Modded Thunder X3 including PSU - US on: April 05, 2016, 03:03:40 AM
Great news everybody!

I'm selling my modded Zeus Thunder X3 scrypt miner!

It has a PSU included (built into the case) and three custom fans making it extremely quiet without overheating. Super stable and reliable. The sound level is similar to an S3.

This unit has been run in a dust free, air conditioned data center environment for the entire time I've owned it.

Gets between 25 and 28 MHs, depending on the frequency you select.

The sale includes:

  • Zeus Thunder X3 scrypt miner
  • A Cougar GX 1050w PSU built into the case
  • 2 LED lit Corsair anti static fans plus a Cougar 80 cfm quiet fan in the center
  • USB and power cables

All you need is a controller (like a RPi running Minera).

Here's a picture:

Buyer pays shipping. I prefer US sales.

Escrow with OgNasty or philipma1957 is fine by me, buyer pays the fee.

Looking for $100. Make me an offer.
4  Economy / Computer hardware / [WTS] 13 x Gridseed 5-chip mini's + 3 PSUs (cables, hubs + extras included) - US on: April 05, 2016, 02:50:25 AM
It's your lucky day because I'm selling my Gridseed mini (5 chip) micro farm! Own a piece of history!

The sale includes:

  • 13 x Gridseed 5 chip mini's
  • 3 x 12 volt power supplies
  • 2 x ORICO P10-U2 10 port USB hubs
  • All the USB and 12 volt connectors for each unit
  • A controller that I never used (I have no idea if it works or not)
  • A whole mess of brass stand offs (not sure how many)

Here's some pictures:

All the Gridseeds work. I've only mined Scrypt with them, never SHA256.

All the equipment has been pampered in a dust free, air conditioned data center environment.

I removed some of the fans in order to work the units into the physical configuration I was after. I'll give you all the fans, but it's up to you if you want to reattach them. You don't need them if you're mining scrypt.

One of the units has a bad hashing LED that won't light, but it's always submitted shares nonetheless.

Edit: Two of the PSUs have bad fans. I didn't notice because these were running in a data center. Lack of fans doesn't seem to matter, at least when running in a cold environment. The PSUs with bad fans are not even warm to the touch. If you care about this, replacement fans can be found online for a few dollars.

Buyer pays shipping. I prefer US sales.

Escrow with OgNasty or philipma1957 is fine by me, buyer pays the fee.

Looking for $250. Make me an offer.
5  Economy / Computer hardware / [WTS] 6 x $100 AntMiner S7 Coupons - 0.01 BTC each on: March 26, 2016, 10:03:37 PM
PM me if you're interested.
6  Economy / Computer hardware / [WTS] 3 x S7 batch 1 US - Sold! on: March 25, 2016, 03:14:08 PM
These three S7s from batch 1 have been running in a dust free, air conditioned data center for their entire mining career. All three have run without any issues.

Looking for 1.44 BTC per unit.

You pay for shipping from the US. I'll ship in the original boxes for safe arrival.

If you want escrow, we'll use OgNasty and you pay his fee.

Here's a picture:

7  Economy / Computer hardware / [SOLD] SP20E / $320 / US / Escrow OK on: September 27, 2015, 06:56:56 PM
This SP20E is a super reliable workhorse. Its entire career has been spent running at stock speeds in a dust free, air conditioned data center.

This beast has been pampered by a cold environment. Input temps have been around 20 decrees C or less. Currently the unit is indicating 18 degrees C on the input sensor.

Looking for $320.

You supply the shipping label from the US. I'll ship in the original box for safe arrival.

If you want escrow, we'll use OgNasty and you pay his fee.

Here's a picture (excuse the bad phone camera quality):

8  Economy / Computer hardware / [SOLD] 29 x DualMiner USB sticks (Scrypt-only) on: September 07, 2015, 11:29:44 PM
Interested in 1.9 MH/s of raw Scrypt power? Well today is your lucky day!

I've got 29 DualMiner 2 USB sticks for sale. These are Scrypt-only, not the original model that also mined SHA256.

I'm looking for $10 each, or $250 for the whole pile.

EDIT: Hubs and fans not included in the above price.

Buyer pays shipping from the US.

If you want escrow, we'll use OgNasty and you pay his fee.

Not that anyone would want these for anything but a collector's item or a key ring, here's some info about these screamers:

  • Each unit produces around 65 - 70 KH/s.
  • Power consumption is around 1.5 watts per unit.
  • Super reliable, these babies have been hashing continuously for 17 months without a single failure.
  • They've spent their entire career in a contaminant free, air-conditioned server closet under near data center conditions.
  • The heat sinks on all the units is blue. Very pretty!

Why am I parting with these beasts? Because I need to make room for my next rig that won't ROI Wink

Get your piece of history today!

9  Bitcoin / Mining support / Mining directly to a Trezor? on: February 28, 2015, 10:15:34 PM
I've gotten to the point where I've mined enough BTC that I'm considering moving to a Trezor.

Currently I mine to a few addresses in a Bitcoin-Qt wallet. I guess we all have to start somewhere Wink

Any concerns about mining directly to a Trezor?
10  Economy / Computer hardware / [SOLD] 2x Antminer S3 batch 3 - US on: November 30, 2014, 03:49:24 PM
I'm upgrading to new hardware and have to make room. So I have 2 S3s from batch 3 for sale.

The price is 0.4 BTC each, you provide shipping. Power supplies not included.

Both S3s are solid performers. I kept notes regarding tuning and performance and can provide them if you're interested.

If you want an escrow, we can use OgNasty. Shipping in original boxes from Bitmain.

I can ship as early as Monday 12/1.

US Sales only please.
11  Bitcoin / Mining support / [GUIDE] Configure your miner software as a service under daemontools on: April 19, 2014, 05:41:57 PM
I run my rigs completely headless. I want the miner software to automatically start at reboot or when it crashes. I also want a few days worth of logs for troubleshooting, but I don't want the logs to chew up too much disk space and I don't want to wear out the SD card in my Raspberry Pi.

There are a number of ways that people autostart their miner software under Linux. But some of the techniques are really not very clean. I'm not interested in running the miner under "screen" and having no reasonable log history. When I want to check on my miners, I prefer to a web front end or a script that calls the miner software's JSON API.

So what I've done is use daemontools from D. J. Bernstein to manage the mining software. It's a simple and awesome set of tools that reminds me of "launchd" for the Mac, but better.

If anyone is interested in going this route, here's how to setup cgminer (although any mining software should work) under daemontools.

Install daemontools

sudo apt-get install daemontools-run daemontools

Create the directories for the run and log scripts:

sudo mkdir /etc/service/cgminer
sudo mkdir /etc/service/cgminer/log

Add the service scripts

Put the following script in a file called "run" in the /etc/service/cgminer directory:

# cgminer/run
# run script for cgminer daemon

# Minimal environment

# Redirect stderr to std out so that our log will pick it up
exec 2>&1
echo "*** Starting service cgminer..."

# Exec cgminer, which preserves the same process. Change the path and options as needed.
# Note that you have to run cgminer in text-only, non-terminal mode. I opted to force that
# option here rather than rely on it being set correctly in the conf file.
exec /usr/local/bin/cgminer --config /home/pi/config/cgminer.conf.ltc --text-only

Note that you may have to change the path to the cgminer executable and your conf file above.

By default daemontools will run services as root. This works well for me because I found that cgminer seems to need root permissions to access the USB devices anyway. But if you prefer to run your miner software as another user, it's easy to do. See the "More information" section at the end of this post for links to daemontools documentation.

If you want logging enabled, then you need to put this script in a file called "run" in the /etc/service/cgminer/log directory:

# cgminer/log
# log script for cgminer daemon

# Minimal environment

# Define the path to the log folder

# Make a folder fo the cgminer log files
mkdir -p ${logFolder}
chmod 755 ${logFolder}

# Set up multilog to handle logging the output from cgminer. It will rotate after 10 meg and
# keep two historical copies in addition to the current one.
exec multilog s10485760 n3 ${logFolder}

The above script will put the log files in the /var/log/cgminer directory. The current log file will be called "current". The parameters to multilog above indicate that it should limit the log file size to 10 meg, and that it should keep the most recent 2 log files plus the current one. This way old log data is deleted and you won't run out of disk space.

You have to also make sure that both scripts are executable:

sudo chmod 755 /etc/service/cgminer/log/run
sudo chmod 755 /etc/service/cgminer/run

If you've done everything right, then cgminer should be running. If you reboot, cgminer will be auto started. If cgminer crashes, then daemontools will restart it automatically.

Check the service

You can use the following command to check on the status of cgminer running under daemontools:

sudo svstat /etc/service/cgminer

And you can see what's happening in the log with a tail command like this:

tail -500f /var/log/cgminer/current

If you need to stop cgminer, maybe because you want to change the config file or other maintenance, this command will stop the cgminer service:

sudo svc -d /etc/service/cgminer

This command will start the service back up again:

sudo svc -u /etc/service/cgminer

Notes on logging

A couple of thoughts regarding logging. First, I'm not sure how safe it is to run a Rasperry Pi from an SD card with lots of log churn. I'm not an expert on flash technology, but I was concerned that at some point lots of log writes might wear out the flash. Again, I must stress that I don't know if this is a real problem or one that I've imagined.

Originally I thought that I'd have logging on only while my rig was new and that I'd disable it later to conserve flash write cycles. But after running two rigs for over a month, I came to the conclusion that logging is essential. Problems crop up with my rigs, and access to historical logs are the only way to figure out what happened.

Second, when I first set up logging, I could not get it to work. Apparently there's an issue with daemontools where if you create the service "run" script first, then you create the "log/run" script, the daemontools service scanner doesn't see the change and does not enable logging.

To work around this, I rebooted my system after configuring logging. After that, logging worked like a charm. There's probably a more elegant way to work around this issue, but I didn't look into it further.

Using ramlog

Since I decided that logging was essential, but I didn't want to burn up my flash, I decided to use a package called ramlog. This useful package keeps the log files in ram, committing them to disk only on reboot. This should save on flash wear and tear. Instructions for installing ramlog follow here.

EDIT: If you're using Raspbian Jessie, then don't install ramlog. Use log2ram instead. See my post below for details.

First, you need to figure out how big to make the ramlog partition.

So how big is my log folder now?

sudo du -sh /var/log
9.9M /var/log

How much of that is the miner log?

sudo du -sh /var/log/cgminer
5.9M /var/log/cgminer

So the regular log files amount to about 4M on my Pi. I've set the miner logging to only keep 3 log files at a time and limit them to 10 meg. I think that means it can grow to 30 meg (including the "current" log).

How much ram do I have left?

free -m

             total       used       free     shared    buffers     cached
Mem:           437        180        256          0         15         82

But I've seen it a lot lower (like 160M).

So I think 50 meg for the ramlog is probably enough and won't impact the system too bad. Once I knew how big to make my ramlog mount point, I followed these ramlog installation instructions:

In case the above URL goes away, here's the steps I took:

sudo apt-get install lsof
mkdir ~/packages
cd ~/packages/
sudo dpkg -i ramlog_2.0.0_all.deb

echo "TMPFS_RAMFS_SIZE=50m" | sudo tee /etc/default/ramlog

sudo reboot

So now all log files are written to a RAM disk based mount point and have no ongoing impact on the flash. When the system is rebooted, the log files are committed to flash, and then read out on the other side, so they aren't lost. But that's a lot less wear and tear than continuously writing log file data.

Shortcuts for convenience

It's nice when I log in via ssh to have a simple set of commands to check on the miner software status, start/stop the miner, etc. Rather than try to remember the commands, I've made a few simple shortcuts that I've added to my .profile, plus help text that's displayed at log in time. This is of course a completely optional step, but I find it helpful.

Here's the script code to add to your .profile file:

# Miner system shortcuts
alias miner_shutdown='sudo shutdown now'
alias miner_reboot='sudo reboot'

# Shortcuts for miner service
export MINER_SERVICE_PATH="/etc/service/cgminer"
alias miner_stat='sudo svstat ${MINER_SERVICE_PATH}'
alias miner_start='sudo svc -u ${MINER_SERVICE_PATH}'
alias miner_stop='sudo svc -d ${MINER_SERVICE_PATH}'
alias miner_restart='miner_stop; miner_start'

# Miner log shortcuts
alias miner_log_stat='sudo svstat ${MINER_SERVICE_LOG_PATH}'
alias miner_log_start='sudo svc -u ${MINER_SERVICE_LOG_PATH}'
alias miner_log_stop='sudo svc -d ${MINER_SERVICE_LOG_PATH}'
alias miner_log_tail='tail -500f /var/log/cgminer/current'

# Misc miner shortcuts
alias miner_list='sudo cgminer -n --usb-devs'

# Show some useful commands
echo "Here are some helpful mining commands:"
echo "  miner_shutdown    - Shut down the system."
echo "  miner_reboot      - Reboot down the system."
echo "  miner_stat        - Shows how long the cgminer service has been running."
echo "  miner_stop        - Stops cgminer service."
echo "  miner_start       - Starts cgminer service."
echo "  miner_restart     - Restarts cgminer service."
echo "  miner_log_tail    - Tails the current mining log."
    echo "  miner_list        - Asks the miner app to list known devices."

# Display a welcome message
echo "Welcome to $HOSTNAME!"

# Show the welcome when logging in

So if something is wrong, I can ssh in and look at the current log via miner_log_tail. If I've changed my config and I want to restart the miner service, I use miner_restart (which just stops and starts the service).

More information

Lastly, if you're interested in more information regarding daemontools, here are some links that I used to get my feet wet:

Hopefully someone finds this info helpful.
Pages: [1]
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!