Tag mysql

Install Mattermost on Ubuntu 22.04 server

Mattermost is a collaboration tool designed for teams to communicate efficiently. It have mobiles apps and they are open source which could be white labelled if needed. In this article let me guide you how to install and setup Mattermost on Ubuntu 22.04 LTS server.

March 16, 2023

How to install Snipe-IT on Ubuntu 22.04

Snipe-IT is an asset management system which can be self hosted too. It provides user friendly UI and has a powerful API. In this guide I will show you how to install Snipe-IT on Ubuntu 22.04 LTS with PHP 8.1 and MariaDB.

January 19, 2023

How to get Authorization header in PHP

In order to construct a secure resource that can be accessed through an API, we must utilize an authorization header with a token or bearer. In this article, I will guide you how to obtain the authorization header, extract the token or bearer. Then authenticate it against a database table and return a JSON output in PHP.

January 17, 2023

Setup LAMP stack (Apache, MariaDB, PHP) on Ubuntu 22.04

In this article we will setup/install LAMP stack (Apache, MariaDB, PHP) on Ubuntu 22.04 including SSL via Certbot and basic firewall with UFW.

August 21, 2022

Recover InnoDB MySQL or MariaDB database from raw files

So you have raw files of your database and don't have a dump or backup at hand. Worry not, it's easy to recover an InnoDB MySQL or MariaDB database from raw files.

June 25, 2022

How to install Nextcloud on TrueNAS CORE

While the plugin version is easy to setup, it is also the most easy one to break with updates. In this article I am going to show how to create a pool/jail and install Nextcloud on TrueNAS CORE from ground up.

May 17, 2022