LHammonds Tutorials

Export User Grants/Revokes The Percona Toolkit comes with a handy utility called pt-show-grants which will allow you to export an SQL file of all the grants for all your databases into a single file that you can use to audit permissions or help with a restore or help with database migrations. This ...

NOTE: I have not tested most of these since I tend to use the command-line. However, Adminer is enjoying frequent updates and is a single php file. Web-based interfaces There are a few web-based tools you can get for a GUI front-end to MariaDB. It is not recommended to install a web server on your ...

Transfer Script - Data Move This script will run on a regular basis and move the data files on each remote server that placed files in the /bak/remote folder. sudo touch /var/scripts/prod/transfer-data.sh sudo chown root:root /var/scripts/prod/transfer-data.sh sudo chmod 700 /var/scripts/prod/trans...

Transfer Script - Partition Copy This script will run on a regular basis and copies the backed up partition files on each remote server. Make sure it is timed to run after the local back-parts.sh script is finished and not more often than that job runs. sudo touch /var/scripts/prod/transfer-partiti...

Increase bak volume Determine how much space you will need to hold the backup files and add the space to the /bak volume. In my case, I will add a 200 GB drive and allocate 100% of that space to the bak volume but only expand the file system by 80% of that to ensure there is room to expand in the f...

------------- WORK-IN-PROGRESS ------------- Greetings and salutations, I hope this thread will be helpful to those who follow in my foot steps as well as getting any advice based on what I have done / documented. To discuss this thread, please participate here: << Insert Ubuntu Forums Link >> High...

Directory Security During install, you should have set the user/group ownership to match your web server (www-data for Apache on Ubuntu). These are the default permissions for your NextCloud directories and files: All files should be read-write for the file owner, read-only for the group owner, and...

NextCloud We are installing manually instead of using the package manager for the following reasons: Can obtain the newer version straight from NextCloud's website Don't want MySQL installed on the same server since I have a dedicate DB server (and also would rather use MariaDB) Want to use my own ...

Configure MariaDB / MySQL In this scenario, a separate, dedicated and general-purpose database server already exists and it will be used to hold the application's database. Connect to the MariaDB/MySQL server using PuTTY. At the login prompt, login with your administrator account ( administrator / ...

Name Resolution Add your NextCloud domain(s) so they point to the local loopback (127.0.0.1) Add your other remote servers such as your mail and database server IPs so you can reference them by name. sudo vi /etc/hosts 127.0.0.1 localhost 127.0.1.1 srv-nextcloud 127.0.0.1 nextcloud.mydomain.com 192...

------------- WORK-IN-PROGRESS ------------- Greetings and salutations, I hope this thread will be helpful to those who follow in my foot steps as well as getting any advice based on what I have done / documented. To discuss this thread, please participate here: << Insert Ubuntu Forums Link >> High...

Fix Web Permissions I use a script to automatically set the web permissions on a regular basis to ensure compliance to standards for each site. The script will set standard ownership, directory and file permissions and then fine-tune the changes needed beyond that. For phpBB, I made a function that...

Reset Admin Password If you do not know your admin password, you can set the password via the database. Login via SSH to your database server and access the mysql console mysql Look at the databases you have and select the correct one: MariaDB [(none)]> show databases; +--------------------+ | Data...

Installing New Styles Visit this sites: https://www.phpbb.com/customise/db/styles-2 Browse for the style(s) you want. Right-click the download link and copy the URL. In Putty, download, unzip and remove the archive. Then set the owner/permissions and move to its final destination. Example: cd /tmp ...

Upgrading phpBB The download page for phpbb does a pretty-good job of telling you how to upgrade phpBB. It can get a bit confusing if you are upgrading very old versions of phpBB so here is what I did to upgrade 3.0.8 to 3.2.0 which required (for me) upgrading to specific versions in between. Pre-U...

Install phpBB At the login prompt, login with your administrator account ( administrator / myadminpass ) and then temporarily grant yourself super user privileges by typing sudo su Type the following commands: mkdir /var/www/forum.mydomain.com cd /tmp wget https://download.phpbb.com/pub/release/3.3...

Add Non-SSL Apache Site Configuration

Refer to this tutorial but substitute the example domain name and path for yours.

Add SSL Apache Site Configuration

Please refer to this tutorial but substitute the example domain name and path for yours.

Install Required phpBB Libraries Type the following to install the required libraries: apt -y install php7.4-json Install Optional phpBB Libraries Type the following to install the optional libraries: apt -y install php7.4-gd php7.4-xml php-imagick PHP Module Verification Make sure the modules you ...

Configure MariaDB / MySQL In this scenario, a dedicated and general-purpose database server already exists and it will be used to hold the application's database. Connect to the MariaDB/MySQL server using PuTTY. At the login prompt, login with your administrator account ( administrator / myadminpas...

Create Ubuntu Web Server Click here for detailed instructions on setting up a production-quality Ubuntu Server . Once you have the base operating system installed, proceed to follow these instructions to install Apache web server . When it talks about setting up your web root, be sure to substitute...