Blog Archive: December 2017

Simple GPU Overclocking Boosts Ethereum Mining Profitability by 20.65% - Now Making $2.66 Daily

| Servers | 12 seen

Welcome to the last post of 2017, and no surprise but today I will speak about increased Ethereum (and Siacoin) mining profitability by overclocking GPU cards.

Those of you following my blog lately already know - in December I decided to build 12 GPU mining rig and ordered goodies from Amazon. In total spending about $1,147.  The total investment right now covers just the core minimum - motherboard, power supply, PCI risers, RAM, processor and just 2 graphics cards.

At the start, I ordered just one graphics card from Amazon, but while still waiting for equipment to arrive I decided to set up a test environment at one of our office spare computers and installed a cheap Radeon RX 560 card. 

Top 14 Best Selling GPU Cards 2018

The first result with RX 560 card gave me about $0.98 profit daily, see: I'm Making $0.98 Per Day By Mining Ethereum and Siacoin, and I want MORE!

I was pretty happy with results I got from this card, though felt kind of surprised seeing hashing power just about 10 MH/s - it didn't sound good (as I have read that others are getting about 14 MH/s out of this card). Anyhow, as I was (and still am) new to mining, I decided to leave it as it is, not touching clocks, memory size e.t.c. 

Now, I what I was looking for was a decent about 22.5 MH/s hashing power from the EVGA 1060 GTX 6 GB card, but felt very poor seeing just 14MH/s out of the box - I was able to increase daily profit from about a dollar to  two and a half dollars, but this time it seemed wrong, see: I'm Making $2.44 Per Day By Dual Mining Ethereum and Siacoin, and I'm NOT HAPPY YET!

Both cards combined gave me really modest 24.5 MH/s hashing power (instead of 36 MH/s). I left mining rig to work for a couple of days, meanwhile watching a dozen of YouTube videos, reading countless forum topics on overclocking. And finally yesterday I applied my newly generated knowledge and was able to increase total hashing power to about 29-30MH/s

  Hashing Power   Mined Coins Exchange Rates Earnings       GPU ETH SC Invested ETH SC ETH SC ETH SC Total How many days 2 28.29 179 $1,147 0.0036256 3.7 $704.16 $0.03 $2.55 $0.11 $2.66 430.5

Now, there are few things I should mention.

  • Currency exchange rates - since my previous test price for ETH has dipped from about $770 to $704
  • Despite ETH has lost some value against USD in the past couple of days, the total income has increased. 
  • I learned that I could get more hashing power with single coin mining, instead of dual coin mining, and the results were actually quite satisfactory, from both cards I was getting about 31 MH/s single mining ETH only.
  • For some reason overclocking worked only for GTX 1060 card, RX 560 was not affected at all, probably the reason it is so - I'm running mixed AMD + NVIDIA rig.

From the positive I should add, that the total ROI has decreased from 468 days to 430 days - a very nice 38 day gain with simple overclocking.

Now, the ROI and ETH exchange rates are the things that worry me the most (now) - to be in the safe side I would love to see ROI in 365 days or better 10 months.

With current mining power, that would ask ETH to be valued at $836 to get investment back in 365 days or about $1,025 for ROI in 10 months. 

Now, I don't dare to say it loud, but OK, I will say - I believe Ethereum reaching $2,000 by the end of 2018.

To Mine or Buy Ethereum/Zcash/Monero in 2018


Taverna Plateia in Mirthios, Crete

| Restaurant reviews | 28 seen

Ok, this is just another roadside cafeteria, discovered by accident - meet Taverna Plateia in the village of Mirthios, on the island of Crete.

At least I believe it is located in Mirthios village, as we did our trip to Crete back in June 2017, now browsing through the huge photo archive at Adobe Lightroom, I might be wrong. Though it's worth to mention this place as we had a nice dinner here.

Taverna Plateia in Crete

My one and only reference point - signboard - Taverna Plateia. If looking through my Crete discovery map, this might be the right location

Quick dinner at Taverna Plateia

Cretan dolma​


Lake Kournas in Crete

| Lakes | 15 seen

Lake Kournas is a lake on the island of Crete, Greece, near the village of Kournas. It is in the Apokoronas municipality of Chania regional unit close to the border with Rethymno regional unit, 47 km from the town of Chania. Kournas is a fairly large village perched on a hill overlooking the lake.

