Create a bootable USB flash media drive for Ubuntu server

Submitted by Mathew Branwell on Thu, 02/23/2023 - 00:21

Format the flash drive:


sudo dd if=/dev/zero of=/dev/sdd bs=1M && sync

Write the iso file to it:


sudo dd if=CentOS-7.0-1406-x86_64-Minimal.iso of=/dev/diskN bs=1M

How to set MySQL "wait_timeout" option on Ubuntu

Submitted by Mathew Branwell on Thu, 11/11/2021 - 10:17

I was trying upload a large database on Ubuntu that kept failing because of connection timeout problem, so I had to take the following steps:

1. To make it easier to find the right .cnf file, create a symbolic link:


ln -s /etc/mysql/mysql.conf.d/mysqld.cnf /etc/my.cnf

2. Paste with nano /etc/my.cnf


[mysqld]
wait_timeout = 31536000
interactive_timeout = 31536000

3. systemctl restart mysql

4. Verify with:

Upgrade Mysql (or MariaDB) to 10.x on CentOS 7

Submitted by Mathew Branwell on Mon, 07/12/2021 - 12:35

You will find all kinds of different instructions on how to update Mysql or MariaDB running on your CentOS 7 system to version 10.x, but the easiest and most straightforward way proven to us turned out to be the following one.

Note that the version in your case may vary, so replace 10.5 accordingly.

1. First, dump all the databases on your system just in case if something goes awry:

mysqldump -u root -p --all-databases > all-databases.sql

2. Paste the following code into the /etc/yum.repos.d/mariadb.repo file:

fatal: no SASL authentication mechanisms && warning: xsasl_cyrus_server_get_mechanism_list: no applicable SASL mechanisms

Submitted by Mathew Branwell on Tue, 06/04/2019 - 05:25

If you see your Postfix reporting:

Jun 4 10:45:35 host postfix/smtpd[13609]: warning: xsasl_cyrus_server_get_mechanism_list: no applicable SASL mechanisms
Jun 4 10:45:35 host postfix/smtpd[13609]: fatal: no SASL authentication mechanisms

Tags:

Troubleshooting the `Failed to start Berkeley Internet Name Domain (DNS)` error message

Submitted by Mathew Branwell on Tue, 08/14/2018 - 17:25

If the Named service goes down we check its status with systemctl status named or journalctl -xe, however sometimes both commands do not contain any indication of specific zone causing the error:

Tags:

Replacing a degraded drive in a software RAID 1 array

Submitted by Mathew Branwell on Mon, 06/04/2018 - 16:37

After physically replacing the degraded drive with the new one and rebooting the system, run the folowing command to create exactly the same partitioning on /dev/sdb (new drive) as on /dev/sda (healthy existing drive):

sfdisk -d /dev/sda | sfdisk /dev/sdb

You can run

fdisk -l

to check if both hard drives have the same partitioning now.

Next we add /dev/sdb1 to /dev/md126 and /dev/sdb2 to /dev/md127:

mdadm --manage /dev/md126 --add /dev/sdb1
mdadm --manage /dev/md127 --add /dev/sdb2

Tags:

How to investigate sessions

Submitted by Mathew Branwell on Fri, 03/09/2018 - 15:24

To list all current sessions:

loginctl list-sessions

To investigate details of particular session run:

loginctl show-session [session_id]

The sessions files are located in /run/systemd/sessions on Fedora-based systems and in /run/systemd/sessions on Debian-based systems.

If sessions fill up the /run directory for 100% then per recommendation on
https://www.centos.org/forums/viewtopic.php?f=48&t=65472:

Tags:

How to check when a file was created on a Linux system

Submitted by Mathew Branwell on Tue, 02/13/2018 - 12:52

This is a brief summary of https://unix.stackexchange.com/questions/50177:

Tags:

Recursively copying between two directories including hidden files

Submitted by Mathew Branwell on Sat, 09/02/2017 - 21:06

Sometimes we need to override large structure of directories and subdirectories with newer files.

There are two ways of copying all the files in one directory including subdirectories and hidden files to another directory:

cd /orig/dir
tar cvf - . | (cd /dest/dir; tar xvf -)

which tars up the current directory to stdout then pipes it to a subshell that first cd's to the destination directory before untarring stdin.

The second way of doing this is using cp:

yes | cp -rT /orig/dir /dest/dir 2> /dev/null

Tags:

Instaling pip command on CentOS

Submitted by Mathew Branwell on Tue, 05/17/2016 - 13:43

Enable the epel repository and run:

yum install python-pip to get:

yum install python-pip
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.nexcess.net
* epel: mirror.sfo12.us.leaseweb.net
* extras: centos.sonn.com
* updates: centos.sonn.com
Resolving Dependencies
--> Running transaction check
---> Package python-pip.noarch 0:7.1.0-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

Tags:

Pages

Subscribe to Front page feed