Install MySQL 5.7 on Ubuntu 20.04

Prerequisites

  • Linux servers running Ubuntu 20.04
  • root privileges

Step 1 – Add MySQL APT repository in Ubuntu

Ubuntu already comes with the default MySQL package repositories. In order to add or install the latest repositories, we are going to install package repositories . Download the repository using the below command:

sudo apt update
sudo apt install wget -y
wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb

Once downloaded, install the repository by running the command below:

sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

In the prompt, choose Ubuntu Bionic and click Ok

The next prompt shows MySQL 8.0 chosen by default. Choose the first option and click OK

Read more

Share

Resctrict RDP Session

Problem statement:

RDP to Windows 10 hangs at the ‘Please wait’ screen forever until rebooted.

Remedy:

Need to apply the Group Policy (gpedit.msc) setting:

Computer Configuration >> Administrative Templates >> Windows Components >> Remote Desktop Services >> Remote Desktop Session Host >> Connections

At that level Enable the following setting

Restrict Remote Desktop Services User to a Single Remote Desktop Services Session
Share

ZFS Manager Webmin Module

I found this wonderful webmin module of ZFS Manager. Kinda love its feature and functions as it literally shortened the tedious siwtches and values of zfsmanager! I’m just quoting from the developer’s readme section down here-

ZFS administration tool for Webmin

This is in early development, not for production. That being said, try this out in a virtual machine or anywhere else where data is non-critical. My hope is that this will ultimately provide Webmin with similar ZFS functionality to FreeNAS and NAS4Free.

This project lives at https://github.com/jonmatifa/zfsmanager provide all feedback and bug reports there. I am brand new to Perl and Webmin’s API. so first I apologize for the shabby state the code is in, second any further contributions are greatly welcomed. I am learning a fair amount about ZFS along the way as well.

I am currently developing this under ZFS on Linux in Ubuntu, but all varients of ZFS/Webmin are planned to be supported in the future.

Installation

You can either use a *.wbm.gz from the releases tab, or “# git clone https://github.com/jonmatifa/zfsmanager.git” from the webmin root directory (Centos/REHL: /usr/libexec/webmin, Debian/Ubuntu: /usr/share/webmin), this will clone everything into the zfsmanager subfolder (which will be created). Then copy the “config” file to /etc/webmin/zfsmanager once that is done, you can then keep up to date with by “# git pull” from the webmin/zfsmanager directory.

Feedback

I am interested in what you think, even during this early alpha phase. The issue tracker can be used not only for bug reports but also feature requests and comments in general. Tracking and fixing bugs is important, but I also want to know what you think about the idea of the project and things like usability and UI design.

Contribution

Right now its just me developing this. I’m not a programmer by trade, but I’m happy to work on this project whenever I can. I would love help from someone more seasoned at perl (don’t judge me too hard), but also someone who “gets” the design philosophy of this project and understands the Webmin API. I’m a beginner myself so I’m not looking for too much.

Src: https://github.com/jonmatifa/zfsmanager/

Installation:

Download the ZFS Manager Alpha 0.1.5a release:

Read more

Share

Install PHPIPAM using Docker on CentOS 7

Update Docker Package Database. In a terminal window, type:

sudo yum check-update

Remove if any docker is preinstalled with your OS-

sudo yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-selinux docker-engine-selinux docker-engine

Install the Dependencies

sudo yum install -y yum-utils device-mapper-persistent-data lvm2

The –y switch indicates to the yum installer to answer “yes” to any prompts that may come up. The yum-utils switch adds the yum-config-manager. Docker uses a device mapper storage driver, and the device-mapper-persistent-data and lvm2 packages are required for it to run correctly.

Read more

Share

Install Jitsi on Debian 11

This article will go through the installation and configuration of the Jitsi Video Conference on the latest Debian 11 Bullseye. At the end of this guide, you will be able to create a meeting using the Jitsi Video conference.