We headed to the Lake Kournas in June 2017, just to spend a nice afternoon here and enjoy a mild swim in the lake water.

It should be noted that Lake Kournas is Crete's only freshwater lake

Lake Kournas in Crete

Lake Kournas, is relatively large, with a perimeter of 3.5 km. Although almost all touristic leaflets say that it is possible to walk around the lake, that is not true. At least not at the end of the rain season (winter). There is a nature preserve on the Southwest of the lake. But there is a rustic road from the North of the lake to the Hills on the West of the lake too.

Catamarans for rent at lake Kournas

Seems a very popular tourist attraction here, as we didn't try one this time I'm not sure about pricing, but it was something like EUR 5 for 1 hour (or at least 30 minutes)

There are two roads that lead to Lake Kournas. As you drive up from the main local road Eparchiaki Odos Georgioupolis-Kournas you will come across road signs posted Lake Kournas Exit 1 and Lake Kournas Exit 2. On Lake Kournas Exit 1 you will come through an area of ten houses and cottages known as Dimitrouliana Metochi(small village) 

A unique feature of Dimitrouliana is a group of stone cottages that were built during the Ottoman rule, during the 1700s and possessing Venetian Architecture. Such houses, can be found in many locations in Crete and have central arches made of thick carved stones and wooden lofts to the left and right sides of the arc. One such cottage with a large central arc is Villa Christiana at the Dimitrouliana Metochi.

Lake Kourna's popularity due to its ecosystem, has always been a tourist attraction and many owners have renovated their cottages and homes during the first decade of the second millennium giving an aesthetic look to the area, while preserving the architecture of the structures. The road off the Metochi leads to the lake within 200 meters. As it continues curving along a stretch of the lake, it will come across several isolated restaurants until it reaches to Exit 2 of Lake Kournas. There you can find a more organized structure of taverns and restaurants overlooking the lake. During the tourist season there are pedalos, canoes and sunbed for enjoyment. Leaving the Lake area up the road of Lake Kournas, Exit 2 it leads to the main Eparchiaki Odos of Georgioupolis-Kournas.


Learning Crypto Currency Mining The Hard Way

| Servers | 17 seen

It has been a couple of days since my first GPU mining rig is set up and running, making me a couple of extra dollars every day. In these past couple of days, I have learned a lot, mostly tech stuff how to install different components on a motherboard and to connect to the mining pool.

In today's article, I will share a few photos and notes what helped to get me here.

