Articles tagged with: linux
Enabling the fingerprint reader on a ThinkPad T470 in Fedora 31
The Thinkpad T470 comes equipped with a fingerprint scanner to allow easier
authorization. Unfortunately, the drivers are still under prototype development
but are working in Fedora. In order to use the fingerprint scanner, it needs to
be initialized with data which can only currently be done from Windows.
First make sure your system is up to date.
bash
sudo dnf update
Restart the machine in order to proceed. In order for VirtualBox to work, some
settings need to be tweaked in the BIOS. …
Read More →
How to enable HAProxy logs on CentOS 8
HAProxy is an open-source, high availability load balancer that quietly sits in front
of any TCP/HTTP service. It's well-known for its efficiency and reliability, and
often used to manage the traffic of high-volume and distributed systems.
If you're using HAProxy, you may have come across a situation where you're looking
through application logs only to realize that you can't find the information you're
looking for. For example, maybe you're looking in apache logs trying to isolate
the IP of a web…
Read More →
Install MySQL Community Server on CentOS 8
CentOS distributes MariaDB 10.3, a drop-in replacement for MySQL Server 5.7. If
you require MySQL 8, there are a few new steps on CentOS 8 that differ from past
versions.
All steps should be performed as the root user.
bash
sudo su
Code snippets that start with a # prompt contain sample output and should not be
copied verbatim.
Start by downloading the GPG key and saving it in /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
bash
wget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql…
Read More →
Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
SELECT INTO OUTFILE is used to export query results to file and can be formatted
using additional export options. By default, columns are separated by tabs ( \t )
while rows are separated by newlines ( \n ).
From the MariaDB documentation, [https://mariadb.com/kb/en/select-into-outfile/](https://mariadb.com/kb/en/select-into-outfile/)
sql
SELECT ... INTO OUTFILE 'file_name'
CHARACTER SET charset_name]
export_options]
export_options:
FIELDS | COLUMNS}
TERMINATED BY 'string']
OPTIONALLY]…
Read More →