Before you get started, ensure you’ve got the following requirements:

  • Operating System: Debian 11 Bullseye
  • Root privileges

Install Packages Dependencies

The first step is to install some packages dependencies such as gnupg2, nginx-full, sudo, apt-transport-https, curl, and java OpenJDK.

1. Update your Debian repository and install those packages on top using the following command.

sudo apt install apt-transport-https gnupg2 nginx-full sudo curl -y

2. Jitsi required Java OpenJDK version 1.8 or 1.11; the default Debian repository provides Java OpenJDK 1.11.

Now execute the following command to install Java OpenJDK packages.

sudo apt install default-jdk -y

After installation completes, verify the Java OpenJDK version using the following command.

java -version

You will see a similar output as below.

openjdk version "11.0.13" 2021-10-19
OpenJDK Runtime Environment (build 11.0.13+8-post-Debian-1deb11u1)
OpenJDK 64-Bit Server VM (build 11.0.13+8-post-Debian-1deb11u1, mixed mode, sharing)

After all packages have been installed, move on to setting up Jitsi and Prosody repositories.

Read more

Share

Nextcloud Upgrade Issue via Web

My Nextcloud update via web was constantly failing. So looked for alternate CLI methods.

Method#1 Using occ cli

sudo -u www-data php ./occ upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Updating database schema
Updated database
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 1.1.1
Updating <gallery> ...
Updated <gallery> to 17.0.0
Updating <activity> ...
Updated <activity> to 2.5.2
Updating <comments> ...
Updated <comments> to 1.2.0
Updating <theming> ...
Updated <theming> to 1.3.0
Starting code integrity check...
Finished code integrity check
Update successful
Maintenance mode is kept active
Reset log level

Method#1 Using updater.phar

Read more

Share

Restore ZFS Pool and storage data

If the disks are recognized from your OS the command:

zpool import

should be enough to get the pool imported and visible in your current OS. You can check the status with command

zpool status

You can try to import it explicitly by name

zpool import ZStore

P.S. Do not forget to set the pool online:

zpool online

You can check zpool-features features and if they are enabled or not in your case. Seems like zfs build in your case is new than the version which create it. The problem is if you update you will be able to mount only with same or upper version of zfs

What I can recommend you is to try (if available) with live version (but this with which you create the pool)

Src:
https://unix.stackexchange.com/questions/483465/restore-zfs-pool-and-storage-data-after-a-system-re-install

Share

Create a RAID array using with mdadm

mdadm (multiple devices admin) is an extremely useful tool for running RAID systems. It’s is a tool for creating, managing, and monitoring RAID devices using the md driver. It can be used as a replacement for the raidtools, or as a supplement. You can use whole disks (/dev/sdb, /dev/sdc) or individual partitions (/dev/sdb1, /dev/sdc1) as a component of an array.

The benefits of using mdadm are:

  1. mdadm can diagnose, monitor and gather detailed information about your arrays.
  2. mdadm is a single centralized program and not a collection of disperse programs, so there’s a common syntax for every RAID management command.
  3. mdadm can perform almost all of its functions without having a configuration file and does not use one by default.

mdadm software tools work for all Linux distributions, with the same syntax.

Read more

Share

Install Discourse on Ubuntu 22.04

Prerequisites

  • A server with Ubuntu 22.04 as OS
  • Valid domain pointed to the servers IP address
  • User privileges: root or non-root user with sudo privileges

Step 1. Update the System

Update the packages to their latest versions available after a fresh install of Ubuntu 22.04

sudo apt-get update -y && sudo apt-get upgrade -y

Step 2. Install Docker

First, we will add the GPG keys and Docker repository since it is not added by default in the Ubuntu 22.04 official repository.

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu focal stable"

Once the keys and repo are added, install Docker with the following command:

sudo apt install docker-ce docker-ce-cli containerd.io -y

After successful installation, start and enable the Docker service.

Read more

Share