It all started with ordering details for 12 GPU mining rig from Amazon. It sounds bit insane but I spent about $1,000 just for the core minimum + about $200 additionally for getting these goodies to Tbilisi (transport and cost). As the estimate shipping time for all details from US to Georgia is about 3 weeks (I've received almost all components, except a few) and I had FOMO for crypto mining, I rushed and bought a cheap Radeon graphics card here in Tbilisi to set up and test on one of the free office computers.

Brand new Radeon RX 560 graphics card

The cat seemed very interested in this business. Once I took this card to the computer, I learned the first couple of lessons:

  • I don't have a screwdriver to open the case
  • Turns out video cards needs an additional power supply, which persisting power block didn't offer out of the box, and I had to use Molex cables to fix this. 
  • The screwdriver was an easy fix - I borrowed one from local Tbilisi restaurant owner - A nice Armenian guy. Molex cables were kind of problem - I spend a good time of afternoon and just in the next days morning find them at Kidobani market in Tbilisi. Bought two of them.

    Molex 6-pin connector

    I watched a dozen of YouTube videos on how to install them correctly.

    Installing graphics card in PC

    As I did a lot of testing, I accidentally damaged existing HDD, probably because of static electricity, who knows. At this stage, HDD is still working though and Windows 10 operating system is running smoothly.

    Radeon graphic card drivers for Windows

    For some reason I tried to install Radeon graphics card drivers for Windows (PC just refused to recognize this new card installed), then I figured out that I should connect the monitor directly to the graphics card and turned out I cannot do it - as the monitor had an older DVI cable. Spent another good time watching YouTube videos to learn I should buy some DVI - VGA converter. 

    It was time to go back to the Kidobani market.

    Again, bought a couple of versions of these adapters, just to be sure

    DVI to VGA converter

    Now it was time to set it up

    Monitor connected to graphics card

    Almost there, and then it happened HDD died.

    I felt poor. Went home - returned to YouTube video's and learned there is Simple Mining OS which could be run from a USB stick.Spend another couple of hours making a bootable USB stick, returned to the office, plugged in the USB stick, configured boot to launch from USB and... VICTORY. I was connected to mining pools and started mining Ethereum and Siacoin. See: I'm Making $0.98 Per Day By Mining Ethereum and Siacoin, and I want MORE!


    I'm Making $2.44 Per Day By Dual Mining Ethereum and Siacoin, and I'm NOT HAPPY YET!

    | Crypto | 11 seen

    This is a quick follow up post after previous and initial I'm Making $0.98 Per Day By Mining Ethereum and Siacoin, and I want MORE!. It has been first 24 hours since my core mining rig have been set up and running.

    Well, more precisely, yesterday I finally received details ordered from Amazon at the start of December - motherboard, processor, power block, graphics card and other, see: Building a 12 GPU Ethereum Mining Rig From Scratch - Part 1: Ordering Details

    By now all mining operations are run from my living room (instead of office) on a separate mining rig. The total investment as of day: $1,147.00 (not counting in transportation and customs tax, which is about $200).

    As of writing this, the total time of ROI is 468 days, which is the reason I'm not happy yet with the results. 468 days is more than one year. And that makes me worried as we don't know what will be the future for gpu mining in next 6 months, no to speak 12 months or 468 days. Right now this seems a bit of gambling to me.

      Hashing Power   Mined Coins Exchange Rates Earnings       GPU ETH SC Invested ETH SC ETH SC ETH SC Total How many days 2 24.76 160.39 $1,147 0.00300494 4.12 $773.12 $0.03 $2.32 $0.12 $2.45 468.77

    On the other hand, currently mining operations are performed by just two graphics cards:

    • Radeon RX 560 4GB card, producing about 10.67MH/s for Ethereum and 85.74MH/s for Siacoin dual - mining.
    • EVGA GeForce GTX 1060 6GB , producing just 15.67 MH/s for Ethereum and about86 MH/s for Siacoin

    When I purchased EVGA GeForce GTX 1060 6GB I believed it will have a hashing power of about 22.5 MH/s - having just 15.67 MH/s or about 3/4 from the expected leads me to think either I haven't configured my mining rig right or maybe 15.67 MH/s is the most this card can get. 

    See: Top 14 Best Selling GPU Cards 2018

    I haven't performed any optimization yet, the numbers are straight out of the box, but I believe there is a room for about 10% improvement by overclocking BIOS.

    For mining, I decided to use Simple Mining OS, run from a USB stick. SimpleMining comes with a cost - $2/mo per mining rig. Which is fair IMHO. In coming days I will make an article on how to mine ether on Simple Mining OS.

    It should be noted that Simple Mining OS officially doesn't support mixing AMD and Nvidia cards on the same rig, but I managed to get both mixed version up and running on the same rig, which probably is the reason I'm getting lower hashrate for NVIDIA card right now. 

    Now I believe I will read a lot of online tutorials, watch dozens of YouTube video and try to optimize existing rig for better performance, before ordering new graphics card from Amazon and hopefully extending rig by at leat one more card in January 2018.


    Thanasis - Cretan Taverna in Stavros

    | Restaurant reviews | 54 seen

    Thanasis is a typical Cretan taverna located in the town of Stavros. We visited this place during our stay at Kavos beach apartment in June 2017.

    Friendly staff, amazing food, affordable prices and amazing sunset views.

    Outdoor deck at Thanasis taverna

    While waiting for our Cretan cuisine to be served made some HDR sunset photography here:

    Sunset photography

    One of the rare handheld HDR's

    Octopus

    Dolma

    Contact info Taverna Thanasis Cafe bar in Stavros, Crete


    Works of Georgian Painter Nino Jikia

    | Living in Georgia | 16 seen

    Nino is a friend, we have been in friends with Nino for about a year. We actually met her as a cat sitter during our 10 days trip to New York City at the end of 2016

    She has cat- sitted several more times since then. In case you are looking for cat minder here in Tbilisi - without hesitation - Nino is one of the best - our boys just adore her. I know that Nino is busy with a cat sitting for many other expats in Tbilisi, and in fact, she has about 15 cats at home - she just can't let little kitties alone on the street and takes them home - helping and taking care. 

    Nino is a Tbilisi Academy of Art graduate and in free time still paints and performs restoration works. She asked could I help her out and take photos of her works, without thinking I agreed - it was agreed that Nino will take some of her works to our apartment and on a Friday afternoon sipping tea and eating cake we made a lovely photo session of her works.

    Poppy fields in Svaneti by Nino Jikia

    This painting we actually bought from Nino and gave as a gift to my mom, while she was visiting me here in Georgia at the end of November. Now, this painting is in Riga, Latvia.

    Now for today's photo project -a sturdy tripod, long exposure and little post-processing in Adobe Lightroom.

    It all starts like this:

    Paintings by Nino Jikia on our coach

    I wanted to make a lovely comp and frame Nino in the middle, but she refused :)

    Painting of mountain by Nino Jikia

    When asked is it some particular mountain - Nino said, nope it's not. Just her imagination.

    Painting of trees

    Still Life by Nino Jikia

    Still Life by Nino Jikia

    Painting of Ananuri complex in Georgia by Nino Jikia

    See my review here: Ananuri Castle Complex On The Aragvi River, Georgia

    Water reflections

    Truly amazing, as a huge fan of HDR photography I would love to capture something similar, when asked where in Georgia we could find such landscape, she replied - nowhere - it's just the imagination of her. Pretty awesome!

    Clouds and flower fields by Nino Jikia

    The rock

    Again a nice commentary from Mrs. Nino Jikia

    I doubt there grow fir-trees on such rocks, but she decided to incorporate some.

    How amazing is that? I believe it is cool being a creative artist - you can make everything happen.

    Shatili village in Georgia by Nino Jikia

    Another painting of Ananuri (framed)

    You can order both unframed and framed painting. 

    Still Life

    Water reflections

    Seems there is more common to photographers and painters - we both love landscapes, reflections e.t.c


    Kavos Beach Apartments & Studios Review in Stavros, Crete

    | Hotel reviews | 13 seen

    Kavos beach apartments are among one of my favorite hotels discovered in Crete. We stayed here for a couple of nights in June 2017, during about a month long trip to Crete.

    Stavros is a village and a popular beach destination located close to the Chania town in Crete, Greece. The beach and surroundings were the place where in 1964 Michael Cacoyannis partly made the popular Greek movie "Zorba the Greek" starring Anthony Quinn.

    Top Hotels and Apartments in Stavros, Crete

    Set amidst landscaped gardens, all apartments and studios at Kavos are air-conditioned and have a spacious balcony or terrace. They are fitted with an LCD TV, kitchenette and fridge, and enjoy free Internet access.

    Kavos beach apartments in Crete

    I was so impressed with the landscape here that decided to make a couple of HDR's

    Rocky bay near Kavos beach

    At a quiet and beautiful location on the coast of Kavos, Kavos Beach Apartments & Studios boasts views over the Cretan Sea. It offers well-designed accommodation and a large outdoor pool with sun terrace.

    Outdoor pool at Kavos beach apartments

    We took a lovely night swim here. Amazing way to look at the stars.

    During the day made this panoramic photo

    Outdoor pool at Kavos beach apartments

    Now, when speaking about rooms - kind of nothing special, just the bare minimum - a bed, TV Set, shower e.t.c

    Our room at Kavos beach apartments in Crete

    Regarding landscape - some really cool features around Kavos hotel, interesting for photography:

    Landscape near Kavos beach hotel


    Fresh Portakalada and Donner somewhere near Kandanos in Crete

    | Restaurant reviews | 6 seen

    There are times Google Maps doesn't help (in fact there are dozen of such times) - this time Google Maps street view didn't help either - after about 6 months since we returned from Crete, I'm still postprocessing a lot of photos, reviewing places (tourist attractions, hotels, and restaurants).

    It was in the morning, we left Palaiochóra and headed towards Heraklion in our rental car. 

    Somewhere near Kandanos we found this lovely roadside cafeteria serving Donner and Portokalada (I mistakenly thought it will be freshly squeezed orange juice, but it turned out local lemonade)

    Portakalada lemonade in Crete

    Additionally ordered some Donner

    Donner

    Sadly I cannot remember the place name and can't find this place on Google maps to add a pin.


    Mining with SAPPHIRE PULSE Radeon™ RX 560 4GD5 Review

    | Servers | 46 seen

    This Sapphire Pulse Radeon RX 560 4GB graphics card is the first I've put on test for mining ethereum.

    Bought it at about $190 at local Tbilisi electronics shop, but you could get this card from Amazon for about $130.

    Out of the box, I was able to get 10.72MH/s for Ether and 85.74 MH/s for dual mining Siacoin, on average by mining with this card only I'm able to make about $0.98 daily, which gives about 190 days for ROI. See: I'm Making $0.98 Per Day By Mining Ethereum and Siacoin, and I want MORE!

    Cat waiting for the first mining rig to be built

    Currently, this card is installed on a desktop PC (single graphics card mining) and while it was in closed tower noticed following measurements for temperature and fan speed

    • 75 Celsius
    • 48% Fan speed

    As I was not happy with +75 Celsius, I decided to remove the cover and shortly temperature and fan speed dropped:

    • 67 Celsius
    • 27% Fan speed

    Now, I believe lower temperatures and slower fan speed will extend the total lifetime of for this card. And that's great. 

    I haven't yet performed optimization for this card (overclocking) but I believe it's possible to get about 10% improvement for it.

     


    I'm Making $0.98 Per Day By Mining Ethereum and Siacoin, and I want MORE!

    | Crypto | 18 seen

    The fans are spinning and graphics cards are heating, it has been 24 hours since I started mining Ethereum and Siacoin. And in these 24 hours, I've made $0.96.

    Ok, in fact, there is just one fan spinning and just one RadeonRX 560 card, which I bought a couple of days ago in Tbilisi, and decided to test the mining process at one of our spare office computers, before details for my 12 GPU mining rig arrives.

    I feel glad I was so impatient and rushed to perform a test, as while doing test setup I discovered a few bottlenecks and faced some issue, also I accidentally damaged one HDD while installing Graphics card on the motherboard.

    My total investment for this experiment was about $187 for purchasing the graphics card, I didn't have to pay for other items, as I already had a free system to install this card on. I believe it could take up to 190 days or little more than 6 months to get my initial investment back.

      Hashing Power   Mined Coins Exchange Rates Earnings       GPU ETH SC Invested ETH SC ETH SC ETH SC Total How many days 1 10.67 85.74 $187.00 0.00136945 2.63 $696.86 $0.01 $0.95 $0.03 $0.98 190.70

    The graphics card used for this setup is a cheap Radeon RX 560 4GB card, producing about 10.67MH/s for Ethereum and 85.74MH/s for Siacoin dual - mining. I haven't performed any optimization yet, the numbers are straight out of the box, but I believe there is a room for about 10% improvement by overclocking BIOS.

    For mining, I decided to use Simple Mining OS, run from a USB stick. SimpleMining comes with a cost - $2/mo per mining rig. Which is fair IMHO. In coming days I will make an article on how to mine ether on Simple Mining OS.

    Now, as for 2017, I've been actively investing in stocks, peer to peer lending and of course in cryptocurrencies, mining ether seems second most profitable investment option after buying coins directly from exchanges. 

    So far, peer to peer lending generates me a passive income of about $1.5 per day,  dividend payments in 2017 have generated on average about $0.82 per day in 2017. If combined all together it would make about $3.3 daily. Not bad. But here is one but:

    My current (2017) stock dividend yield is ~5%, peer to peer lending ~ 8%, now when speaking about mining - I can see a yield of 50-100% in a year. Am, I happy with 5% dividend yield with stocks? Sure dude, anything above 3% seems more than inflation, 8% at peer to peer lending? Amazing, wish we could have such interest rates at savings accounts. 50-100%? Too good to be true, but I'm in!

    As I'm still waiting for equipment for 12 GPU mining rig to arrive (in fact there should arrive one graphics card at about 22MH/s - next week) - I'm looking to increase daily and monthly return for mining to about $3 per day by the end of 2017.

    If things will turn out bright - average daily revenue from mining operations should produce the highest daily average income from my investments portfolio.


    Is It Profitable Mining Siacoin (SC) in 2018?

    | Crypto | 12 seen

    Sia is a new approach to cloud storage platforms. Instead of all datacenters being owned and operated by a single company, Sia opens the floodgates and allows anyone to make money by renting out their hard drive. Data integrity is protected using redundancy and cryptography.

    Sia uses a cryptocurrency, Siacoin, to enable decentralized payments via file contracts. All payments on the network happen in Siacoin, which is a critical component of our cryptographic SLAs. Siacoin allows us to do things that would not be possible with Bitcoin or traditional online payments. See: 8 Things Every Crypto Investor Should Know About SIACOIN

    I hold a couple of thousands of Siacoins (3,374), which I've gained via my swing trade activities. The current price (Middle December) is about $0.01 per Siacoin. I keep buying and holding a bunch of crypto coins, and I should note that 2017 has been a crazy in terms of returns. Currently, my Crypto portfolio has gained a total value of 268.47%, which is the highest return I've ever seen (compared to stocks or peer to peer lending, for example, where I can get about 10% annually)

    Affiliate link here: If you are just planning to acquire your first bitcoin, ethereum or litecoin, consider to register at coinbase.com with this link, once you buy or sell $100 (€85) of digital currency or more, we will both get $10 (€8) of free bitcoin.

    Remember your capital is at risk, never invest capital you cannot afford to lose!

    Now it was at the start of December when I decided to build my first GPU mining rig, I decided to go with a 12 GPU rig and ordered goodies from Amazon, while still waiting for items to arrive I purchased a cheap Radeon graphics card (Top 14 Best Selling GPU Cards 2018) and put it in one of the spare office computers. I made some calculations and find that mining probably could be profitable in 2018, see:  To Mine or Buy Ethereum/Zcash/Monero in 2018

    Now once I successfully installed this card on PC I decided to mine with Simple Mining OS.

    I was pleasantly surprised to learn that I could dual-mine two coins without affecting total performance for ethereum mining. I chose to dual-mine and ethereum and siacoin.

    Mining Ethereum and Siacoin with Simple Mining OS

    I got following hashrates from this Radeon RX 560 graphics card:

    • ETH - 10.7 MH/s
    • SC - 85.64 MH/s

    Now using online calculator I got following return per month (results are after 1% pool fee, and $5.8 electricity fee)

    • ETH - $33.58
    • SC - $0.84

    Without doubts, mining ethereum seems logical, but hey in terms of mined coins the return is completely different:

    • ETH - 0.0493084
    • SC - 80.95

    Imagine if Siacoin would go up in value from $0.01 to $0.5, for example (I'm not saying it will happen, but it could happen), 80 siacoins would be worth $40.

    Well, sure it doesn't sound realistic (yet), but in 2017 we have already seen even greater breakouts, ripple for example (see: Why I Rushed to Buy Ripple (XRP) Cryptocurrency at $0.19) .

    With Siacoin ranked 42 and Ripple #3, it's probably not right to draw parallels, but any gains, even a $0.01 would mean a 100% profit.


    How to Install Drupal 8 with Nginx, PHP-FPM, MySQL, phpMyAdmin on Ubuntu 16.04 - Linode Guide

    | Servers | 40 seen

    In this article, you will learn how to set up a Drupal 8 with Nginx, PHP-FPM, MySQL and phpMyAdmin.

    This article might not be complete, but you will find a lot of useful information

    Update: How to Install Drupal 8 with Nginx, PHP-FPM 7.2, MySQL, phpMyAdmin on Ubuntu 18.04 - Linode Guide

    Prerequisites

    • Ubuntu 16.04 - 64bit version.
    • Root privileges.

    You can get a cheap VPS for $10/mo from Linode. As I've few test Linodes already purchased I'm going to use one of them

    Follow basic security guide, see: Securing Your Server

    I will use Putty for Windows to access SSH

    Secure your server

    Create the user, replacing example_user with your desired username. You’ll then be asked to assign the user a password:

    adduser example_user


    Add the user to the sudo group so you’ll have administrative privileges:

    adduser example_user sudo

    Disallow root logins over SSH. This requires all SSH connections be by non-root users. Once a limited user account is connected, administrative privileges are accessible either by using sudo or changing to a root shell using su -.

    sudo nano /etc/ssh/sshd_config

    Under # Authetification section change to

    # Authentication: ... PermitRootLogin no

    Update the Ubuntu system

    sudo apt-get update

    Install Nginx and PHP-FPM

    Install Nginx with the following apt command:

    sudo apt-get install nginx -y

    Next, install php7.0-fpm with php-gd extension that is required by Drupal core:

    sudo apt-get install php7.0-fpm php7.0-cli php7.0-gd php7.0-mysql php7.0-xml -y

    Configure Nginx and PHP-FPM

    In this step, we will configure Nginx to use php-fpm to serve HTTP requests for PHP pages. Go to the php-fpm directory "/etc/php/7.0/fpm" and edit the "php.ini" file:

    sudo nano /etc/php/7.0/fpm/php.ini

    Un-comment the cgi.fix_pathinfo line and change the value to "0"

    When using nano command you can use CTRL+W to locate that line. Once changed press CTRL+O to save changes and CTRL+X to exit from nano editor

    Now we should modify the default Nginx virtual host configuration. Edit the "default" file and enable the php-fpm directive.

    sudo nano /etc/nginx/sites-available/default

    Un-comment  location ~ \.php$ section, so it look like this

    location ~ \.php$ { include snippets/fastcgi-php.conf; # With php7.0-cgi alone: #fastcgi_pass 127.0.0.1:9000; # With php7.0-fpm: fastcgi_pass unix:/run/php/php7.0-fpm.sock; }

    CTRL+O and CTRL+X

    Then test the Nginx configuration with the command "nginx -t" to ensure that it is valid:

    nginx -t

    If there is no error, restart nginx and the php-fpm service:

    systemctl restart nginx systemctl restart php7.0-fpm

    PHP Info file (Optional)

    Next, test that php-fpm is working properly with nginx by creating new php info file in the web directory "/var/www/html"

    cd /var/www/html/ echo "<?php phpinfo(); ?>" > info.php

    Visit the info.php file at the server IP  in a web browser. The result should be similar to the screenshot below.

    PHP Version Info log

    Configure the VirtualHost for Drupal

    We will install Drupal 8 in the directory "/srv/www/reinisfischer.com". Please replace my domain name in your installation with the domain name of the website that you want to use this Drupal installation for. So let's create the directory:

    sudo mkdir -p /srv/www/reinisfischer.com/{public_html,logs} sudo usermod -a -G www-data admin sudo chown -R www-data:www-data /srv/www sudo chmod -R 775 /srv/www sudo nano /etc/nginx/sites-available/felicia.com

    Paste the Nginx configuration for Drupal 8:

    server { server_name reinisfischer.com; root /srv/www/reinisfischer.com/public_html; ## <-- Your only path $ access_log /srv/www/reinisfischer.com/logs/access.log; error_log /srv/www/reinisfischer.com/logs/error.log; listen 80; listen [::]:80; location = /favicon.ico { log_not_found off; access_log off; } location = /robots.txt { allow all; log_not_found off; access_log off; } # Very rarely should these ever be accessed outside of your lan location ~* \.(txt|log)$ { allow 192.168.0.0/16; deny all; } location ~ \..*/.*\.php$ { return 403; } location ~ ^/sites/.*/private/ { return 403; } # Block access to "hidden" files and directories whose names begin with a # period. This includes directories used by version control systems such # as Subversion or Git to store control files. location ~ (^|/)\. { return 403; } location / { # try_files $uri @rewrite; # For Drupal <= 6 try_files $uri /index.php?$query_string; # For Drupal >= 7 } location @rewrite { rewrite ^/(.*)$ /index.php?q=$1; } # In Drupal 8, we must also match new paths where the '.php' appears in the middle, # such as update.php/selection. The rule we use is strict, and only allows this pattern # with the update.php front controller. This allows legacy path aliases in the form of # blog/index.php/legacy-path to continue to route to Drupal nodes. If you do not have # any paths like that, then you might prefer to use a laxer rule, such as: # location ~ \.php(/|$) { # The laxer rule will continue to work if Drupal uses this new URL pattern with front # controllers other than update.php in a future release. location ~ '\.php$|^/update.php' { fastcgi_split_path_info ^(.+?\.php)(|/.*)$; #NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini include fastcgi_params; include snippets/fastcgi-php.conf; fastcgi_param SCRIPT_FILENAME $request_filename; fastcgi_intercept_errors on; fastcgi_pass unix:/run/php/php7.0-fpm.sock; } # Fighting with Styles? This little gem is amazing. # location ~ ^/sites/.*/files/imagecache/ { # For Drupal <= 6 location ~ ^/sites/.*/files/styles/ { # For Drpal >= 7 try_files $uri @rewrite; } location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ { expires max; log_not_found off; } }

    CTRL+O and CTRL + X

    The Drupal virtual host file has been created, now we have to activate it by creating a symlink to the file in the "sites-enabled" directory:

    ln -s /etc/nginx/sites-available/reinisfischer.com /etc/nginx/sites-enabled/

    Test the Nginx configuration and if there is no errors restart Nginx:

    nginx -t systemctl restart nginx

    Install MySQL

    sudo apt-get install mysql-server ​sudo mysql_secure_installation

    Install phpMyAdmin

    sudo apt-get install phpmyadmin

    Hit ESC when the installation prompts you for auto-configuration, because there is no option for Nginx.

    Make an easy accessible symlink

    sudo ln -s /usr/share/phpmyadmin/ /srv/www/reinisfischer.com/public_html/phpmyadmin

    Install and Configure Drupal

    Enter the directory that we created earlier and download Drupal with wget. I'm using the latest Drupal 8.2.7. release as of March 23, 2017, make sure you are downloading latest version by visiting Drupal 8 download page and writing down the last numbers (version)

    cd /srv/www/reinisfischer.com sudo wget https://ftp.drupal.org/files/projects/drupal-8.2.7.tar.gz sudo tar -xvzf drupal-8.2.7.tar.gz sudo cp drupal-8.2.7/* public_html/ -R sudo chown www-data:www-data public_html -R

    Now visit your Drupal site in the web Browser, you should see following screen

    Drupal 8 welcome screen

    Now, it's just time to connect database and set up your Drupal 8 website


    Buying Graphic Cards (GPU) and Computer Parts in Tbilisi, Georgia

    | Living in Georgia | 84 seen

    It should be noted that buying GPU's in Tbilisi is not a very cost-effective option, better use Amazon.com and service like usa2georgia.com to deliver your goodies to Georgia.

    But if you are in rush, as I was today, and you are desperate to have a GPU right now, while in Tbilisi - there are several electronic stores I could recommend.

    While I was still waiting for goodies from the US to be shipped to Georgia, I decided to buy an additional cheap GPU and put in on test at one of our spare office computers. Doing my due diligence I found Sapphire Pulse X560 4GB GDDR5 card at pshop.ge for GEL 499 (USD 187), unfortunately, I was not able to find this card on Amazon store, and I believe this card is sold in European and CIS markets.

    Cat waiting for the first mining rig to be built

    Another option was Asus ROG Strix GeForce GTX 1050 Ti OC Edition 4GB GDDR5  card sold at AltaOk store for GEL 779 (USD 292). This card though is sold on Amazon for just ~ $190. The savings are huge. I was able to track down this card at MetroMart store in Tbilisi for GEL 699 (USD 262)

    See: Top 14 Best Selling GPU Cards 2018

    As both cards promise a similar mining power (~11-14 MH/s), with GeForce version being a slightly better in most of the benchmarks, I still decided to stick with cheaper Sapphire Pulse X560 4GB GDDR5,  probably by saving a $100 I made a fatal error, who knows. I'm planning to put this card to test soon and will share the results. Not sure yet, but planning to mine ethereum, zcash and monero, see: To Mine or Buy Ethereum/Zcash/Monero in 2018

    There is a great comparison video on YouTube for both cards, see it here: Sapphire RX 560 Pulse OC 4GB Review vs. GTX 1050 & More

    From my personal experience dealing with buying computers and computer parts, I would recommend following stores - AltaOk, MetroMart, PC shop.


    How to Check Motherboard Model on Windows 10

    | Servers | 28 seen

    Recently I ordered goodies for my first 12 GPU mining rig, including the motherboard. As I have got a few other PC's I decided to explore, are they optimal for GPU mining, for doing that, I had to learn the motherboard model and version.

    Luckily, there is a simple command line to run from CMD. 

    Open up the command prompt in Windows via either the run dialog (Windows+R) or by searching for “cmd” on the Start menu. At the command line, type the following text (noting that there are no spaces between the modifiers—just commas), and then hit Enter:

    wmic baseboard get product,Manufacturer,version,serialnumber

    Command Prompt

    The information returned checks out for the motherboard we’re using: the Manufacturer is ASUSTeK COMPUTER INC , the board is the X550MD, the serial number is BSN12345678901234567 and the version 1.0. Well I did this test on my Asus notebook, on which I'm not actually planning to add any GPU cards