AWS: MariaDB RDS – kill: You are not owner of thread

14 May 2019
 

 We have AWS RDS with MariaDB. The error below and its solution aren’t specific to AWS RDS and MariaDB. The next error appears during attempt to kill() a thread in MySQL: [simterm] MariaDB [(none)]> kill 759; ERROR 1095 (HY000): You are not owner of thread 759 [/simterm] The solution is to use the mysql.rds_kill() procedure… Read More »

TestRail: reset admin password

13 May 2019
 

 We have a TestRail installation but suddenly lose its Admin user password. The Reset Password says that “Email sending failed” although email was configured and users are able to get emails from the server. Also, the log /var/www/testrail.example.com/logs/log-2019-05-13.php didn’t says anything so will reset password in another way – by update this TestRail MySQL database… Read More »

Bitwarden: an organization’s password manager self-hosted version installation on an AWS EC2

1 May 2019
 

 We consider Bitwarden as a passwords keeper for our project with the main goal to have an ability to have separated access to secrets by user roles and/or ACLs. I.e. Pass or KeePass are good for self-usage by one person but they have no main things – a normal web-interface and role-based access to data.… Read More »

Linux: GPG-keys, Pass – passwords manager, and passwords import from the KeePass database

25 April 2019
 

 pass – a password manager for Linux/UNIX. Stores data in tree-based directories/files structure and encrypts files with a GPG-key. In Arch Linux present by default, in Debian can be installed using apt from default repositories: [simterm] $ sudo apt install pass [/simterm] For macOS can be installed with Homebrew: [simterm] $ brew install pass [/simterm]… Read More »

Golang: pointers – detailed overview

20 April 2019
 

 What is the pointer? Shortly, the pointer is a variable which stores an address of another variable, where some data is stored. A pointer example Let’s take the simplest example where a pointer is used: package main import “fmt” func main() { a := 1 b := &a fmt.Println(“A: “, a) fmt.Println(“B: “, b) fmt.Println(“B:… Read More »

Authy: step by step Multi-Factor Authentication configuration for Github and AWS

17 April 2019
 

  I’m sure that using MFA (Multi-Factor Authentication) today is oblivious. For 2FA (2-Factor Authentication) the most used method is TOTP – Time-based One-time Password, when alongside with the common login:password also needs to enter a code generated by a device or software. The most known implementation is Google Authenticator but also there is a… Read More »

Jenkins: a job to check a Github organization’s public repositories list

16 April 2019
 

 Proceeding with a Github repositories checker. To recall: the idea is to have such a check in case if somebody from developers accidentally will share our project’s private repository as public, or will create a public repository instead of making it as a private one – we will get a Slack alarm about such a… Read More »

Redis: replication, part 4 – writing an Ansible role fore the Master-Slave replication with Redis Sentinel provisioning

15 April 2019
 

 The next post from the Redis replication series. Previous parts: Redis: replication, part 1 – an overview. Replication vs Sharding. Sentinel vs Cluster. Redis topology. Redis: replication, part 2 – Master-Slave replication, and Redis Sentinel Redis: replication, part 3 – redis-py and work with Redis Sentinel from Python The task now is to write an… Read More »

Arch Linux: Albion Online – Unable to preload the following plugins: libSDL2-2.0.so.0

14 April 2019
 

 Didn’t play in Albion Online for a while, but recalled about it and tried to play on my Arch Linux. It works fine from the Steam client, but I bought with a start package some time ago and can’t log in to Steam’s version with my old credentials. Okay – download game from the https://albiononline.com/ru/download,… Read More »