MyBlueLinux.com

phpmyadmin - how recovery error (HY000/1698): Access denied for user 'root'@'localhost'

When I try login as a root user to my mariadb (mysql) database in phpmyadmin on my linux debian stretch, I got this error message: mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Debian Linux Databases

ProFTPd Server with virtual users and in SFTP mode

How to configure proftpd server with virtual users and with sftp mode.

Debian Linux Networking Security

Python List or any Iterable Comprehension

Sometimes a programming design pattern becomes common enough to warrant its own special syntax. Python’s are a prime example of such a syntactic sugar. List comprehensions in Python are great, but mastering them can be tricky because they don’t solve a new problem: they just provide a new syntax to solve an existing problem. Let’s learn what list comprehensions are and how to identify when to use them.

Python Development

SED Tutorial - how print or delete particular line

How we can print or delete particular line with SED (text) stream editor

Linux Linux Utilities

Time zone and precise time setting in Linux

Properly set system time is important for the user, but also for the system itself. Let's explain how Linux accesses time zones and how to set the exact time to get you right.

Linux Debian

nftables geoip - continents ip

In the previous articles, we showed how to perform packet marking in nftables based on geoip source ip addresses and also how to log traffic to external files .
Today we will show how to mark packets based on which continent they come from.

The principle is that we first mark packets based on the source IP address so that we know which countries they are coming from. And then we'll find out which continent the state is on.

Linux Security Networking

nftables and GeoIP

We'll learn how we can block traffic originated from specific country or continent IPs using GeoIP database and linux nftables . This article describes the configuration for debian linux distros. nftables is the new packet classification framework that intends to replaces the existing {ip,ip6,arp,eb}_tables infrastructure. In a nutshell:

It is available in Linux kernels >= 3.13
It comes with a new command line utility nft whose syntax is different to iptables.
It also comes with a compatibility layer that allows you to run iptables commands over the new nftables kernel framework.
It provides generic set infrastructure that allows you to construct maps and concatenation. You can use this new feature to arrange your ruleset in multidimensional tree which drastically reduces the number of rules that need to be inspected until you find the final action on the packet.

I assume you have at least basic experience with the nftables configuration.

Linux Security Networking

How nftables log to external file

Logging traffic blocked by the nftables or iptables firewall rules is necessary for debugging the firewall rules and to be alerted to local software problems. Any packet matching a rule can be logged by using -j LOG target for iptables or log statement for nftables. Logging packet has no effect on the packet's disposition, however. The packet must match an accept or drop rule.

Linux Security Networking

One of the new features of the Windows 10 May 2019 Update is the Windows Sandbox . It is a simple virtualization tool that can be used, for example, to test software that we do not want to install on the operating system itself, or to open a potentially infected file without risking damage to the computer.

It is not a replacement for VirtualBox or similar complex tools. Windows Sandbox can create one isolated copy of Windows 10 itself, the state of which cannot be saved. The tool also has its advantages - very simple usage.

Windows

Learn How to do 3 Advanced Excel Tasks in Python

Excel is the ubiquitous data analysis tool — it’s easy to pick up, mostly everyone has a copy of it, and it’s quite powerful once you get the hang of it! Meanwhile, Python is often regarded as a bit more challenging to pick up, but as having limitless potential. In this post, we’ll explore three things you can easily do in Python that you normally do in Excel!

Setup

For debian based distro you must install python pandas and xlrd packages first:

Python

Python Pandas Cheat Sheet

Being able to look up and use functions fast allows us to achieve a certain flow when writing code. So I’ve created this cheatsheet of functions from python pandas. This is not a comprehensive list but contains the functions I use most, an example, and my insights as to when it’s most useful.

Python Development

Nagios / Icinga check multi plugin problem

The Nagios / Icinga plugin check_multi is a convenient tool to execute multiple checks within a single check command that generates an overall returned state and output from it.

It calls multiple child plugins and displays their output in the long_plugin_output. A summary is given in the standard plugin output. The child return code with the highest severity becomes the parent (check_multi) plugin return code.

check_multi problem

When I configure to run multiple nagios/icinga monitoring plugins with check_multi plugin, icinga web server show me this error messages:

Monitoring