Author: Yuri Gagarin

Setting up a simple VPN with WireGuard and Raspberry Pi as the server

Since WireGuard will become part of the future Linux kernel 5.6, I decided to see how to best integrate this VPN with my LTE router/access point on the Raspberry Pi. The hardware is a Raspberry Pi 3 with an LTE module and a public IP address. Here will be the VPN server (referred to in the text as edgewalker). An Android phone that will use the VPN for all communications. A Linux laptop, […]

VPN WireGuard included in the Linux kernel 5.6

Today, Linus transferred the net-next branch with WireGuard VPN interfaces to himself. This event was reported on the WireGuard mailing list. Currently, the code collection for the new Linux kernel 5.6 is ongoing. WireGuard is a fast next-generation VPN that implements modern cryptography. It was originally developed as a simpler and more user-friendly alternative to existing VPNs. The author is a Canadian expert in […]

SQL HowTo: Writing a while-loop directly in a query, or 'An Elementary Three-Way'

There is periodically a task to search for related data by a set of keys until we accumulate the required total number of records. The most 'realistic' example is to display the 20 oldest tasks listed for employees (for instance, within a single department). This topic is often required for various management dashboards with brief overviews of work areas. In this article, we will discuss the implementation in PostgreSQL […]

I have zero turnover.

Once at the factory where I worked as an IT director, we were preparing reports for yet another event. We needed to calculate and provide metrics based on the issued list, among which was employee turnover. It turned out that mine was zero. Among the managers, I was the only one like that, which drew attention to me. I was surprised myself – it turns out that when […]

Overview of the open-source non-profit project MyVPN

The open-source MyVPN application automates the management of virtual private networks. No system administration skills are required to use it. When choosing a VPN provider, trust is more important than the cost of services. Free services are often accused of lacking reliable encryption and of tracking users, while commercial ones may succumb to regulators and start […]

A solar-powered home web server operated for 15 months: uptime 95.26%

The first prototype of a solar server with a charge controller. Photo: solar.lowtechmagazine.com In September 2018, an enthusiast from Low-tech Magazine launched a project for a "low-tech" web server. The goal was to reduce energy consumption enough so that a home self-hosted server could be powered by just one solar panel. This is not easy, as the site needs to operate 24 hours a day. Let's see what the outcome was. You can visit the server solar.lowtechmagazine.com and check […]

New Intel microcode updates have been released for all versions of Windows 10

The entire year of 2019 was marked by a struggle against various hardware vulnerabilities in processors, primarily related to speculative execution of commands. Recently, a new type of attack on Intel CPU cache was discovered — CacheOut (CVE-2020-0549). Processor manufacturers, especially Intel, are striving to release patches as quickly as possible. Recently, Microsoft introduced yet another series of these updates. All versions of Windows 10, including 1909 (the update […]

A distribution for creating firewalls OPNsense 20.1 is available.

The OPNsense 20.1 distribution for creating firewalls has been released, which is a branch of the pfSense project, created with the aim of forming a completely open distribution that could possess functionality at the level of commercial solutions for deploying firewalls and network gateways. Unlike pfSense, the project is positioned as not controlled by one company, developed with direct community involvement, and possessing […]

Google has introduced the open stack OpenSK for creating cryptographic tokens

Google has introduced the OpenSK platform, enabling the creation of firmware for cryptographic tokens that fully comply with FIDO U2F and FIDO2 standards. Tokens prepared using OpenSK can be used as authenticators for single and two-factor authentication, as well as to verify the physical presence of the user. The project is written in Rust and is distributed under the Apache 2.0 license. OpenSK allows the creation of […]

Release of DXVK 1.5.3 with Direct3D 9/10/11 implementation over the Vulkan API

The release of the DXVK 1.5.3 layer has been formed, providing an implementation of DXGI (DirectX Graphics Infrastructure), Direct3D 9, 10, and 11, which operates through API call translation to Vulkan. To use DXVK, drivers compatible with Vulkan API 1.1 are required, such as AMD RADV 18.3, NVIDIA 415.22, Intel ANV 19.0, and AMDVLK. DXVK can be utilized to run 3D applications and games in […]

Linux kernel 5.5 release

After two months of development, Linus Torvalds has released Linux kernel 5.5. Among the most notable changes are the ability to assign alternative names to network interfaces, integration of cryptographic functions from the Zinc library, the capability to mirror to more than 2 disks in Btrfs RAID1, a mechanism for tracking the state of Live patches, the kunit unit testing framework, improved performance of the mac80211 wireless stack, and access to the root partition through […]

The Free Software Foundation is gathering signatures for the release of the Windows 7 source code

Microsoft is known for wanting to support free software. Microsoft has officially ended support for Windows 7. Why not open the source code of the system? The Free Software Foundation aims to gather 7,777 signatures for the petition "Upcycle Windows 7." The life of an old operating system doesn't necessarily have to end. Microsoft can demonstrate that it truly respects its users and their freedom through its actions. […]

Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster