Exporting Transaction Logs for Cube Bitcoin ATM

A list of the most recent transactions are visible from within the transaction panel of the admin.

Full details on all transactions may be exported in spreadsheet format for accounting and research purposes following the article below.

⚠️‏‏‎ ‎ NOTE: You may also securely download logs directly from the server. This is helpful in case an email provider blocks these log attachments. If so, please follow the instructions under the Direct tab.

You may download and install the log scripts with the following command:

curl -sS https://raw.githubusercontent.com/lamassu/lamassu-patches/master/logs/download.sh | bash

The commands it adds are:

• export-cash-in

• export-cash-out

• export-bills

• export-out-actions

• export-customers

• export-sanctions-log

• export-trades

These will save the latest logs as a spreadsheet in your server's /tmp folder.

For example, to export cash-in transaction logs from the database, run:

root@wynand-building:~# export-cash-in
COPY 145
Saved to /tmp/cash_in_txs.csv

You can use scp to download the logs directly to your computer.

Follow the instructions below accordingly to the computer you're using:

Mac OS / LinuxWindows

Within your Mac or Linux computer's terminal (not your server terminal), run, replacing 1.2.3.4 with the IP of your droplet, and replacing 'cash_in_txs.csv' with the name of the file you just exported:

scp root@1.2.3.4:/tmp/cash_in_txs.csv ~/cash_in_txs.csv

It will prompt for the same passphrase that you use to connect to your droplet via SSH. The command will download the log file to your home directory.

Run the above for each log you exported, replacing 'cash_in_txs.csv' above with the appropriate file name. Examples for cash-out and bills:

scp root@1.2.3.4:/tmp/cash_out_txs.csv ~/cash_out_txs.csv

scp root@1.2.3.4:/tmp/bills.csv ~/bills.csv

Within your Windows computer's terminal (not your server terminal), run, replacing 1.2.3.4 with the IP of your droplet, and replacing 'cash_in_txs.csv' with the name of the file you just exported:

scp root@1.2.3.4:/tmp/cash_in_txs.csv ./cash_in_txs.csv

It will prompt for the same passphrase that you use to connect to your droplet via SSH. The command will download the log file to your home directory.

Run the above for each log you exported, replacing 'cash_in_txs.csv' above with the appropriate file name. Examples for cash-out and bills:

scp root@1.2.3.4:/tmp/cash_out_txs.csv ./cash_out_txs.csv

scp root@1.2.3.4:/tmp/bills.csv ./bills.csv

In your server, run the command for the log you wish to export, followed by your email address.

If it's the command for an encrypted log, you'll need to import a PGP key and use the email address associated with your PGP key. (See the importing section below.)

Encrypted logs:

• cash-in-log – All cash-in transactions.

• cash-out-log – All cash-out transactions (if a two-way machine).

• cash-out-actions – All cash-out dispense and refill events.

• bills-log – Each individual bill inserted and their denomination.

• customers-log – Table of customers and their scanned ID information.

• sanctions-log – Instances of customers triggering sanctions.

• trades-log – Record of exchange trades.

• send-server-log – Emails lamassu-server logs to our support team for research.

Unencrypted logs:

• cash-in-unencrypted

• cash-out-unencrypted

• out-actions-unencrypted

• bills-log-unencrypted

• trades-log-unencrypted

If the email doesn't appear, check your spam folder. Some email services may block such emails entirely, so if not in spam, try an email address with a different provider or download logs directly from the server.

This is optional, though will allow you to export spreadsheets so that they are encrypted in transit, and thus not expose you or your customers' data.

Instructions for creating a PGP keypair and uploading to a public keyserver:

– Linux
– Mac
– Windows (creating, uploading)

Once uploaded to a keyserver, import your key to your Lamassu server by running:

gpg --search-keys --keyserver <keyserver> <key ID or email address>

Buy Cube ATM - CubeATMs.com

Bitcoin Capitalist - BitcoinCapitalist.io

YouTube - Demo Videos

LinkTree - All Links