TechSparx Technology News

Subscribe by email (Delivered by FeedBurner):

Block remote root login via ssh on Ubuntu/etc to keep your server safe

A moment ago I was checking the system logs on my Ubuntu server and found that in auth.log reports that someone was repeatedly trying to SSH login as root. The "root" entry in /etc/passwd is setup so that no password will ever be matched, so perhaps this potential cracker would never get into my server anyway. But the requests are using bandwidth - and what if they were able to figure out a password that would work? Why not just block remote SSH login access to logging in as root in the first place?

Make your own Raspberry Pi git repository server with Gogs and Docker

The Raspberry Pi is an amazing little computer that, while it's targeted at the DIY Hardware Maker, it is a full-fledged Linux computer that can be used to run services that used to require much bigger and more expensive computers. How long ago were office servers required to be $4000 systems from the likes of Dell Computers? It seems that the Raspberry Pi (and other tiny computers) can perform the same tasks at a low cost with minuscule energy requirements. To this end I'm setting up Gogs (a github-like server for Git repositories) on a Raspberry Pi.

Easily have quality Git server on your laptop with Gogs and Docker, and enable auto-push to remote repository

Github doesn't have to be the only game for git servers - while they run an excellent service, you can't install it on your own server, making it little better (in "Freedom" regards) than a closed source proprietary software package. Yes it's expedient to host your repositories on Github, but do we all have to cede this functionality to them? There happen to be several alternatives to github that offer a competent web-based git repository service.

Canon introduces a new mirrorless digital camera, Canon EOS M5, 24 MPixels of goodness


Canon has expanded their line of mirrorless digital cameras, the Canon EOS M series, with a new entry, the Canon EOS M5. It has a 24 Mega Pixel APS-C sensor. Also introduced is the new Canon EF-M 18-150mm f/3.5-6.3 IS STM lens, offering a an almost 10x zoom ratio.

The Doctor, Harriet Jones, Donald J Trump, and Hillary Clinton

doctor-who-harriet-jones.jpgIt was David Tennant's first show as The Doctor, the Christmas Invasion. He spent most of the episode sleeping off the effects of a regeneration, while London was under threat from a big space ship full of bad guys threatening Planet Earth. The Prime Minister was Harriet Jones, who had previously met the Christopher Eccleston version of The Doctor (Doctor #9 or #10 depending on how you count it).

Setting up LibreOffice to access MySQL database with JDBC driver

I wanted to try using LibreOffice Base on Mac OS X to play with a MySQL database. I thought it would be easy, just connect to the database and start doing queries, maybe even pull data into a LibreOffice spreadsheet for advanced data munging. But doing the obvious thing got me messages like "No Java Installation found" and "the driver class com.mysql.jdbc.Driver could not be found". Further, yahoogling with some obvious search phrases turned up nothing.

Upgrading or replacing battery pack, SSD and other parts on Acer C720 Chromebook's

I have owned an Acer C720 Chromebook for a couple years now and in many ways it's the best computer I've ever owned. It's small and light and is easy to carry around anywhere. The keyboard and trackpad are excellent. The screen field-of-view leaves something to be desired, but when viewed head-on the screen looks good and the sound quality is acceptible. I do a lot of writing and software development and web browsing and image editing and related work, and have solutions to do everything (including software development) on the Chromebook.

How to restore a MySQL database and tables from .frm .ibd or .myd raw database files

powered-by-mysql-167x86.pngConsider a situation - you've got a well tuned MySQL database server running some popular websites. The sites are implemented with Drupal and Wordpress, but using MySQL to store the content and settings. You think everything is fine, until one day you look at Google Analytics and are aghast to see zero traffic for the previous two days. You go to the websites and are greeted by a 404 error, with the server saying there's nothing there.

If Wordpress is switching from PHP to Node.js, how should they do it?

wordpress-logo-stacked-rgb.pngnodejs-dark.pngSupposedly the Wordpress team is migrating Wordpress from PHP to Node.js. That astonishing bit of news comes from, but the evidence presented isn't exactly compelling.